contig_metadata
6 rows where bioproject = "PRJEB25583", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5125389 | 5125389 | PRJEB25583_P_NODE_3765_length_209_cov_1.127907_g3588_i0 | PRJEB25583 | 3765 | 209 | 1.127907 | 2.35732563 | Coccomyxa viridis | 1274662 | Plants | Plants | 103 | 4.57e-25 | NR | CAK0735959.1 | 1274662 | g3588 | i0 | 76.7 | 0.861244019138756 | 60 | 14 | 86.1 | 0 | 29 | 208 | 4 | 63 | CAK0735959.1 Chlorophyll a-b binding protein of LHCII type I, chloroplastic [Coccomyxa viridis] | diamond | 180 | 103 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 8950005 | 8950005 | PRJEB25583_P_NODE_5728_length_173_cov_1.654412_g5551_i0 | PRJEB25583 | 5728 | 173 | 1.654412 | 2.86213276 | Chlamydomonas bacca | 51684 | Plants | Plants | 252 | 1.33e-62 | NTclustered | gi|15281658|gb|AF395498.1| | 51684 | g5551 | i0 | 99.281 | 80.3988439306358 | 139 | 1 | 80 | 0 | 1 | 139 | 285 | 147 | Chlamydomonas bacca strain SAG 24.87 voucher SAG:24.87 26S ribosomal RNA gene, partial sequence | blastn | 13909 | 252 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas bacca | |
| 12776564 | 12776564 | PRJEB25583_P_NODE_3451_length_218_cov_1.259669_g3274_i0 | PRJEB25583 | 3451 | 218 | 1.259669 | 2.74607842 | Ulva compressa | 63659 | Plants | Plants | 195 | 3.0299999999999997e-45 | NTclustered | gi|2043344467|gb|MW353781.1| | 63659 | g3274 | i0 | 83.732 | 115.954128440367 | 209 | 31 | 96 | 3 | 7 | 215 | 69552 | 69347 | Ulva compressa isolate Uco3 plastid, complete genome | blastn | 25278 | 195 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva compressa | |
| 16599811 | 16599811 | PRJEB25583_P_NODE_4954_length_184_cov_3.000000_g4777_i0 | PRJEB25583 | 4954 | 184 | 3 | 5.52 | Chlamydomonas nivalis | 47906 | Plants | Plants | 124 | 3.28e-24 | NTclustered | gi|952952715|gb|KT624640.1| | 47906 | g4777 | i0 | 81.41 | 2.54347826086957 | 156 | 25 | 83 | 4 | 19 | 171 | 3403 | 3249 | Chlamydomonas nivalis clone contig00011 chloroplast, partial genome | blastn | 468 | 124 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas nivalis | |
| 22663404 | 22663404 | PRJEB25583_P_NODE_6338_length_166_cov_1.596899_g6161_i0 | PRJEB25583 | 6338 | 166 | 1.596899 | 2.65085234 | Chlorophyta | 3041 | Plants | Plants | 302 | 1.2500000000000001e-77 | NTclustered | gi|1518373083|gb|MK201746.1| | 152768 | g6161 | i0 | 99.398 | 97.0602409638554 | 166 | 1 | 100 | 0 | 1 | 166 | 1010 | 845 | Diplosphaera chodatii strain KZ-26-5 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 16112 | 302 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Diplosphaera | Diplosphaera chodatii | |
| 22974987 | 22974987 | PRJEB25583_P_NODE_8279_length_151_cov_1.315789_g8102_i0 | PRJEB25583 | 8279 | 151 | 1.315789 | 1.98684139 | Chlamydomonas incerta | 51695 | Plants | Plants | 132 | 1.54e-26 | NTclustered | gi|87313230|gb|DQ370101.1| | 51695 | g8102 | i0 | 84.559 | 1.63576158940397 | 136 | 17 | 89 | 4 | 3 | 136 | 340 | 473 | Chlamydomonas incerta strain SAG 7.73 light-harvesting chlorophyll-a/b binding protein LhcbM8 mRNA, partial cds | blastn | 247 | 132 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta |
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);;