contig_metadata
4 rows where bioproject = "PRJDB12134" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2255868 | 2255868 | PRJDB12134_P_NODE_12162_length_255_cov_1.318681_g12027_i0 | PRJDB12134 | 12162 | 255 | 1.318681 | 3.36263655 | Trebouxiophyceae | 75966 | Plants | Plants | 374 | 4.3499999999999996e-99 | NTclustered | gi|371782094|emb|HE610126.1| | 33092 | g12027 | i0 | 93.359 | 100.235294117647 | 256 | 12 | 100 | 5 | 1 | 255 | 4532 | 4281 | Koliella longiseta 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 470-1 | blastn | 25560 | 374 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella longiseta | |
| 9908815 | 9908815 | PRJDB12134_P_NODE_9148_length_307_cov_1.320513_g9013_i0 | PRJDB12134 | 9148 | 307 | 1.320513 | 4.05397491 | Myrmecia | 13617 | Plants | Plants | 568 | 2.3e-157 | NTclustered | gi|871410|emb|Z47208.1| | 41461 | g9013 | i0 | 100 | 99.9348534201954 | 307 | 0 | 100 | 0 | 1 | 307 | 656 | 962 | M.astigmatica gene for 18S ribosomal RNA (small subunit) | blastn | 30680 | 568 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | Myrmecia astigmatica | |
| 10202906 | 10202906 | PRJDB12134_P_NODE_12909_length_249_cov_2.784091_g12774_i0 | PRJDB12134 | 12909 | 249 | 2.784091 | 6.93238659 | chlorobiont of Psora decipiens | 1938899 | Plants | Plants | 460 | 3.16e-125 | NTclustered | gi|1158556132|emb|LT717572.1| | 1938899 | g12774 | i0 | 100 | 86.3012048192771 | 249 | 0 | 100 | 0 | 1 | 249 | 273 | 25 | Chlorobiont of Psora decipiens partial 26S rRNA gene, isolate Swe2-Aus | blastn | 21489 | 460 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | chlorobiont of Psora decipiens | ||||
| 12459811 | 12459811 | PRJDB12134_P_NODE_6830_length_384_cov_1.655949_g6695_i0 | PRJDB12134 | 6830 | 384 | 1.655949 | 6.35884416 | Chlorella | 3071 | Plants | Plants | 521 | 2.3199999999999992e-143 | NTclustered | gi|77627727|dbj|AB237642.1| | 3077 | g6695 | i0 | 91.214 | 101.028645833333 | 387 | 29 | 100 | 5 | 1 | 384 | 1783 | 2167 | Chlorella vulgaris NIES:227 gene for 28S ribosomal RNA, partial sequence | blastn | 38795 | 521 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris |
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);;