Output for matching questions


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Output for matching questions
# 1  
Old 03-18-2015
Output for matching questions

Hi, I have two files A and B.
file_A
Code:
gga-mir-181b-1
gga-mir-181b-2
gga-mir-199-1
gga-mir-203
gga-mir-204-1
gga-mir-205a
gga-mir-206
gga-mir-214
gga-mir-218-1
gga-mir-365-2
gga-mir-454
gga-mir-551
gga-mir-1464
gga-mir-1465
gga-mir-1466
gga-mir-1553
gga-mir-15c
gga-mir-16c
gga-mir-1577
gga-mir-1578
gga-mir-1582
gga-mir-1608
gga-mir-1617
gga-mir-1639
gga-mir-1644
gga-mir-1645
gga-mir-1653
gga-mir-1665
gga-let-7a-3
gga-mir-21
gga-mir-22
gga-mir-1677
gga-mir-1697
gga-mir-1700
gga-mir-1704
gga-mir-1713
gga-mir-1714
gga-mir-1723
gga-mir-1725
gga-mir-1727
gga-mir-1733
gga-mir-1753
gga-let-7b
gga-mir-24
gga-mir-27b
gga-mir-30a
gga-mir-30b
gga-mir-1780
gga-mir-1783
gga-mir-1787
gga-mir-1788
gga-mir-1806
gga-mir-2126
gga-mir-3526
gga-mir-3533
gga-mir-3540
gga-mir-6516
gga-mir-6553
gga-mir-6559
gga-mir-30e
gga-mir-32
gga-mir-6574
gga-mir-6576
gga-mir-6581
gga-mir-6610
gga-mir-6613
gga-mir-6631
gga-mir-6647
gga-mir-6663
gga-mir-6667
gga-mir-6675
gga-mir-6697
gga-mir-124c
gga-mir-147
gga-mir-181b-1
gga-mir-199-1
gga-mir-218-1
gga-mir-365-2
gga-mir-454
gga-mir-551
gga-mir-1553
gga-mir-15c
gga-mir-16c
gga-let-7a-3
gga-mir-21
gga-mir-22
gga-mir-1677
gga-mir-24
gga-mir-27b
gga-mir-30a
gga-mir-30b
gga-mir-1788
gga-mir-6516
gga-mir-6553
gga-mir-6559
gga-mir-30e
gga-mir-32
gga-mir-6574
gga-mir-6576
gga-mir-6581
gga-mir-6675
gga-mir-124c

file_B
Code:
gga-mir-6708 chr1 290088 290197     
gga-mir-1604 chr1 314579 314675     
gga-mir-1651 chr1 505088 505171     
gga-mir-183 chr1 796221 796318     
gga-mir-6676 chr1 858538 858647     
gga-mir-6629 chr1 868652 868761     
gga-mir-205b chr1 1223722 1223819     
gga-mir-6659 chr1 1678308 1678417     
gga-mir-6621 chr1 2622379 2622488     
gga-mir-29b-1 chr1 3328673 3328753     
gga-mir-29a chr1 3329690 3329778     
gga-mir-1626 chr1 5558265 5558354     
gga-mir-1596 chr1 5678879 5678968     
gga-mir-1460 chr1 6824865 6824963     
gga-mir-2126 chr1 14567820 14567965     
gga-mir-1693 chr1 20342133 20342234     
gga-mir-1645 chr1 23147247 23147310     
gga-mir-1695 chr1 26663517 26663595     
gga-mir-7447 chr1 29560368 29560429     
gga-let-7i chr1 33019229 33019312     
gga-mir-1691 chr1 46087390 46087480     
gga-mir-135a-2 chr1 46153508 46153607     
gga-mir-6581 chr1 48223222 48223323     
gga-mir-1581 chr1 49133041 49133126     
gga-mir-33-1 chr1 49353559 49353627     
gga-mir-1683 chr1 49748062 49748162     
gga-mir-3538 chr1 50552408 50552482     
gga-mir-1742 chr1 51573092 51573174     
gga-mir-7450 chr1 54894245 54894298     
gga-mir-490 chr1 58018957 58019049     
gga-mir-6700 chr1 59483131 59483239     
gga-mir-1593 chr1 59704345 59704434     
gga-mir-6608-1 chr1 65986597 65986706     
gga-mir-6608-2 chr1 65992614 65992723     
gga-mir-7451 chr1 67305764 67305818     
gga-let-7a-3 chr1 71371150 71371225     
gga-let-7b chr1 71371979 71372063     
gga-mir-1727 chr1 71640474 71640579     
gga-mir-6606 chr1 75871760 75871869     
gga-mir-6553 chr1 76381420 76381519     
gga-mir-6609 chr1 79371004 79371113     
gga-mir-3539 chr1 80199429 80199499     
gga-mir-1690 chr1 83233227 83233330     
gga-mir-7446 chr1 87937436 87937498     
gga-mir-6616 chr1 91716451 91716560     
gga-mir-1806 chr1 93185199 93185283     
gga-mir-99a chr1 98347473 98347553     
gga-let-7c chr1 98348226 98348309     
gga-mir-125b-2 chr1 98380668 98380757     
gga-mir-155 chr1 101820932 101820994     
gga-mir-1738 chr1 104085133 104085223     
gga-mir-3524a chr1 105212787 105212902     
gga-mir-3525 chr1 105212803 105212886     
gga-mir-7452 chr1 105985416 105985483     
gga-mir-222a chr1 109977177 109977274     
gga-mir-221 chr1 109977681 109977779     
gga-mir-6672 chr1 111965213 111965322     
gga-mir-7448 chr1 125477797 125477853     
gga-mir-1397 chr1 126318826 126318930     
gga-mir-1805 chr1 130382447 130382530     
gga-mir-6559 chr1 132416104 132416212     
gga-mir-1656 chr1 132938805 132938870     
gga-mir-1700 chr1 136086269 136086368     
gga-mir-1736 chr1 138533094 138533192     
gga-mir-1632 chr1 139187329 139187419     
gga-mir-1555 chr1 144185923 144186008     
gga-mir-92-1 chr1 147253128 147253205     
gga-mir-19b chr1 147253241 147253327     
gga-mir-20a chr1 147253364 147253461     
gga-mir-19a chr1 147253550 147253630     
gga-mir-18a chr1 147253684 147253776     
gga-mir-17 chr1 147253839 147253923     
gga-mir-1743 chr1 155877449 155877551     
gga-mir-7445-2 chr1 160939457 160939516     
gga-mir-7445-1 chr1 160939459 160939518     
gga-mir-2127 chr1 165191206 165191309     
gga-mir-6555 chr1 166351480 166351579     
gga-mir-16-1 chr1 168694548 168694631     
gga-mir-15a chr1 168694690 168694772     
gga-mir-1646 chr1 174458049 174458142     
gga-mir-6656 chr1 175178559 175178668     
gga-mir-6641 chr1 178435317 178435420     
gga-mir-1709 chr1 180222477 180222558     
gga-mir-7449 chr1 181580126 181580193     
gga-mir-6570 chr1 184262390 184262489     
gga-mir-1657 chr1 187518611 187518704     
gga-mir-1664 chr1 189303425 189303521     
gga-mir-1600 chr1 193524356 193524435     
gga-mir-1708 chr1 194414383 194414476     
gga-mir-1670 chr10 360172 360231     
gga-mir-6692 chr10 699613 699722     
gga-mir-1688 chr10 869890 869960     
gga-mir-6660 chr10 1076742 1076851     
gga-mir-1623 chr10 1515862 1515957     
gga-mir-6625 chr10 1882076 1882185     
gga-mir-2128 chr10 1900845 1900908     
gga-mir-6703 chr10 2016309 2016418     
gga-mir-1794 chr10 2048859 2048956     
gga-mir-6575 chr10 2190021 2190128     
gga-mir-190a chr10 3767388 3767472     
gga-mir-1574 chr10 5189799 5189872     
gga-mir-204-2 chr10 5190072 5190172     
gga-mir-1744 chr10 9412311 9412399     
gga-mir-147 chr10 10170161 10170230     
gga-mir-6596 chr10 10272568 10272661     
gga-mir-3540 chr10 10562408 10562469     
gga-mir-1720 chr10 12627132 12627196     
gga-mir-7-2 chr10 12627267 12627365     
gga-mir-3529 chr10 12627271 12627361     
gga-mir-1611 chr10 14127514 14127595     
gga-mir-1680 chr10 15365468 15365556     
gga-mir-1813-2 chr10 16080572 16080645     
gga-mir-1737 chr10 16575378 16575470     
gga-mir-1722 chr10 17345594 17345685     
gga-mir-1642 chr10 18561845 18561918     
gga-mir-6550 chr10 18644669 18644768     
gga-mir-184 chr10 19462850 19462923     
gga-mir-6709 chr11 567609 567718     
gga-mir-1616 chr11 1261870 1261963     
gga-mir-1643 chr11 1933494 1933588     
gga-mir-138-2 chr11 2036243 2036325     
gga-mir-1789 chr11 8363039 8363101     
gga-mir-1791 chr11 8443431 8443515     
gga-mir-6589 chr11 10563109 10563218     
gga-mir-1634-1 chr11 10799331 10799426     
gga-mir-6595 chr11 12754009 12754118     
gga-mir-1571 chr11 17862696 17862793     
gga-mir-1560 chr11 18095261 18095364     
gga-mir-1785 chr11 18154149 18154250     
gga-mir-6667 chr11 18210719 18210828     
gga-mir-140 chr11 18514128 18514222     
gga-mir-1699 chr11 18933029 18933125     
gga-mir-1563 chr12 733993 734063     
gga-mir-1719 chr12 835709 835797     
gga-mir-1678 chr12 2560848 2560933     
gga-let-7g chr12 2982077 2982159     
gga-mir-135a-1 chr12 3003740 3003827     
gga-let-7d chr12 6076930 6077032     
gga-let-7f chr12 6077975 6078061     
gga-let-7a-1 chr12 6078389 6078478     
gga-mir-1787 chr12 8747037 8747126     
gga-mir-1783 chr12 8795545 8795645     
gga-mir-1572 chr12 9401983 9402077     
gga-mir-1731 chr12 10637850 10637951     
gga-mir-6684 chr12 11072268 11072377     
gga-mir-1550 chr12 12834954 12835051     
gga-mir-1711 chr12 16392265 16392332     
gga-mir-1702 chr13 1448162 1448245     
gga-mir-218-2 chr13 3934522 3934616     
gga-mir-103-1 chr13 4060404 4060481     
gga-mir-6569 chr13 4071149 4071252     
gga-mir-146a chr13 7137989 7138087     
gga-mir-458a chr13 7575893 7576008     
gga-mir-458b chr13 7575899 7576000     
gga-mir-6652 chr13 8253534 8253643     
gga-mir-3523 chr13 8384599 8384764     
gga-mir-7460 chr13 9695805 9695865     
gga-mir-1778 chr13 11461782 11461854     
gga-mir-1609 chr13 16166965 16167058     
gga-mir-6588 chr13 16922251 16922360     
gga-mir-1576 chr13 17396211 17396305     
gga-mir-6686 chr14 757680 757789     
gga-mir-193b chr14 762081 762163     
gga-mir-365b chr14 766887 766996     
gga-mir-365-1 chr14 766899 766983     
gga-mir-1781 chr14 3316667 3316759     
gga-mir-2129 chr14 3998884 3998967     
gga-mir-3533 chr14 4170287 4170370     
gga-mir-1682 chr14 4912472 4912544     
gga-mir-1551 chr14 5206161 5206250     
gga-mir-1554 chr14 5786820 5786898     
gga-mir-1615 chr14 6697962 6698054     
gga-mir-6548 chr14 7275795 7275901     
gga-mir-1786 chr14 7716086 7716194     
gga-mir-1644 chr14 8124516 8124601     
gga-mir-1763 chr14 12262850 12262915     
gga-mir-1564 chr14 12263702 12263772     
gga-mir-6714 chr14 12388339 12388448     
gga-mir-6643 chr14 13143450 13143559     
gga-mir-1588 chr14 14125510 14125611     
gga-mir-1715 chr14 14285835 14285936     
gga-mir-7471 chr14 14312407 14312466     
gga-mir-130b chr15 390543 390619     
gga-mir-454 chr15 391656 391776     
gga-mir-301a chr15 398134 398226     
gga-mir-130a chr15 399359 399441     
gga-mir-1673 chr15 741749 741848     
gga-mir-1729 chr15 754851 754921     
gga-mir-1306 chr15 1279112 1279180     
gga-mir-1769 chr15 2225214 2225316     
gga-mir-1636 chr15 4688786 4688873     
gga-mir-7476 chr15 4975672 4975734     
gga-mir-1671 chr15 5044461 5044520     
gga-mir-762 chr15 5706075 5706153     
gga-mir-1764 chr15 5778571 5778673     
gga-mir-6648-1 chr15 6645228 6645326     
gga-mir-6635-1 chr15 6927885 6927994     
gga-mir-1625 chr15 7568815 7568894     
gga-mir-6650 chr15 7683164 7683273     
gga-mir-6673 chr15 8860990 8861099     
gga-mir-1640 chr15 9973454 9973544     
gga-mir-1464 chr15 11434695 11434804     
gga-mir-1707 chr17 1824191 1824286     
gga-mir-7441 chr17 2068080 2068142     
gga-mir-7442 chr17 2440746 2440803     
gga-mir-6696 chr17 4690776 4690878     
gga-mir-455 chr17 4701970 4702055     
gga-mir-219b chr17 4948485 4948573     
gga-mir-219a chr17 4948488 4948572     
gga-mir-199-1 chr17 5034551 5034644     
gga-mir-1753 chr17 5958864 5958942     
gga-mir-3528 chr17 7723310 7723406     
gga-mir-126 chr17 7748465 7748548     
gga-mir-1465 chr17 8168589 8168698     
gga-mir-1705 chr17 8801359 8801448     
gga-mir-181a-2 chr17 9496903 9496993     
gga-mir-181b-2 chr17 9498543 9498627     
gga-mir-6712 chr17 9515769 9515878     
gga-mir-1748 chr18 761046 761126     
gga-mir-6516 chr18 4105545 4105654     
gga-mir-6599 chr18 5018210 5018306     
gga-mir-1765 chr18 5811211 5811315     
gga-mir-1561 chr18 6381008 6381092     
gga-mir-365-2 chr18 6405040 6405135     
gga-mir-3064 chr18 6861731 6861854     
gga-mir-1672 chr18 9054663 9054738     
gga-mir-6551 chr18 9590168 9590275     
gga-mir-1652 chr18 9906187 9906282     
gga-mir-7443 chr18 10001789 10001847     
gga-mir-1637 chr18 10532541 10532605     
gga-mir-1580 chr18 10864474 10864546     
gga-mir-142 chr19 491906 491993     
gga-mir-1698-1 chr19 622426 622532     
gga-mir-1698-2 chr19 687031 687137     
gga-mir-1567 chr19 1728894 1728982     
gga-mir-1354 chr19 1813848 1813923     
gga-mir-1587 chr19 1820497 1820592     
gga-mir-7444 chr19 2941353 2941415     
gga-mir-6592 chr19 3209216 3209325     
gga-mir-6585 chr19 5052627 5052736     
gga-mir-22 chr19 5377511 5377610     
gga-mir-1666 chr19 5562187 5562276     
gga-mir-1696 chr19 5600965 5601034     
gga-mir-451 chr19 5862879 5862947     
gga-mir-144 chr19 5863034 5863118     
gga-mir-301b chr19 7193224 7193313     
gga-mir-130c chr19 7193512 7193605     
gga-mir-1697 chr19 7241334 7241412     
gga-mir-21 chr19 7367265 7367361     
gga-mir-6639 chr19 8674403 8674512     
gga-mir-1585 chr19 8834278 8834368     
gga-mir-1592 chr19 9367029 9367095     
gga-mir-1689 chr19 9390741 9390844     
gga-mir-1749 chr2 569326 569423     
gga-mir-6710 chr2 724388 724497     
gga-mir-7461 chr2 966581 966667     
gga-mir-1662 chr2 1818925 1818997     
gga-mir-6713 chr2 2482608 2482717     
gga-mir-1639 chr2 3254985 3255056     
gga-mir-460a chr2 3654245 3654334     
gga-mir-1706 chr2 3818009 3818082     
gga-mir-26a chr2 4537766 4537842     
gga-mir-6610 chr2 4874819 4874928     
gga-mir-6600 chr2 5790773 5790882     
gga-mir-6554 chr2 6741175 6741280     
gga-mir-153 chr2 8813789 8813875     
gga-mir-6628 chr2 12060312 12060421     
gga-mir-1768 chr2 14062311 14062387     
gga-mir-1661 chr2 19683389 19683449     
gga-mir-466 chr2 21607538 21607606     
gga-mir-1650 chr2 22840865 22840957     
gga-mir-489 chr2 23246915 23246998     
gga-mir-6601 chr2 24012383 24012492     
gga-mir-1685 chr2 24912242 24912336     
gga-mir-148a chr2 32253587 32253654     
gga-mir-1732-1 chr2 32863481 32863581     
gga-mir-196-2 chr2 32864663 32864756     
gga-mir-1732-2 chr2 32976244 32976344     
gga-mir-196-4 chr2 32977426 32977519     
gga-mir-1732-3 chr2 33157015 33157115     
gga-mir-196-5 chr2 33158197 33158290     
gga-mir-1622 chr2 40788808 40788904     
gga-mir-138-1 chr2 41316138 41316233     
gga-mir-1723 chr2 41948661 41948766     
gga-mir-7457 chr2 44567065 44567118     
gga-mir-1607 chr2 46000263 46000341     
gga-mir-128-2 chr2 46095826 46095909     
gga-mir-7458-1 chr2 56301149 56301212     
gga-mir-7459 chr2 57829998 57830065     
gga-mir-6557 chr2 61149125 61149230     
gga-mir-1747 chr2 61712114 61712190     
gga-mir-1759 chr2 62610756 62610830     
gga-mir-6571 chr2 64452318 64452423     
gga-mir-6698 chr2 67878128 67878237     
gga-mir-1782 chr2 68575039 68575137     
gga-mir-6545 chr2 71697392 71697498     
gga-mir-1766 chr2 75609268 75609360     
gga-mir-757 chr2 76426270 76426351     
gga-mir-1613 chr2 77808828 77808904     
gga-mir-187 chr2 83630901 83630986     
gga-mir-32 chr2 84239873 84239942     
gga-mir-1816 chr2 88290498 88290602     
gga-mir-1803 chr2 92563597 92563685     
gga-mir-6584 chr2 93544765 93544874     
gga-mir-1681 chr2 93973210 93973309     
gga-mir-3524b chr2 95601105 95601214     
gga-mir-6701 chr2 97173132 97173241     
gga-mir-133a-1 chr2 102176853 102176939     
gga-mir-1a-2 chr2 102179979 102180063     
gga-mir-1597 chr2 103453436 103453508     
gga-mir-6707 chr2 106512944 106513053     
gga-mir-1557 chr2 112605422 112605491     
gga-mir-124c chr2 114001455 114001555     
gga-mir-124a chr2 114001462 114001557     
gga-mir-1714 chr2 114004468 114004543     
gga-mir-7456 chr2 114763688 114763745     
gga-mir-1569 chr2 116341906 116341975     
gga-mir-1796 chr2 117163520 117163589     
gga-mir-6630 chr2 128704144 128704253     
gga-mir-1813-1 chr2 130687107 130687192     
gga-mir-1467-1 chr2 135124476 135124585     
gga-mir-1467-2 chr2 135256279 135256388     
gga-mir-1457 chr2 136647985 136648071     
gga-mir-30b chr2 142225959 142226045     
gga-mir-30d chr2 142229501 142229564     
gga-mir-6572 chr2 145236906 145237013     
gga-mir-1770 chr2 145493414 145493510     
gga-mir-6664 chr20 606662 606771     
gga-mir-1558 chr20 968247 968331     
gga-mir-1453 chr20 1654250 1654323     
gga-mir-7453 chr20 2310038 2310101     
gga-mir-6674 chr20 2467054 2467163     
gga-mir-499 chr20 2955127 2955217     
gga-mir-1614 chr20 5286402 5286483     
gga-mir-1a-1 chr20 8472265 8472335     
gga-mir-1773 chr20 8473570 8473647     
gga-mir-133a-2 chr20 8483487 8483582     
gga-mir-6681 chr20 8762829 8762938     
gga-mir-6567 chr20 8789276 8789382     
gga-mir-1746 chr20 8991446 8991545     
gga-mir-124a-2 chr20 9040251 9040348     
gga-mir-1798 chr20 10028660 10028755     
gga-mir-6597 chr20 11240167 11240276     
gga-mir-6564 chr20 11288976 11289073     
gga-mir-1619 chr20 12990348 12990439     
gga-mir-6677 chr20 13420930 13421038     
gga-mir-1687 chr20 13423654 13423744     
gga-mir-1648 chr20 14163574 14163659     
gga-mir-1635 chr21 1741924 1742030     
gga-mir-1795 chr21 2375601 2375678     
gga-mir-429 chr21 2595422 2595505     
gga-mir-200a chr21 2597927 2598013     
gga-mir-200b chr21 2600252 2600336     
gga-mir-6680 chr21 2638678 2638787     
gga-mir-34a chr21 3266632 3266740     
gga-mir-6626 chr21 4626828 4626937     
gga-mir-6576 chr22 52491 52596     
gga-mir-2188 chr22 2634242 2634410     
gga-mir-3531 chr23 440597 440683     
gga-mir-124b chr23 2183626 2183718     
gga-mir-1724 chr23 2718664 2718765     
gga-mir-1b chr23 4294312 4294375     
gga-mir-133c chr23 4294451 4294529     
gga-mir-30e chr23 4883379 4883474     
gga-mir-30c-1 chr23 4884602 4884690     
gga-mir-1780 chr23 5024764 5024839     
gga-mir-6637-1 chr23 5162447 5162556     
gga-mir-6637-2 chr23 5169903 5170012     
gga-mir-1758 chr24 25065 25135     
gga-mir-1601 chr24 2010029 2010105     
gga-mir-1807 chr24 3166329 3166418     
gga-mir-100 chr24 3330837 3330916     
gga-mir-6675 chr24 3337464 3337572     
gga-let-7a-2 chr24 3338936 3339007     
gga-mir-1466 chr24 4170955 4171064     
gga-mir-6612 chr24 4779927 4780036     
gga-mir-6671 chr24 5035783 5035892     
gga-mir-1745 chr24 5163387 5163473     
gga-mir-1667 chr24 5314667 5314753     
gga-mir-34b chr24 5562070 5562153     
gga-mir-34c chr24 5562807 5562880     
gga-mir-6662 chr25 648172 648281     
gga-mir-3536 chr25 1309436 1309513     
gga-mir-1629 chr25 1381572 1381664     
gga-mir-1752 chr25 1457611 1457692     
gga-mir-6646-1 chr25 1588340 1588449     
gga-mir-6620 chr25 2097073 2097182     
gga-mir-6607 chr26 675737 675846     
gga-let-7j chr26 1591918 1592000     
gga-let-7k chr26 1592118 1592200     
gga-mir-6618 chr26 1713408 1713517     
gga-mir-135a-3 chr26 2065494 2065589     
gga-mir-1797 chr26 2220800 2220900     
gga-mir-6602 chr26 2228959 2229068     
gga-mir-29c chr26 2640705 2640793     
gga-mir-29b-2 chr26 2641616 2641695     
gga-mir-6654 chr26 2795073 2795182     
gga-mir-205a chr26 3017914 3018009     
gga-mir-1669 chr26 3568060 3568150     
gga-mir-7454 chr26 5304485 5304538     
gga-mir-6644-2 chr27 380937 381046     
gga-mir-6644-1 chr27 389178 389287     
gga-mir-6695 chr27 1155019 1155128     
gga-mir-6573 chr27 1532553 1532671     
gga-mir-196-1 chr27 3561326 3561420     
gga-mir-10a chr27 3620210 3620283     
gga-mir-6663 chr27 3965608 3965717     
gga-mir-1735 chr27 3990639 3990717     
gga-mir-6547 chr27 4244999 4245118     
gga-mir-1774 chr28 1299723 1299801     
gga-mir-1434 chr28 1442291 1442367     
gga-mir-6615 chr28 1748828 1748938     
gga-mir-211 chr28 2175845 2175918     
gga-mir-1647 chr28 2209424 2209530     
gga-mir-1777 chr28 3115010 3115104     
gga-mir-1621 chr28 3375877 3375947     
gga-mir-1565 chr28 3377144 3377225     
gga-mir-9-1 chr28 3378847 3378934     
gga-mir-6693 chr28 4049943 4050052     
gga-mir-6666 chr28 4471108 4471217     
gga-mir-7-3 chr28 4641011 4641105     
gga-mir-217 chr3 298909 299015     
gga-mir-216a chr3 301577 301682     
gga-mir-216b chr3 306984 307072     
gga-mir-216c chr3 306986 307071     
gga-mir-6583 chr3 737586 737695     
gga-mir-7463 chr3 1020676 1020737     
gga-mir-1740 chr3 3722992 3723093     
gga-mir-6542 chr3 4348122 4348248     
gga-mir-1792 chr3 7694748 7694846     
gga-mir-6711 chr3 9944719 9944828     
gga-mir-6631 chr3 11871358 11871467     
gga-mir-1641 chr3 12620456 12620550     
gga-mir-1756b chr3 14028997 14029085     
gga-mir-3526 chr3 14930762 14930876     
gga-mir-6563 chr3 15722961 15723070     
gga-mir-7464 chr3 16228319 16228375     
gga-mir-194 chr3 18143383 18143457     
gga-mir-215 chr3 18143689 18143793     
gga-mir-1649 chr3 21194285 21194382     
gga-mir-6640 chr3 21535494 21535603     
gga-mir-1598 chr3 22197514 22197588     
gga-mir-6580 chr3 26665020 26665124     
gga-mir-4732 chr3 29704335 29704444     
gga-mir-456 chr3 30789064 30789175     
gga-mir-1717 chr3 33118442 33118542     
gga-mir-1784 chr3 34968393 34968495     
gga-mir-135b chr3 36785160 36785226     
gga-mir-1767 chr3 42165536 42165594     
gga-mir-1734 chr3 45520635 45520718     
gga-mir-7462 chr3 53417540 53417600     
gga-mir-6568 chr3 54480212 54480309     
gga-mir-1454 chr3 56049382 56049481     
gga-mir-6582 chr3 56764245 56764349     
gga-mir-6697 chr3 57518333 57518442     
gga-mir-1660 chr3 57720708 57720761     
gga-mir-199b chr3 62411976 62412041     
gga-mir-6699 chr3 66859781 66859890     
gga-mir-1677 chr3 73379297 73379369     
gga-mir-1686 chr3 74983393 74983490     
gga-mir-1451 chr3 75401219 75401328     
gga-mir-1712 chr3 78631047 78631119     
gga-mir-6670 chr3 79001169 79001278     
gga-mir-6633 chr3 79616869 79616978     
gga-mir-6687 chr3 80912033 80912142     
gga-mir-7465 chr3 80973307 80973359     
gga-mir-30a chr3 81754485 81754556     
gga-mir-30c-2 chr3 81779099 81779170     
gga-mir-6605 chr3 83660653 83660762     
gga-mir-6634 chr3 89124219 89124328     
gga-mir-6655 chr3 96307259 96307368     
gga-mir-1329 chr3 96487080 96487174     
gga-mir-6678 chr3 102374181 102374290     
gga-mir-6578 chr3 104615495 104615596     
gga-mir-6690 chr3 107000658 107000767     
gga-mir-6702 chr3 107007864 107007973     
gga-mir-133b chr3 107209163 107209246     
gga-mir-206 chr3 107213960 107214035     
gga-mir-223 chr4 242669 242768     
gga-mir-6594 chr4 574788 574897     
gga-mir-6658 chr4 1174077 1174186     
gga-mir-1586 chr4 1223651 1223747     
gga-mir-1628 chr4 1894848 1894944     
gga-mir-222b chr4 2147533 2147643     
gga-mir-460b chr4 2677836 2677925     
gga-mir-6689 chr4 3199902 3200011     
gga-mir-20b chr4 3946318 3946402     
gga-mir-18b chr4 3946499 3946582     
gga-mir-106 chr4 3946630 3946710     
gga-mir-16c chr4 4023458 4023528     
gga-mir-15c chr4 4023824 4023899     
gga-mir-1462 chr4 8488386 8488495     
gga-mir-6704 chr4 8620570 8620679     
gga-mir-1750 chr4 10531500 10531584     
gga-mir-1728 chr4 10910465 10910560     
gga-mir-1790 chr4 11534471 11534575     
gga-mir-1573 chr4 12427324 12427396     
gga-mir-1606 chr4 13396908 13396976     
gga-mir-6614 chr4 13721888 13721997     
gga-mir-6679 chr4 15517560 15517669     
gga-mir-1757 chr4 16541306 16541410     
gga-mir-7469 chr4 18043001 18043067     
gga-mir-6682 chr4 20900133 20900242     
gga-mir-6688 chr4 21269413 21269522     
gga-mir-1575 chr4 28998678 28998781     
gga-mir-6668 chr4 33472329 33472438     
gga-mir-6591 chr4 34196016 34196125     
gga-mir-1627 chr4 38434799 38434868     
gga-mir-1776 chr4 43047467 43047567     
gga-mir-6632 chr4 44243713 44243822     
gga-mir-1804 chr4 45821511 45821593     
gga-mir-1730 chr4 47627247 47627339     
gga-mir-1751 chr4 49506377 49506466     
gga-mir-1679 chr4 50526287 50526374     
gga-mir-7468 chr4 54145364 54145430     
gga-mir-302b chr4 56692821 56692892     
gga-mir-302c chr4 56693083 56693147     
gga-mir-1811 chr4 56693205 56693285     
gga-mir-302a chr4 56693386 56693452     
gga-mir-302d chr4 56693721 56693789     
gga-mir-367 chr4 56693857 56693929     
gga-mir-7466 chr4 57749951 57749998     
gga-mir-122b chr4 58317521 58317597     
gga-mir-1814 chr4 59705671 59705744     
gga-mir-1605 chr4 62660845 62660932     
gga-mir-383 chr4 63595605 63595677     
gga-mir-6586 chr4 68633335 68633444     
gga-mir-218-1 chr4 74617807 74617915     
gga-mir-1602 chr4 75836469 75836559     
gga-mir-1701 chr4 78845682 78845758     
gga-mir-6661 chr4 82213019 82213128     
gga-mir-7467 chr4 82376451 82376513     
gga-mir-6705 chr4 84644172 84644281     
gga-mir-103-2 chr4 88047783 88047865     
gga-mir-146c chr4 88268236 88268364     
gga-mir-1684a chr4 88602925 88603026     
gga-mir-1654 chr4 88719865 88719958     
gga-mir-6627 chr4 89228532 89228641     
gga-mir-6579-2 chr5 516685 516798     
gga-mir-6579-1 chr5 543583 543696     
gga-mir-1808 chr5 983735 983825     
gga-mir-1775 chr5 2455690 2455778     
gga-mir-1760 chr5 3859360 3859452     
gga-mir-1568 chr5 7569014 7569081     
gga-mir-1463 chr5 9641946 9642055     
gga-mir-6642 chr5 13052807 13052907     
gga-mir-1663 chr5 15181878 15181979     
gga-mir-1802 chr5 16372225 16372304     
gga-mir-1725 chr5 22182228 22182296     
gga-mir-6603 chr5 22404967 22405076     
gga-mir-6706 chr5 22966049 22966158     
gga-mir-6544 chr5 23747043 23747148     
gga-mir-6685 chr5 24317892 24317991     
gga-mir-6587 chr5 25484986 25485094     
gga-mir-1710 chr5 27158286 27158365     
gga-mir-1617 chr5 27598380 27598468     
gga-mir-6683 chr5 29436768 29436877     
gga-mir-1718 chr5 30723941 30724020     
gga-mir-3532 chr5 32244881 32244964     
gga-mir-6598 chr5 37147036 37147145     
gga-mir-6645 chr5 38408374 38408483     
gga-mir-1739 chr5 38516933 38517025     
gga-mir-1799 chr5 39215817 39215900     
gga-mir-1800 chr5 44412724 44412799     
gga-mir-6552 chr5 44456296 44456399     
gga-mir-6590 chr5 45676949 45677052     
gga-mir-203a chr5 50592418 50592515     
gga-mir-1771 chr5 51508701 51508786     
gga-mir-1578 chr5 55044564 55044630     
gga-mir-1638 chr5 56020281 56020367     
gga-mir-1676 chr5 56301455 56301554     
gga-mir-1716 chr5 57603653 57603757     
gga-mir-1703 chr5 57886558 57886646     
gga-mir-1579 chr6 2164858 2164924     
gga-mir-1772 chr6 10054565 10054633     
gga-mir-1590 chr6 11997264 11997362     
gga-mir-1624 chr6 15372471 15372545     
gga-mir-3537 chr6 16490397 16490473     
gga-mir-6577 chr6 16782325 16782432     
gga-mir-107 chr6 18945413 18945493     
gga-mir-6657 chr6 19615057 19615166     
gga-mir-202 chr6 21042710 21042798     
gga-mir-6604 chr6 21904154 21904263     
gga-mir-1674 chr6 22350667 22350762     
gga-mir-146b chr6 22680083 22680187     
gga-mir-1815 chr6 27635092 27635168     
gga-mir-7472 chr6 29599895 29599957     
gga-mir-1726 chr6 31856425 31856521     
gga-mir-6560 chr6 31915142 31915251     
gga-mir-6694 chr6 32132816 32132925     
gga-mir-1812 chr7 1252400 1252487     
gga-mir-1559 chr7 1318656 1318731     
gga-mir-1694 chr7 5370847 5370944     
gga-mir-6691-1 chr7 5728256 5728365     
gga-mir-6691-2 chr7 5821835 5821944     
gga-mir-1845 chr7 6597642 6597727     
gga-mir-1603 chr7 9710392 9710478     
gga-mir-1659 chr7 13177026 13177126     
gga-mir-7474 chr7 14849462 14849536     
gga-mir-6624 chr7 15758919 15759028     
gga-mir-1713 chr7 15775767 15775865     
gga-mir-10b chr7 15780526 15780635     
gga-mir-1570 chr7 16274218 16274317     
gga-mir-1733 chr7 18452934 18453017     
gga-mir-1591 chr7 18810406 18810483     
gga-mir-375 chr7 21842379 21842443     
gga-mir-1788 chr7 21851756 21851843     
gga-mir-1582 chr7 23199976 23200064     
gga-mir-1553 chr7 23245928 23246032     
gga-mir-1599 chr7 23875684 23875745     
gga-mir-3530 chr7 24770052 24770140     
gga-mir-128-1 chr7 30116396 30116477     
gga-mir-7473 chr7 32903858 32903919     
gga-mir-1c chr7 34497646 34497719     
gga-mir-6546 chr7 35757572 35757688     
gga-mir-181a-1 chr8 1986687 1986790     
gga-mir-181b-1 chr8 1986876 1986964     
gga-mir-1801 chr8 3801341 3801443     
gga-mir-199-2 chr8 4621376 4621483     
gga-mir-214 chr8 4627233 4627342     
gga-mir-1721 chr8 4977439 4977512     
gga-mir-6665 chr8 5198809 5198918     
gga-mir-1633 chr8 5302569 5302663     
gga-mir-1618 chr8 7422181 7422259     
gga-mir-1655 chr8 7475856 7475958     
gga-mir-6561 chr8 10191131 10191235     
gga-mir-1610 chr8 10666679 10666766     
gga-mir-137 chr8 11470723 11470818     
gga-mir-1589 chr8 15393407 15393485     
gga-mir-1761 chr8 15744295 15744375     
gga-mir-1620 chr8 17395557 17395644     
gga-mir-1665 chr8 18639978 18640055     
gga-mir-6647 chr8 18702753 18702862     
gga-mir-1595 chr8 19665805 19665869     
gga-mir-6622 chr8 21075069 21075178     
gga-mir-1809 chr8 21587584 21587691     
gga-mir-1562 chr8 23064105 23064206     
gga-mir-6549 chr8 23386523 23386635     
gga-mir-6623 chr8 23516908 23517017     
gga-mir-1675 chr8 23549022 23549121     
gga-mir-101-2 chr8 27164028 27164103     
gga-mir-6653 chr8 27652713 27652822     
gga-mir-1630 chr9 378052 378108     
gga-mir-1704 chr9 4390437 4390507     
gga-mir-1612 chr9 4482098 4482181     
gga-mir-1608 chr9 4723169 4723261     
gga-mir-1577 chr9 4942397 4942481     
gga-mir-1741 chr9 6653578 6653650     
gga-mir-6574 chr9 7104153 7104259     
gga-mir-1458 chr9 10140254 10140363     
gga-mir-6611 chr9 11797059 11797168     
gga-mir-1762 chr9 13364365 13364462     
gga-mir-1653 chr9 13811232 13811335     
gga-mir-6558 chr9 14633406 14633527     
gga-mir-3535 chr9 14752127 14752208     
gga-mir-1755 chr9 15091729 15091819     
gga-mir-6617 chr9 15660966 15661075     
gga-mir-551 chr9 19886058 19886170     
gga-mir-1692 chr9 21603206 21603294     
gga-mir-16-2 chr9 21653410 21653503     
gga-mir-15b chr9 21653585 21653675     
gga-mir-1658 chr9 22400082 22400171     
gga-mir-1754 chr9 22907054 22907121     
gga-mir-1793 chr9 23006780 23006876     
gga-mir-6556 chr9 23087166 23087271     
gga-mir-1594 chrZ 193844 193934     
gga-mir-122-1 chrZ 761054 761130     
gga-mir-6649 chrZ 8444188 8444326     
gga-mir-6613 chrZ 10464854 10464963     
gga-mir-1631 chrZ 16311551 16311624     
gga-mir-449a chrZ 16561816 16561901     
gga-mir-449b chrZ 16561966 16562059     
gga-mir-449c chrZ 16562969 16563040     
gga-mir-1584 chrZ 18733802 18733866     
gga-mir-101-1 chrZ 27369524 27369602     
gga-mir-6669 chrZ 27570294 27570401     
gga-mir-1779 chrZ 32169221 32169312     
gga-mir-7482-1 chrZ 34159350 34159406     
gga-mir-7482-2 chrZ 34174431 34174487     
gga-mir-7482-3 chrZ 34189817 34189873     
gga-mir-7482-4 chrZ 34254330 34254386     
gga-mir-7482-5 chrZ 34269364 34269420     
gga-mir-1556 chrZ 34504176 34504261     
gga-mir-1416 chrZ 34781501 34781589     
gga-mir-204-1 chrZ 35040031 35040134     
gga-mir-7-1 chrZ 39936987 39937095     
gga-mir-7439 chrZ 40511125 40511198     
gga-mir-23b chrZ 41508036 41508121     
gga-mir-27b chrZ 41508272 41508368     
gga-mir-24 chrZ 41508805 41508872     
gga-mir-1456 chrZ 44756224 44756333     
gga-mir-6651 chrZ 48508022 48508131     
gga-mir-6565 chrZ 55328621 55328721     
gga-mir-9-2 chrZ 60293370 60293456     
gga-mir-7479-1 chrZ 60638626 60638703     
gga-mir-7479-2 chrZ 60641067 60641144     
gga-mir-7479-3 chrZ 60649964 60650041     
gga-mir-3607 chrZ 61061980 61062087     
gga-mir-1756a chrZ 62615973 62616062     
gga-mir-7481 chrZ 64128336 64128387     
gga-mir-7440 chrZ 64494384 64494452     
gga-mir-1452 chrZ 66266224 66266301     
gga-mir-1459 chrZ 66269415 66269499     
gga-mir-7437 chrZ 68307634 68307708     
gga-mir-2954 chrZ 70557171 70557238     
gga-mir-1583 chrZ 70558469 70558566     
gga-mir-2131 chrZ 70567945 70568033     
gga-mir-7438 chrZ 70599677 70599741     
gga-mir-31 chrZ 78336380 78336473     
gga-mir-7483 chrZ 81357266 81357322

There are some duplicated lines in file A and there is no duplicated lines in file B. Some lines in file A can exactly match the first portion of a line in file B. For example, the line 1 in file A is
Code:
gga-mir-181b-1

, and it matches the line 617 in file B
Code:
gga-mir-181b-1 chr8 1986876 1986964

and I want this line 617 in file B as the output for the first line. Some lines in file A has no matching lines in file B and I want the output is N/A. So I expect the output file should have the same 102 lines as file A and the output file is like this
Code:
gga-mir-181b-1 chr8 1986876 1986964
gga-mir-181b-2 chr17 9498543 9498627     
gga-mir-199-1 chr17 5034551 5034644     
N/A
gga-mir-204-1 chrZ 35040031 35040134     
...

. I was trying to use this script
Code:
grep -Fwf file_A file_B

. but the output file removed the duplicated matching lines and the matching line order is not based on the line order in file A. I hope some one can help me. Thank you!
# 2  
Old 03-18-2015
Here is a solution that is slow but uses little memory.
Code:
#!/bin/sh
while read line
do
  awk '($1==search) {print; exit 1}' search="$line" file_B && echo "N/A"
done < file_A

This User Gave Thanks to MadeInGermany For This Post:
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to control grep output intact for each matching line?

I have multiple (~80) files (some can be as big as 30GB of >1 billion of lines!) to grep on a pattern, and piped the match to a single file. I have a 96-core machine so that each grep job was sent to the background to speed up the search: file1.tab chr1A_part1 123241847 123241848... (6 Replies)
Discussion started by: yifangt
6 Replies

2. Shell Programming and Scripting

Expect pattern matching in the command output

This is the command output need to be matched: Telnet console listening to port 42365. (the port number changes every time) Code to test it: ======================================= #!/tools/AGRtools/bin/expect exp_internal 1 set timeout 10 spawn bash set bashId $spawn_id ... (4 Replies)
Discussion started by: marsala
4 Replies

3. Shell Programming and Scripting

Pattern Matching and creating output

HI Unix Forum, My requirement I have two set of Patterns UBA and CIE for which different Phases are there which will have Start and End time. They are not in same order. I want the o/p in the below mentioned format. Eg: Mangolia Alien 03:04:56 Phase 0 started (10... (5 Replies)
Discussion started by: TechGyaann
5 Replies

4. Shell Programming and Scripting

Formatting The Output Files & Matching Keys

I have the following 2 output files, one contain the standard output after i decrypt the encrypted file and another keys listed from the gpg trust db, Provider File: gpg: encrypted with 2048-bit RSA key, ID 96301328, created 2014-04-29 "JKL <400@abc.com>" gpg: encrypted with 2048-bit... (2 Replies)
Discussion started by: Ariean
2 Replies

5. Shell Programming and Scripting

Df -h | awk - output incorrect matching

Running solaris 9, on issuing the follwing command df -h | awk '$5 > 45 {print}' Filesystems with utilisation > 45% are being displayed as well as those between 5 and-9%!!! (3 Replies)
Discussion started by: squrcles
3 Replies

6. UNIX for Dummies Questions & Answers

Matching position and output neighbors within 500 distant

Hi, I have been struggling to match positions output its neigbors. Can you please help ? I have 2 files.They both have the same format (same number of columns) but first file is a kind of subset of second file The first file looks like this (tab delimited): 1 11567687 snpid20 1 153881... (4 Replies)
Discussion started by: fat
4 Replies

7. Shell Programming and Scripting

awk file comparison, x lines after matching as output

Hello, I couldn't find anything on the Forum that would help me to solve this problem. Could any body help me process below data using awk? I have got two files: file1: Worker1: Thomas Position: Manager Department: Sales Salary: $5,000 Worker2: Jason Position: ... (5 Replies)
Discussion started by: killerbee
5 Replies

8. UNIX for Dummies Questions & Answers

Noob questions.. Append output to a file in different directory

Noob question! I know almost nothing so far, and I'm trying to teach myself from books, on a typical command line without using scripts how would I append output from a sort to a file in a completely different directory? example: If I'm sorting a file in my documents directory but I... (2 Replies)
Discussion started by: Byrang
2 Replies

9. Linux

problem of wild cards matching..$ls t[A-Z] output

hi all, i have created a file by name tt and while listing the file ,i used the command $ls t from which i was expecting not to list tt file output coz of uppercase range, But it listed that file tt file and am not able understand the reason. kindly help. NOTE OS :Red Hat Enterprise... (0 Replies)
Discussion started by: rajp_8007
0 Replies

10. Shell Programming and Scripting

awk should output if one input file doesnt have matching key

nawk -F, 'FNR==NR{a= $3 ;next} $2 in a{print $1, 'Person',$2, a}' OFS=, filea fileb Input filea Input fileb output i am getting : (2 Replies)
Discussion started by: pinnacle
2 Replies
Login or Register to Ask a Question