contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA395690" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1078965 | 1078965 | PRJNA395690_P_NODE_14101_length_217_cov_0.910714_g13949_i0 | PRJNA395690 | 14101 | 217 | 0.910714 | 1.97624938 | Viridiplantae | 33090 | Plants | Plants | 307 | 3.7e-79 | NTclustered | gi|162134340|gb|EU123979.1| | 160068 | g13949 | i0 | 92.202 | 121.875576036866 | 218 | 16 | 100 | 1 | 1 | 217 | 2025 | 2242 | Trebouxia aggregata strain SAG 219-1d large subunit ribosomal RNA (rrl) gene, complete sequence; and putative site-specific DNA endonuclease (orf210) and hypothetical protein (orf277) genes, complete cds; chloroplast | blastn | 26447 | 309 | 0.993527508090615 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia aggregata | |
| 3629866 | 3629866 | PRJNA395690_P_NODE_36163_length_161_cov_0.910714_g36011_i0 | PRJNA395690 | 36163 | 161 | 0.910714 | 1.46624954 | Eukaryota | 2759 | Plants | Plants | 137 | 3.59e-28 | NTclustered | gi|760444892|ref|XM_011401213.1| | 3075 | g36011 | i0 | 82.39 | 36.0496894409938 | 159 | 26 | 98 | 2 | 4 | 161 | 650 | 493 | Auxenochlorella protothecoides RuvB-like 1 partial mRNA | blastn | 5804 | 137 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 5515365 | 5515365 | PRJNA395690_P_NODE_2665_length_479_cov_1.269767_g2517_i0 | PRJNA395690 | 2665 | 479 | 1.269767 | 6.08218393 | Polytomella sp. Pringsheim 198.80 | 37502 | Plants | Plants | 193 | 2.63e-44 | NTclustered | gi|28193497|emb|AJ439528.1| | 37502 | g2517 | i0 | 79.225 | 34.2526096033403 | 284 | 53 | 58 | 4 | 171 | 450 | 595 | 314 | Polytomella sp. 'Pringsheim 198.80' mRNA for 40S ribosomal protein s5 (rs5 gene) | blastn | 16407 | 193 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella sp. Pringsheim 198.80 | |
| 8064873 | 8064873 | PRJNA395690_P_NODE_18007_length_191_cov_2.971831_g17855_i0 | PRJNA395690 | 18007 | 191 | 2.971831 | 5.67619721 | Koliella sp. HS-2024a | 3231931 | Plants | Plants | 139 | 1.23e-28 | NTclustered | gi|2754686564|gb|PP990794.1| | 3231931 | g17855 | i0 | 88.235 | 87.1361256544503 | 119 | 11 | 61 | 3 | 21 | 137 | 8823 | 8940 | Koliella sp. HS-2024a strain FACHB-3607 mitochondrion, complete genome | blastn | 16643 | 139 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella sp. HS-2024a | |
| 8064976 | 8064976 | PRJNA395690_P_NODE_26147_length_172_cov_1.292683_g25995_i0 | PRJNA395690 | 26147 | 172 | 1.292683 | 2.22341476 | Polulichloris maxima | 2704661 | Plants | Plants | 222 | 1.04e-53 | NTclustered | gi|2473928686|ref|NC_072905.1| | 2704661 | g25995 | i0 | 92.308 | 96.1802325581395 | 156 | 12 | 91 | 0 | 1 | 156 | 126487 | 126332 | Polulichloris maxima clone L123 chloroplast, complete genome | blastn | 16543 | 222 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Polulichloris | Polulichloris maxima | |
| 8731883 | 8731883 | PRJNA395690_P_NODE_6807_length_309_cov_1.361538_g6655_i0 | PRJNA395690 | 6807 | 309 | 1.361538 | 4.20715242 | Marvania | 97104 | Plants | Plants | 137 | 7.74e-28 | NTclustered | gi|2724824493|gb|PP746561.1| | 97105 | g6655 | i0 | 79.512 | 10.5954692556634 | 205 | 33 | 65 | 8 | 33 | 234 | 1286 | 1484 | Marvania geminata culture SAG:12.88 mitochondrion, complete genome | blastn | 3274 | 137 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Marvania | Marvania geminata | |
| 12557744 | 12557744 | PRJNA395690_P_NODE_32130_length_164_cov_0.886957_g31978_i0 | PRJNA395690 | 32130 | 164 | 0.886957 | 1.45460948 | Scenedesmaceae | 3086 | Plants | Plants | 252 | 1.26e-62 | NTclustered | gi|2312613210|ref|NC_066651.1| | 77547 | g31978 | i0 | 95 | 148.981707317073 | 160 | 8 | 98 | 0 | 5 | 164 | 74783 | 74942 | Desmodesmus abundans strain FBCC-A1277 chloroplast, complete genome | blastn | 24433 | 252 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Desmodesmus | Desmodesmus abundans | |
| 17656589 | 17656589 | PRJNA395690_P_NODE_21674_length_182_cov_7.924812_g21522_i0 | PRJNA395690 | 21674 | 182 | 7.924812 | 14.42315784 | Eukaryota | 2759 | Plants | Plants | 274 | 3.03e-69 | NTclustered | gi|1255307117|gb|KY198301.1| | 3067 | g21522 | i0 | 100 | 85.4395604395604 | 148 | 0 | 99 | 0 | 35 | 182 | 376 | 229 | Volvox carteri isolate EMBOSS_001 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 15550 | 274 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 18263358 | 18263358 | PRJNA395690_P_NODE_29675_length_166_cov_0.871795_g29523_i0 | PRJNA395690 | 29675 | 166 | 0.871795 | 1.4471797 | uncultured Scenedesmus | 223195 | Plants | Plants | 224 | 2.7799999999999995e-54 | NTclustered | gi|430000717|gb|JX877643.1| | 223195 | g29523 | i0 | 96.324 | 70.6144578313253 | 136 | 5 | 82 | 0 | 31 | 166 | 1 | 136 | Uncultured Scenedesmus clone HP04 23S ribosomal RNA gene, partial sequence | blastn | 11722 | 224 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | uncultured Scenedesmus |
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);;