contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA576995" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3111711 | 3111711 | PRJNA576995_P_NODE_37483_length_248_cov_0.880000_g36891_i0 | PRJNA576995 | 37483 | 248 | 0.88 | 2.1824 | Chlorella variabilis | 554065 | Plants | Plants | 176 | 1.28e-39 | NTclustered | gi|552825269|ref|XM_005846724.1| | 554065 | g36891 | i0 | 80 | 4.42741935483871 | 240 | 46 | 96 | 2 | 4 | 242 | 554 | 316 | Chlorella variabilis 26S proteasome AAA-ATPase subunit RPT6a (CHLNCDRAFT_135304) mRNA, complete cds | blastn | 1098 | 176 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 6240614 | 6240614 | PRJNA576995_P_NODE_9445_length_507_cov_1.419355_g8855_i0 | PRJNA576995 | 9445 | 507 | 1.419355 | 7.19612985 | Chlorellaceae | 35461 | Plants | Plants | 324 | 9.52e-84 | NTclustered | gi|2724824453|gb|PP746560.1| | 173497 | g8855 | i0 | 79.867 | 66.6587771203156 | 452 | 83 | 88 | 7 | 6 | 453 | 50202 | 49755 | Pseudochlorella signiensis culture SAG:7.90 mitochondrion, complete genome | blastn | 33796 | 324 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Pseudochlorella | Pseudochlorella signiensis | |
| 17138408 | 17138408 | PRJNA576995_P_NODE_33634_length_257_cov_1.451087_g33042_i0 | PRJNA576995 | 33634 | 257 | 1.451087 | 3.72929359 | Monoraphidium neglectum | 145388 | Plants | Plants | 58.4 | 5.02e-4 | NTclustered | gi|926777873|ref|XM_014041957.1| | 145388 | g33042 | i0 | 97.059 | 1.33073929961089 | 34 | 1 | 13 | 0 | 80 | 113 | 1140 | 1173 | Monoraphidium neglectum hypothetical protein mRNA | blastn | 342 | 58.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum |
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);;