contig_metadata
9 rows where bioproject = "PRJNA1156092" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18154553 | 18154553 | PRJNA1156092_P_NODE_21995_length_251_cov_0.865169_g21865_i0 | PRJNA1156092 | 21995 | 251 | 0.865169 | 2.17157419 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 289 | 1.59e-73 | NTclustered | gi|545367524|ref|XM_005648521.1| | 574566 | g21865 | i0 | 87.549 | 11.597609561753 | 257 | 23 | 100 | 7 | 1 | 251 | 551 | 298 | Coccomyxa subellipsoidea C-169 chloroplast ribulose 1,5-bisphosphate carboxylase/oxygenase small subunit mRNA | blastn | 2911 | 289 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 24528961 | 24528961 | PRJNA1156092_P_NODE_500_length_1201_cov_2.898050_g431_i0 | PRJNA1156092 | 500 | 1201 | 2.89805 | 34.8055805 | Scherffelia dubia | 3190 | Plants | Plants | 75 | 2.62e-8 | NTclustered | gi|1783497212|ref|NC_045363.1| | 3190 | g431 | i0 | 77.536 | 4.5661948376353 | 138 | 21 | 11 | 9 | 603 | 732 | 31508 | 31373 | Scherffelia dubia culture SAG:17.86 mitochondrion, complete genome | blastn | 5484 | 75 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorodendrophyceae | Chlorodendrales | Chlorodendraceae | Scherffelia | Scherffelia dubia | |
| 27565028 | 27565028 | PRJNA1156092_P_NODE_12184_length_326_cov_0.909091_g12054_i0 | PRJNA1156092 | 12184 | 326 | 0.909091 | 2.96363666 | Chlorophyta | 3041 | Plants | Plants | 79.7 | 1.04e-14 | NR | KAK9916564.1 | 248742 | g12054 | i0 | 52.1 | 2.99079754601227 | 71 | 34 | 65.3 | 0 | 105 | 317 | 655 | 725 | KAK9916564.1 hypothetical protein WJX75_004254 [Coccomyxa subellipsoidea] | diamond | 975 | 79.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 27798666 | 27798666 | PRJNA1156092_P_NODE_29564_length_244_cov_0.900585_g29434_i0 | PRJNA1156092 | 29564 | 244 | 0.900585 | 2.1974274 | Coccomyxa sp. Obi | 2315456 | Plants | Plants | 72.4 | 1.48e-13 | NR | BDA45404.1 | 2315456 | g29434 | i0 | 94.4 | 0.442622950819672 | 36 | 2 | 44.3 | 0 | 2 | 109 | 16 | 51 | BDA45404.1 hypothetical protein COCOBI_07-1910 [Coccomyxa sp. Obi] | diamond | 108 | 72.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa sp. Obi | ||
| 29882571 | 29882571 | PRJNA1156092_P_NODE_20051_length_263_cov_1.368421_g19921_i0 | PRJNA1156092 | 20051 | 263 | 1.368421 | 3.59894723 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 74.3 | 3.49e-13 | NR | GAX85640.1 | 1157962 | g19921 | i0 | 63.2 | 0.650190114068441 | 57 | 21 | 65 | 0 | 172 | 2 | 236 | 292 | GAX85640.1 hypothetical protein CEUSTIGMA_g13055.t1 [Chlamydomonas eustigma] | diamond | 171 | 74.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 30281306 | 30281306 | PRJNA1156092_P_NODE_29212_length_244_cov_0.900585_g29082_i0 | PRJNA1156092 | 29212 | 244 | 0.900585 | 2.1974274 | Eukaryota | 2759 | Plants | Plants | 90.9 | 8.91e-20 | NR | WIA16162.1 | 3088 | g29082 | i0 | 66.7 | 4.47540983606557 | 72 | 23 | 88.5 | 1 | 218 | 3 | 1 | 71 | WIA16162.1 hypothetical protein OEZ85_012877 [Tetradesmus obliquus] | diamond | 1092 | 90.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 31196742 | 31196742 | PRJNA1156092_P_NODE_11355_length_334_cov_1.475096_g11225_i0 | PRJNA1156092 | 11355 | 334 | 1.475096 | 4.92682064 | root | 1 | Root_unresolved | Root_unresolved | 150 | 1.62e-43 | NR | CAD7699412.1 | 121088 | g11225 | i0 | 66.1 | 2.88323353293413 | 109 | 37 | 97.9 | 0 | 6 | 332 | 1 | 109 | CAD7699412.1 unnamed protein product [Ostreobium quekettii] | diamond | 963 | 150 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii | |
| 31715421 | 31715421 | PRJNA1156092_P_NODE_26077_length_247_cov_0.885057_g25947_i0 | PRJNA1156092 | 26077 | 247 | 0.885057 | 2.18609079 | Coccomyxa viridis | 1274662 | Plants | Plants | 51.2 | 2.99e-5 | NR | CAL5223732.1 | 1274662 | g25947 | i0 | 37.5 | 0.97165991902834 | 80 | 50 | 97.2 | 0 | 245 | 6 | 82 | 161 | CAL5223732.1 g6292 [Coccomyxa viridis] | diamond | 240 | 51.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 32221647 | 32221647 | PRJNA1156092_P_NODE_28778_length_245_cov_0.866279_g28648_i0 | PRJNA1156092 | 28778 | 245 | 0.866279 | 2.12238355 | Monoraphidium minutum | 39955 | Plants | Plants | 76.3 | 5.95e-14 | NR | KAI8462587.1 | 39955 | g28648 | i0 | 49.4 | 0.991836734693878 | 81 | 39 | 99.2 | 2 | 243 | 1 | 179 | 257 | KAI8462587.1 MAG: phosphoglucomutase [Monoraphidium minutum] | diamond | 243 | 76.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium minutum |
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);;