contig_metadata
6 rows where bioproject = "PRJNA675042" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 647324 | 647324 | PRJNA675042_P_NODE_75121_length_287_cov_0.873832_g74671_i0 | PRJNA675042 | 75121 | 287 | 0.873832 | 2.50789784 | Florometra sp. BMK-2020 | 2719553 | Echinodermata | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|1850791165|gb|MT302206.1| | 2719553 | g74671 | i0 | 100 | 0.101045296167247 | 29 | 0 | 10 | 0 | 139 | 167 | 5039 | 5067 | Florometra sp. BMK-2020 mitochondrion, complete genome | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Antedonidae | Florometra | Florometra sp. BMK-2020 | |
| 9575056 | 9575056 | PRJNA675042_P_NODE_168368_length_242_cov_0.911243_g167918_i0 | PRJNA675042 | 168368 | 242 | 0.911243 | 2.20520806 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 58.4 | 4.69e-4 | NTclustered | gi|2037982977|ref|XM_041604086.1| | 7654 | g167918 | i0 | 97.143 | 0.433884297520661 | 35 | 0 | 14 | 1 | 209 | 242 | 5262 | 5296 | PREDICTED: Lytechinus variegatus uncharacterized LOC121411388 (LOC121411388), transcript variant X2, mRNA | blastn | 105 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 11371757 | 11371757 | PRJNA675042_P_NODE_43469_length_336_cov_1.787072_g43019_i0 | PRJNA675042 | 43469 | 336 | 1.787072 | 6.00456192 | root | 1 | Root_unresolved | Root_unresolved | 73.1 | 2.43e-8 | NTclustered | gi|2038007074|ref|XM_041616830.1| | 7654 | g43019 | i0 | 95.556 | 1.11904761904762 | 45 | 2 | 13 | 0 | 1 | 45 | 1454 | 1410 | PREDICTED: Lytechinus variegatus mucin-like protein (LOC121422029), partial mRNA | blastn | 376 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 18498925 | 18498925 | PRJNA675042_P_NODE_18415_length_421_cov_1.304598_g17965_i0 | PRJNA675042 | 18415 | 421 | 1.304598 | 5.49235758 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 54.7 | 0.011 | NTclustered | gi|1752404259|ref|XM_030974533.1| | 7668 | g17965 | i0 | 100 | 0.0688836104513064 | 29 | 0 | 7 | 0 | 6 | 34 | 12916 | 12944 | PREDICTED: Strongylocentrotus purpuratus neurobeachin-like protein 1 (LOC580791), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 23598655 | 23598655 | PRJNA675042_P_NODE_110539_length_251_cov_0.865169_g110089_i0 | PRJNA675042 | 110539 | 251 | 0.865169 | 2.17157419 | Ocnus glacialis | 3074281 | Echinodermata | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2587931046|ref|NC_082941.1| | 3074281 | g110089 | i0 | 90.698 | 0.171314741035857 | 43 | 3 | 17 | 1 | 190 | 232 | 16771 | 16730 | Ocnus glacialis mitochondrion, complete genome | blastn | 43 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Dendrochirotida | Cucumariidae | Ocnus | Ocnus glacialis | |
| 23599628 | 23599628 | PRJNA675042_P_NODE_30619_length_371_cov_0.822148_g30169_i0 | PRJNA675042 | 30619 | 371 | 0.822148 | 3.05016908 | Ophiotreta durbanensis | 3135534 | Echinodermata | other_Eukaryota | 52.8 | 0.035 | NTclustered | gi|2705278880|gb|ON685890.1| | 3135534 | g30169 | i0 | 100 | 0.0754716981132075 | 28 | 0 | 8 | 0 | 32 | 59 | 1593 | 1566 | Ophiotreta durbanensis mitochondrion, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Ophiuroidea | Amphilepidida | Ophiacanthidae | Ophiotreta | Ophiotreta durbanensis |
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);;