contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA576995" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 560851 | 560851 | PRJNA576995_P_NODE_31881_length_268_cov_1.256410_g31289_i0 | PRJNA576995 | 31881 | 268 | 1.25641 | 3.3671788 | Micromonas commoda | 296587 | Plants | Plants | 224 | 4.909999999999999e-54 | NTclustered | gi|255081109|ref|XM_002504075.1| | 296587 | g31289 | i0 | 81.784 | 45.9514925373134 | 269 | 47 | 100 | 2 | 1 | 268 | 7 | 274 | Micromonas commoda predicted protein partial mRNA | blastn | 12315 | 224 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 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 | |
| 10765289 | 10765289 | PRJNA576995_P_NODE_8389_length_543_cov_2.661702_g7802_i0 | PRJNA576995 | 8389 | 543 | 2.661702 | 14.45304186 | Chloropicon roscoffensis | 1461544 | Plants | Plants | 141 | 1.11e-28 | NTclustered | gi|2863418128|gb|CP145462.1| | 1461544 | g7802 | i0 | 84 | 2.96685082872928 | 150 | 21 | 27 | 3 | 337 | 484 | 130232 | 130380 | Chloropicon roscoffensis strain RCC2335 chromosome 3 | blastn | 1611 | 141 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Chloropicophyceae | Chloropicales | Chloropicaceae | Chloropicon | Chloropicon roscoffensis | ||
| 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 | |
| 19687235 | 19687235 | PRJNA576995_P_NODE_31356_length_271_cov_1.151515_g30764_i0 | PRJNA576995 | 31356 | 271 | 1.151515 | 3.12060565 | Mantoniella tinhauana | 3097027 | Plants | Plants | 196 | 1.08e-45 | NTclustered | gi|2735153277|gb|CP140062.1| | 3097027 | g30764 | i0 | 81.405 | 1.80073800738007 | 242 | 43 | 89 | 2 | 1 | 241 | 795144 | 795384 | Mantoniella tinhauana isolate LFS chromosome 1 | blastn | 488 | 196 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Mantoniella | Mantoniella tinhauana |
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);;