contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA939370" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2190073 | 2190073 | PRJNA939370_S_NODE_82_length_816_cov_3.998696_g55_i0 | PRJNA939370 | 82 | 816 | 3.998696 | 32.62935936 | Prototheca wickerhamii | 3111 | Plants | Plants | 93.5 | 4.83e-14 | NTclustered | gi|14212|emb|X68722.1| | 3111 | g55 | i0 | 89.333 | 4.9031862745098 | 75 | 7 | 9 | 1 | 167 | 241 | 318 | 391 | P.wickerhamii mitochondrial gene for large ribosomal RNA | blastn | 4001 | 93.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 6017859 | 6017859 | PRJNA939370_S_NODE_3005_length_164_cov_1.217391_g2953_i0 | PRJNA939370 | 3005 | 164 | 1.217391 | 1.99652124 | Pseudochlorella signiensis | 173497 | Plants | Plants | 237 | 3.52e-58 | NTclustered | gi|725650714|ref|NC_025529.1| | 173497 | g2953 | i0 | 92.727 | 145.30487804878 | 165 | 11 | 100 | 1 | 1 | 164 | 151181 | 151017 | Pabia signiensis culture-collection SAG:7.90 chloroplast, complete genome | blastn | 23830 | 237 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Pseudochlorella | Pseudochlorella signiensis | |
| 9842665 | 9842665 | PRJNA939370_S_NODE_2128_length_188_cov_1.100719_g2076_i0 | PRJNA939370 | 2128 | 188 | 1.100719 | 2.06935172 | Stichococcus bacillaris | 37433 | Plants | Plants | 122 | 1.2099999999999999e-23 | NTclustered | gi|371782130|emb|HE610162.1| | 37433 | g2076 | i0 | 89.583 | 58.5851063829787 | 96 | 10 | 51 | 0 | 93 | 188 | 1039 | 944 | Stichococcus bacillaris plastid partial 23S rRNA gene, strain SAG 379-2 | blastn | 11014 | 122 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 24207718 | 24207718 | PRJNA939370_S_NODE_1259_length_247_cov_2.535354_g1207_i0 | PRJNA939370 | 1259 | 247 | 2.535354 | 6.26232438 | Eukaryota | 2759 | Plants | Plants | 313 | 9.28e-81 | NTclustered | gi|2316813204|gb|OP643786.1| | 3079 | g1207 | i0 | 99.419 | 70.331983805668 | 172 | 1 | 70 | 0 | 76 | 247 | 681 | 510 | Chlorella sp. isolate NTBN_1 small subunit ribosomal RNA gene, partial sequence | blastn | 17372 | 313 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. |
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);;