contig_metadata
5 rows where bioproject = "PRJNA473799", tax_clade = "core chlorophytes" and tax_kingdom = "Viridiplantae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1720736 | 1720736 | PRJNA473799_P_NODE_49782_length_243_cov_0.905882_g49508_i0 | PRJNA473799 | 49782 | 243 | 0.905882 | 2.20129326 | Desmochloris halophila | 138176 | Plants | Plants | 433 | 6.69e-117 | NTclustered | gi|371782123|emb|HE610155.1| | 138176 | g49508 | i0 | 98.765 | 115.683127572016 | 243 | 3 | 100 | 0 | 1 | 243 | 2230 | 1988 | Desmochloris halophila plastid 16S rRNA gene (partial), 23S rRNA gene (partial) and ITS1, strain UTEX 2073 | blastn | 28111 | 433 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris halophila | |
| 5549046 | 5549046 | PRJNA473799_P_NODE_13925_length_293_cov_1.586364_g13651_i0 | PRJNA473799 | 13925 | 293 | 1.586364 | 4.64804652 | Polytomella parva | 51329 | Plants | Plants | 52.8 | 0.027 | NTclustered | gi|1861356485|gb|MT377470.1| | 51329 | g13651 | i0 | 94.118 | 0.116040955631399 | 34 | 2 | 12 | 0 | 46 | 79 | 1191 | 1224 | Polytomella parva clone 0016335261 alpha-amylase (AMY) mRNA, partial cds; plastid | blastn | 34 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella parva | |
| 20222235 | 20222235 | PRJNA473799_P_NODE_56456_length_231_cov_2.468354_g56182_i0 | PRJNA473799 | 56456 | 231 | 2.468354 | 5.70189774 | Eukaryota | 2759 | Plants | Plants | 425 | 1.0599999999999999e-114 | NTclustered | gi|944383253|gb|KR607498.1| | 332221 | g56182 | i0 | 100 | 99.5670995670996 | 230 | 0 | 99 | 0 | 1 | 230 | 587 | 816 | Neochlorosarcina negevensis small subunit ribosomal RNA gene, partial sequence | blastn | 23000 | 425 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlorosarcinales | Chlorosarcinaceae | Neochlorosarcina | Neochlorosarcina negevensis | |
| 22772802 | 22772802 | PRJNA473799_P_NODE_39618_length_248_cov_2.285714_g39344_i0 | PRJNA473799 | 39618 | 248 | 2.285714 | 5.66857072 | Watanabeaceae | 2981775 | Plants | Plants | 459 | 1.13e-124 | NTclustered | gi|1560019362|gb|MG515421.1| | 167235 | g39344 | i0 | 100 | 100.20564516129 | 248 | 0 | 100 | 0 | 1 | 248 | 1509 | 1756 | Uncultured Trebouxiophyceae clone LSY2027 18S ribosomal RNA gene, partial sequence | blastn | 24851 | 459 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | uncultured Trebouxiophyceae | ||||
| 29539190 | 29539190 | PRJNA473799_P_NODE_31230_length_257_cov_1.059783_g30956_i0 | PRJNA473799 | 31230 | 257 | 1.059783 | 2.72364231 | Coccomyxa viridis | 1274662 | Plants | Plants | 45.1 | 0.00639 | NR | CAK0780810.1 | 1274662 | g30956 | i0 | 61.3 | 1.08560311284047 | 31 | 12 | 36.2 | 0 | 161 | 253 | 275 | 305 | CAK0780810.1 Subunit of heteropentameric Replication factor C (RF-C) [Coccomyxa viridis] | diamond | 279 | 45.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis |
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);;