contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA594101" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3118122 | 3118122 | PRJNA594101_S_NODE_42543_length_267_cov_1.871134_g42241_i0 | PRJNA594101 | 42543 | 267 | 1.871134 | 4.99592778 | Hariotina sp. MMOGRB0030F | 1867922 | Plants | Plants | 67.6 | 8.73e-7 | NTclustered | gi|1090895397|gb|KX131180.1| | 1867922 | g42241 | i0 | 93.333 | 0.464419475655431 | 45 | 3 | 19 | 0 | 168 | 212 | 120293 | 120249 | Hariotina sp. MMOGRB0030F chloroplast, complete genome | blastn | 124 | 67.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Hariotina | Hariotina sp. MMOGRB0030F | |
| 3118222 | 3118222 | PRJNA594101_S_NODE_54983_length_244_cov_0.900585_g54681_i0 | PRJNA594101 | 54983 | 244 | 0.900585 | 2.1974274 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 172 | 1.62e-38 | NTclustered | gi|2082258287|ref|XM_043067367.1| | 3055 | g54681 | i0 | 82.741 | 20.7418032786885 | 197 | 30 | 80 | 4 | 44 | 238 | 1346 | 1152 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_11g467616v5), mRNA | blastn | 5061 | 172 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 9495308 | 9495308 | PRJNA594101_S_NODE_10848_length_498_cov_16.230588_g10547_i0 | PRJNA594101 | 10848 | 498 | 16.230588 | 80.82832824 | Chlorella variabilis | 554065 | Plants | Plants | 180 | 2.14e-40 | NTclustered | gi|552812172|ref|XM_005843586.1| | 554065 | g10547 | i0 | 77.852 | 45.0080321285141 | 298 | 60 | 59 | 6 | 80 | 374 | 426 | 132 | Chlorella variabilis histone H3.2 precursor (CHLNCDRAFT_139997) mRNA, complete cds | blastn | 22414 | 180 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 9495359 | 9495359 | PRJNA594101_S_NODE_17588_length_396_cov_18.501548_g17286_i0 | PRJNA594101 | 17588 | 396 | 18.501548 | 73.26613008 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 54.7 | 0.011 | NTclustered | gi|2917929618|emb|OZ234906.1| | 3350044 | g17286 | i0 | 100 | 0.0732323232323232 | 29 | 0 | 7 | 0 | 162 | 190 | 4253123 | 4253151 | Trebouxia sp. SL0000003 genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 9495666 | 9495666 | PRJNA594101_S_NODE_59128_length_224_cov_22.298013_g58826_i0 | PRJNA594101 | 59128 | 224 | 22.298013 | 49.94754912 | Dunaliella sp. KU22 | 1545437 | Plants | Plants | 217 | 6.67e-52 | NTclustered | gi|685431495|gb|KM033846.1| | 1545437 | g58826 | i0 | 86.432 | 80.8973214285714 | 199 | 26 | 89 | 1 | 16 | 214 | 267 | 70 | Dunaliella sp. KU22 alpha-tubulin protein (ATUB) mRNA, partial cds | blastn | 18121 | 217 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella sp. KU22 | |
| 14596088 | 14596088 | PRJNA594101_S_NODE_51532_length_248_cov_0.880000_g51230_i0 | PRJNA594101 | 51532 | 248 | 0.88 | 2.1824 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 82.4 | 2.86e-11 | NTclustered | gi|760450068|ref|XM_011403801.1| | 3075 | g51230 | i0 | 87.324 | 1.42338709677419 | 71 | 9 | 29 | 0 | 170 | 240 | 49 | 119 | Auxenochlorella protothecoides Peptidyl-prolyl cis-trans isomerase CYP18-4 partial mRNA | blastn | 353 | 82.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 18418957 | 18418957 | PRJNA594101_S_NODE_36735_length_286_cov_1.305164_g36433_i0 | PRJNA594101 | 36735 | 286 | 1.305164 | 3.73276904 | Monoraphidium neglectum | 145388 | Plants | Plants | 163 | 1.17e-35 | NTclustered | gi|926787363|ref|XM_014046702.1| | 145388 | g36433 | i0 | 83.333 | 7.96503496503496 | 180 | 26 | 62 | 4 | 29 | 206 | 870 | 693 | Monoraphidium neglectum Calreticulin Flags: Precursor mRNA | blastn | 2278 | 163 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 22244396 | 22244396 | PRJNA594101_S_NODE_54018_length_245_cov_0.895349_g53716_i0 | PRJNA594101 | 54018 | 245 | 0.895349 | 2.19360505 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 226 | 1.23e-54 | NTclustered | gi|2082257783|ref|XM_001698358.2| | 3055 | g53716 | i0 | 83.471 | 24.8408163265306 | 242 | 40 | 99 | 0 | 2 | 243 | 1110 | 1351 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_10g461050v5), mRNA | blastn | 6086 | 226 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii |
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);;