contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA672101" and tax_phylum = "Streptophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22319381 | 22319381 | PRJNA672101_S_NODE_33438_length_241_cov_0.916667_g33407_i0 | PRJNA672101 | 33438 | 241 | 0.916667 | 2.20916747 | Adiantum capillus-veneris | 13818 | Plants | Plants | 116 | 1.93e-30 | NR | KAI5082972.1 | 13818 | g33407 | i0 | 80.6 | 2.70124481327801 | 72 | 13 | 88.4 | 1 | 215 | 3 | 1 | 72 | KAI5082972.1 hypothetical protein GOP47_0002715 [Adiantum capillus-veneris] | diamond | 651 | 116 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Polypodiopsida | Polypodiales | Pteridaceae | Adiantum | Adiantum capillus-veneris | |
| 26872545 | 26872545 | PRJNA672101_S_NODE_22281_length_275_cov_1.772277_g22250_i0 | PRJNA672101 | 22281 | 275 | 1.772277 | 4.87376175 | Solanaceae | 4070 | Plants | Plants | 96.3 | 6.290000000000001e-21 | NR | QGT31829.1 | 4102 | g22250 | i0 | 54.1 | 4.02545454545455 | 74 | 34 | 80.7 | 0 | 47 | 268 | 148 | 221 | QGT31829.1 vacuolar sorting protein 9 [Petunia x hybrida] | diamond | 1107 | 96.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Petunia | Petunia x hybrida | |
| 27018451 | 27018451 | PRJNA672101_S_NODE_17782_length_296_cov_1.524664_g17751_i0 | PRJNA672101 | 17782 | 296 | 1.524664 | 4.51300544 | Riccia fluitans | 41844 | Plants | Plants | 104 | 8.24e-24 | NR | KAL2609485.1 | 41844 | g17751 | i0 | 52.8 | 9.9222972972973 | 89 | 42 | 90.2 | 0 | 295 | 29 | 141 | 229 | KAL2609485.1 hypothetical protein R1flu_028058 [Riccia fluitans] | diamond | 2937 | 104 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Marchantiopsida | Marchantiales | Ricciaceae | Riccia | Riccia fluitans | |
| 27397967 | 27397967 | PRJNA672101_S_NODE_22483_length_274_cov_2.298507_g22452_i0 | PRJNA672101 | 22483 | 274 | 2.298507 | 6.29790918 | Chara braunii | 69332 | Plants | Plants | 76.3 | 8.92e-14 | NR | GBG85973.1 | 69332 | g22452 | i0 | 62.5 | 0.613138686131387 | 56 | 20 | 61.3 | 1 | 106 | 273 | 74 | 128 | GBG85973.1 hypothetical protein CBR_g40786 [Chara braunii] | diamond | 168 | 76.3 | 1 | Eukaryota | Viridiplantae | Streptophyta | Charophyceae | Charales | Characeae | Chara | Chara braunii | ||
| 27441572 | 27441572 | PRJNA672101_S_NODE_15743_length_307_cov_4.034188_g15712_i0 | PRJNA672101 | 15743 | 307 | 4.034188 | 12.38495716 | Closterium | 34145 | Plants | Plants | 102 | 1.26e-22 | NR | CAI5529157.1 | 2996811 | g15712 | i0 | 54.5 | 10.8273615635179 | 101 | 43 | 96.7 | 3 | 307 | 11 | 1269 | 1368 | CAI5529157.1 unnamed protein product, partial [Closterium sp. Naga37s-1] | diamond | 3324 | 102 | 1 | Eukaryota | Viridiplantae | Streptophyta | Zygnematophyceae | Desmidiales | Closteriaceae | Closterium | Closterium sp. Naga37s-1 | ||
| 27682330 | 27682330 | PRJNA672101_S_NODE_17944_length_295_cov_2.000000_g17913_i0 | PRJNA672101 | 17944 | 295 | 2 | 5.9 | Physcomitrium patens | 3218 | Plants | Plants | 50.4 | 1.39e-4 | NR | XP_024388470.1 | 3218 | g17913 | i0 | 42.9 | 0.640677966101695 | 63 | 35 | 63.1 | 1 | 289 | 104 | 591 | 653 | XP_024388470.1 structural maintenance of chromosomes protein 6B-like isoform X1 [Physcomitrium patens] | diamond | 189 | 50.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Funariales | Funariaceae | Physcomitrium | Physcomitrium patens | |
| 28376502 | 28376502 | PRJNA672101_S_NODE_16906_length_300_cov_7.101322_g16875_i0 | PRJNA672101 | 16906 | 300 | 7.101322 | 21.303966 | Riccia fluitans | 41844 | Plants | Plants | 76.6 | 9.08e-14 | NR | KAL2635517.1 | 41844 | g16875 | i0 | 38 | 1.08 | 108 | 58 | 99 | 1 | 2 | 298 | 606 | 713 | KAL2635517.1 hypothetical protein R1flu_006996 [Riccia fluitans] | diamond | 324 | 76.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Marchantiopsida | Marchantiales | Ricciaceae | Riccia | Riccia fluitans | |
| 28818310 | 28818310 | PRJNA672101_S_NODE_11888_length_333_cov_2.134615_g11857_i0 | PRJNA672101 | 11888 | 333 | 2.134615 | 7.10826795 | Closterium sp. NIES-68 | 2019903 | Plants | Plants | 84 | 3.74e-16 | NR | GJP46592.1 | 2019903 | g11857 | i0 | 51.9 | 2.08108108108108 | 77 | 37 | 69.4 | 0 | 233 | 3 | 611 | 687 | GJP46592.1 hypothetical protein CLOM_g5865 [Closterium sp. NIES-68] | diamond | 693 | 84 | 1 | Eukaryota | Viridiplantae | Streptophyta | Zygnematophyceae | Desmidiales | Closteriaceae | Closterium | Closterium sp. NIES-68 | ||
| 29134618 | 29134618 | PRJNA672101_S_NODE_34749_length_226_cov_2.516340_g34718_i0 | PRJNA672101 | 34749 | 226 | 2.51634 | 5.6869284 | Juncus effusus | 13579 | Plants | Plants | 50.1 | 7.39e-5 | NR | KAJ3677941.1 | 13579 | g34718 | i0 | 42.9 | 0.836283185840708 | 63 | 31 | 77 | 2 | 176 | 3 | 25 | 87 | KAJ3677941.1 hypothetical protein LUZ60_001744 [Juncus effusus] | diamond | 189 | 50.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Juncaceae | Juncus | Juncus effusus | |
| 30049990 | 30049990 | PRJNA672101_S_NODE_4231_length_423_cov_3.102857_g4200_i0 | PRJNA672101 | 4231 | 423 | 3.102857 | 13.12508511 | Lupinus luteus | 3873 | Plants | Plants | 115 | 6.73e-27 | NR | CAL0329890.1 | 3873 | g4200 | i0 | 52.6 | 1.47517730496454 | 97 | 46 | 68.8 | 0 | 95 | 385 | 81 | 177 | CAL0329890.1 unnamed protein product [Lupinus luteus] | diamond | 624 | 115 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Lupinus | Lupinus luteus | |
| 31314050 | 31314050 | PRJNA672101_S_NODE_34575_length_228_cov_2.980645_g34544_i0 | PRJNA672101 | 34575 | 228 | 2.980645 | 6.7958706 | Dipteronia dyeriana | 168575 | Plants | Plants | 86.3 | 7.16e-20 | NR | KAK2651974.1 | 168575 | g34544 | i0 | 48.6 | 4.60526315789474 | 70 | 33 | 92.1 | 1 | 3 | 212 | 40 | 106 | KAK2651974.1 hypothetical protein Ddye_011830 [Dipteronia dyeriana] | diamond | 1050 | 86.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Sapindaceae | Dipteronia | Dipteronia dyeriana |
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);;