contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA602115" and tax_kingdom = "Viridiplantae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17720784 | 17720784 | PRJNA602115_P_NODE_7814_length_225_cov_1.195122_g7789_i0 | PRJNA602115 | 7814 | 225 | 1.195122 | 2.6890245 | Eukaryota | 2759 | Plants | Plants | 114 | 2.6600000000000003e-27 | NR | KAK9796680.1 | 706552 | g7789 | i0 | 72 | 6.97333333333333 | 75 | 21 | 100 | 0 | 1 | 225 | 437 | 511 | KAK9796680.1 hypothetical protein WJX73_008232 [Symbiochloris irregularis] | diamond | 1569 | 114 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 26668177 | 26668177 | PRJNA602115_P_NODE_10001_length_206_cov_0.882759_g9976_i0 | PRJNA602115 | 10001 | 206 | 0.882759 | 1.81848354 | Salix brachista | 2182728 | Plants | Plants | 53.5 | 3.6e-6 | NR | KAB5541615.1 | 2182728 | g9976 | i0 | 74.4 | 0.567961165048544 | 39 | 6 | 56.8 | 1 | 205 | 89 | 814 | 848 | KAB5541615.1 hypothetical protein DKX38_014589 [Salix brachista] | diamond | 117 | 53.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Salix | Salix brachista | |
| 27996025 | 27996025 | PRJNA602115_P_NODE_6705_length_246_cov_0.778378_g6680_i0 | PRJNA602115 | 6705 | 246 | 0.778378 | 1.91480988 | Solanum verrucosum | 315347 | Plants | Plants | 43.9 | 0.0142 | NR | WMV10992.1 | 315347 | g6680 | i0 | 38.1 | 3.17073170731707 | 63 | 31 | 75.6 | 3 | 58 | 243 | 123 | 178 | WMV10992.1 hypothetical protein MTR67_004377 [Solanum verrucosum] | diamond | 780 | 43.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum verrucosum | |
| 28122206 | 28122206 | PRJNA602115_P_NODE_9225_length_208_cov_0.870748_g9200_i0 | PRJNA602115 | 9225 | 208 | 0.870748 | 1.81115584 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 72 | 3.88e-13 | NR | GAX76853.1 | 1157962 | g9200 | i0 | 54.4 | 2.85576923076923 | 68 | 29 | 96.6 | 2 | 205 | 5 | 23 | 89 | GAX76853.1 hypothetical protein CEUSTIGMA_g4299.t1 [Chlamydomonas eustigma] | diamond | 594 | 72 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 28374736 | 28374736 | PRJNA602115_P_NODE_11546_length_202_cov_0.900709_g11521_i0 | PRJNA602115 | 11546 | 202 | 0.900709 | 1.81943218 | Populus tomentosa | 118781 | Plants | Plants | 50.4 | 3.26e-5 | NR | KAG6793008.1 | 118781 | g11521 | i0 | 100 | 0.311881188118812 | 21 | 0 | 31.2 | 0 | 2 | 64 | 145 | 165 | KAG6793008.1 hypothetical protein POTOM_002178 [Populus tomentosa] | diamond | 63 | 50.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Populus | Populus tomentosa | |
| 28627638 | 28627638 | PRJNA602115_P_NODE_3887_length_313_cov_0.900794_g3862_i0 | PRJNA602115 | 3887 | 313 | 0.900794 | 2.81948522 | Lotus japonicus | 34305 | Plants | Plants | 146 | 3.369999999999999e-42 | NR | AFK43985.1 | 34305 | g3862 | i0 | 66.3 | 0.996805111821086 | 104 | 35 | 99.7 | 0 | 313 | 2 | 34 | 137 | AFK43985.1 unknown [Lotus japonicus] | diamond | 312 | 146 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Lotus | Lotus japonicus | |
| 29271943 | 29271943 | PRJNA602115_P_NODE_11569_length_202_cov_0.872340_g11544_i0 | PRJNA602115 | 11569 | 202 | 0.87234 | 1.7621268 | Eukaryota | 2759 | Plants | Plants | 44.3 | 0.00282 | NR | PRW34016.1 | 3076 | g11544 | i0 | 79.2 | 4.26237623762376 | 24 | 5 | 35.6 | 0 | 201 | 130 | 120 | 143 | PRW34016.1 60S ribosomal L23A [Chlorella sorokiniana] | diamond | 861 | 44.7 | 0.991051454138702 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 31122215 | 31122215 | PRJNA602115_P_NODE_9575_length_207_cov_0.876712_g9550_i0 | PRJNA602115 | 9575 | 207 | 0.876712 | 1.81479384 | Zea mays | 4577 | Plants | Plants | 65.1 | 2.93e-10 | NR | ONM29629.1 | 4577 | g9550 | i0 | 91.2 | 0.492753623188406 | 34 | 3 | 49.3 | 0 | 103 | 2 | 358 | 391 | ONM29629.1 Pectin lyase-like superfamily protein [Zea mays] | diamond | 102 | 65.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Zea | Zea mays | |
| 31185501 | 31185501 | PRJNA602115_P_NODE_11695_length_201_cov_0.914286_g11670_i0 | PRJNA602115 | 11695 | 201 | 0.914286 | 1.83771486 | Paspalum notatum var. saurae | 547442 | Plants | Plants | 55.5 | 3.81e-7 | NR | WVZ67832.1 | 547442 | g11670 | i0 | 65.2 | 0.686567164179104 | 46 | 14 | 65.7 | 1 | 27 | 158 | 171 | 216 | WVZ67832.1 hypothetical protein U9M48_016861 [Paspalum notatum var. saurae] | diamond | 138 | 55.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Paspalum | Paspalum notatum | |
| 31438694 | 31438694 | PRJNA602115_P_NODE_11316_length_202_cov_0.907801_g11291_i0 | PRJNA602115 | 11316 | 202 | 0.907801 | 1.83375802 | Coccomyxa viridis | 1274662 | Plants | Plants | 74.3 | 1.63e-13 | NR | CAK0736545.1 | 1274662 | g11291 | i0 | 54.5 | 2.94059405940594 | 66 | 30 | 98 | 0 | 1 | 198 | 572 | 637 | CAK0736545.1 hypothetical protein CVIRNUC_000763 [Coccomyxa viridis] | diamond | 594 | 74.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 32829631 | 32829631 | PRJNA602115_P_NODE_8940_length_209_cov_0.864865_g8915_i0 | PRJNA602115 | 8940 | 209 | 0.864865 | 1.80756785 | Sphagnum balticum | 128184 | Plants | Plants | 106 | 1.24e-25 | NR | CAM6002056.1 | 128184 | g8915 | i0 | 73.5 | 0.976076555023923 | 68 | 18 | 97.6 | 0 | 204 | 1 | 121 | 188 | CAM6002056.1 unnamed protein product, partial [Sphagnum balticum] | diamond | 204 | 106 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum balticum |
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);;