contig_metadata
14 rows where 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 | |
| 26637767 | 26637767 | PRJNA637219_S_NODE_11001_length_167_cov_0.864407_g10956_i0 | PRJNA637219 | 11001 | 167 | 0.864407 | 1.44355969 | Monoraphidium neglectum | 145388 | Plants | Plants | 43.5 | 0.00134 | NR | XP_013891194.1 | 145388 | g10956 | i0 | 42.9 | 1.50898203592814 | 42 | 24 | 75.4 | 0 | 167 | 42 | 21 | 62 | XP_013891194.1 hypothetical protein MNEG_15788 [Monoraphidium neglectum] | diamond | 252 | 43.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 28533920 | 28533920 | PRJNA637219_S_NODE_10507_length_167_cov_1.296610_g10462_i0 | PRJNA637219 | 10507 | 167 | 1.29661 | 2.1653387 | Ulva partita | 1605170 | Plants | Plants | 97.4 | 1.28e-24 | NR | BAV58192.1 | 1605170 | g10462 | i0 | 80 | 0.988023952095808 | 55 | 11 | 98.8 | 0 | 2 | 166 | 51 | 105 | BAV58192.1 H/ACA ribonucleoprotein complex subunit 3 [Ulva partita] | diamond | 165 | 97.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva partita | |
| 30270832 | 30270832 | PRJNA637219_S_NODE_712_length_490_cov_7.390023_g667_i0 | PRJNA637219 | 712 | 490 | 7.390023 | 36.2111127 | Picochlorum sp. BPE23 | 2696299 | Plants | Plants | 142 | 2.1e-40 | NR | KAI8104783.1 | 2696299 | g667 | i0 | 65.6 | 3.03673469387755 | 122 | 42 | 74.7 | 0 | 27 | 392 | 1 | 122 | KAI8104783.1 hypothetical protein M9434_003335 [Picochlorum sp. BPE23] | diamond | 1488 | 142 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Picochlorum | Picochlorum sp. BPE23 | |||
| 30270833 | 30270833 | PRJNA637219_S_NODE_7452_length_190_cov_1.085106_g7407_i0 | PRJNA637219 | 7452 | 190 | 1.085106 | 2.0617014 | Gonium pectorale | 33097 | Plants | Plants | 52.4 | 6.96e-6 | NR | KXZ42091.1 | 33097 | g7407 | i0 | 77.8 | 2.13157894736842 | 27 | 6 | 42.6 | 0 | 190 | 110 | 285 | 311 | KXZ42091.1 hypothetical protein GPECTOR_208g403 [Gonium pectorale] | diamond | 405 | 52.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale | |
| 31692840 | 31692840 | PRJNA637219_S_NODE_16477_length_161_cov_1.366071_g16432_i0 | PRJNA637219 | 16477 | 161 | 1.366071 | 2.19937431 | Tetraselmis sp. RG-15 | 65602 | Plants | Plants | 46.2 | 6.67e-4 | NR | AAB70556.1 | 65602 | g16432 | i0 | 87 | 0.428571428571429 | 23 | 3 | 42.9 | 0 | 161 | 93 | 229 | 251 | AAB70556.1 chlorophyll a/b binding protein [Tetraselmis sp. RG-15] | diamond | 69 | 46.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorodendrophyceae | Chlorodendrales | Chlorodendraceae | Tetraselmis | Tetraselmis sp. RG-15 |
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);;