contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJEB6055" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27026758 | 27026758 | PRJEB6055_S_NODE_662_length_312_cov_4.191336_g638_i0 | PRJEB6055 | 662 | 312 | 4.191336 | 13.07696832 | Eukaryota | 2759 | Plants | Plants | 80.1 | 1.61e-15 | NR | KAJ9529013.1 | 44745 | g638 | i0 | 50.6 | 3.15384615384615 | 83 | 41 | 79.8 | 0 | 281 | 33 | 171 | 253 | KAJ9529013.1 hypothetical protein QJQ45_007086 [Haematococcus lacustris] | diamond | 984 | 80.9 | 0.990111248454882 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 28991914 | 28991914 | PRJEB6055_S_NODE_5748_length_152_cov_1.914530_g5724_i0 | PRJEB6055 | 5748 | 152 | 1.91453 | 2.9100856 | Carpinus fangiana | 176857 | Plants | Plants | 61.6 | 1.7e-10 | NR | KAE8124078.1 | 176857 | g5724 | i0 | 91.9 | 0.730263157894737 | 37 | 3 | 73 | 0 | 16 | 126 | 1 | 37 | KAE8124078.1 hypothetical protein FH972_018988 [Carpinus fangiana] | diamond | 111 | 61.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Betulaceae | Carpinus | Carpinus fangiana | |
| 29363799 | 29363799 | PRJEB6055_S_NODE_649_length_314_cov_2.071685_g625_i0 | PRJEB6055 | 649 | 314 | 2.071685 | 6.5050909 | Eukaryota | 2759 | Plants | Plants | 53.1 | 4.45e-6 | NR | XP_055818756.1 | 45834 | g625 | i0 | 66.7 | 7.80573248407643 | 81 | 25 | 77.4 | 1 | 289 | 47 | 69 | 147 | XP_055818756.1 60S acidic ribosomal protein P2B-like [Solanum dulcamara] | diamond | 2451 | 53.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum dulcamara | |
| 29844076 | 29844076 | PRJEB6055_S_NODE_2911_length_193_cov_2.398734_g2887_i0 | PRJEB6055 | 2911 | 193 | 2.398734 | 4.62955662 | Sphenostylis stenocarpa | 92480 | Plants | Plants | 74.7 | 9.92e-14 | NR | CAJ1971540.1 | 92480 | g2887 | i0 | 65.5 | 4.29015544041451 | 55 | 19 | 85.5 | 0 | 193 | 29 | 400 | 454 | CAJ1971540.1 unnamed protein product [Sphenostylis stenocarpa] | diamond | 828 | 74.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Sphenostylis | Sphenostylis stenocarpa | |
| 29907408 | 29907408 | PRJEB6055_S_NODE_731_length_304_cov_3.758364_g707_i0 | PRJEB6055 | 731 | 304 | 3.758364 | 11.42542656 | Rhamnella rubrinervis | 2594499 | Plants | Plants | 49.7 | 2.64e-4 | NR | KAF3449793.1 | 2594499 | g707 | i0 | 41.4 | 0.690789473684211 | 70 | 28 | 69.1 | 3 | 94 | 303 | 301 | 357 | KAF3449793.1 hypothetical protein FNV43_RR05871 [Rhamnella rubrinervis] | diamond | 210 | 49.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rhamnaceae | Rhamnella | Rhamnella rubrinervis | |
| 31360955 | 31360955 | PRJEB6055_S_NODE_2876_length_194_cov_1.138365_g2852_i0 | PRJEB6055 | 2876 | 194 | 1.138365 | 2.2084281 | Volvox carteri f. nagariensis | 3068 | Plants | Plants | 43.1 | 0.0144 | NR | XP_002951961.1 | 3068 | g2852 | i0 | 48.9 | 1.00515463917526 | 45 | 19 | 69.6 | 1 | 4 | 138 | 598 | 638 | XP_002951961.1 cysteine protease [Volvox carteri f. nagariensis] | diamond | 195 | 43.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 31575542 | 31575542 | PRJEB6055_S_NODE_2256_length_210_cov_2.451429_g2232_i0 | PRJEB6055 | 2256 | 210 | 2.451429 | 5.1480009 | Eukaryota | 2759 | Plants | Plants | 87 | 1.58e-19 | NR | CAD7696009.1 | 121088 | g2232 | i0 | 76.5 | 11.6571428571429 | 51 | 12 | 72.9 | 0 | 1 | 153 | 121 | 171 | CAD7696009.1 unnamed protein product [Ostreobium quekettii] | diamond | 2448 | 87.8 | 0.990888382687927 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii |
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);;