contig_metadata
7 rows where bioproject = "PRJNA1095825", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2751512 | 2751512 | PRJNA1095825_P_NODE_254923_length_248_cov_0.880000_g251860_i0 | PRJNA1095825 | 254923 | 248 | 0.88 | 2.1824 | Calyptraster sp. | 3240086 | Echinodermata | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2843360714|gb|PQ424520.1| | 3240086 | g251860 | i0 | 100 | 0.112903225806452 | 28 | 0 | 11 | 0 | 218 | 245 | 15600 | 15627 | Calyptraster sp. mitochondrion, partial genome | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Velatida | Pterasteridae | Calyptraster | Calyptraster sp. | |
| 10404544 | 10404544 | PRJNA1095825_P_NODE_297129_length_241_cov_0.916667_g294066_i0 | PRJNA1095825 | 297129 | 241 | 0.916667 | 2.20916747 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 58.4 | 4.66e-4 | NTclustered | gi|1229162798|ref|XM_022238692.1| | 133434 | g294066 | i0 | 92.5 | 0.663900414937759 | 40 | 3 | 17 | 0 | 162 | 201 | 3018 | 3057 | PREDICTED: Acanthaster planci uncharacterized LOC110981270 (LOC110981270), transcript variant X1, mRNA | blastn | 160 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 27058975 | 27058975 | PRJNA1095825_P_NODE_297702_length_241_cov_0.916667_g294639_i0 | PRJNA1095825 | 297702 | 241 | 0.916667 | 2.20916747 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 52.4 | 1.28e-5 | NR | XP_038052371.1 | 46514 | g294639 | i0 | 53.7 | 3.08713692946058 | 67 | 27 | 82.2 | 3 | 204 | 7 | 16 | 79 | XP_038052371.1 ficolin-1-like [Patiria miniata] | diamond | 744 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 30478492 | 30478492 | PRJNA1095825_P_NODE_76733_length_432_cov_1.596100_g73670_i0 | PRJNA1095825 | 76733 | 432 | 1.5961 | 6.895152 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 78.6 | 2.16e-14 | NR | XP_030850438.1 | 7668 | g73670 | i0 | 42.4 | 2.01388888888889 | 92 | 52 | 63.2 | 1 | 19 | 291 | 167 | 258 | XP_030850438.1 40S ribosomal protein S4 [Strongylocentrotus purpuratus] | diamond | 870 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 30532854 | 30532854 | PRJNA1095825_P_NODE_295453_length_241_cov_0.916667_g292390_i0 | PRJNA1095825 | 295453 | 241 | 0.916667 | 2.20916747 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 49.7 | 1.14e-4 | NR | KAJ8025248.1 | 206669 | g292390 | i0 | 56.8 | 0.908713692946058 | 37 | 16 | 46.1 | 0 | 227 | 117 | 249 | 285 | KAJ8025248.1 hypothetical protein HOLleu_35403 [Holothuria leucospilota] | diamond | 219 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 30541534 | 30541534 | PRJNA1095825_P_NODE_271953_length_245_cov_0.895349_g268890_i0 | PRJNA1095825 | 271953 | 245 | 0.895349 | 2.19360505 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 69.3 | 1.43e-11 | NR | XP_033121476.1 | 1529436 | g268890 | i0 | 48.3 | 0.73469387755102 | 60 | 27 | 73.5 | 1 | 202 | 23 | 300 | 355 | XP_033121476.1 uncharacterized protein LOC117120560, partial [Anneissia japonica] | diamond | 180 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 32303899 | 32303899 | PRJNA1095825_P_NODE_252379_length_248_cov_1.554286_g249316_i0 | PRJNA1095825 | 252379 | 248 | 1.554286 | 3.85462928 | root | 1 | Root_unresolved | Root_unresolved | 44.3 | 0.0092 | NR | PIK48495.1 | 307972 | g249316 | i0 | 34.3 | 2.56451612903226 | 70 | 45 | 84.7 | 1 | 219 | 10 | 89 | 157 | PIK48495.1 hypothetical protein BSL78_14644 [Apostichopus japonicus] | diamond | 636 | 44.7 | 0.991051454138702 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus |
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);;