contig_metadata
20 rows where bioproject = "PRJEB43370", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1334540 | 1334540 | PRJEB43370_P_NODE_502_length_608_cov_1.933810_g461_i0 | PRJEB43370 | 502 | 608 | 1.93381 | 11.7575648 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 256 | 2.9300000000000005e-79 | NR | XP_063966105.1 | 7653 | g461 | i0 | 63.6 | 6.82894736842105 | 198 | 67 | 97.2 | 2 | 593 | 3 | 1 | 194 | XP_063966105.1 large ribosomal subunit protein uL18-like [Lytechinus pictus] | diamond | 4152 | 258 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 2610163 | 2610163 | PRJEB43370_P_NODE_7843_length_168_cov_1.310924_g7800_i0 | PRJEB43370 | 7843 | 168 | 1.310924 | 2.20235232 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 97.1 | 5.64e-23 | NR | XP_038051326.1 | 46514 | g7800 | i0 | 78.6 | 4 | 56 | 12 | 100 | 0 | 168 | 1 | 93 | 148 | XP_038051326.1 60S ribosomal protein L7-like [Patiria miniata] | diamond | 672 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 6093061 | 6093061 | PRJEB43370_P_NODE_4245_length_216_cov_1.245509_g4202_i0 | PRJEB43370 | 4245 | 216 | 1.245509 | 2.69029944 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 92.8 | 6.06e-20 | NR | XP_033646620.1 | 7604 | g4202 | i0 | 61.6 | 3.98611111111111 | 73 | 26 | 98.6 | 1 | 215 | 3 | 334 | 406 | XP_033646620.1 polyadenylate-binding protein 1-A-like [Asterias rubens] | diamond | 861 | 93.2 | 0.995708154506438 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 7712593 | 7712593 | PRJEB43370_P_NODE_4467_length_212_cov_1.245399_g4424_i0 | PRJEB43370 | 4467 | 212 | 1.245399 | 2.64024588 | root | 1 | Root_unresolved | Root_unresolved | 91.7 | 1.06e-21 | NR | XP_071486245.1 | 105358 | g4424 | i0 | 58.6 | 7.92452830188679 | 70 | 29 | 99.1 | 0 | 1 | 210 | 61 | 130 | XP_071486245.1 small ribosomal subunit protein eS12-like [Diadema antillarum] | diamond | 1680 | 92.4 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 16637024 | 16637024 | PRJEB43370_P_NODE_7654_length_169_cov_0.866667_g7611_i0 | PRJEB43370 | 7654 | 169 | 0.866667 | 1.46466723 | Heliocidaris tuberculata | 7635 | Echinodermata | other_Eukaryota | 58.4 | 3.03e-4 | NTclustered | gi|91214449|gb|DQ453497.1| | 7635 | g7611 | i0 | 97.059 | 3.42603550295858 | 34 | 1 | 20 | 0 | 49 | 82 | 388 | 355 | Heliocidaris tuberculata tetraspanin mRNA, complete cds | blastn | 579 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Echinometridae | Heliocidaris | Heliocidaris tuberculata | |
| 26906941 | 26906941 | PRJEB43370_P_NODE_4182_length_218_cov_0.923077_g4139_i0 | PRJEB43370 | 4182 | 218 | 0.923077 | 2.01230786 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 76.3 | 7.49e-16 | NR | XP_033644463.1 | 7604 | g4139 | i0 | 54.8 | 1.67889908256881 | 73 | 28 | 93.6 | 2 | 206 | 3 | 16 | 88 | XP_033644463.1 eukaryotic translation initiation factor 4E-binding protein 2-like [Asterias rubens] | diamond | 366 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 28006192 | 28006192 | PRJEB43370_P_NODE_7205_length_171_cov_1.278689_g7162_i0 | PRJEB43370 | 7205 | 171 | 1.278689 | 2.18655819 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 46.6 | 4.4e-4 | NR | XP_041475166.1 | 7654 | g7162 | i0 | 66.7 | 3.96491228070175 | 33 | 11 | 57.9 | 0 | 169 | 71 | 99 | 131 | XP_041475166.1 muscle-specific protein 20-like [Lytechinus variegatus] | diamond | 678 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28075667 | 28075667 | PRJEB43370_P_NODE_3545_length_233_cov_1.130435_g3502_i0 | PRJEB43370 | 3545 | 233 | 1.130435 | 2.63391355 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 79.7 | 6.28e-16 | NR | XP_041458277.1 | 7654 | g3502 | i0 | 47.4 | 1.95708154506438 | 76 | 38 | 97.9 | 1 | 230 | 3 | 82 | 155 | XP_041458277.1 phosphatidylcholine transfer protein-like isoform X1 [Lytechinus variegatus] | diamond | 456 | 79.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 29275444 | 29275444 | PRJEB43370_P_NODE_10729_length_162_cov_0.920354_g10686_i0 | PRJEB43370 | 10729 | 162 | 0.920354 | 1.49097348 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 90.1 | 2.46e-19 | NR | KAJ8024628.1 | 206669 | g10686 | i0 | 77.4 | 4.85185185185185 | 53 | 12 | 98.1 | 0 | 161 | 3 | 484 | 536 | KAJ8024628.1 ATP-binding cassette sub-family F member 2 [Holothuria leucospilota] | diamond | 786 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 29401879 | 29401879 | PRJEB43370_P_NODE_4709_length_207_cov_1.316456_g4666_i0 | PRJEB43370 | 4709 | 207 | 1.316456 | 2.72506392 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 77.8 | 1.01e-14 | NR | XP_030832764.1 | 7668 | g4666 | i0 | 53.8 | 2.82608695652174 | 65 | 27 | 89.9 | 1 | 203 | 18 | 216 | 280 | XP_030832764.1 peroxisomal multifunctional enzyme type 2-like [Strongylocentrotus purpuratus] | diamond | 585 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 29496608 | 29496608 | PRJEB43370_P_NODE_10890_length_162_cov_0.920354_g10847_i0 | PRJEB43370 | 10890 | 162 | 0.920354 | 1.49097348 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 74.7 | 6.02e-14 | NR | XP_030853533.1 | 7668 | g10847 | i0 | 69.8 | 3.92592592592593 | 53 | 16 | 98.1 | 0 | 2 | 160 | 326 | 378 | XP_030853533.1 probable medium-chain specific acyl-CoA dehydrogenase, mitochondrial [Strongylocentrotus purpuratus] | diamond | 636 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 29742306 | 29742306 | PRJEB43370_P_NODE_8210_length_168_cov_0.873950_g8167_i0 | PRJEB43370 | 8210 | 168 | 0.87395 | 1.468236 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 43.5 | 0.00709 | NR | KAJ8029653.1 | 206669 | g8167 | i0 | 50 | 2.53571428571429 | 34 | 17 | 60.7 | 0 | 53 | 154 | 289 | 322 | KAJ8029653.1 Endophilin-A1 [Holothuria leucospilota] | diamond | 426 | 43.9 | 0.990888382687927 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 29932254 | 29932254 | PRJEB43370_P_NODE_7211_length_171_cov_1.278689_g7168_i0 | PRJEB43370 | 7211 | 171 | 1.278689 | 2.18655819 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 93.2 | 1.41e-20 | NR | XP_022092473.1 | 133434 | g7168 | i0 | 73.6 | 3.84210526315789 | 53 | 14 | 93 | 0 | 166 | 8 | 91 | 143 | XP_022092473.1 ethanolamine-phosphate cytidylyltransferase-like [Acanthaster planci] | diamond | 657 | 93.6 | 0.995726495726496 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 29995357 | 29995357 | PRJEB43370_P_NODE_3331_length_240_cov_1.073298_g3288_i0 | PRJEB43370 | 3331 | 240 | 1.073298 | 2.5759152 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 125 | 3.78e-31 | NR | XP_071504792.1 | 105358 | g3288 | i0 | 75.9 | 14.8125 | 79 | 18 | 98.8 | 1 | 3 | 239 | 493 | 570 | XP_071504792.1 major vault protein [Diadema antillarum] | diamond | 3555 | 126 | 0.992063492063492 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 30311675 | 30311675 | PRJEB43370_P_NODE_2392_length_279_cov_1.356522_g2349_i0 | PRJEB43370 | 2392 | 279 | 1.356522 | 3.78469638 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 124 | 5.96e-33 | NR | XP_033635647.1 | 7604 | g2349 | i0 | 68.3 | 9.18279569892473 | 82 | 26 | 88.2 | 0 | 2 | 247 | 175 | 256 | XP_033635647.1 40S ribosomal protein S4, X isoform-like isoform X2 [Asterias rubens] | diamond | 2562 | 125 | 0.992 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 30412923 | 30412923 | PRJEB43370_P_NODE_4033_length_221_cov_0.906977_g3990_i0 | PRJEB43370 | 4033 | 221 | 0.906977 | 2.00441917 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 117 | 1.88e-30 | NR | XP_033125693.1 | 1529436 | g3990 | i0 | 69.9 | 0.990950226244344 | 73 | 22 | 99.1 | 0 | 220 | 2 | 183 | 255 | XP_033125693.1 40S ribosomal protein S4, X isoform-like [Anneissia japonica] | diamond | 219 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 31329010 | 31329010 | PRJEB43370_P_NODE_7656_length_169_cov_0.866667_g7613_i0 | PRJEB43370 | 7656 | 169 | 0.866667 | 1.46466723 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 48.1 | 1.75e-4 | NR | XP_033098128.1 | 1529436 | g7613 | i0 | 46.9 | 1.81065088757396 | 49 | 26 | 87 | 0 | 151 | 5 | 230 | 278 | XP_033098128.1 unconventional myosin-Ib-like isoform X1 [Anneissia japonica] | diamond | 306 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 31645168 | 31645168 | PRJEB43370_P_NODE_8377_length_167_cov_0.881356_g8334_i0 | PRJEB43370 | 8377 | 167 | 0.881356 | 1.47186452 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 78.2 | 4.19e-15 | NR | XP_033110570.1 | 1529436 | g8334 | i0 | 70.6 | 10.185628742515 | 51 | 15 | 91.6 | 0 | 154 | 2 | 423 | 473 | XP_033110570.1 serine/threonine-protein phosphatase 5-like [Anneissia japonica] | diamond | 1701 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 32334945 | 32334945 | PRJEB43370_P_NODE_3819_length_226_cov_1.468927_g3776_i0 | PRJEB43370 | 3819 | 226 | 1.468927 | 3.31977502 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 99 | 4.66e-22 | NR | XP_033647424.1 | 7604 | g3776 | i0 | 66.1 | 7.5929203539823 | 59 | 20 | 78.3 | 0 | 6 | 182 | 220 | 278 | XP_033647424.1 protein DD3-3-like [Asterias rubens] | diamond | 1716 | 99.8 | 0.991983967935872 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 32531366 | 32531366 | PRJEB43370_P_NODE_6819_length_176_cov_1.015748_g6776_i0 | PRJEB43370 | 6819 | 176 | 1.015748 | 1.78771648 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 70.9 | 1.82e-12 | NR | KAJ8043531.1 | 206669 | g6776 | i0 | 56.9 | 0.988636363636364 | 58 | 24 | 98.9 | 1 | 3 | 176 | 35 | 91 | KAJ8043531.1 Major vault protein [Holothuria leucospilota] | diamond | 174 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota |
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);;