contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA473824" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18298654 | 18298654 | PRJNA473824_P_NODE_55355_length_173_cov_5.698529_g54717_i0 | PRJNA473824 | 55355 | 173 | 5.698529 | 9.85845517 | Trebouxia | 13786 | Plants | Plants | 80.5 | 7e-16 | NR | KAL0035877.1 | 2905653 | g54717 | i0 | 71 | 7.49132947976879 | 62 | 12 | 97.1 | 1 | 169 | 2 | 284 | 345 | KAL0035877.1 hypothetical protein WJX77_006076 [Trebouxia sp. C0004] | diamond | 1296 | 80.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0004 | |
| 26902709 | 26902709 | PRJNA473824_P_NODE_54501_length_173_cov_5.948529_g53863_i0 | PRJNA473824 | 54501 | 173 | 5.948529 | 10.29095517 | Chlorellaceae | 35461 | Plants | Plants | 50.4 | 2.74e-5 | NR | KAL4527278.1 | 1650286 | g53863 | i0 | 91.7 | 1.2485549132948 | 24 | 2 | 41.6 | 0 | 100 | 171 | 244 | 267 | KAL4527278.1 hypothetical protein Ndes2437A_g02451 [Chlorella desiccata (nom. nud.)] | diamond | 216 | 50.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 27044628 | 27044628 | PRJNA473824_P_NODE_153582_length_151_cov_3.377193_g152944_i0 | PRJNA473824 | 153582 | 151 | 3.377193 | 5.09956143 | Chlorella desiccata (nom. nud.) | 1650286 | Plants | Plants | 43.1 | 0.00782 | NR | KAG7666926.1 | 1650286 | g152944 | i0 | 63 | 1.0728476821192101 | 27 | 10 | 53.6 | 0 | 70 | 150 | 231 | 257 | KAG7666926.1 hypothetical protein KSW81_000678 [Chlorella desiccata (nom. nud.)] | diamond | 162 | 43.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 27123660 | 27123660 | PRJNA473824_P_NODE_113462_length_173_cov_2.389706_g112824_i0 | PRJNA473824 | 113462 | 173 | 2.389706 | 4.13419138 | root | 1 | Root_unresolved | Root_unresolved | 43.5 | 0.00782 | NR | KAK9819377.1 | 381761 | g112824 | i0 | 91.3 | 1.94219653179191 | 23 | 2 | 39.9 | 0 | 169 | 101 | 452 | 474 | KAK9819377.1 hypothetical protein WJX81_001266 [Elliptochloris bilobata] | diamond | 336 | 43.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Elliptochloris | Elliptochloris bilobata | |||
| 27850306 | 27850306 | PRJNA473824_P_NODE_126524_length_162_cov_4.496000_g125886_i0 | PRJNA473824 | 126524 | 162 | 4.496 | 7.28352 | Trebouxiophyceae | 75966 | Plants | Plants | 78.6 | 2.86e-15 | NR | YP_009105386.1 | 33092 | g125886 | i0 | 66 | 2.94444444444444 | 53 | 18 | 98.1 | 0 | 161 | 3 | 1204 | 1256 | YP_009105386.1 cell division protein [Koliella longiseta] | diamond | 477 | 79.3 | 0.991172761664565 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella longiseta | |
| 28166281 | 28166281 | PRJNA473824_P_NODE_117705_length_172_cov_3.474074_g117067_i0 | PRJNA473824 | 117705 | 172 | 3.474074 | 5.97540728 | Chlorophyta | 3041 | Plants | Plants | 45.1 | 0.00225 | NR | KAK9809702.1 | 706552 | g117067 | i0 | 87.5 | 0.802325581395349 | 24 | 3 | 41.9 | 0 | 101 | 172 | 1426 | 1449 | KAK9809702.1 hypothetical protein WJX73_007079 [Symbiochloris irregularis] | diamond | 138 | 45.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 28339527 | 28339527 | PRJNA473824_P_NODE_132626_length_155_cov_0.991525_g131988_i0 | PRJNA473824 | 132626 | 155 | 0.991525 | 1.53686375 | Monoraphidium neglectum | 145388 | Plants | Plants | 40.4 | 0.0446 | NR | XP_013897247.1 | 145388 | g131988 | i0 | 40 | 0.774193548387097 | 40 | 24 | 77.4 | 0 | 147 | 28 | 52 | 91 | XP_013897247.1 Protein SYM1 [Monoraphidium neglectum] | diamond | 120 | 40.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 28592228 | 28592228 | PRJNA473824_P_NODE_80087_length_173_cov_3.382353_g79449_i0 | PRJNA473824 | 80087 | 173 | 3.382353 | 5.85147069 | [Myrmecia] bisecta | 41462 | Plants | Plants | 79.7 | 1.27e-15 | NR | KAK9819898.1 | 41462 | g79449 | i0 | 75 | 0.832369942196532 | 48 | 7 | 83.2 | 1 | 161 | 18 | 167 | 209 | KAK9819898.1 hypothetical protein WJX72_003766 [[Myrmecia] bisecta] | diamond | 144 | 79.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 29081950 | 29081950 | PRJNA473824_P_NODE_159668_length_151_cov_2.929825_g159030_i0 | PRJNA473824 | 159668 | 151 | 2.929825 | 4.42403575 | Chlorophyta | 3041 | Plants | Plants | 42 | 0.0197 | NR | CAD7701162.1 | 121088 | g159030 | i0 | 55.9 | 3.05960264900662 | 34 | 15 | 67.5 | 0 | 28 | 129 | 92 | 125 | CAD7701162.1 unnamed protein product [Ostreobium quekettii] | diamond | 462 | 42.4 | 0.990566037735849 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii | |
| 29633678 | 29633678 | PRJNA473824_P_NODE_69270_length_173_cov_3.977941_g68632_i0 | PRJNA473824 | 69270 | 173 | 3.977941 | 6.88183793 | Bryopsis sp. KO-2 | 3115439 | Plants | Plants | 49.3 | 6.43e-5 | NR | GMH32261.1 | 3041901 | g68632 | i0 | 59.5 | 0.641618497109827 | 37 | 13 | 60.7 | 1 | 129 | 25 | 196 | 232 | GMH32261.1 hypothetical protein BSKO_00095 [Bryopsis sp. KO-2023] | diamond | 111 | 49.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis sp. KO-2023 | |
| 30534658 | 30534658 | PRJNA473824_P_NODE_154593_length_151_cov_3.315789_g153955_i0 | PRJNA473824 | 154593 | 151 | 3.315789 | 5.00684139 | Chlorophyta | 3041 | Plants | Plants | 50.4 | 2.03e-5 | NR | CAD7699737.1 | 121088 | g153955 | i0 | 60 | 2.24503311258278 | 35 | 10 | 61.6 | 1 | 147 | 55 | 132 | 166 | CAD7699737.1 unnamed protein product [Ostreobium quekettii] | diamond | 339 | 50.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii | |
| 31403619 | 31403619 | PRJNA473824_P_NODE_53476_length_173_cov_6.345588_g52838_i0 | PRJNA473824 | 53476 | 173 | 6.345588 | 10.97786724 | Trebouxia sp. C | 2796353 | Plants | Plants | 45.1 | 0.00223 | NR | KAL3133770.1 | 3373145 | g52838 | i0 | 85.7 | 0.815028901734104 | 21 | 3 | 36.4 | 0 | 3 | 65 | 141 | 161 | KAL3133770.1 hypothetical protein ABBQ32_008252 [Trebouxia sp. C0010 RCD-2024] | diamond | 141 | 45.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0010 RCD-2024 |
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);;