contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJEB9859" and tax_kingdom = "Metazoa"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6523316 | 6523316 | PRJEB9859_P_NODE_8206_length_197_cov_21.184524_g8171_i0 | PRJEB9859 | 8206 | 197 | 21.184524 | 41.73351228 | Cephus cinctus | 211228 | Arthropoda | Arthropoda | 85.9 | 1.21e-17 | NR | XP_024939559.1 | 211228 | g8171 | i0 | 66.7 | 5.93908629441624 | 54 | 18 | 82.2 | 0 | 170 | 9 | 213 | 266 | XP_024939559.1 glutathione hydrolase 1 proenzyme isoform X2 [Cephus cinctus] | diamond | 1170 | 85.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Cephidae | Cephus | Cephus cinctus | |
| 10347984 | 10347984 | PRJEB9859_P_NODE_2069_length_316_cov_7.156794_g2034_i0 | PRJEB9859 | 2069 | 316 | 7.156794 | 22.61546904 | Daphnia pulex | 6669 | Arthropoda | Arthropoda | 139 | 7.73e-40 | NR | EFX60013.1 | 6669 | g2034 | i0 | 82.3 | 1.57594936708861 | 79 | 14 | 75 | 0 | 25 | 261 | 67 | 145 | EFX60013.1 hypothetical protein DAPPUDRAFT_73053 [Daphnia pulex] | diamond | 498 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Diplostraca | Daphniidae | Daphnia | Daphnia pulex | |
| 14173497 | 14173497 | PRJEB9859_P_NODE_1032_length_390_cov_3.210526_g998_i0 | PRJEB9859 | 1032 | 390 | 3.210526 | 12.5210514 | Metazoa | 33208 | Arthropoda | Arthropoda | 149 | 3.27e-43 | NR | OTF70000.1 | 6958 | g998 | i0 | 71.6 | 11.9 | 95 | 27 | 73.1 | 0 | 387 | 103 | 74 | 168 | OTF70000.1 60S ribosomal protein L11-like protein [Euroglyphus maynei] | diamond | 4641 | 150 | 0.993333333333333 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Pyroglyphidae | Euroglyphus | Euroglyphus maynei | |
| 26646870 | 26646870 | PRJEB9859_P_NODE_3481_length_267_cov_7.344538_g3446_i0 | PRJEB9859 | 3481 | 267 | 7.344538 | 19.60991646 | Metazoa | 33208 | Arthropoda | Arthropoda | 67 | 9.96e-12 | NR | XP_055701935.1 | 29031 | g3446 | i0 | 48.6 | 9.33707865168539 | 72 | 36 | 80.9 | 1 | 2 | 217 | 70 | 140 | XP_055701935.1 40S ribosomal protein S12 [Phlebotomus papatasi] | diamond | 2493 | 67.4 | 0.99406528189911 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Psychodidae | Phlebotomus | Phlebotomus papatasi | |
| 26741690 | 26741690 | PRJEB9859_P_NODE_2081_length_316_cov_1.519164_g2046_i0 | PRJEB9859 | 2081 | 316 | 1.519164 | 4.80055824 | Metazoa | 33208 | Rotifera | other_Eukaryota | 66.6 | 3.71e-10 | NR | CAF0946957.1 | 249248 | g2046 | i0 | 39.5 | 7.13924050632911 | 76 | 44 | 72.2 | 1 | 315 | 88 | 890 | 963 | CAF0946957.1 unnamed protein product [Adineta ricciae] | diamond | 2256 | 67 | 0.994029850746269 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 26876425 | 26876425 | PRJEB9859_P_NODE_3641_length_263_cov_3.632479_g3606_i0 | PRJEB9859 | 3641 | 263 | 3.632479 | 9.55341977 | Acrostichus sp. RS5 | 669107 | Nematoda | Nematoda | 58.9 | 8.02e-9 | NR | ACV21050.1 | 669107 | g3606 | i0 | 58.5 | 1.3574144486692 | 53 | 18 | 60.5 | 1 | 210 | 52 | 67 | 115 | ACV21050.1 large subunit ribosomal protein 35, partial [Acrostichus sp. RS5083] | diamond | 357 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Acrostichus | Acrostichus sp. RS5083 | |
| 27318978 | 27318978 | PRJEB9859_P_NODE_5603_length_242_cov_1.042254_g5568_i0 | PRJEB9859 | 5603 | 242 | 1.042254 | 2.52225468 | Mesorhabditis spiculigera | 96644 | Nematoda | Nematoda | 49.7 | 1.32e-4 | NR | CAJ0567478.1 | 96644 | g5568 | i0 | 34.4 | 0.793388429752066 | 64 | 36 | 71.9 | 1 | 241 | 68 | 365 | 428 | CAJ0567478.1 unnamed protein product, partial [Mesorhabditis spiculigera] | diamond | 192 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis spiculigera | |
| 27532532 | 27532532 | PRJEB9859_P_NODE_1143_length_378_cov_1.229226_g1109_i0 | PRJEB9859 | 1143 | 378 | 1.229226 | 4.64647428 | Opisthokonta | 33154 | Chordata | Chordata | 79.3 | 2.52e-14 | NR | XP_039250853.1 | 7725 | g1109 | i0 | 45.5 | 8.46031746031746 | 88 | 38 | 69.8 | 1 | 378 | 115 | 412 | 489 | XP_039250853.1 ATP-dependent RNA helicase DDX19A-like [Styela clava] | diamond | 3198 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 27627430 | 27627430 | PRJEB9859_P_NODE_4804_length_246_cov_3.658986_g4769_i0 | PRJEB9859 | 4804 | 246 | 3.658986 | 9.00110556 | Opisthokonta | 33154 | Chordata | Chordata | 65.1 | 2.34e-11 | NR | XP_039259620.1 | 7725 | g4769 | i0 | 57.4 | 7.58536585365854 | 61 | 26 | 74.4 | 0 | 236 | 54 | 46 | 106 | XP_039259620.1 40S ribosomal protein S25-like [Styela clava] | diamond | 1866 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 28100723 | 28100723 | PRJEB9859_P_NODE_365_length_532_cov_3.773360_g342_i0 | PRJEB9859 | 365 | 532 | 3.77336 | 20.0742752 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 165 | 9.86e-49 | NR | XP_009021356.1 | 6412 | g342 | i0 | 60.8 | 7.55639097744361 | 120 | 47 | 67.7 | 0 | 500 | 141 | 7 | 126 | XP_009021356.1 hypothetical protein HELRODRAFT_157357 [Helobdella robusta] | diamond | 4020 | 166 | 0.993975903614458 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28108079 | 28108079 | PRJEB9859_P_NODE_1385_length_359_cov_2.093939_g1350_i0 | PRJEB9859 | 1385 | 359 | 2.093939 | 7.51724101 | Idotea baltica | 82763 | Arthropoda | Arthropoda | 89.7 | 1.11e-20 | NR | MCL4170146.1 | 82763 | g1350 | i0 | 57.5 | 0.668523676880223 | 80 | 34 | 66.9 | 0 | 6 | 245 | 12 | 91 | MCL4170146.1 hypothetical protein [Idotea baltica] | diamond | 240 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Isopoda | Idoteidae | Idotea | Idotea baltica | |
| 28329185 | 28329185 | PRJEB9859_P_NODE_3146_length_277_cov_2.120968_g3111_i0 | PRJEB9859 | 3146 | 277 | 2.120968 | 5.87508136 | Liolophura japonica | 13599 | Mollusca | Mollusca | 68.2 | 4.06e-11 | NR | XP_064604563.1 | 13599 | g3111 | i0 | 69.6 | 0.498194945848375 | 46 | 14 | 49.8 | 0 | 275 | 138 | 255 | 300 | XP_064604563.1 uncharacterized protein LOC135469869 [Liolophura japonica] | diamond | 138 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 28582015 | 28582015 | PRJEB9859_P_NODE_4487_length_249_cov_1.009091_g4452_i0 | PRJEB9859 | 4487 | 249 | 1.009091 | 2.51263659 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 68.9 | 9.92e-13 | NR | RMZ92811.1 | 10195 | g4452 | i0 | 64 | 0.602409638554217 | 50 | 18 | 60.2 | 0 | 249 | 100 | 73 | 122 | RMZ92811.1 COMM domain-containing 3 [Brachionus plicatilis] | diamond | 150 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 28606055 | 28606055 | PRJEB9859_P_NODE_3667_length_263_cov_1.508547_g3632_i0 | PRJEB9859 | 3667 | 263 | 1.508547 | 3.96747861 | Opisthokonta | 33154 | Annelida | Annelida | 83.6 | 1.21e-16 | NR | CAH1788497.1 | 6347 | g3632 | i0 | 55.2 | 3.05703422053232 | 67 | 30 | 76.4 | 0 | 262 | 62 | 298 | 364 | CAH1788497.1 unnamed protein product [Owenia fusiformis] | diamond | 804 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28897475 | 28897475 | PRJEB9859_P_NODE_3048_length_280_cov_6.657371_g3013_i0 | PRJEB9859 | 3048 | 280 | 6.657371 | 18.6406388 | Batillaria attramentaria | 370345 | Mollusca | Mollusca | 122 | 1.7599999999999998e-31 | NR | KAK7487324.1 | 370345 | g3013 | i0 | 78.6 | 3.65357142857143 | 70 | 15 | 75 | 0 | 278 | 69 | 267 | 336 | KAK7487324.1 hypothetical protein BaRGS_00021413 [Batillaria attramentaria] | diamond | 1023 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Batillariidae | Batillaria | Batillaria attramentaria | ||
| 29718254 | 29718254 | PRJEB9859_P_NODE_210_length_639_cov_7.260656_g199_i0 | PRJEB9859 | 210 | 639 | 7.260656 | 46.39559184 | Lepeophtheirus salmonis | 72036 | Arthropoda | Arthropoda | 115 | 3.1699999999999998e-28 | NR | ADD38186.1 | 72036 | g199 | i0 | 37.6 | 0.849765258215962 | 181 | 104 | 84 | 2 | 637 | 101 | 16 | 189 | ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis] | diamond | 543 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Hexanauplia | Siphonostomatoida | Caligidae | Lepeophtheirus | Lepeophtheirus salmonis | |
| 29971152 | 29971152 | PRJEB9859_P_NODE_4771_length_247_cov_1.018349_g4736_i0 | PRJEB9859 | 4771 | 247 | 1.018349 | 2.51532203 | Limnephilus lunatus | 1218281 | Arthropoda | Arthropoda | 48.9 | 2.52e-4 | NR | WIM01487.1 | 1218281 | g4736 | i0 | 60.5 | 0.461538461538462 | 38 | 15 | 46.2 | 0 | 3 | 116 | 504 | 541 | WIM01487.1 T-complex protein 1 subunit eta [Limnephilus lunatus] | diamond | 114 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Trichoptera | Limnephilidae | Limnephilus | Limnephilus lunatus | |
| 30027123 | 30027123 | PRJEB9859_P_NODE_4191_length_251_cov_1.612613_g4156_i0 | PRJEB9859 | 4191 | 251 | 1.612613 | 4.04765863 | Metazoa | 33208 | Chordata | Chordata | 54.3 | 2.82e-6 | NR | CAB3265758.1 | 59560 | g4156 | i0 | 45.3 | 2.86852589641434 | 53 | 29 | 63.3 | 0 | 249 | 91 | 212 | 264 | CAB3265758.1 40S ribosomal protein S2 [Phallusia mammillata] | diamond | 720 | 54.7 | 0.992687385740402 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Ascidiidae | Phallusia | Phallusia mammillata | |
| 30160514 | 30160514 | PRJEB9859_P_NODE_872_length_409_cov_1.918421_g838_i0 | PRJEB9859 | 872 | 409 | 1.918421 | 7.84634189 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 144 | 7.91e-40 | NR | XP_001639308.1 | 45351 | g838 | i0 | 60 | 1.76039119804401 | 120 | 48 | 88 | 0 | 408 | 49 | 143 | 262 | XP_001639308.1 60S ribosomal protein L7a [Nematostella vectensis] | diamond | 720 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 30785263 | 30785263 | PRJEB9859_P_NODE_1314_length_364_cov_1.907463_g1279_i0 | PRJEB9859 | 1314 | 364 | 1.907463 | 6.94316532 | Opisthokonta | 33154 | Arthropoda | Arthropoda | 122 | 1.35e-32 | NR | NP_476778.1 | 7227 | g1279 | i0 | 67 | 21.7087912087912 | 94 | 26 | 77.5 | 1 | 348 | 67 | 64 | 152 | NP_476778.1 ribosomal protein S27A [Drosophila melanogaster] | diamond | 7902 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Drosophilidae | Drosophila | Drosophila melanogaster | |
| 31139813 | 31139813 | PRJEB9859_P_NODE_5015_length_245_cov_1.120370_g4980_i0 | PRJEB9859 | 5015 | 245 | 1.12037 | 2.7449065 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 57.8 | 9.64e-8 | NR | CAF1423921.1 | 1234261 | g4980 | i0 | 52.9 | 1.2 | 51 | 23 | 61.2 | 1 | 42 | 191 | 108 | 158 | CAF1423921.1 unnamed protein product [Didymodactylos carnosus] | diamond | 294 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 31354224 | 31354224 | PRJEB9859_P_NODE_2816_length_288_cov_1.648649_g2781_i0 | PRJEB9859 | 2816 | 288 | 1.648649 | 4.74810912 | Brachionus | 10194 | Rotifera | other_Eukaryota | 101 | 6.52e-25 | NR | RMZ96144.1 | 10195 | g2781 | i0 | 75.8 | 1.375 | 66 | 16 | 68.8 | 0 | 3 | 200 | 86 | 151 | RMZ96144.1 40S ribosomal S19a-like [Brachionus plicatilis] | diamond | 396 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 31361682 | 31361682 | PRJEB9859_P_NODE_1356_length_361_cov_2.807229_g1321_i0 | PRJEB9859 | 1356 | 361 | 2.807229 | 10.13409669 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 66.2 | 7.66e-10 | NR | PAA86220.1 | 282301 | g1321 | i0 | 42.2 | 1.37950138504155 | 83 | 44 | 67.3 | 2 | 33 | 275 | 156 | 236 | PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] | diamond | 498 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31449128 | 31449128 | PRJEB9859_P_NODE_2676_length_292_cov_3.399240_g2641_i0 | PRJEB9859 | 2676 | 292 | 3.39924 | 9.9257808 | Insecta | 50557 | Arthropoda | Arthropoda | 88.2 | 2.87e-19 | NR | XP_068905359.1 | 7067 | g2641 | i0 | 51.9 | 5.49657534246575 | 79 | 38 | 81.2 | 0 | 257 | 21 | 63 | 141 | XP_068905359.1 large ribosomal subunit protein eL13-like [Tenebrio molitor] | diamond | 1605 | 89 | 0.991011235955056 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Tenebrionidae | Tenebrio | Tenebrio molitor | |
| 32588088 | 32588088 | PRJEB9859_P_NODE_3139_length_277_cov_3.318548_g3104_i0 | PRJEB9859 | 3139 | 277 | 3.318548 | 9.19237796 | Arthropoda | 6656 | Arthropoda | Arthropoda | 76.6 | 2e-15 | NR | XP_037794350.1 | 6687 | g3104 | i0 | 70.7 | 24.4440433212996 | 58 | 17 | 62.8 | 0 | 257 | 84 | 82 | 139 | XP_037794350.1 uncharacterized protein LOC119589836 isoform X1 [Penaeus monodon] | diamond | 6771 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Penaeidae | Penaeus | Penaeus monodon |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;