contig_metadata
6 rows where bioproject = "PRJNA812001" and tax_clade = "core chlorophytes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 811010 | 811010 | PRJNA812001_P_NODE_81101_length_251_cov_0.865169_g80855_i0 | PRJNA812001 | 81101 | 251 | 0.865169 | 2.17157419 | Pyrobotrys stellatus | 3064 | Plants | Plants | 206 | 1.65e-48 | NTclustered | gi|18266|emb|X68202.1| | 3064 | g80855 | i0 | 81.673 | 2.48605577689243 | 251 | 43 | 99 | 3 | 1 | 250 | 269 | 21 | C.stellata mRNA for ribosomal protein L27 | blastn | 624 | 206 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Spondylomoraceae | Pyrobotrys | Pyrobotrys stellatus | |
| 2499809 | 2499809 | PRJNA812001_P_NODE_12502_length_450_cov_9.143236_g12256_i0 | PRJNA812001 | 12502 | 450 | 9.143236 | 41.144562 | Eukaryota | 2759 | Plants | Plants | 69.4 | 4.33e-7 | NTclustered | gi|1946821799|gb|MW380426.1| | 3077 | g12256 | i0 | 100 | 17.4733333333333 | 37 | 0 | 8 | 0 | 1 | 37 | 1606 | 1642 | Chlorella vulgaris strain H1 small subunit ribosomal RNA gene, partial sequence | blastn | 7863 | 69.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 10152910 | 10152910 | PRJNA812001_P_NODE_137728_length_209_cov_6.750000_g137482_i0 | PRJNA812001 | 137728 | 209 | 6.75 | 14.1075 | Chlamydomonadales | 3042 | Plants | Plants | 298 | 2.13e-76 | NTclustered | gi|66864300|gb|DQ015755.1| | 52964 | g137482 | i0 | 95.213 | 89.4928229665072 | 188 | 8 | 89 | 1 | 1 | 187 | 291 | 104 | Dysmorphococcus globosus strain UTEX LB 65 26S ribosomal RNA gene, partial sequence | blastn | 18704 | 298 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Phacotaceae | Dysmorphococcus | Dysmorphococcus globosus | |
| 25450989 | 25450989 | PRJNA812001_P_NODE_136880_length_228_cov_2.535484_g136634_i0 | PRJNA812001 | 136880 | 228 | 2.535484 | 5.78090352 | Desmochloris | 138596 | Plants | Plants | 350 | 6.44e-92 | NTclustered | gi|371782086|emb|HE610118.1| | 138176 | g136634 | i0 | 94.298 | 101.513157894737 | 228 | 13 | 100 | 0 | 1 | 228 | 760 | 987 | Desmochloris halophila 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain UTEX 2073 | blastn | 23145 | 350 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris halophila | |
| 30622830 | 30622830 | PRJNA812001_P_NODE_2293_length_993_cov_21.628261_g2100_i0 | PRJNA812001 | 2293 | 993 | 21.628261 | 214.76863173 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 390 | 1.76e-134 | NR | KAA6420323.1 | 2608996 | g2100 | i0 | 92.8 | 0.631419939577039 | 209 | 15 | 63.1 | 0 | 878 | 252 | 1 | 209 | KAA6420323.1 MAG: peroxiredoxin Q [Trebouxia sp. A1-2] | diamond | 627 | 390 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 32615097 | 32615097 | PRJNA812001_P_NODE_27700_length_343_cov_5.396296_g27454_i0 | PRJNA812001 | 27700 | 343 | 5.396296 | 18.50929528 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 50.1 | 1.25e-4 | NR | KAA6420509.1 | 2608996 | g27454 | i0 | 35.4 | 1.12827988338192 | 65 | 40 | 55.1 | 1 | 334 | 146 | 86 | 150 | KAA6420509.1 MAG: hypothetical protein FRX49_09670 [Trebouxia sp. A1-2] | diamond | 387 | 50.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 |
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);;