contig_metadata
26 rows where analysis = "blastn", bioproject = "PRJEB73599" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 135176 | 135176 | PRJEB73599_P_NODE_3661_length_368_cov_1.769912_g3375_i0 | PRJEB73599 | 3661 | 368 | 1.769912 | 6.51327616 | Penaeus monodon | 6687 | Arthropoda | Arthropoda | 165 | 4.2999999999999995e-36 | NTclustered | gi|148646394|gb|EF426560.1| | 6687 | g3375 | i0 | 85.185 | 5.6929347826087 | 162 | 22 | 44 | 2 | 3 | 163 | 1680 | 1520 | Penaeus monodon elongation factor 2 mRNA, complete cds | blastn | 2095 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Penaeidae | Penaeus | Penaeus monodon | |
| 3546078 | 3546078 | PRJEB73599_P_NODE_623_length_945_cov_29.326419_g502_i0 | PRJEB73599 | 623 | 945 | 29.326419 | 277.13465955 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 219 | 8.91e-52 | NTclustered | gi|34495333|gb|AY303975.1| | 10228 | g502 | i0 | 92.308 | 16.9280423280423 | 156 | 9 | 17 | 2 | 294 | 449 | 1408 | 1560 | Trichoplax adhaerens 28S ribosomal RNA gene, partial sequence | blastn | 15997 | 219 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 3961267 | 3961267 | PRJEB73599_P_NODE_2964_length_421_cov_5.318878_g2682_i0 | PRJEB73599 | 2964 | 421 | 5.318878 | 22.39247638 | Keratella quadrata | 204742 | Rotifera | other_Eukaryota | 396 | 1.63e-105 | NTclustered | gi|83285188|gb|DQ297735.1| | 204742 | g2682 | i0 | 83.765 | 66.855106888361 | 425 | 62 | 100 | 7 | 1 | 421 | 738 | 317 | Keratella quadrata 28S ribosomal RNA gene, partial sequence | blastn | 28146 | 396 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Keratella | Keratella quadrata | |
| 4823564 | 4823564 | PRJEB73599_P_NODE_2464_length_470_cov_12.102041_g2196_i0 | PRJEB73599 | 2464 | 470 | 12.102041 | 56.8795927 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 316 | 1.4699999999999996e-81 | NTclustered | gi|1230128092|ref|XM_022322392.1| | 13164 | g2196 | i0 | 83.631 | 177.96170212766 | 336 | 55 | 71 | 0 | 135 | 470 | 795 | 460 | PREDICTED: Myzus persicae polyubiquitin-G (LOC111039080), mRNA | blastn | 83642 | 316 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Aphididae | Myzus | Myzus persicae | |
| 5237730 | 5237730 | PRJEB73599_P_NODE_4665_length_308_cov_2.060932_g4378_i0 | PRJEB73599 | 4665 | 308 | 2.060932 | 6.34767056 | Drosophila serrata | 7274 | Arthropoda | Arthropoda | 326 | 1.53e-84 | NTclustered | gi|1189070371|ref|XM_020947228.1| | 7274 | g4378 | i0 | 85.902 | 248.730519480519 | 305 | 43 | 99 | 0 | 2 | 306 | 2279 | 1975 | PREDICTED: Drosophila serrata polyubiquitin-C (LOC110179621), mRNA | blastn | 76609 | 326 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Drosophilidae | Drosophila | Drosophila serrata | |
| 5237737 | 5237737 | PRJEB73599_P_NODE_5245_length_281_cov_2.928571_g4958_i0 | PRJEB73599 | 5245 | 281 | 2.928571 | 8.22928451 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 209 | 1.45e-49 | NTclustered | gi|2782844603|ref|XM_067056021.1| | 252671 | g4958 | i0 | 81.061 | 41.5658362989324 | 264 | 48 | 94 | 2 | 15 | 277 | 96 | 358 | PREDICTED: Clytia hemisphaerica tubulin beta-4B chain (LOC136799316), mRNA | blastn | 11680 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 6513292 | 6513292 | PRJEB73599_P_NODE_6406_length_237_cov_3.038462_g6119_i0 | PRJEB73599 | 6406 | 237 | 3.038462 | 7.20115494 | Brachionus urceolaris | 204736 | Rotifera | other_Eukaryota | 320 | 5.28e-83 | NTclustered | gi|72153738|gb|DQ089740.1| | 204736 | g6119 | i0 | 91.176 | 43.3459915611814 | 238 | 18 | 100 | 3 | 1 | 237 | 2065 | 1830 | Brachionus urceolaris 28S ribosomal RNA gene, partial sequence | blastn | 10273 | 320 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus urceolaris | |
| 9062463 | 9062463 | PRJEB73599_P_NODE_6508_length_234_cov_2.107317_g6221_i0 | PRJEB73599 | 6508 | 234 | 2.107317 | 4.93112178 | Siphonaria japonica | 981056 | Mollusca | Mollusca | 89.8 | 1.6e-13 | NTclustered | gi|1229196001|gb|KX529886.1| | 981056 | g6221 | i0 | 79.675 | 4.88034188034188 | 123 | 25 | 53 | 0 | 106 | 228 | 738 | 860 | Siphonaria japonica beta-tubulin mRNA, partial cds | blastn | 1142 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Siphonariida | Siphonariidae | Siphonaria | Siphonaria japonica | |
| 9062469 | 9062469 | PRJEB73599_P_NODE_7108_length_216_cov_1.903743_g6821_i0 | PRJEB73599 | 7108 | 216 | 1.903743 | 4.11208488 | Flustra foliacea | 478208 | Bryozoa | other_Eukaryota | 163 | 8.44e-36 | NTclustered | gi|158524727|gb|EU074268.1| | 478208 | g6821 | i0 | 85.443 | 18.3888888888889 | 158 | 21 | 72 | 2 | 14 | 169 | 348 | 505 | Flustra foliacea mitochondrial ATP synthase beta subunit mRNA, partial cds; nuclear gene for mitochondrial product | blastn | 3972 | 163 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Flustridae | Flustra | Flustra foliacea | |
| 10338254 | 10338254 | PRJEB73599_P_NODE_8869_length_173_cov_2.944444_g8582_i0 | PRJEB73599 | 8869 | 173 | 2.944444 | 5.09388812 | Encentrum tectipes | 360662 | Rotifera | other_Eukaryota | 176 | 8.26e-40 | NTclustered | gi|83285187|gb|DQ297734.1| | 360662 | g8582 | i0 | 85.057 | 37.2601156069364 | 174 | 24 | 99 | 2 | 2 | 173 | 1 | 174 | Encentrum tectipes 28S ribosomal RNA gene, partial sequence | blastn | 6446 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Dicranophoridae | Encentrum | Encentrum tectipes | |
| 11198800 | 11198800 | PRJEB73599_P_NODE_2929_length_423_cov_8.449239_g2647_i0 | PRJEB73599 | 2929 | 423 | 8.449239 | 35.74028097 | Ploima | 84394 | Rotifera | other_Eukaryota | 387 | 9.83e-103 | NTclustered | gi|83285199|gb|DQ297746.1| | 360681 | g2647 | i0 | 83.333 | 67.4397163120567 | 432 | 59 | 100 | 9 | 1 | 423 | 317 | 744 | Mytilina mucronata 28S ribosomal RNA gene, partial sequence | blastn | 28527 | 387 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Mytilina | Mytilina mucronata | |
| 11613665 | 11613665 | PRJEB73599_P_NODE_3190_length_402_cov_3.613941_g2904_i0 | PRJEB73599 | 3190 | 402 | 3.613941 | 14.52804282 | Monommata maculata | 360679 | Rotifera | other_Eukaryota | 285 | 3.4899999999999997e-72 | NTclustered | gi|83285198|gb|DQ297745.1| | 360679 | g2904 | i0 | 82.749 | 17.4253731343284 | 342 | 38 | 83 | 16 | 71 | 402 | 410 | 740 | Monommata maculata 28S ribosomal RNA gene, partial sequence | blastn | 7005 | 285 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Notommatidae | Monommata | Monommata maculata | |
| 11613723 | 11613723 | PRJEB73599_P_NODE_9270_length_166_cov_2.218978_g8983_i0 | PRJEB73599 | 9270 | 166 | 2.218978 | 3.68350348 | Psocoptera sp. PS02 | 1291676 | Arthropoda | Arthropoda | 78.7 | 2.29e-10 | NTclustered | gi|449084630|gb|KC513101.1| | 1291676 | g8983 | i0 | 92.593 | 0.650602409638554 | 54 | 4 | 33 | 0 | 113 | 166 | 1025 | 1078 | Psocoptera sp. PS02 28S ribosomal RNA gene, partial sequence | blastn | 108 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Psocoptera sp. PS02 | |||
| 12474460 | 12474460 | PRJEB73599_P_NODE_5910_length_254_cov_4.413333_g5623_i0 | PRJEB73599 | 5910 | 254 | 4.413333 | 11.20986582 | Ploima | 84394 | Rotifera | other_Eukaryota | 368 | 2.02e-97 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g5623 | i0 | 92.913 | 87.9803149606299 | 254 | 17 | 100 | 1 | 1 | 254 | 1705 | 1453 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 22347 | 370 | 0.994594594594595 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 13748928 | 13748928 | PRJEB73599_P_NODE_6751_length_226_cov_3.360406_g6464_i0 | PRJEB73599 | 6751 | 226 | 3.360406 | 7.59451756 | Plexauridae | 44191 | Cnidaria | other_Eukaryota | 89.8 | 1.53e-13 | NTclustered | gi|2689317080|gb|PP410637.1| | 1329949 | g6464 | i0 | 91.935 | 3.2787610619469 | 62 | 5 | 27 | 0 | 2 | 63 | 3580 | 3519 | Swiftia koreni voucher USNM:55966 large subunit ribosomal RNA gene, partial sequence | blastn | 741 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Swiftia | Swiftia koreni | |
| 14163562 | 14163562 | PRJEB73599_P_NODE_2592_length_457_cov_3.070093_g2319_i0 | PRJEB73599 | 2592 | 457 | 3.070093 | 14.03032501 | Vespula pensylvanica | 30213 | Arthropoda | Arthropoda | 182 | 5.42e-41 | NTclustered | gi|2098661466|ref|XM_043811691.1| | 30213 | g2319 | i0 | 86.585 | 44.054704595186 | 164 | 22 | 36 | 0 | 252 | 415 | 294 | 131 | PREDICTED: Vespula pensylvanica ubiquitin-40S ribosomal protein S27a (LOC122628880), mRNA | blastn | 20133 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Vespidae | Vespula | Vespula pensylvanica | |
| 15437668 | 15437668 | PRJEB73599_P_NODE_5513_length_270_cov_1.659751_g5226_i0 | PRJEB73599 | 5513 | 270 | 1.659751 | 4.4813277 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g5226 | i0 | 100 | 0.107407407407407 | 29 | 0 | 11 | 0 | 236 | 264 | 10839856 | 10839828 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 16711831 | 16711831 | PRJEB73599_P_NODE_2514_length_465_cov_6.465596_g2243_i0 | PRJEB73599 | 2514 | 465 | 6.465596 | 30.0650214 | Nanorchestes sp. AD1283 | 2051758 | Arthropoda | Arthropoda | 89.8 | 3.44e-13 | NTclustered | gi|1282187771|gb|KY921976.1| | 2051758 | g2243 | i0 | 88.889 | 15.305376344086 | 72 | 8 | 15 | 0 | 129 | 200 | 1698 | 1769 | Nanorchestes sp. AD1283 voucher UMMZ BMOC 08-0812-002 AD1283 28S ribosomal RNA gene, partial sequence | blastn | 7117 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Nanorchestidae | Nanorchestes | Nanorchestes sp. AD1283 | |
| 16711832 | 16711832 | PRJEB73599_P_NODE_2654_length_450_cov_3.624703_g2379_i0 | PRJEB73599 | 2654 | 450 | 3.624703 | 16.3111635 | Arthropoda environmental sample | 260574 | Arthropoda | Arthropoda | 520 | 9.939999999999997e-143 | NTclustered | gi|683809786|gb|KC266787.1| | 260574 | g2379 | i0 | 98.328 | 99.9555555555555 | 299 | 0 | 66 | 5 | 153 | 450 | 1 | 295 | Arthropoda environmental sample clone HENBPVM09FOE5C1 cytochrome c oxidase 1-like gene, partial sequence; mitochondrial | blastn | 44980 | 520 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arthropoda environmental sample | |||||
| 16711846 | 16711846 | PRJEB73599_P_NODE_4134_length_337_cov_3.957792_g3847_i0 | PRJEB73599 | 4134 | 337 | 3.957792 | 13.33775904 | Sitophilus oryzae | 7048 | Arthropoda | Arthropoda | 115 | 4e-21 | NTclustered | gi|1746720267|ref|XM_030895823.1| | 7048 | g3847 | i0 | 92.5 | 6.10979228486647 | 80 | 6 | 24 | 0 | 1 | 80 | 1383 | 1462 | PREDICTED: Sitophilus oryzae tubulin alpha-1 chain (LOC115879149), mRNA | blastn | 2059 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Curculionidae | Sitophilus | Sitophilus oryzae | |
| 17986749 | 17986749 | PRJEB73599_P_NODE_4235_length_332_cov_1.706271_g3948_i0 | PRJEB73599 | 4235 | 332 | 1.706271 | 5.66481972 | Polypodium hydriforme | 43186 | Cnidaria | other_Eukaryota | 54.7 | 0.009 | NTclustered | gi|2663986578|emb|OY756919.1| | 43186 | g3948 | i0 | 100 | 0.0873493975903614 | 29 | 0 | 9 | 0 | 79 | 107 | 6126 | 6154 | Polypodium hydriforme genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Polypodiozoa | Polypodiidea | Polypodiidae | Polypodium | Polypodium hydriforme | |
| 19260757 | 19260757 | PRJEB73599_P_NODE_2456_length_471_cov_2.208145_g2189_i0 | PRJEB73599 | 2456 | 471 | 2.208145 | 10.40036295 | Anopheles moucheti | 186751 | Arthropoda | Arthropoda | 52.8 | 0.046 | NTclustered | gi|2429159303|ref|XM_053034811.1| | 186751 | g2189 | i0 | 100 | 0.059447983014862 | 28 | 0 | 6 | 0 | 411 | 438 | 2753 | 2726 | PREDICTED: Anopheles moucheti centrosomal and chromosomal factor (LOC128298985), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Anopheles | Anopheles moucheti | |
| 19260766 | 19260766 | PRJEB73599_P_NODE_3336_length_392_cov_2.578512_g3050_i0 | PRJEB73599 | 3336 | 392 | 2.578512 | 10.10776704 | Ascomorpha ovalis | 360655 | Rotifera | other_Eukaryota | 303 | 9.37e-78 | NTclustered | gi|83285183|gb|DQ297730.1| | 360655 | g3050 | i0 | 80 | 16.4285714285714 | 400 | 69 | 100 | 10 | 1 | 392 | 341 | 737 | Ascomorpha ovalis 28S ribosomal RNA gene, partial sequence | blastn | 6440 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Gastropidae | Ascomorpha | Ascomorpha ovalis | |
| 19260801 | 19260801 | PRJEB73599_P_NODE_8276_length_185_cov_4.724359_g7989_i0 | PRJEB73599 | 8276 | 185 | 4.724359 | 8.74006415 | invertebrate environmental sample | 693772 | Root_unresolved | Root_unresolved | 239 | 1.13e-58 | NTclustered | gi|283050937|gb|GU070933.1| | 693772 | g7989 | i0 | 95.918 | 94.1297297297297 | 147 | 6 | 79 | 0 | 1 | 147 | 569 | 715 | Invertebrate environmental sample clone B05 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 17414 | 239 | 1 | Eukaryota | Opisthokonta | Metazoa | invertebrate environmental sample | ||||||
| 21811978 | 21811978 | PRJEB73599_P_NODE_9138_length_168_cov_4.517986_g8851_i0 | PRJEB73599 | 9138 | 168 | 4.517986 | 7.59021648 | Encentrum tectipes | 360662 | Rotifera | other_Eukaryota | 237 | 3.63e-58 | NTclustered | gi|83285187|gb|DQ297734.1| | 360662 | g8851 | i0 | 92.262 | 64.6428571428571 | 168 | 11 | 100 | 2 | 1 | 168 | 908 | 743 | Encentrum tectipes 28S ribosomal RNA gene, partial sequence | blastn | 10860 | 237 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Dicranophoridae | Encentrum | Encentrum tectipes | |
| 23086994 | 23086994 | PRJEB73599_P_NODE_6439_length_236_cov_2.966184_g6152_i0 | PRJEB73599 | 6439 | 236 | 2.966184 | 7.00019424 | Myxidium coryphaenoideum | 371538 | Cnidaria | other_Eukaryota | 121 | 5.72e-23 | NTclustered | gi|241911754|gb|FJ417060.1| | 371538 | g6152 | i0 | 86.486 | 15.4110169491525 | 111 | 14 | 47 | 1 | 19 | 129 | 392 | 283 | Myxidium coryphaenoideum isolate M0409 28S large subunit ribosomal RNA gene, partial sequence | blastn | 3637 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium coryphaenoideum |
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);;