contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1105232" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2763259 | 2763259 | PRJNA1105232_S_NODE_11703_length_189_cov_1.114286_g11487_i0 | PRJNA1105232 | 11703 | 189 | 1.114286 | 2.10600054 | Chlamydomonas cribrum | 69356 | Plants | Plants | 93.5 | 9.56e-15 | NTclustered | gi|1483735093|dbj|LC380266.1| | 69356 | g11487 | i0 | 87.5 | 38.7248677248677 | 80 | 10 | 42 | 0 | 1 | 80 | 372 | 293 | Chlamydomonas cribrum SAG 13.72 chloroplast atpB gene for ATP synthase beta-subunit, partial cds | blastn | 7319 | 93.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas cribrum | |
| 2763314 | 2763314 | PRJNA1105232_S_NODE_7943_length_221_cov_1.668605_g7727_i0 | PRJNA1105232 | 7943 | 221 | 1.668605 | 3.68761705 | Monoraphidium neglectum | 145388 | Plants | Plants | 104 | 5.33e-18 | NTclustered | gi|926774775|ref|XM_014040408.1| | 145388 | g7727 | i0 | 79.73 | 12.7013574660633 | 148 | 26 | 66 | 4 | 1 | 146 | 394 | 539 | Monoraphidium neglectum 60S ribosomal protein L10 mRNA | blastn | 2807 | 104 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 4039344 | 4039344 | PRJNA1105232_S_NODE_16344_length_165_cov_1.344828_g16128_i0 | PRJNA1105232 | 16344 | 165 | 1.344828 | 2.2189662 | Chlorella variabilis | 554065 | Plants | Plants | 52.8 | 0.014 | NTclustered | gi|552824771|ref|XM_005846606.1| | 554065 | g16128 | i0 | 100 | 0.16969696969697 | 28 | 0 | 17 | 0 | 122 | 149 | 2148 | 2175 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_53051) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 5315458 | 5315458 | PRJNA1105232_S_NODE_15545_length_168_cov_0.873950_g15329_i0 | PRJNA1105232 | 15545 | 168 | 0.87395 | 1.468236 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 163 | 6.25e-36 | NTclustered | gi|2917929626|emb|OZ234914.1| | 3350044 | g15329 | i0 | 95.146 | 6.69642857142857 | 103 | 5 | 61 | 0 | 19 | 121 | 1365587 | 1365689 | Trebouxia sp. SL0000003 genome assembly, chromosome: 9 | blastn | 1125 | 163 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 9140197 | 9140197 | PRJNA1105232_S_NODE_3308_length_311_cov_4.118321_g3092_i0 | PRJNA1105232 | 3308 | 311 | 4.118321 | 12.80797831 | Trebouxia lynnae | 1825957 | Plants | Plants | 67.6 | 1.04e-6 | NTclustered | gi|1750939486|gb|MH917293.1| | 1825957 | g3092 | i0 | 87.719 | 0.183279742765273 | 57 | 7 | 18 | 0 | 102 | 158 | 13045 | 13101 | Trebouxia sp. TR9 mitochondrion, complete genome | blastn | 57 | 67.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia lynnae | |
| 15048103 | 15048103 | PRJNA1105232_S_NODE_1612_length_407_cov_7.924581_g1397_i0 | PRJNA1105232 | 1612 | 407 | 7.924581 | 32.25304467 | Trebouxiophyceae | 75966 | Plants | Plants | 63.9 | 1.8e-5 | NTclustered | gi|371782132|emb|HE610164.1| | 33092 | g1397 | i0 | 95 | 16.0884520884521 | 40 | 2 | 10 | 0 | 91 | 130 | 76 | 37 | Koliella longiseta plastid partial 23S rRNA gene, strain SAG 470-1 | blastn | 6548 | 63.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella longiseta | |
| 19338399 | 19338399 | PRJNA1105232_S_NODE_12636_length_183_cov_1.164179_g12420_i0 | PRJNA1105232 | 12636 | 183 | 1.164179 | 2.13044757 | Koliella longiseta | 33092 | Plants | Plants | 87.9 | 4.27e-13 | NTclustered | gi|371782132|emb|HE610164.1| | 33092 | g12420 | i0 | 88.889 | 28.9398907103825 | 72 | 7 | 39 | 1 | 45 | 115 | 76 | 5 | Koliella longiseta plastid partial 23S rRNA gene, strain SAG 470-1 | blastn | 5296 | 87.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella longiseta | |
| 24438530 | 24438530 | PRJNA1105232_S_NODE_7940_length_221_cov_1.813953_g7724_i0 | PRJNA1105232 | 7940 | 221 | 1.813953 | 4.00883613 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|2082235889|ref|XM_001700244.2| | 3055 | g7724 | i0 | 100 | 0.135746606334842 | 30 | 0 | 14 | 0 | 76 | 105 | 2266 | 2295 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g009400v5), mRNA | blastn | 30 | 56.5 | 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);;