contig_metadata
10 rows where bioproject = "PRJNA1061474" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2729561 | 2729561 | PRJNA1061474_P_NODE_56303_length_242_cov_0.911243_g56057_i0 | PRJNA1061474 | 56303 | 242 | 0.911243 | 2.20520806 | Coccomyxa viridis | 1274662 | Plants | Plants | 160 | 9.37e-46 | NR | CAK0912297.1 | 1274662 | g56057 | i0 | 97.5 | 3.96694214876033 | 80 | 2 | 99.2 | 0 | 240 | 1 | 261 | 340 | CAK0912297.1 tufA [Coccomyxa viridis] | diamond | 960 | 160 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 7389431 | 7389431 | PRJNA1061474_P_NODE_54466_length_244_cov_0.900585_g54220_i0 | PRJNA1061474 | 54466 | 244 | 0.900585 | 2.1974274 | Desmochloris | 138596 | Plants | Plants | 322 | 1.52e-83 | NTclustered | gi|313476264|emb|FM882217.1| | 578869 | g54220 | i0 | 98.37 | 75.0573770491803 | 184 | 1 | 75 | 2 | 15 | 198 | 344 | 163 | Desmochloris sp. TP-2008 partial 18S rRNA gene, ITS1, 5.8S rRNA and ITS2, strain CCAP 6006/2 | blastn | 18314 | 322 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris mollenhaueri | |
| 7830696 | 7830696 | PRJNA1061474_P_NODE_24087_length_391_cov_0.814465_g23841_i0 | PRJNA1061474 | 24087 | 391 | 0.814465 | 3.18455815 | Eukaryota | 2759 | Plants | Plants | 171 | 1.5899999999999999e-46 | NR | PRW32884.1 | 3076 | g23841 | i0 | 82.1 | 20.7928388746803 | 106 | 19 | 81.3 | 0 | 5 | 322 | 20 | 125 | PRW32884.1 Histone H2A [Chlorella sorokiniana] | diamond | 8130 | 172 | 0.994186046511628 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 17589500 | 17589500 | PRJNA1061474_P_NODE_49834_length_247_cov_1.591954_g49588_i0 | PRJNA1061474 | 49834 | 247 | 1.591954 | 3.93212638 | Chlorophyta | 3041 | Plants | Plants | 396 | 8.95e-106 | NTclustered | gi|45385169|gb|AY553213.1| | 3075 | g49588 | i0 | 95.547 | 100.004048582996 | 247 | 11 | 100 | 0 | 1 | 247 | 862 | 1108 | Auxenochlorella protothecoides 16S small subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 24701 | 396 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 27541132 | 27541132 | PRJNA1061474_P_NODE_33344_length_317_cov_1.737705_g33098_i0 | PRJNA1061474 | 33344 | 317 | 1.737705 | 5.50852485 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 192 | 3.8899999999999994e-57 | NR | GAX78472.1 | 1157962 | g33098 | i0 | 88.6 | 0.993690851735016 | 105 | 12 | 99.4 | 0 | 315 | 1 | 351 | 455 | GAX78472.1 hypothetical protein CEUSTIGMA_g5911.t1 [Chlamydomonas eustigma] | diamond | 315 | 192 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 28606274 | 28606274 | PRJNA1061474_P_NODE_56707_length_242_cov_0.911243_g56461_i0 | PRJNA1061474 | 56707 | 242 | 0.911243 | 2.20520806 | root | 1 | Root_unresolved | Root_unresolved | 53.1 | 7.98e-6 | NR | GIL51318.1 | 51714 | g56461 | i0 | 50 | 2.98760330578512 | 52 | 26 | 64.5 | 0 | 215 | 60 | 124 | 175 | GIL51318.1 hypothetical protein Vafri_7335 [Volvox africanus] | diamond | 723 | 53.5 | 0.992523364485981 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox africanus | |
| 29624416 | 29624416 | PRJNA1061474_P_NODE_35830_length_303_cov_0.982609_g35584_i0 | PRJNA1061474 | 35830 | 303 | 0.982609 | 2.97730527 | Chlorella desiccata (nom. nud.) | 1650286 | Plants | Plants | 60.8 | 7.63e-9 | NR | KAG7666851.1 | 1650286 | g35584 | i0 | 53.2 | 2.6039603960396 | 62 | 28 | 61.4 | 1 | 118 | 303 | 34 | 94 | KAG7666851.1 hypothetical protein KSW81_000618 [Chlorella desiccata (nom. nud.)] | diamond | 789 | 60.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 30003981 | 30003981 | PRJNA1061474_P_NODE_32371_length_324_cov_0.804781_g32125_i0 | PRJNA1061474 | 32371 | 324 | 0.804781 | 2.60749044 | Scenedesmus sp. NREL 46B-D3 | 2650976 | Plants | Plants | 49.3 | 2.65e-4 | NR | KAF6259220.1 | 2650976 | g32125 | i0 | 39.5 | 0.703703703703704 | 76 | 38 | 66.7 | 2 | 109 | 324 | 11 | 82 | KAF6259220.1 plastid lipid-associated protein/fibrillin conserved domain-containing protein [Scenedesmus sp. NREL 46B-D3] | diamond | 228 | 49.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. NREL 46B-D3 | |
| 31227725 | 31227725 | PRJNA1061474_P_NODE_27935_length_355_cov_1.702128_g27689_i0 | PRJNA1061474 | 27935 | 355 | 1.702128 | 6.0425544 | root | 1 | Root_unresolved | Root_unresolved | 91.3 | 1.32e-18 | NR | WIA21344.1 | 3088 | g27689 | i0 | 64.6 | 2.67887323943662 | 65 | 23 | 54.9 | 0 | 7 | 201 | 597 | 661 | WIA21344.1 hypothetical protein OEZ85_000570 [Tetradesmus obliquus] | diamond | 951 | 91.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 31931905 | 31931905 | PRJNA1061474_P_NODE_21097_length_424_cov_1.316239_g20851_i0 | PRJNA1061474 | 21097 | 424 | 1.316239 | 5.58085336 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 100 | 2.1699999999999994e-24 | NR | CAG9460866.1 | 765719 | g20851 | i0 | 47.3 | 0.92688679245283 | 131 | 53 | 92.7 | 1 | 401 | 9 | 8 | 122 | CAG9460866.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 393 | 100 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 |
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);;