contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA692200" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7051363 | 7051363 | PRJNA692200_S_NODE_19866_length_167_cov_1.686441_g19809_i0 | PRJNA692200 | 19866 | 167 | 1.686441 | 2.81635647 | Raphidocelis subcapitata | 307507 | Plants | Plants | 59.3 | 1.83e-8 | NR | GBF90757.1 | 307507 | g19809 | i0 | 53.1 | 0.880239520958084 | 49 | 23 | 88 | 0 | 3 | 149 | 315 | 363 | GBF90757.1 ubiquitin carboxyl-terminal hydrolase-like protein [Raphidocelis subcapitata] | diamond | 147 | 59.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Raphidocelis | Raphidocelis subcapitata | |
| 9601356 | 9601356 | PRJNA692200_S_NODE_508_length_503_cov_10.823789_g475_i0 | PRJNA692200 | 508 | 503 | 10.823789 | 54.44365867 | Coccomyxa subellipsoidea C-169 | 574566 | Plants | Plants | 196 | 7.02e-60 | NR | XP_005643653.1 | 574566 | g475 | i0 | 66.7 | 2.52286282306163 | 141 | 47 | 84.1 | 0 | 3 | 425 | 107 | 247 | XP_005643653.1 60S ribosomal protein L7 [Coccomyxa subellipsoidea C-169] | diamond | 1269 | 196 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 14702000 | 14702000 | PRJNA692200_S_NODE_832_length_460_cov_196.836983_g792_i0 | PRJNA692200 | 832 | 460 | 196.836983 | 905.4501218 | Trebouxia sp. C | 2796353 | Plants | Plants | 73.9 | 8.36e-14 | NR | KAL0042167.1 | 2905653 | g792 | i0 | 54 | 1.29782608695652 | 63 | 28 | 40.4 | 1 | 54 | 239 | 3 | 65 | KAL0042167.1 hypothetical protein WJX77_005300 [Trebouxia sp. C0004] | diamond | 597 | 73.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0004 | |
| 21075074 | 21075074 | PRJNA692200_S_NODE_1477_length_408_cov_4.799443_g1422_i0 | PRJNA692200 | 1477 | 408 | 4.799443 | 19.58172744 | Raphidocelis subcapitata | 307507 | Plants | Plants | 110 | 2.83e-25 | NR | GBF98594.1 | 307507 | g1422 | i0 | 65.2 | 2.58823529411765 | 89 | 30 | 64.7 | 1 | 399 | 136 | 325 | 413 | GBF98594.1 60S ribosomal protein L4 [Raphidocelis subcapitata] | diamond | 1056 | 110 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Raphidocelis | Raphidocelis subcapitata | |
| 24899093 | 24899093 | PRJNA692200_S_NODE_220_length_580_cov_629.561205_g194_i0 | PRJNA692200 | 220 | 580 | 629.561205 | 3651.454989 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 226 | 9.77e-72 | NR | GAX77325.1 | 1157962 | g194 | i0 | 68.3 | 3.39310344827586 | 164 | 52 | 84.8 | 0 | 576 | 85 | 41 | 204 | GAX77325.1 hypothetical protein CEUSTIGMA_g4771.t1 [Chlamydomonas eustigma] | diamond | 1968 | 226 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 26861407 | 26861407 | PRJNA692200_S_NODE_13421_length_197_cov_1.695946_g13364_i0 | PRJNA692200 | 13421 | 197 | 1.695946 | 3.34101362 | Coccomyxa sp. Obi | 2315456 | Plants | Plants | 50.1 | 5.04e-5 | NR | BDA45109.1 | 2315456 | g13364 | i0 | 36.8 | 1.03553299492386 | 68 | 35 | 92.9 | 2 | 8 | 190 | 8 | 74 | BDA45109.1 THO complex subunit 3 [Coccomyxa sp. Obi] | diamond | 204 | 50.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa sp. Obi | ||
| 27346946 | 27346946 | PRJNA692200_S_NODE_15563_length_185_cov_2.139706_g15506_i0 | PRJNA692200 | 15563 | 185 | 2.139706 | 3.9584561 | Chlamydomonadales | 3042 | Plants | Plants | 61.2 | 4.21e-9 | NR | XP_001701753.1 | 3055 | g15506 | i0 | 58.6 | 4.7027027027027 | 58 | 24 | 94.1 | 0 | 177 | 4 | 196 | 253 | XP_001701753.1 uncharacterized protein CHLRE_02g088000v5 [Chlamydomonas reinhardtii] | diamond | 870 | 61.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 27430448 | 27430448 | PRJNA692200_S_NODE_18823_length_170_cov_2.107438_g18766_i0 | PRJNA692200 | 18823 | 170 | 2.107438 | 3.5826446 | Scenedesmus sp. NREL 46B-D3 | 2650976 | Plants | Plants | 47.8 | 2.38e-4 | NR | KAF6258334.1 | 2650976 | g18766 | i0 | 46.5 | 0.758823529411765 | 43 | 23 | 75.9 | 0 | 3 | 131 | 803 | 845 | KAF6258334.1 elongation factor 2 (EF-2, EF-TU) [Scenedesmus sp. NREL 46B-D3] | diamond | 129 | 47.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. NREL 46B-D3 | |
| 27683162 | 27683162 | PRJNA692200_S_NODE_2724_length_350_cov_4.803987_g2667_i0 | PRJNA692200 | 2724 | 350 | 4.803987 | 16.8139545 | Tetradesmus obliquus | 3088 | Plants | Plants | 77.4 | 4.83e-16 | NR | WIA13555.1 | 3088 | g2667 | i0 | 54.4 | 0.677142857142857 | 79 | 34 | 67.7 | 1 | 305 | 69 | 1 | 77 | WIA13555.1 hypothetical protein OEZ85_007123 [Tetradesmus obliquus] | diamond | 237 | 77.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 28409046 | 28409046 | PRJNA692200_S_NODE_486_length_508_cov_15.862745_g453_i0 | PRJNA692200 | 486 | 508 | 15.862745 | 80.5827446 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 102 | 1.42e-24 | NR | CAG9460866.1 | 765719 | g453 | i0 | 46.8 | 0.832677165354331 | 141 | 56 | 83.3 | 2 | 498 | 76 | 1 | 122 | CAG9460866.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 423 | 102 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 29829786 | 29829786 | PRJNA692200_S_NODE_16431_length_181_cov_1.181818_g16374_i0 | PRJNA692200 | 16431 | 181 | 1.181818 | 2.13909058 | Polytomella parva | 51329 | Plants | Plants | 95.1 | 2.14e-21 | NR | QKY14960.1 | 51329 | g16374 | i0 | 83.3 | 0.994475138121547 | 60 | 10 | 99.4 | 0 | 2 | 181 | 235 | 294 | QKY14960.1 pyruvate dehydrogenase E1 component subunit alpha - subunit beta (PDh-E1 BETA) [Polytomella parva] | diamond | 180 | 95.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella parva | |
| 30915537 | 30915537 | PRJNA692200_S_NODE_12494_length_203_cov_1.915584_g12437_i0 | PRJNA692200 | 12494 | 203 | 1.915584 | 3.88863552 | Eukaryota | 2759 | Plants | Plants | 73.9 | 2.24e-14 | NR | PRW58685.1 | 3076 | g12437 | i0 | 60 | 2.73399014778325 | 60 | 23 | 87.2 | 1 | 200 | 24 | 79 | 138 | PRW58685.1 nucleoredoxin 1 [Chlorella sorokiniana] | diamond | 555 | 74.3 | 0.994616419919246 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 30967378 | 30967378 | PRJNA692200_S_NODE_17914_length_174_cov_1.240000_g17857_i0 | PRJNA692200 | 17914 | 174 | 1.24 | 2.1576 | Helicosporidium sp. ATCC 5 | 1907511 | Plants | Plants | 77 | 1.19e-14 | NR | KDD76893.1 | 1291522 | g17857 | i0 | 64.9 | 2.91379310344828 | 57 | 15 | 98.3 | 1 | 3 | 173 | 1115 | 1166 | KDD76893.1 domain 6 of RNA polymerase Rpb2 [Helicosporidium sp. ATCC 50920] | diamond | 507 | 77 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Helicosporidium | Helicosporidium sp. ATCC 50920 | |
| 31156484 | 31156484 | PRJNA692200_S_NODE_17915_length_174_cov_1.240000_g17858_i0 | PRJNA692200 | 17915 | 174 | 1.24 | 2.1576 | Haematococcus lacustris | 44745 | Plants | Plants | 42.4 | 0.0204 | NR | KAJ9515634.1 | 44745 | g17858 | i0 | 36.7 | 0.844827586206897 | 49 | 31 | 84.5 | 0 | 15 | 161 | 373 | 421 | KAJ9515634.1 hypothetical protein QJQ45_021737 [Haematococcus lacustris] | diamond | 147 | 42.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 31990433 | 31990433 | PRJNA692200_S_NODE_6978_length_257_cov_2.274038_g6921_i0 | PRJNA692200 | 6978 | 257 | 2.274038 | 5.84427766 | Eukaryota | 2759 | Plants | Plants | 68.2 | 4.87e-11 | NR | KAI3433814.1 | 3077 | g6921 | i0 | 50.8 | 16.6575875486381 | 65 | 32 | 75.9 | 0 | 16 | 210 | 542 | 606 | KAI3433814.1 hypothetical protein D9Q98_003618 [Chlorella vulgaris] | diamond | 4281 | 68.6 | 0.994169096209913 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 32517327 | 32517327 | PRJNA692200_S_NODE_14619_length_190_cov_1.028369_g14562_i0 | PRJNA692200 | 14619 | 190 | 1.028369 | 1.9539011 | Bryopsis sp. KO-2 | 3115439 | Plants | Plants | 40.4 | 0.0428 | NR | GMH36206.1 | 3041901 | g14562 | i0 | 41.5 | 0.647368421052632 | 41 | 24 | 64.7 | 0 | 186 | 64 | 45 | 85 | GMH36206.1 hypothetical protein BSKO_04074 [Bryopsis sp. KO-2023] | diamond | 123 | 40.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis sp. KO-2023 | |
| 32674555 | 32674555 | PRJNA692200_S_NODE_5880_length_273_cov_2.290179_g5823_i0 | PRJNA692200 | 5880 | 273 | 2.290179 | 6.25218867 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 48.1 | 7.1e-4 | NR | GAX73886.1 | 1157962 | g5823 | i0 | 42.1 | 0.626373626373626 | 57 | 33 | 62.6 | 0 | 267 | 97 | 1228 | 1284 | GAX73886.1 hypothetical protein CEUSTIGMA_g1336.t1 [Chlamydomonas eustigma] | diamond | 171 | 48.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma |
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);;