contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA637219" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1885006 | 1885006 | PRJNA637219_S_NODE_18142_length_151_cov_2.843137_g18097_i0 | PRJNA637219 | 18142 | 151 | 2.843137 | 4.29313687 | Chloroidium ellipsoideum | 63676 | Plants | Plants | 268 | 1.12e-67 | NTclustered | gi|535783|dbj|D17810.1|CHLLSURRNA | 63676 | g18097 | i0 | 98.675 | 100 | 151 | 2 | 100 | 0 | 1 | 151 | 2109 | 1959 | Chlorella ellipsoidea gene for large subunit rRNA, with group-I self-splicing intron | blastn | 15100 | 268 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 6987365 | 6987365 | PRJNA637219_S_NODE_46_length_1315_cov_16.098736_g34_i0 | PRJNA637219 | 46 | 1315 | 16.098736 | 211.6983784 | Trentepohlia sp. BN17 | 3063876 | Plants | Plants | 76.8 | 7.98e-9 | NTclustered | gi|2192923729|ref|NC_060532.1| | 3063876 | g34 | i0 | 92.453 | 0.27148288973384 | 53 | 4 | 4 | 0 | 637 | 689 | 223485 | 223433 | Trentepohlia sp. BN17 chloroplast, complete genome | blastn | 357 | 76.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Trentepohliales | Trentepohliaceae | Trentepohlia | Trentepohlia sp. BN17 | |
| 7532891 | 7532891 | PRJNA637219_S_NODE_11386_length_166_cov_1.735043_g11341_i0 | PRJNA637219 | 11386 | 166 | 1.735043 | 2.88017138 | Pseudochlorella | 63681 | Plants | Plants | 307 | 2.69e-79 | NTclustered | gi|694226641|gb|KM116465.1| | 173497 | g11341 | i0 | 100 | 94.078313253012 | 166 | 0 | 100 | 0 | 1 | 166 | 2931 | 3096 | Pabia signiensis strain SAG 2110 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence | blastn | 15617 | 307 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Pseudochlorella | Pseudochlorella signiensis | |
| 8262047 | 8262047 | PRJNA637219_S_NODE_3567_length_251_cov_3.064356_g3522_i0 | PRJNA637219 | 3567 | 251 | 3.064356 | 7.69153356 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 63.9 | 1.05e-5 | NTclustered | gi|2082238366|ref|XM_043059241.1| | 3055 | g3522 | i0 | 91.304 | 0.183266932270916 | 46 | 4 | 18 | 0 | 117 | 162 | 1511 | 1556 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_02g081250v5), mRNA | blastn | 46 | 63.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 17186672 | 17186672 | PRJNA637219_S_NODE_12414_length_165_cov_1.163793_g12369_i0 | PRJNA637219 | 12414 | 165 | 1.163793 | 1.92025845 | Pseudochlorella signiensis | 173497 | Plants | Plants | 294 | 2.08e-75 | NTclustered | gi|725650714|ref|NC_025529.1| | 173497 | g12369 | i0 | 98.788 | 131.187878787879 | 165 | 2 | 100 | 0 | 1 | 165 | 151173 | 151009 | Pabia signiensis culture-collection SAG:7.90 chloroplast, complete genome | blastn | 21646 | 294 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Pseudochlorella | Pseudochlorella signiensis | |
| 17186792 | 17186792 | PRJNA637219_S_NODE_4994_length_220_cov_1.333333_g4949_i0 | PRJNA637219 | 4994 | 220 | 1.333333 | 2.9333326 | Pseudochlorella signiensis | 173497 | Plants | Plants | 368 | 1.6999999999999997e-97 | NTclustered | gi|725650714|ref|NC_025529.1| | 173497 | g4949 | i0 | 96.818 | 113.281818181818 | 220 | 7 | 100 | 0 | 1 | 220 | 151480 | 151261 | Pabia signiensis culture-collection SAG:7.90 chloroplast, complete genome | blastn | 24922 | 368 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Pseudochlorella | Pseudochlorella signiensis | |
| 17732938 | 17732938 | PRJNA637219_S_NODE_1994_length_319_cov_2.151852_g1949_i0 | PRJNA637219 | 1994 | 319 | 2.151852 | 6.86440788 | Pseudochlorella | 63681 | Plants | Plants | 507 | 5.31e-139 | NTclustered | gi|1139689052|emb|LT560356.1| | 3072 | g1949 | i0 | 95.327 | 100.529780564263 | 321 | 12 | 100 | 3 | 1 | 319 | 607 | 926 | Pseudochlorella pringsheimii partial 18S rRNA gene, strain SAG 211-1a | blastn | 32069 | 512 | 0.990234375 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Pseudochlorella | Pseudochlorella pringsheimii | |
| 18460977 | 18460977 | PRJNA637219_S_NODE_8915_length_178_cov_1.131783_g8870_i0 | PRJNA637219 | 8915 | 178 | 1.131783 | 2.01457374 | Chlorella variabilis | 554065 | Plants | Plants | 167 | 5.149999999999999e-37 | NTclustered | gi|552812580|ref|XM_005843676.1| | 554065 | g8870 | i0 | 84.211 | 0.960674157303371 | 171 | 27 | 96 | 0 | 5 | 175 | 205 | 375 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_140078) mRNA, complete cds | blastn | 171 | 167 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 23561409 | 23561409 | PRJNA637219_S_NODE_16859_length_161_cov_0.910714_g16814_i0 | PRJNA637219 | 16859 | 161 | 0.910714 | 1.46624954 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 279 | 5.64e-71 | NTclustered | gi|760448684|ref|XM_011403109.1| | 3075 | g16814 | i0 | 98.125 | 0.993788819875776 | 160 | 3 | 99 | 0 | 2 | 161 | 300 | 141 | Auxenochlorella protothecoides hypothetical protein partial mRNA | blastn | 160 | 279 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides |
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);;