contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA414036" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26600421 | 26600421 | PRJNA414036_P_NODE_24221_length_308_cov_3.186813_g22489_i0 | PRJNA414036 | 24221 | 308 | 3.186813 | 9.81538404 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 81.6 | 8.62e-16 | NR | KAA6423777.1 | 2608996 | g22489 | i0 | 46.4 | 0.944805194805195 | 97 | 49 | 91.6 | 1 | 4 | 285 | 50 | 146 | KAA6423777.1 MAG: hypothetical protein FRX49_06348 [Trebouxia sp. A1-2] | diamond | 291 | 81.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 27802233 | 27802233 | PRJNA414036_P_NODE_53524_length_231_cov_1.632653_g51785_i0 | PRJNA414036 | 53524 | 231 | 1.632653 | 3.77142843 | Chloroidium sp. KL-2 | 2812591 | Plants | Plants | 43.5 | 0.00551 | NR | WDY12788.1 | 3031248 | g51785 | i0 | 86.4 | 0.285714285714286 | 22 | 3 | 28.6 | 0 | 10 | 75 | 42 | 63 | WDY12788.1 ribosomal protein L19 [Chloroidium sp. KL-2023a] | diamond | 66 | 43.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium sp. KL-2023a | |
| 28275588 | 28275588 | PRJNA414036_P_NODE_37166_length_242_cov_6.415459_g35427_i0 | PRJNA414036 | 37166 | 242 | 6.415459 | 15.52541078 | Bryopsis sp. KO-2 | 3115439 | Plants | Plants | 67.8 | 5.66e-11 | NR | GMH43826.1 | 3041901 | g35427 | i0 | 66.7 | 1.11570247933884 | 45 | 15 | 55.8 | 0 | 190 | 56 | 1584 | 1628 | GMH43826.1 hypothetical protein BSKO_11760 [Bryopsis sp. KO-2023] | diamond | 270 | 67.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis sp. KO-2023 | |
| 28686413 | 28686413 | PRJNA414036_P_NODE_44747_length_231_cov_3.357143_g43008_i0 | PRJNA414036 | 44747 | 231 | 3.357143 | 7.75500033 | Trebouxia sp. C | 2796353 | Plants | Plants | 52.4 | 1.27e-5 | NR | KAL0035942.1 | 2905653 | g43008 | i0 | 100 | 0.857142857142857 | 22 | 0 | 28.6 | 0 | 157 | 222 | 191 | 212 | KAL0035942.1 hypothetical protein WJX77_008507 [Trebouxia sp. C0004] | diamond | 198 | 52.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0004 | |
| 30882018 | 30882018 | PRJNA414036_P_NODE_80974_length_161_cov_4.246032_g79235_i0 | PRJNA414036 | 80974 | 161 | 4.246032 | 6.83611152 | Chlorophyta | 3041 | Plants | Plants | 50.1 | 3.2e-5 | NR | CAD7696789.1 | 121088 | g79235 | i0 | 71.4 | 10.0807453416149 | 49 | 14 | 91.3 | 0 | 157 | 11 | 1493 | 1541 | CAD7696789.1 unnamed protein product [Ostreobium quekettii] | diamond | 1623 | 50.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii | |
| 31055311 | 31055311 | PRJNA414036_P_NODE_7755_length_467_cov_7.895833_g6447_i0 | PRJNA414036 | 7755 | 467 | 7.895833 | 36.87354011 | Volvox reticuliferus | 1737510 | Plants | Plants | 49.7 | 5.84e-4 | NR | GIL85124.1 | 1737510 | g6447 | i0 | 42.4 | 0.423982869379015 | 66 | 38 | 42.4 | 0 | 299 | 102 | 80 | 145 | GIL85124.1 hypothetical protein Vretifemale_13751, partial [Volvox reticuliferus] | diamond | 198 | 49.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox reticuliferus | |
| 31117957 | 31117957 | PRJNA414036_P_NODE_52055_length_231_cov_1.867347_g50316_i0 | PRJNA414036 | 52055 | 231 | 1.867347 | 4.31357157 | Trebouxia sp. C | 2796353 | Plants | Plants | 66.2 | 1.72e-10 | NR | KAL3133778.1 | 3373145 | g50316 | i0 | 54.9 | 0.922077922077922 | 71 | 18 | 92.2 | 1 | 10 | 222 | 541 | 597 | KAL3133778.1 hypothetical protein ABBQ32_008258 [Trebouxia sp. C0010 RCD-2024] | diamond | 213 | 66.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0010 RCD-2024 | |
| 31212553 | 31212553 | PRJNA414036_P_NODE_10715_length_426_cov_6.918159_g9170_i0 | PRJNA414036 | 10715 | 426 | 6.918159 | 29.47135734 | Dunaliella salina | 3046 | Plants | Plants | 45.8 | 0.0184 | NR | KAF5831003.1 | 3046 | g9170 | i0 | 83.3 | 15.2112676056338 | 30 | 5 | 21.1 | 0 | 154 | 65 | 340 | 369 | KAF5831003.1 eukaryotic initiation factor [Dunaliella salina] | diamond | 6480 | 45.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 31244572 | 31244572 | PRJNA414036_P_NODE_52915_length_231_cov_1.729592_g51176_i0 | PRJNA414036 | 52915 | 231 | 1.729592 | 3.99535752 | Trebouxia sp. C | 2796353 | Plants | Plants | 54.3 | 2.64e-6 | NR | KAL3154486.1 | 3373145 | g51176 | i0 | 95.8 | 0.311688311688312 | 24 | 1 | 31.2 | 0 | 157 | 228 | 226 | 249 | KAL3154486.1 hypothetical protein ABBQ32_013949 [Trebouxia sp. C0010 RCD-2024] | diamond | 72 | 54.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0010 RCD-2024 | |
| 32431871 | 32431871 | PRJNA414036_P_NODE_26299_length_294_cov_6.061776_g24565_i0 | PRJNA414036 | 26299 | 294 | 6.061776 | 17.82162144 | Viridiplantae | 33090 | Plants | Plants | 57 | 6.3e-7 | NR | KAF5843682.1 | 3046 | g24565 | i0 | 50 | 42.1224489795918 | 86 | 43 | 87.8 | 0 | 260 | 3 | 318 | 403 | KAF5843682.1 peptidase M24, structural domain-containing protein [Dunaliella salina] | diamond | 12384 | 57 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 32856596 | 32856596 | PRJNA414036_P_NODE_17720_length_356_cov_6.713396_g16009_i0 | PRJNA414036 | 17720 | 356 | 6.713396 | 23.89968976 | Bryopsis sp. KO-2 | 3115439 | Plants | Plants | 44.7 | 0.00671 | NR | GMH41053.1 | 3041901 | g16009 | i0 | 43.8 | 0.615168539325843 | 73 | 41 | 61.5 | 0 | 349 | 131 | 23 | 95 | GMH41053.1 hypothetical protein BSKO_08963 [Bryopsis sp. KO-2023] | diamond | 219 | 44.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis sp. KO-2023 |
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);;