contig_metadata
4 rows where bioproject = "PRJNA1120203", tax_clade = "Discoba" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 275091 | 275091 | PRJNA1120203_P_NODE_57021_length_298_cov_4.857778_g56005_i0 | PRJNA1120203 | 57021 | 298 | 4.857778 | 14.47617844 | Euglena mutabilis | 38275 | Euglenozoa | other_Eukaryota | 272 | 1.9499999999999993e-68 | NTclustered | gi|985482797|gb|KT223519.1| | 38275 | g56005 | i0 | 99.333 | 93.8624161073825 | 150 | 1 | 95 | 0 | 3 | 152 | 82505 | 82356 | Euglena mutabilis chloroplast, complete genome | blastn | 27971 | 272 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena mutabilis | ||
| 15055514 | 15055514 | PRJNA1120203_P_NODE_48512_length_324_cov_2.597610_g47496_i0 | PRJNA1120203 | 48512 | 324 | 2.59761 | 8.4162564 | Euglena | 3038 | Euglenozoa | other_Eukaryota | 254 | 7.77e-63 | NTclustered | gi|156140592|gb|EF525317.1| | 3040 | g47496 | i0 | 99.286 | 92.2037037037037 | 140 | 1 | 90 | 0 | 173 | 312 | 1334 | 1473 | Euglena viridis strain ATCC PRA110 large subunit ribosomal RNA gene, partial sequence; plastid | blastn | 29874 | 254 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena viridis | ||
| 15577900 | 15577900 | PRJNA1120203_P_NODE_55653_length_302_cov_4.253275_g54637_i0 | PRJNA1120203 | 55653 | 302 | 4.253275 | 12.8448905 | Euglena longa | 3037 | Euglenozoa | other_Eukaryota | 255 | 2e-63 | NTclustered | gi|12545411|ref|NC_002652.1| | 3037 | g54637 | i0 | 97.333 | 93.9271523178808 | 150 | 4 | 95 | 0 | 151 | 300 | 48077 | 48226 | Euglena longa plastid, complete genome | blastn | 28366 | 255 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena longa | ||
| 21951843 | 21951843 | PRJNA1120203_P_NODE_57018_length_298_cov_10.271111_g56002_i0 | PRJNA1120203 | 57018 | 298 | 10.271111 | 30.60791078 | Euglena pseudoviridis | 509933 | Euglenozoa | other_Eukaryota | 278 | 4.2e-70 | NTclustered | gi|944275091|gb|KT305141.1| | 509933 | g56002 | i0 | 99.346 | 101.322147651007 | 153 | 1 | 99 | 0 | 145 | 297 | 1195 | 1043 | Euglena pseudoviridis strain SAG1224-17c large subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 30194 | 278 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena pseudoviridis |
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);;