contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA1233465" and tax_phylum = "Echinodermata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32915348 | 32915348 | PRJNA1233465b_S_NODE_367649_length_162_cov_0.663717_g365964_i0 | PRJNA1233465 | 367649 | 162 | 0.663717 | 1.07522154 | Hyocrinidae sp. | 3078845 | Echinodermata | other_Eukaryota | 63.5 | 5.31e-10 | NR | WNS59349.1 | 3078845 | g365964 | i0 | 62.3 | 0.981481481481482 | 53 | 20 | 98.1 | 0 | 3 | 161 | 111 | 163 | WNS59349.1 cytochrome b [Hyocrinidae sp.] | diamond | 159 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Hyocrinida | Hyocrinidae | Hyocrinidae sp. | ||
| 32915611 | 32915611 | PRJNA1233465d_S_NODE_149873_length_154_cov_2.428571_g148762_i0 | PRJNA1233465 | 149873 | 154 | 2.428571 | 3.73999934 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 41.6 | 0.00876 | NR | KAJ8043773.1 | 206669 | g148762 | i0 | 52.5 | 0.779220779220779 | 40 | 19 | 77.9 | 0 | 1 | 120 | 60 | 99 | KAJ8043773.1 hypothetical protein HOLleu_11030 [Holothuria leucospilota] | diamond | 120 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 32983133 | 32983133 | PRJNA1233465a_S_NODE_228019_length_165_cov_1.189655_g226745_i0 | PRJNA1233465 | 228019 | 165 | 1.189655 | 1.96293075 | Zoroaster ophiactis | 467010 | Echinodermata | other_Eukaryota | 44.7 | 8.05e-4 | NR | YP_010388449.1 | 467010 | g226745 | i0 | 53.2 | 1.83636363636364 | 47 | 22 | 85.5 | 0 | 3 | 143 | 43 | 89 | YP_010388449.1 NADH dehydrogenase subunit 3, partial [Zoroaster ophiactis] | diamond | 303 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Zoroasteridae | Zoroaster | Zoroaster ophiactis | |
| 32983394 | 32983394 | PRJNA1233465b_S_NODE_102563_length_272_cov_31.394619_g100878_i0 | PRJNA1233465 | 102563 | 272 | 31.394619 | 85.39336368 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 47.4 | 2.06e-4 | NR | KAJ8043773.1 | 206669 | g100878 | i0 | 51.1 | 1.06985294117647 | 47 | 23 | 51.8 | 0 | 30 | 170 | 53 | 99 | KAJ8043773.1 hypothetical protein HOLleu_11030 [Holothuria leucospilota] | diamond | 291 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 32985042 | 32985042 | PRJNA1233465e_S_NODE_91811_length_199_cov_3.353333_g90501_i0 | PRJNA1233465 | 91811 | 199 | 3.353333 | 6.67313267 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 40.8 | 0.0301 | NR | KAJ8043773.1 | 206669 | g90501 | i0 | 55.6 | 0.542713567839196 | 36 | 16 | 54.3 | 0 | 9 | 116 | 64 | 99 | KAJ8043773.1 hypothetical protein HOLleu_11030 [Holothuria leucospilota] | diamond | 108 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 32999819 | 32999819 | PRJNA1233465a_S_NODE_148051_length_196_cov_2.251701_g146777_i0 | PRJNA1233465 | 148051 | 196 | 2.251701 | 4.41333396 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 47.4 | 4.72e-4 | NR | PIK43814.1 | 307972 | g146777 | i0 | 47.7 | 0.673469387755102 | 44 | 23 | 67.3 | 0 | 186 | 55 | 449 | 492 | PIK43814.1 hypothetical protein BSL78_19340 [Apostichopus japonicus] | diamond | 132 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 33002209 | 33002209 | PRJNA1233465f_S_NODE_12731_length_558_cov_7.522593_g10686_i0 | PRJNA1233465 | 12731 | 558 | 7.522593 | 41.97606894 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 52.4 | 2.79e-5 | NR | KAJ8038144.1 | 206669 | g10686 | i0 | 40.8 | 0.553763440860215 | 103 | 58 | 55.4 | 1 | 191 | 499 | 7 | 106 | KAJ8038144.1 hypothetical protein HOLleu_19138 [Holothuria leucospilota] | diamond | 309 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 33033886 | 33033886 | PRJNA1233465a_S_NODE_107332_length_223_cov_1.160920_g106058_i0 | PRJNA1233465 | 107332 | 223 | 1.16092 | 2.5888516 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 45.4 | 0.00318 | NR | KAJ8020766.1 | 206669 | g106058 | i0 | 43.4 | 0.713004484304933 | 53 | 29 | 70 | 1 | 179 | 24 | 799 | 851 | KAJ8020766.1 RNA-directed DNA polymerase from mobile element jockey [Holothuria leucospilota] | diamond | 159 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 33043528 | 33043528 | PRJNA1233465f_S_NODE_229516_length_168_cov_1.159664_g227236_i0 | PRJNA1233465 | 229516 | 168 | 1.159664 | 1.94823552 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 55.5 | 4.28e-7 | NR | XP_033635072.1 | 7604 | g227236 | i0 | 61.1 | 78.125 | 54 | 21 | 96.4 | 0 | 2 | 163 | 118 | 171 | XP_033635072.1 tubulin alpha-2/alpha-4 chain-like isoform X3 [Asterias rubens] | diamond | 13125 | 55.8 | 0.99462365591397806 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 33051367 | 33051367 | PRJNA1233465a_S_NODE_63669_length_270_cov_17.425339_g62395_i0 | PRJNA1233465 | 63669 | 270 | 17.425339 | 47.0484153 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 47 | 2.82e-4 | NR | KAJ8043773.1 | 206669 | g62395 | i0 | 51.1 | 1.65555555555556 | 47 | 23 | 52.2 | 0 | 30 | 170 | 53 | 99 | KAJ8043773.1 hypothetical protein HOLleu_11030 [Holothuria leucospilota] | diamond | 447 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 33068074 | 33068074 | PRJNA1233465a_S_NODE_171381_length_185_cov_1.125000_g170107_i0 | PRJNA1233465 | 171381 | 185 | 1.125 | 2.08125 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 46.6 | 7.6e-4 | NR | XP_030848373.1 | 7668 | g170107 | i0 | 60 | 2.51351351351351 | 40 | 13 | 64.9 | 2 | 39 | 158 | 892 | 928 | XP_030848373.1 uncharacterized protein LOC592250 [Strongylocentrotus purpuratus] | diamond | 465 | 47 | 0.991489361702128 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 33087628 | 33087628 | PRJNA1233465f_S_NODE_179046_length_186_cov_1.562044_g176766_i0 | PRJNA1233465 | 179046 | 186 | 1.562044 | 2.90540184 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 43.1 | 0.00171 | NR | KAJ8033627.1 | 206669 | g176766 | i0 | 51.4 | 0.596774193548387 | 37 | 15 | 59.7 | 1 | 48 | 158 | 20 | 53 | KAJ8033627.1 hypothetical protein HOLleu_23936 [Holothuria leucospilota] | diamond | 111 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 33102767 | 33102767 | PRJNA1233465b_S_NODE_141902_length_241_cov_1.541667_g140217_i0 | PRJNA1233465 | 141902 | 241 | 1.541667 | 3.7154174700000002 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 56.2 | 4.68e-7 | NR | XP_030835901.1 | 7668 | g140217 | i0 | 37.8 | 0.921161825726141 | 74 | 42 | 87.1 | 1 | 221 | 12 | 105 | 178 | XP_030835901.1 uncharacterized protein LOC115921817 [Strongylocentrotus purpuratus] | diamond | 222 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 33103744 | 33103744 | PRJNA1233465d_S_NODE_67654_length_214_cov_1.612121_g66543_i0 | PRJNA1233465 | 67654 | 214 | 1.612121 | 3.44993894 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 55.5 | 5.98e-7 | NR | ACF74200.1 | 307972 | g66543 | i0 | 49.3 | 1.92056074766355 | 67 | 34 | 93.9 | 0 | 4 | 204 | 152 | 218 | ACF74200.1 beta-actin, partial [Apostichopus japonicus] | diamond | 411 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 33119217 | 33119217 | PRJNA1233465a_S_NODE_150815_length_195_cov_1.089041_g149541_i0 | PRJNA1233465 | 150815 | 195 | 1.089041 | 2.12362995 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 43.1 | 0.0127 | NR | XP_033634209.1 | 7604 | g149541 | i0 | 42.6 | 1.87692307692308 | 61 | 35 | 93.8 | 0 | 194 | 12 | 90 | 150 | XP_033634209.1 uncharacterized protein LOC117295613 [Asterias rubens] | diamond | 366 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 33122031 | 33122031 | PRJNA1233465f_S_NODE_51015_length_318_cov_1.479554_g48735_i0 | PRJNA1233465 | 51015 | 318 | 1.479554 | 4.70498172 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 74.7 | 4.87e-13 | NR | XP_038077693.1 | 46514 | g48735 | i0 | 60.8 | 68.3962264150943 | 97 | 38 | 91.5 | 0 | 293 | 3 | 27 | 123 | XP_038077693.1 tubulin alpha-1 chain-like isoform X1 [Patiria miniata] | diamond | 21750 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 33128902 | 33128902 | PRJNA1233465f_S_NODE_277063_length_154_cov_40473.304762_g274783_i0 | PRJNA1233465 | 277063 | 154 | 40473.304762 | 62328.88933348 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 42.4 | 0.0155 | NR | XP_038078881.1 | 46514 | g274783 | i0 | 73.1 | 3.91558441558442 | 26 | 7 | 50.6 | 0 | 106 | 29 | 399 | 424 | XP_038078881.1 heat shock cognate 71 kDa protein-like [Patiria miniata] | diamond | 603 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 33153950 | 33153950 | PRJNA1233465b_S_NODE_155912_length_232_cov_1.628415_g154227_i0 | PRJNA1233465 | 155912 | 232 | 1.628415 | 3.7779228 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 47.4 | 7.31e-4 | NR | PIK43814.1 | 307972 | g154227 | i0 | 47.7 | 2.18534482758621 | 44 | 23 | 56.9 | 0 | 21 | 152 | 449 | 492 | PIK43814.1 hypothetical protein BSL78_19340 [Apostichopus japonicus] | diamond | 507 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 33154305 | 33154305 | PRJNA1233465b_S_NODE_374256_length_161_cov_0.892857_g372571_i0 | PRJNA1233465 | 374256 | 161 | 0.892857 | 1.43749977 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 45.1 | 0.00188 | NR | PIK57350.1 | 307972 | g372571 | i0 | 51.3 | 1.45341614906832 | 39 | 19 | 72.7 | 0 | 6 | 122 | 379 | 417 | PIK57350.1 hypothetical protein BSL78_05739 [Apostichopus japonicus] | diamond | 234 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 33170610 | 33170610 | PRJNA1233465a_S_NODE_185776_length_179_cov_1.138462_g184502_i0 | PRJNA1233465 | 185776 | 179 | 1.138462 | 2.03784698 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 44.3 | 0.00399 | NR | XP_071480075.1 | 105358 | g184502 | i0 | 56.8 | 1.27374301675978 | 37 | 15 | 60.3 | 1 | 174 | 67 | 103 | 139 | XP_071480075.1 uncharacterized protein [Diadema antillarum] | diamond | 228 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 33179713 | 33179713 | PRJNA1233465b_S_NODE_210392_length_205_cov_0.980769_g208707_i0 | PRJNA1233465 | 210392 | 205 | 0.980769 | 2.01057645 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 48.9 | 1.05e-4 | NR | XP_038071089.1 | 46514 | g208707 | i0 | 38.1 | 2.75121951219512 | 63 | 38 | 90.7 | 1 | 19 | 204 | 80 | 142 | XP_038071089.1 uncharacterized protein LOC119739982 [Patiria miniata] | diamond | 564 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata |
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);;