contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA1013345" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12911928 | 12911928 | PRJNA1013345_P_NODE_25451_length_163_cov_0.879310_g25321_i0 | PRJNA1013345 | 25451 | 163 | 0.87931 | 1.4332753 | Setaria italica | 4555 | Plants | Plants | 103 | 6.529999999999999e-24 | NR | XP_022680992.1 | 4555 | g25321 | i0 | 79.6 | 2.98159509202454 | 54 | 11 | 99.4 | 0 | 2 | 163 | 1126 | 1179 | XP_022680992.1 LOW QUALITY PROTEIN: uncharacterized protein LOC101759701, partial [Setaria italica] | diamond | 486 | 103 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Setaria | Setaria italica | |
| 26749567 | 26749567 | PRJNA1013345_P_NODE_25061_length_163_cov_1.758621_g24931_i0 | PRJNA1013345 | 25061 | 163 | 1.758621 | 2.86655223 | Cryptomeria japonica | 3369 | Plants | Plants | 62 | 1.93e-9 | NR | XP_057859694.2 | 3369 | g24931 | i0 | 71.4 | 0.901840490797546 | 49 | 7 | 77.3 | 1 | 36 | 161 | 137 | 185 | XP_057859694.2 uncharacterized protein LOC131068522 isoform X3 [Cryptomeria japonica] | diamond | 147 | 62 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 28037938 | 28037938 | PRJNA1013345_P_NODE_30485_length_158_cov_1.837838_g30355_i0 | PRJNA1013345 | 30485 | 158 | 1.837838 | 2.90378404 | Trifolium | 3898 | Plants | Plants | 52 | 6.33e-6 | NR | KAK2368679.1 | 3899 | g30355 | i0 | 42.3 | 6.91139240506329 | 52 | 30 | 98.7 | 0 | 156 | 1 | 596 | 647 | KAK2368679.1 bromodomain-containing protein [Trifolium repens] | diamond | 1092 | 52 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Trifolium | Trifolium repens | |
| 28519341 | 28519341 | PRJNA1013345_P_NODE_14807_length_183_cov_1.375000_g14677_i0 | PRJNA1013345 | 14807 | 183 | 1.375 | 2.51625 | Cryptomeria japonica | 3369 | Plants | Plants | 60.8 | 6.7e-9 | NR | XP_057826909.2 | 3369 | g14677 | i0 | 64.9 | 1.18032786885246 | 37 | 13 | 60.7 | 0 | 163 | 53 | 78 | 114 | XP_057826909.2 protein transport protein SEC23 G [Cryptomeria japonica] | diamond | 216 | 60.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 28985356 | 28985356 | PRJNA1013345_P_NODE_28308_length_160_cov_1.805310_g28178_i0 | PRJNA1013345 | 28308 | 160 | 1.80531 | 2.888496 | Lolium | 4520 | Plants | Plants | 98.2 | 3.58e-22 | NR | XP_051221032.1 | 4522 | g28178 | i0 | 92.5 | 4.96875 | 53 | 4 | 99.4 | 0 | 160 | 2 | 1142 | 1194 | XP_051221032.1 uncharacterized protein LOC127339195 [Lolium perenne] | diamond | 795 | 98.6 | 0.995943204868154 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Lolium | Lolium perenne | |
| 28985357 | 28985357 | PRJNA1013345_P_NODE_29348_length_159_cov_1.821429_g29218_i0 | PRJNA1013345 | 29348 | 159 | 1.821429 | 2.89607211 | Lolium | 4520 | Plants | Plants | 87.8 | 1.54e-18 | NR | KAK1608478.1 | 4521 | g29218 | i0 | 86.5 | 4.90566037735849 | 52 | 7 | 98.1 | 0 | 3 | 158 | 370 | 421 | KAK1608478.1 hypothetical protein QYE76_032151 [Lolium multiflorum] | diamond | 780 | 87.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Lolium | Lolium multiflorum | |
| 29182456 | 29182456 | PRJNA1013345_P_NODE_20689_length_170_cov_1.365854_g20559_i0 | PRJNA1013345 | 20689 | 170 | 1.365854 | 2.3219518 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 46.6 | 5.96e-4 | NR | XP_044971996.1 | 112509 | g20559 | i0 | 55.2 | 1.02352941176471 | 58 | 23 | 97.1 | 1 | 1 | 165 | 169 | 226 | XP_044971996.1 uncharacterized protein LOC123439332 [Hordeum vulgare subsp. vulgare] | diamond | 174 | 46.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 29214083 | 29214083 | PRJNA1013345_P_NODE_30569_length_158_cov_1.837838_g30439_i0 | PRJNA1013345 | 30569 | 158 | 1.837838 | 2.90378404 | Gossypium anomalum | 47600 | Plants | Plants | 45.8 | 9.63e-4 | NR | KAG8478880.1 | 47600 | g30439 | i0 | 37.5 | 2.77215189873418 | 48 | 30 | 91.1 | 0 | 7 | 150 | 66 | 113 | KAG8478880.1 hypothetical protein CXB51_028735 [Gossypium anomalum] | diamond | 438 | 45.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malvales | Malvaceae | Gossypium | Gossypium anomalum | |
| 29497982 | 29497982 | PRJNA1013345_P_NODE_23570_length_165_cov_0.864407_g23440_i0 | PRJNA1013345 | 23570 | 165 | 0.864407 | 1.42627155 | Triticum aestivum | 4565 | Plants | Plants | 45.8 | 0.00105 | NR | BDI54558.1 | 4565 | g23440 | i0 | 51.9 | 0.981818181818182 | 54 | 23 | 98.2 | 1 | 2 | 163 | 432 | 482 | BDI54558.1 retrotransposon protein, putative, Ty3-gypsy subclass [Triticum aestivum] | diamond | 162 | 45.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 29592351 | 29592351 | PRJNA1013345_P_NODE_27830_length_161_cov_0.894737_g27700_i0 | PRJNA1013345 | 27830 | 161 | 0.894737 | 1.44052657 | Lolium multiflorum | 4521 | Plants | Plants | 99.8 | 7.42e-23 | NR | KAK1626726.1 | 4521 | g27700 | i0 | 100 | 17.776397515528 | 53 | 0 | 98.8 | 0 | 161 | 3 | 196 | 248 | KAK1626726.1 hypothetical protein QYE76_001041 [Lolium multiflorum] | diamond | 2862 | 99.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Lolium | Lolium multiflorum | |
| 30635019 | 30635019 | PRJNA1013345_P_NODE_19233_length_173_cov_1.619048_g19103_i0 | PRJNA1013345 | 19233 | 173 | 1.619048 | 2.80095304 | Tetracentron sinense | 13715 | Plants | Plants | 100 | 6.57e-23 | NR | KAF8402079.1 | 13715 | g19103 | i0 | 73.7 | 1.97687861271676 | 57 | 15 | 98.8 | 0 | 171 | 1 | 502 | 558 | KAF8402079.1 hypothetical protein HHK36_013031 [Tetracentron sinense] | diamond | 342 | 100 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Trochodendrales | Trochodendraceae | Tetracentron | Tetracentron sinense | |
| 30856311 | 30856311 | PRJNA1013345_P_NODE_23254_length_165_cov_1.305085_g23124_i0 | PRJNA1013345 | 23254 | 165 | 1.305085 | 2.15339025 | Sesamum indicum | 4182 | Plants | Plants | 65.5 | 1.17e-10 | NR | XP_011075308.1 | 4182 | g23124 | i0 | 70 | 3.74545454545455 | 40 | 11 | 72.7 | 1 | 134 | 15 | 19 | 57 | XP_011075308.1 uncharacterized protein LOC105159808 [Sesamum indicum] | diamond | 618 | 65.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Pedaliaceae | Sesamum | Sesamum indicum | |
| 30951336 | 30951336 | PRJNA1013345_P_NODE_9474_length_208_cov_3.273292_g9344_i0 | PRJNA1013345 | 9474 | 208 | 3.273292 | 6.80844736 | Cannabis sativa | 3483 | Plants | Plants | 46.6 | 0.00105 | NR | KAF4368741.1 | 3483 | g9344 | i0 | 39.3 | 2.63942307692308 | 61 | 28 | 77.9 | 2 | 43 | 204 | 485 | 543 | KAF4368741.1 hypothetical protein G4B88_003614 [Cannabis sativa] | diamond | 549 | 46.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Cannabis | Cannabis sativa | |
| 31741469 | 31741469 | PRJNA1013345_P_NODE_32797_length_155_cov_4.833333_g32667_i0 | PRJNA1013345 | 32797 | 155 | 4.833333 | 7.49166615 | Stephania cephalantha | 152367 | Plants | Plants | 78.2 | 2.78e-17 | NR | KAK9120000.1 | 152367 | g32667 | i0 | 74 | 11.5741935483871 | 50 | 13 | 96.8 | 0 | 6 | 155 | 30 | 79 | KAK9120000.1 hypothetical protein Scep_018093 [Stephania cephalantha] | diamond | 1794 | 78.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ranunculales | Menispermaceae | Stephania | Stephania cephalantha | |
| 31986780 | 31986780 | PRJNA1013345_P_NODE_30538_length_158_cov_1.837838_g30408_i0 | PRJNA1013345 | 30538 | 158 | 1.837838 | 2.90378404 | Magnoliopsida | 3398 | Plants | Plants | 51.2 | 1.19e-5 | NR | XP_052181862.1 | 55363 | g30408 | i0 | 70 | 2.84810126582278 | 30 | 9 | 57 | 0 | 3 | 92 | 190 | 219 | XP_052181862.1 glycerophosphodiester phosphodiesterase GDPDL6-like [Diospyros lotus] | diamond | 450 | 51.6 | 0.992248062015504 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Ebenaceae | Diospyros | Diospyros lotus | |
| 32026350 | 32026350 | PRJNA1013345_P_NODE_31998_length_157_cov_0.927273_g31868_i0 | PRJNA1013345 | 31998 | 157 | 0.927273 | 1.45581861 | Medicago truncatula | 3880 | Plants | Plants | 44.3 | 0.00309 | NR | KEH15938.1 | 3880 | g31868 | i0 | 70.4 | 0.515923566878981 | 27 | 8 | 51.6 | 0 | 72 | 152 | 22 | 48 | KEH15938.1 endonuclease/exonuclease/phosphatase family protein [Medicago truncatula] | diamond | 81 | 44.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Medicago | Medicago truncatula | |
| 32057934 | 32057934 | PRJNA1013345_P_NODE_27678_length_161_cov_0.894737_g27548_i0 | PRJNA1013345 | 27678 | 161 | 0.894737 | 1.44052657 | Taxus chinensis | 29808 | Plants | Plants | 46.6 | 5.36e-4 | NR | KAH9291031.1 | 29808 | g27548 | i0 | 51.2 | 0.801242236024845 | 43 | 21 | 80.1 | 0 | 2 | 130 | 838 | 880 | KAH9291031.1 hypothetical protein KI387_044160 [Taxus chinensis] | diamond | 129 | 46.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Taxaceae | Taxus | Taxus chinensis | |
| 32311418 | 32311418 | PRJNA1013345_P_NODE_27539_length_161_cov_0.894737_g27409_i0 | PRJNA1013345 | 27539 | 161 | 0.894737 | 1.44052657 | Solanum lycopersicum | 4081 | Plants | Plants | 48.5 | 7.54e-5 | NR | XP_069152831.1 | 4081 | g27409 | i0 | 52.4 | 0.782608695652174 | 42 | 20 | 78.3 | 0 | 145 | 20 | 139 | 180 | XP_069152831.1 uncharacterized protein [Solanum lycopersicum] | diamond | 126 | 48.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum lycopersicum | |
| 32437917 | 32437917 | PRJNA1013345_P_NODE_22719_length_166_cov_1.184874_g22589_i0 | PRJNA1013345 | 22719 | 166 | 1.184874 | 1.96689084 | Sesbania bispinosa | 485725 | Plants | Plants | 38.9 | 0.0408 | NR | KAJ1442485.1 | 485725 | g22589 | i0 | 65 | 0.36144578313253 | 20 | 7 | 36.1 | 0 | 38 | 97 | 1 | 20 | KAJ1442485.1 putative arf-GAP with Rho-GAP domain, ANK repeat and PH domain-containing [Sesbania bispinosa] | diamond | 60 | 38.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Sesbania | Sesbania bispinosa | |
| 32753168 | 32753168 | PRJNA1013345_P_NODE_19300_length_173_cov_1.388889_g19170_i0 | PRJNA1013345 | 19300 | 173 | 1.388889 | 2.40277797 | Lolium multiflorum | 4521 | Plants | Plants | 105 | 1.57e-24 | NR | KAK1660476.1 | 4521 | g19170 | i0 | 93 | 6.90173410404624 | 57 | 4 | 98.8 | 0 | 173 | 3 | 1779 | 1835 | KAK1660476.1 hypothetical protein QYE76_048635 [Lolium multiflorum] | diamond | 1194 | 105 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Lolium | Lolium multiflorum | |
| 32784538 | 32784538 | PRJNA1013345_P_NODE_32480_length_157_cov_0.927273_g32350_i0 | PRJNA1013345 | 32480 | 157 | 0.927273 | 1.45581861 | Tetracentron sinense | 13715 | Plants | Plants | 41.2 | 0.0414 | NR | KAF8369441.1 | 13715 | g32350 | i0 | 67.7 | 0.592356687898089 | 31 | 7 | 53.5 | 1 | 1 | 84 | 433 | 463 | KAF8369441.1 hypothetical protein HHK36_032542 [Tetracentron sinense] | diamond | 93 | 41.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Trochodendrales | Trochodendraceae | Tetracentron | Tetracentron sinense |
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);;