contig_metadata
8 rows where bioproject = "PRJNA1126661", tax_clade = "core chlorophytes" and tax_phylum = "Chlorophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1557188 | 1557188 | PRJNA1126661_P_NODE_52442_length_293_cov_3.900000_g51913_i0 | PRJNA1126661 | 52442 | 293 | 3.9 | 11.427 | Polulichloris maxima | 2704661 | Plants | Plants | 252 | 2.4999999999999997e-62 | NTclustered | gi|2473928686|ref|NC_072905.1| | 2704661 | g51913 | i0 | 97.315 | 91.3447098976109 | 149 | 3 | 99 | 1 | 4 | 151 | 126300 | 126152 | Polulichloris maxima clone L123 chloroplast, complete genome | blastn | 26764 | 252 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Polulichloris | Polulichloris maxima | |
| 6660279 | 6660279 | PRJNA1126661_P_NODE_38846_length_301_cov_3.850877_g38317_i0 | PRJNA1126661 | 38846 | 301 | 3.850877 | 11.59113977 | Trebouxia aggregata | 160068 | Plants | Plants | 196 | 1.22e-45 | NTclustered | gi|162134372|gb|EU123990.1| | 160068 | g38317 | i0 | 99.083 | 0.624584717607973 | 109 | 1 | 61 | 0 | 149 | 257 | 1290 | 1182 | Trebouxia aggregata strain SAG 219-1d M polypeptide of photosystem I (psaM), hypothetical chloroplast RF12 (ycf12), and K protein of photosystem II (psbK) genes, complete cds; and magnesium chelatase subunit of protochlorophyllide (chlI) gene, partial cds; chloroplast | blastn | 188 | 196 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia aggregata | |
| 11760753 | 11760753 | PRJNA1126661_P_NODE_16310_length_326_cov_4.695652_g15781_i0 | PRJNA1126661 | 16310 | 326 | 4.695652 | 15.30782552 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 224 | 6.139999999999998e-54 | NTclustered | gi|2917929619|emb|OZ234907.1| | 3350044 | g15781 | i0 | 93.377 | 0.46319018404908 | 151 | 10 | 46 | 0 | 176 | 326 | 4107600 | 4107750 | Trebouxia sp. SL0000003 genome assembly, chromosome: 2 | blastn | 151 | 224 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 15585336 | 15585336 | PRJNA1126661_P_NODE_38593_length_301_cov_3.947368_g38064_i0 | PRJNA1126661 | 38593 | 301 | 3.947368 | 11.88157768 | Tetrabaena socialis | 47790 | Plants | Plants | 139 | 6.33e-40 | NR | PNH06964.1 | 47790 | g38064 | i0 | 59.1 | 3.05980066445183 | 127 | 20 | 94.7 | 1 | 285 | 1 | 6 | 132 | PNH06964.1 40S ribosomal protein S5 [Tetrabaena socialis] | diamond | 921 | 139 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Tetrabaenaceae | Tetrabaena | Tetrabaena socialis | |
| 27354956 | 27354956 | PRJNA1126661_P_NODE_37523_length_301_cov_4.447368_g36994_i0 | PRJNA1126661 | 37523 | 301 | 4.447368 | 13.38657768 | Coccomyxa viridis | 1274662 | Plants | Plants | 49.3 | 3.5e-4 | NR | CAK0775132.1 | 1274662 | g36994 | i0 | 42.2 | 0.448504983388704 | 45 | 26 | 44.9 | 0 | 14 | 148 | 297 | 341 | CAK0775132.1 hypothetical protein CVIRNUC_004237 [Coccomyxa viridis] | diamond | 135 | 49.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 29333117 | 29333117 | PRJNA1126661_P_NODE_74929_length_241_cov_2.785714_g74399_i0 | PRJNA1126661 | 74929 | 241 | 2.785714 | 6.71357074 | Eukaryota | 2759 | Plants | Plants | 70.9 | 2.43e-13 | NR | CAD7699508.1 | 121088 | g74399 | i0 | 50.8 | 2.75103734439834 | 65 | 32 | 80.9 | 0 | 46 | 240 | 37 | 101 | CAD7699508.1 unnamed protein product [Ostreobium quekettii] | diamond | 663 | 70.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii | |
| 30153918 | 30153918 | PRJNA1126661_P_NODE_82612_length_215_cov_5.464789_g82082_i0 | PRJNA1126661 | 82612 | 215 | 5.464789 | 11.74929635 | Eukaryota | 2759 | Plants | Plants | 118 | 7.35e-29 | NR | PRW20811.1 | 3076 | g82082 | i0 | 82.6 | 45.0279069767442 | 69 | 12 | 96.3 | 0 | 2 | 208 | 208 | 276 | PRW20811.1 Receptor of activated kinase C component of 40S small ribosomal subunit isoform C [Chlorella sorokiniana] | diamond | 9681 | 118 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 32725529 | 32725529 | PRJNA1126661_P_NODE_48860_length_297_cov_4.794643_g48331_i0 | PRJNA1126661 | 48860 | 297 | 4.794643 | 14.24008971 | Trebouxia sp. C | 2796353 | Plants | Plants | 190 | 1.3e-56 | NR | KAL3153183.1 | 3373144 | g48331 | i0 | 83.9 | 1.13131313131313 | 112 | 4 | 99 | 1 | 2 | 295 | 180 | 291 | KAL3153183.1 formate dehydrogenase (NAD+) [Trebouxia sp. C0009 RCD-2024] | diamond | 336 | 190 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0009 RCD-2024 |
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);;