contig_metadata
19 rows where bioproject = "PRJNA928559" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8905955 | 8905955 | PRJNA928559_P_NODE_54147_length_468_cov_56.108861_g52581_i0 | PRJNA928559 | 54147 | 468 | 56.108861 | 262.58946948 | Echinoidea | 7625 | Echinodermata | other_Eukaryota | 115 | 5.72e-21 | NTclustered | gi|2707351026|ref|XR_008586834.2| | 7653 | g52581 | i0 | 82.09 | 24.0747863247863 | 134 | 24 | 29 | 0 | 49 | 182 | 3369 | 3502 | PREDICTED: Lytechinus pictus large subunit ribosomal RNA (LOC129284211), rRNA | blastn | 11267 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 9831515 | 9831515 | PRJNA928559_P_NODE_226228_length_209_cov_6.330882_g224659_i0 | PRJNA928559 | 226228 | 209 | 6.330882 | 13.23154338 | Ophiomyxa flaccida | 331090 | Echinodermata | other_Eukaryota | 156 | 1.36e-33 | NTclustered | gi|82623452|gb|DQ273711.1| | 331090 | g224659 | i0 | 85.906 | 39.555023923445 | 149 | 18 | 70 | 3 | 13 | 159 | 152 | 5 | Ophiomyxa flaccida 28S ribosomal RNA gene, partial sequence | blastn | 8267 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Ophiuroidea | Amphilepidida | Ophiomyxidae | Ophiomyxa | Ophiomyxa flaccida | |
| 11105516 | 11105516 | PRJNA928559_P_NODE_102889_length_352_cov_0.946237_g101320_i0 | PRJNA928559 | 102889 | 352 | 0.946237 | 3.33075424 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 177 | 5.33e-50 | NR | XP_030836029.1 | 7668 | g101320 | i0 | 69.8 | 19.7727272727273 | 116 | 34 | 98.9 | 1 | 351 | 4 | 470 | 584 | XP_030836029.1 peptidylprolyl isomerase domain and WD repeat-containing protein 1 [Strongylocentrotus purpuratus] | diamond | 6960 | 177 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 26968605 | 26968605 | PRJNA928559_P_NODE_190822_length_252_cov_0.871508_g189253_i0 | PRJNA928559 | 190822 | 252 | 0.871508 | 2.19620016 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 69.7 | 3.52e-13 | NR | XP_038065126.1 | 46514 | g189253 | i0 | 58.9 | 2.01190476190476 | 56 | 23 | 66.7 | 0 | 251 | 84 | 6 | 61 | XP_038065126.1 60S acidic ribosomal protein P1-like [Patiria miniata] | diamond | 507 | 70.1 | 0.994293865905849 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 27246004 | 27246004 | PRJNA928559_P_NODE_150863_length_287_cov_1.247664_g149294_i0 | PRJNA928559 | 150863 | 287 | 1.247664 | 3.58079568 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 44.3 | 0.0177 | NR | XP_022094680.1 | 133434 | g149294 | i0 | 31.9 | 1.52613240418118 | 72 | 44 | 75.3 | 1 | 53 | 268 | 18 | 84 | XP_022094680.1 radial spoke head protein 4 homolog A-like isoform X2 [Acanthaster planci] | diamond | 438 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 27467381 | 27467381 | PRJNA928559_P_NODE_55043_length_465_cov_5.099490_g53477_i0 | PRJNA928559 | 55043 | 465 | 5.09949 | 23.7126285 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 47.8 | 0.00673 | NR | XP_033109451.1 | 1529436 | g53477 | i0 | 33.7 | 0.632258064516129 | 98 | 45 | 63.2 | 3 | 322 | 29 | 673 | 750 | XP_033109451.1 proprotein convertase subtilisin/kexin type 5-like [Anneissia japonica] | diamond | 294 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 27751600 | 27751600 | PRJNA928559_P_NODE_184264_length_255_cov_2.664835_g182695_i0 | PRJNA928559 | 184264 | 255 | 2.664835 | 6.79532925 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 52 | 2.39e-5 | NR | XP_071497020.1 | 105358 | g182695 | i0 | 38.3 | 0.705882352941177 | 60 | 35 | 68.2 | 1 | 250 | 77 | 432 | 491 | XP_071497020.1 BOS complex subunit NOMO1-like [Diadema antillarum] | diamond | 180 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 27783120 | 27783120 | PRJNA928559_P_NODE_17424_length_753_cov_2.186765_g16004_i0 | PRJNA928559 | 17424 | 753 | 2.186765 | 16.46634045 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 344 | 5.71e-113 | NR | XP_038044202.1 | 46514 | g16004 | i0 | 63.9 | 24.8167330677291 | 249 | 90 | 99.2 | 0 | 752 | 6 | 164 | 412 | XP_038044202.1 probable methylmalonate-semialdehyde dehydrogenase [acylating], mitochondrial [Patiria miniata] | diamond | 18687 | 344 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 27909018 | 27909018 | PRJNA928559_P_NODE_45985_length_501_cov_1.775701_g44423_i0 | PRJNA928559 | 45985 | 501 | 1.775701 | 8.89626201 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 125 | 1.53e-30 | NR | XP_033098988.1 | 1529436 | g44423 | i0 | 43.5 | 1.0059880239521 | 168 | 91 | 99.4 | 4 | 499 | 2 | 156 | 321 | XP_033098988.1 suppressor of SWI4 1 homolog [Anneissia japonica] | diamond | 504 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 28382837 | 28382837 | PRJNA928559_P_NODE_18366_length_736_cov_2.028658_g16924_i0 | PRJNA928559 | 18366 | 736 | 2.028658 | 14.93092288 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 71.2 | 3.08e-10 | NR | XP_030843713.1 | 7668 | g16924 | i0 | 32.9 | 1.15760869565217 | 143 | 65 | 58.3 | 1 | 734 | 306 | 246 | 357 | XP_030843713.1 L-lactate dehydrogenase-like isoform X1 [Strongylocentrotus purpuratus] | diamond | 852 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 28382871 | 28382871 | PRJNA928559_P_NODE_225766_length_213_cov_4.878571_g224197_i0 | PRJNA928559 | 225766 | 213 | 4.878571 | 10.39135623 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 77.4 | 6.34e-15 | NR | XP_071492371.1 | 105358 | g224197 | i0 | 50 | 0.929577464788732 | 66 | 33 | 93 | 0 | 200 | 3 | 88 | 153 | XP_071492371.1 nucleoside diphosphate-linked moiety X motif 6-like [Diadema antillarum] | diamond | 198 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 28705891 | 28705891 | PRJNA928559_P_NODE_103907_length_350_cov_1.783394_g102338_i0 | PRJNA928559 | 103907 | 350 | 1.783394 | 6.241879 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 53.9 | 1.43e-5 | NR | XP_041477726.1 | 7654 | g102338 | i0 | 30.3 | 3.76285714285714 | 99 | 67 | 84 | 2 | 294 | 1 | 244 | 341 | XP_041477726.1 lupus La protein homolog isoform X2 [Lytechinus variegatus] | diamond | 1317 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28887970 | 28887970 | PRJNA928559_P_NODE_204788_length_246_cov_0.901734_g203219_i0 | PRJNA928559 | 204788 | 246 | 0.901734 | 2.21826564 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 43.5 | 0.02 | NR | XP_071492943.1 | 105358 | g203219 | i0 | 51.5 | 0.402439024390244 | 33 | 16 | 40.2 | 0 | 3 | 101 | 345 | 377 | XP_071492943.1 N-acetylglucosamine-1-phosphodiester alpha-N-acetylglucosaminidase-like [Diadema antillarum] | diamond | 99 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 28982979 | 28982979 | PRJNA928559_P_NODE_116568_length_330_cov_1.821012_g114999_i0 | PRJNA928559 | 116568 | 330 | 1.821012 | 6.0093396 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 90.9 | 4.28e-19 | NR | KAJ8035763.1 | 206669 | g114999 | i0 | 55.2 | 1.83636363636364 | 67 | 30 | 60.9 | 0 | 330 | 130 | 265 | 331 | KAJ8035763.1 Methylsterol monooxygenase 1 [Holothuria leucospilota] | diamond | 606 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 29684259 | 29684259 | PRJNA928559_P_NODE_98570_length_359_cov_2.265734_g97001_i0 | PRJNA928559 | 98570 | 359 | 2.265734 | 8.13398506 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 98.2 | 5.1e-21 | NR | XP_030828487.1 | 7668 | g97001 | i0 | 57.7 | 3.47632311977716 | 78 | 33 | 65.2 | 0 | 236 | 3 | 116 | 193 | XP_030828487.1 peroxisomal acyl-coenzyme A oxidase 1-like [Strongylocentrotus purpuratus] | diamond | 1248 | 99 | 0.991919191919192 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 30814647 | 30814647 | PRJNA928559_P_NODE_133194_length_307_cov_2.243590_g131625_i0 | PRJNA928559 | 133194 | 307 | 2.24359 | 6.8878213 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 78.6 | 1.6e-14 | NR | PIK56023.1 | 307972 | g131625 | i0 | 43.5 | 1.76872964169381 | 92 | 49 | 87 | 1 | 2 | 268 | 261 | 352 | PIK56023.1 Ethanolamine-phosphate cytidylyltransferase [Apostichopus japonicus] | diamond | 543 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 31636597 | 31636597 | PRJNA928559_P_NODE_186196_length_254_cov_1.414365_g184627_i0 | PRJNA928559 | 186196 | 254 | 1.414365 | 3.5924871 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 86.7 | 1.53e-17 | NR | XP_071479160.1 | 105358 | g184627 | i0 | 56.9 | 3.74409448818898 | 72 | 30 | 85 | 1 | 2 | 217 | 525 | 595 | XP_071479160.1 ATP-dependent translocase ABCB1-like [Diadema antillarum] | diamond | 951 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 31636628 | 31636628 | PRJNA928559_P_NODE_227696_length_198_cov_6.240000_g226127_i0 | PRJNA928559 | 227696 | 198 | 6.24 | 12.3552 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 58.5 | 3.04e-9 | NR | KAJ8029990.1 | 206669 | g226127 | i0 | 63.3 | 0.742424242424242 | 49 | 18 | 74.2 | 0 | 195 | 49 | 2 | 50 | KAJ8029990.1 hypothetical protein HOLleu_29549 [Holothuria leucospilota] | diamond | 147 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 32687191 | 32687191 | PRJNA928559_P_NODE_44660_length_507_cov_1.389401_g43101_i0 | PRJNA928559 | 44660 | 507 | 1.389401 | 7.04426307 | root | 1 | Root_unresolved | Root_unresolved | 79 | 1.54e-13 | NR | XP_071480560.1 | 105358 | g43101 | i0 | 60 | 1.75147928994083 | 60 | 24 | 35.5 | 0 | 5 | 184 | 606 | 665 | XP_071480560.1 ATP-dependent translocase ABCB1-like [Diadema antillarum] | diamond | 888 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum |
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);;