contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA782551" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2039721 | 2039721 | PRJNA782551_P_NODE_4262_length_455_cov_4.282723_g4140_i0 | PRJNA782551 | 4262 | 455 | 4.282723 | 19.48638965 | Eukaryota | 2759 | Plants | Plants | 226 | 2.2e-70 | NR | XP_022154562.1 | 3673 | g4140 | i0 | 91.7 | 953.538461538462 | 132 | 11 | 87 | 0 | 455 | 60 | 5 | 136 | XP_022154562.1 uncharacterized protein LOC111021800 [Momordica charantia] | diamond | 433860 | 228 | 0.991228070175439 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cucurbitales | Cucurbitaceae | Momordica | Momordica charantia | |
| 26990099 | 26990099 | PRJNA782551_P_NODE_16742_length_250_cov_0.870056_g16620_i0 | PRJNA782551 | 16742 | 250 | 0.870056 | 2.17514 | Triticum aestivum | 4565 | Plants | Plants | 147 | 6.49e-39 | NR | BDI54638.1 | 4565 | g16620 | i0 | 82.9 | 1.956 | 82 | 14 | 98.4 | 0 | 248 | 3 | 1367 | 1448 | BDI54638.1 retrotransposon protein, putative, unclassified [Triticum aestivum] | diamond | 489 | 147 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 27590929 | 27590929 | PRJNA782551_P_NODE_10744_length_289_cov_1.134259_g10622_i0 | PRJNA782551 | 10744 | 289 | 1.134259 | 3.27800851 | Pisum sativum | 3888 | Plants | Plants | 70.1 | 1.12e-11 | NR | XP_050895662.1 | 3888 | g10622 | i0 | 47.3 | 0.768166089965398 | 74 | 39 | 76.8 | 0 | 232 | 11 | 228 | 301 | XP_050895662.1 uncharacterized protein LOC127102326 [Pisum sativum] | diamond | 222 | 70.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Lathyrus | Lathyrus oleraceus | |
| 27969560 | 27969560 | PRJNA782551_P_NODE_10545_length_290_cov_1.419355_g10423_i0 | PRJNA782551 | 10545 | 290 | 1.419355 | 4.1161295 | Vitis vinifera | 29760 | Plants | Plants | 71.2 | 8.54e-13 | NR | CAN83205.1 | 29760 | g10423 | i0 | 41 | 6.1551724137931 | 83 | 49 | 85.9 | 0 | 42 | 290 | 90 | 172 | CAN83205.1 hypothetical protein VITISV_019936 [Vitis vinifera] | diamond | 1785 | 71.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Vitales | Vitaceae | Vitis | Vitis vinifera | |
| 27978883 | 27978883 | PRJNA782551_P_NODE_14425_length_260_cov_1.406417_g14303_i0 | PRJNA782551 | 14425 | 260 | 1.406417 | 3.6566842 | Chenopodiaceae | 1804623 | Plants | Plants | 100 | 1.18e-22 | NR | XP_057247061.1 | 3555 | g14303 | i0 | 53.5 | 4.91538461538462 | 86 | 40 | 99.2 | 0 | 258 | 1 | 240 | 325 | XP_057247061.1 uncharacterized protein LOC130589645 [Beta vulgaris subsp. vulgaris] | diamond | 1278 | 100 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Chenopodiaceae | Beta | Beta vulgaris | |
| 28222017 | 28222017 | PRJNA782551_P_NODE_22286_length_244_cov_0.900585_g22164_i0 | PRJNA782551 | 22286 | 244 | 0.900585 | 2.1974274 | Aegilops tauschii subsp. strangulata | 200361 | Plants | Plants | 61.2 | 1.09e-8 | NR | XP_040243755.1 | 200361 | g22164 | i0 | 42.7 | 1.00819672131148 | 82 | 45 | 98.4 | 1 | 3 | 242 | 1 | 82 | XP_040243755.1 uncharacterized protein LOC120963231 [Aegilops tauschii subsp. strangulata] | diamond | 246 | 61.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Aegilops | Aegilops tauschii | |
| 28348469 | 28348469 | PRJNA782551_P_NODE_20626_length_246_cov_0.890173_g20504_i0 | PRJNA782551 | 20626 | 246 | 0.890173 | 2.18982558 | Capsicum baccatum | 33114 | Plants | Plants | 53.5 | 6e-6 | NR | PHT44289.1 | 33114 | g20504 | i0 | 51.1 | 0.573170731707317 | 47 | 23 | 57.3 | 0 | 150 | 10 | 16 | 62 | PHT44289.1 hypothetical protein CQW23_18314 [Capsicum baccatum] | diamond | 141 | 53.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Capsicum | Capsicum baccatum | |
| 28443408 | 28443408 | PRJNA782551_P_NODE_23306_length_242_cov_1.822485_g23184_i0 | PRJNA782551 | 23306 | 242 | 1.822485 | 4.4104137 | Triticum aestivum | 4565 | Plants | Plants | 82.8 | 2.02e-17 | NR | BDI54686.1 | 4565 | g23184 | i0 | 76 | 0.619834710743802 | 50 | 12 | 62 | 0 | 241 | 92 | 21 | 70 | BDI54686.1 predicted protein [Triticum aestivum] | diamond | 150 | 82.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 28916591 | 28916591 | PRJNA782551_P_NODE_16628_length_250_cov_0.870056_g16506_i0 | PRJNA782551 | 16628 | 250 | 0.870056 | 2.17514 | Heracleum sosnowskyi | 360622 | Plants | Plants | 120 | 2.59e-29 | NR | KAK1403678.1 | 360622 | g16506 | i0 | 69.5 | 1.968 | 82 | 25 | 98.4 | 0 | 250 | 5 | 638 | 719 | KAK1403678.1 hypothetical protein POM88_003283 [Heracleum sosnowskyi] | diamond | 492 | 120 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Apiales | Apiaceae | Heracleum | Heracleum sosnowskyi | |
| 29106378 | 29106378 | PRJNA782551_P_NODE_20408_length_246_cov_0.890173_g20286_i0 | PRJNA782551 | 20408 | 246 | 0.890173 | 2.18982558 | Capsicum annuum | 4072 | Plants | Plants | 51.6 | 2.83e-5 | NR | KAF3669731.1 | 4072 | g20286 | i0 | 61.1 | 0.439024390243902 | 36 | 14 | 43.9 | 0 | 208 | 101 | 263 | 298 | KAF3669731.1 hypothetical protein FXO38_07463 [Capsicum annuum] | diamond | 108 | 51.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Capsicum | Capsicum annuum | |
| 29557462 | 29557462 | PRJNA782551_P_NODE_17650_length_249_cov_0.875000_g17528_i0 | PRJNA782551 | 17650 | 249 | 0.875 | 2.17875 | Eukaryota | 2759 | Plants | Plants | 78.6 | 3.91e-15 | NR | CAL5374787.1 | 4442 | g17528 | i0 | 50.7 | 18.1204819277108 | 71 | 35 | 85.5 | 0 | 11 | 223 | 226 | 296 | CAL5374787.1 unnamed protein product [Camellia sinensis] | diamond | 4512 | 78.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Theaceae | Camellia | Camellia sinensis | |
| 29958807 | 29958807 | PRJNA782551_P_NODE_13591_length_266_cov_1.590674_g13469_i0 | PRJNA782551 | 13591 | 266 | 1.590674 | 4.23119284 | Capsicum annuum | 4072 | Plants | Plants | 73.6 | 7e-13 | NR | PHT74244.1 | 4072 | g13469 | i0 | 67.2 | 0.654135338345865 | 58 | 19 | 65.4 | 0 | 266 | 93 | 35 | 92 | PHT74244.1 hypothetical protein T459_21521 [Capsicum annuum] | diamond | 174 | 73.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Capsicum | Capsicum annuum | |
| 30179854 | 30179854 | PRJNA782551_P_NODE_17952_length_249_cov_0.875000_g17830_i0 | PRJNA782551 | 17952 | 249 | 0.875 | 2.17875 | Vigna mungo | 3915 | Plants | Plants | 99.4 | 4.89e-22 | NR | WVZ07038.1 | 3915 | g17830 | i0 | 66.2 | 4.72289156626506 | 65 | 22 | 78.3 | 0 | 248 | 54 | 1508 | 1572 | WVZ07038.1 hypothetical protein V8G54_020384 [Vigna mungo] | diamond | 1176 | 99.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Vigna | Vigna mungo | |
| 30243304 | 30243304 | PRJNA782551_P_NODE_24172_length_242_cov_0.905325_g24050_i0 | PRJNA782551 | 24172 | 242 | 0.905325 | 2.1908865 | Hibiscus sabdariffa | 183260 | Plants | Plants | 141 | 2.3499999999999997e-37 | NR | KAK9020348.1 | 183260 | g24050 | i0 | 95 | 0.991735537190083 | 80 | 4 | 99.2 | 0 | 1 | 240 | 413 | 492 | KAK9020348.1 hypothetical protein V6N11_010373 [Hibiscus sabdariffa] | diamond | 240 | 141 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malvales | Malvaceae | Hibiscus | Hibiscus sabdariffa | |
| 30379247 | 30379247 | PRJNA782551_P_NODE_20372_length_246_cov_0.890173_g20250_i0 | PRJNA782551 | 20372 | 246 | 0.890173 | 2.18982558 | Poaceae | 4479 | Plants | Plants | 118 | 7.78e-29 | NR | KAK1653689.1 | 4521 | g20250 | i0 | 61.3 | 4.8780487804878 | 80 | 31 | 97.6 | 0 | 240 | 1 | 50 | 129 | KAK1653689.1 hypothetical protein QYE76_071494 [Lolium multiflorum] | diamond | 1200 | 118 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Lolium | Lolium multiflorum | |
| 30496080 | 30496080 | PRJNA782551_P_NODE_23333_length_242_cov_1.715976_g23211_i0 | PRJNA782551 | 23333 | 242 | 1.715976 | 4.15266192 | Triticum aestivum | 4565 | Plants | Plants | 62.4 | 3.84e-9 | NR | XBI48710.1 | 4565 | g23211 | i0 | 61.1 | 0.669421487603306 | 54 | 19 | 64.5 | 1 | 241 | 86 | 260 | 313 | XBI48710.1 hypothetical protein VPH35_112388 [Triticum aestivum] | diamond | 162 | 62.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 30622187 | 30622187 | PRJNA782551_P_NODE_7673_length_337_cov_2.329545_g7551_i0 | PRJNA782551 | 7673 | 337 | 2.329545 | 7.85056665 | Arabis alpina | 50452 | Plants | Plants | 102 | 1.7e-23 | NR | KFK27235.1 | 50452 | g7551 | i0 | 51.9 | 1.93175074183976 | 108 | 50 | 95.3 | 2 | 336 | 16 | 124 | 230 | KFK27235.1 hypothetical protein AALP_AA8G355200 [Arabis alpina] | diamond | 651 | 102 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Arabis | Arabis alpina | |
| 30875084 | 30875084 | PRJNA782551_P_NODE_17174_length_250_cov_0.870056_g17052_i0 | PRJNA782551 | 17174 | 250 | 0.870056 | 2.17514 | Aegilops tauschii subsp. strangulata | 200361 | Plants | Plants | 112 | 1.73e-26 | NR | XP_040252162.1 | 200361 | g17052 | i0 | 63.9 | 1.992 | 83 | 30 | 99.6 | 0 | 249 | 1 | 242 | 324 | XP_040252162.1 uncharacterized protein LOC109757173 [Aegilops tauschii subsp. strangulata] | diamond | 498 | 112 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Aegilops | Aegilops tauschii | |
| 31001556 | 31001556 | PRJNA782551_P_NODE_11214_length_285_cov_1.443396_g11092_i0 | PRJNA782551 | 11214 | 285 | 1.443396 | 4.1136786 | Pisum sativum | 3888 | Plants | Plants | 47.4 | 0.00143 | NR | KAI5445919.1 | 3888 | g11092 | i0 | 35.8 | 0.852631578947368 | 81 | 52 | 85.3 | 0 | 40 | 282 | 247 | 327 | KAI5445919.1 hypothetical protein KIW84_013954 [Pisum sativum] | diamond | 243 | 47.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Lathyrus | Lathyrus oleraceus | |
| 31096166 | 31096166 | PRJNA782551_P_NODE_16155_length_251_cov_0.865169_g16033_i0 | PRJNA782551 | 16155 | 251 | 0.865169 | 2.17157419 | Aegilops tauschii subsp. strangulata | 200361 | Plants | Plants | 58.5 | 1.08e-7 | NR | XP_020187187.1 | 200361 | g16033 | i0 | 62.7 | 1.42231075697211 | 59 | 22 | 70.5 | 0 | 3 | 179 | 151 | 209 | XP_020187187.1 tropomyosin-like [Aegilops tauschii subsp. strangulata] | diamond | 357 | 58.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Aegilops | Aegilops tauschii | |
| 31096167 | 31096167 | PRJNA782551_P_NODE_17975_length_249_cov_0.875000_g17853_i0 | PRJNA782551 | 17975 | 249 | 0.875 | 2.17875 | Triticum aestivum | 4565 | Plants | Plants | 45.8 | 0.00308 | NR | XBI58107.1 | 4565 | g17853 | i0 | 57.6 | 0.397590361445783 | 33 | 12 | 37.3 | 1 | 209 | 117 | 51 | 83 | XBI58107.1 hypothetical protein VPH35_039384 [Triticum aestivum] | diamond | 99 | 45.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 31254247 | 31254247 | PRJNA782551_P_NODE_4015_length_471_cov_3.095477_g3893_i0 | PRJNA782551 | 4015 | 471 | 3.095477 | 14.57969667 | Marchantia paleacea | 56867 | Plants | Plants | 58.2 | 7.11e-7 | NR | KAG6542793.1 | 56867 | g3893 | i0 | 38.3 | 2.19745222929936 | 141 | 75 | 88.5 | 5 | 50 | 466 | 90 | 220 | KAG6542793.1 hypothetical protein Mapa_015696 [Marchantia paleacea] | diamond | 1035 | 58.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Marchantiopsida | Marchantiales | Marchantiaceae | Marchantia | Marchantia paleacea | |
| 31358604 | 31358604 | PRJNA782551_P_NODE_16776_length_250_cov_0.870056_g16654_i0 | PRJNA782551 | 16776 | 250 | 0.870056 | 2.17514 | Magnoliopsida | 3398 | Plants | Plants | 58.5 | 1.1e-7 | NR | GAU25214.1 | 3900 | g16654 | i0 | 71.1 | 1.404 | 38 | 11 | 45.6 | 0 | 3 | 116 | 1117 | 1154 | GAU25214.1 hypothetical protein TSUD_151140 [Trifolium subterraneum] | diamond | 351 | 58.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Trifolium | Trifolium subterraneum | |
| 31886821 | 31886821 | PRJNA782551_P_NODE_16877_length_250_cov_0.870056_g16755_i0 | PRJNA782551 | 16877 | 250 | 0.870056 | 2.17514 | Zea mays | 4577 | Plants | Plants | 45.1 | 0.00637 | NR | AAL76006.1 | 4577 | g16755 | i0 | 45.5 | 0.66 | 55 | 29 | 66 | 1 | 250 | 86 | 352 | 405 | AAL76006.1 putative retrotransposon protein [Zea mays] | diamond | 165 | 45.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Zea | Zea mays | |
| 31918551 | 31918551 | PRJNA782551_P_NODE_19757_length_247_cov_0.885057_g19635_i0 | PRJNA782551 | 19757 | 247 | 0.885057 | 2.18609079 | Cocos nucifera | 13894 | Plants | Plants | 75.9 | 5.55e-14 | NR | KAG1370944.1 | 13894 | g19635 | i0 | 82.2 | 0.546558704453441 | 45 | 8 | 54.7 | 0 | 6 | 140 | 304 | 348 | KAG1370944.1 hypothetical protein COCNU_16G000380 [Cocos nucifera] | diamond | 135 | 75.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Arecales | Arecaceae | Cocos | Cocos nucifera | |
| 32013451 | 32013451 | PRJNA782551_P_NODE_13598_length_266_cov_1.544041_g13476_i0 | PRJNA782551 | 13598 | 266 | 1.544041 | 4.10714906 | Pisum sativum | 3888 | Plants | Plants | 58.5 | 8.31e-8 | NR | KAI5389440.1 | 3888 | g13476 | i0 | 43.6 | 0.879699248120301 | 78 | 44 | 88 | 0 | 21 | 254 | 153 | 230 | KAI5389440.1 hypothetical protein KIW84_074916 [Pisum sativum] | diamond | 234 | 58.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Lathyrus | Lathyrus oleraceus | |
| 32654837 | 32654837 | PRJNA782551_P_NODE_4080_length_467_cov_3.997462_g3958_i0 | PRJNA782551 | 4080 | 467 | 3.997462 | 18.66814754 | root | 1 | Root_unresolved | Root_unresolved | 64.3 | 7.15e-9 | NR | XP_027071354.1 | 13443 | g3958 | i0 | 51.8 | 3.32762312633833 | 56 | 27 | 36 | 0 | 2 | 169 | 236 | 291 | XP_027071354.1 29 kDa ribonucleoprotein A, chloroplastic [Coffea arabica] | diamond | 1554 | 64.7 | 0.993817619783617 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Gentianales | Rubiaceae | Coffea | Coffea arabica |
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);;