contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA951810" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3486024 | 3486024 | PRJNA951810_P_NODE_101583_length_292_cov_3.073059_g101239_i0 | PRJNA951810 | 101583 | 292 | 3.073059 | 8.97333228 | Volvox carteri | 3067 | Plants | Plants | 87.9 | 7.42e-13 | NTclustered | gi|302853986|ref|XM_002958459.1| | 3068 | g101239 | i0 | 85.882 | 36.2876712328767 | 85 | 9 | 29 | 3 | 170 | 253 | 1048 | 966 | Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_108163), mRNA | blastn | 10596 | 87.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 3486936 | 3486936 | PRJNA951810_P_NODE_156723_length_252_cov_6.016760_g156378_i0 | PRJNA951810 | 156723 | 252 | 6.01676 | 15.1622352 | Paradoxia multiseta | 249350 | Plants | Plants | 409 | 1.18e-109 | NTclustered | gi|723457039|ref|NC_025540.1| | 249350 | g156378 | i0 | 96.032 | 2.65873015873016 | 252 | 8 | 99 | 2 | 1 | 251 | 87316 | 87566 | Paradoxia multiseta culture-collection SAG:18.84 chloroplast, complete genome | blastn | 670 | 409 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Paradoxia | Paradoxia multiseta | ||
| 7640967 | 7640967 | PRJNA951810_P_NODE_117426_length_282_cov_1.377990_g117082_i0 | PRJNA951810 | 117426 | 282 | 1.37799 | 3.8859318 | Ulva | 3118 | Plants | Plants | 52.8 | 0.026 | NTclustered | gi|2589364038|ref|NC_077591.1| | 434723 | g117082 | i0 | 100 | 0.198581560283688 | 28 | 0 | 10 | 0 | 88 | 115 | 34563 | 34590 | Ulva meridionalis isolate LF010 chloroplast, complete genome | blastn | 56 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva meridionalis | |
| 9866198 | 9866198 | PRJNA951810_P_NODE_86828_length_298_cov_5.000000_g86484_i0 | PRJNA951810 | 86828 | 298 | 5 | 14.9 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|2082257428|ref|XM_043067003.1| | 3055 | g86484 | i0 | 100 | 0.100671140939597 | 30 | 0 | 10 | 0 | 205 | 234 | 1431 | 1460 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_10g453400v5), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 11140340 | 11140340 | PRJNA951810_P_NODE_181809_length_230_cov_2.834395_g181464_i0 | PRJNA951810 | 181809 | 230 | 2.834395 | 6.5191085 | Asterochloris sp. DA2 | 909298 | Plants | Plants | 176 | 1.17e-39 | NTclustered | gi|310877182|gb|HM355458.1| | 909298 | g181464 | i0 | 80.952 | 85.3521739130435 | 231 | 36 | 99 | 8 | 1 | 227 | 411 | 185 | Asterochloris sp. DA2 clone SLJClgrII_0233_ef1a hypothetical protein mRNA, partial cds | blastn | 19631 | 176 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Asterochloris | Asterochloris sp. DA2 | |
| 16239097 | 16239097 | PRJNA951810_P_NODE_158393_length_251_cov_3.044944_g158048_i0 | PRJNA951810 | 158393 | 251 | 3.044944 | 7.64280944 | Pleurastrosarcina brevispinosa | 163096 | Plants | Plants | 259 | 1.25e-64 | NTclustered | gi|698349064|gb|KM462875.1| | 163096 | g158048 | i0 | 97.987 | 0.593625498007968 | 149 | 3 | 59 | 0 | 103 | 251 | 234713 | 234861 | Chlorosarcina brevispinosa culture-collection UTEX:1176 chloroplast, partial genome | blastn | 149 | 259 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Pleurastrosarcina | Pleurastrosarcina brevispinosa | |||
| 16239317 | 16239317 | PRJNA951810_P_NODE_171833_length_241_cov_1.738095_g171488_i0 | PRJNA951810 | 171833 | 241 | 1.738095 | 4.18880895 | Monoraphidium neglectum | 145388 | Plants | Plants | 60.2 | 1.3e-4 | NTclustered | gi|926785291|ref|XM_014045666.1| | 145388 | g171488 | i0 | 97.222 | 15.8257261410788 | 36 | 0 | 15 | 1 | 4 | 39 | 478 | 444 | Monoraphidium neglectum Asparagine synthetase domain-containing protein 1 mRNA | blastn | 3814 | 60.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 16240369 | 16240369 | PRJNA951810_P_NODE_53293_length_310_cov_4.776371_g52950_i0 | PRJNA951810 | 53293 | 310 | 4.776371 | 14.8067501 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 87.9 | 7.94e-13 | NTclustered | gi|545364112|ref|XM_005647064.1| | 574566 | g52950 | i0 | 89.706 | 0.419354838709677 | 68 | 7 | 22 | 0 | 80 | 147 | 2177 | 2244 | Coccomyxa subellipsoidea C-169 ubiquitin-activating enzyme E1 mRNA | blastn | 130 | 87.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 25161830 | 25161830 | PRJNA951810_P_NODE_124720_length_277_cov_1.318627_g124375_i0 | PRJNA951810 | 124720 | 277 | 1.318627 | 3.65259679 | Chlorella variabilis | 554065 | Plants | Plants | 52.8 | 0.025 | NTclustered | gi|552833079|ref|XM_005848416.1| | 554065 | g124375 | i0 | 96.774 | 0.111913357400722 | 31 | 1 | 11 | 0 | 60 | 90 | 2179 | 2149 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_144896) mRNA, complete cds | blastn | 31 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 25162823 | 25162823 | PRJNA951810_P_NODE_186140_length_224_cov_4.523179_g185795_i0 | PRJNA951810 | 186140 | 224 | 4.523179 | 10.13192096 | Volvox carteri | 3067 | Plants | Plants | 58.4 | 4.28e-4 | NTclustered | gi|302834113|ref|XM_002948574.1| | 3068 | g185795 | i0 | 100 | 0.669642857142857 | 31 | 0 | 14 | 0 | 190 | 220 | 4152 | 4122 | Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_103955), partial mRNA | blastn | 150 | 58.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri |
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);;