contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA849646" and tax_clade = "Embryophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8490985 | 8490985 | PRJNA849646_P_NODE_21507_length_265_cov_2.796875_g21389_i0 | PRJNA849646 | 21507 | 265 | 2.796875 | 7.41171875 | Tanacetum cinerariifolium | 118510 | Plants | Plants | 135 | 4.19e-38 | NR | GEY04738.1 | 118510 | g21389 | i0 | 80.7 | 8.90943396226415 | 88 | 17 | 99.6 | 0 | 264 | 1 | 33 | 120 | GEY04738.1 reverse transcriptase domain-containing protein [Tanacetum cinerariifolium] | diamond | 2361 | 135 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Tanacetum | Tanacetum cinerariifolium | |
| 11041946 | 11041946 | PRJNA849646_P_NODE_32569_length_247_cov_2.649425_g32451_i0 | PRJNA849646 | 32569 | 247 | 2.649425 | 6.54407975 | Humulus lupulus | 3486 | Plants | Plants | 86.3 | 1.92e-17 | NR | XP_062118184.1 | 3486 | g32451 | i0 | 57.6 | 1.03238866396761 | 85 | 31 | 99.6 | 2 | 2 | 247 | 504 | 586 | XP_062118184.1 putative disease resistance RPP13-like protein 1 [Humulus lupulus] | diamond | 255 | 86.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Humulus | Humulus lupulus | |
| 19084950 | 19084950 | PRJNA849646_P_NODE_5435_length_310_cov_2.966245_g5317_i0 | PRJNA849646 | 5435 | 310 | 2.966245 | 9.1953595 | Diphasiastrum complanatum | 34168 | Plants | Plants | 139 | 1.03e-35 | NR | KAJ7519640.1 | 34168 | g5317 | i0 | 67.3 | 1.06451612903226 | 110 | 25 | 95.8 | 2 | 14 | 310 | 52 | 161 | KAJ7519640.1 hypothetical protein O6H91_20G048000 [Diphasiastrum complanatum] | diamond | 330 | 139 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Lycopodiopsida | Lycopodiales | Lycopodiaceae | Diphasiastrum | Diphasiastrum complanatum | |
| 23790397 | 23790397 | PRJNA849646_P_NODE_18979_length_270_cov_2.172589_g18861_i0 | PRJNA849646 | 18979 | 270 | 2.172589 | 5.8659903 | Quillaja saponaria | 32244 | Plants | Plants | 86.3 | 2.57e-17 | NR | KAJ7950679.1 | 32244 | g18861 | i0 | 63.2 | 3.82222222222222 | 57 | 21 | 63.3 | 0 | 6 | 176 | 870 | 926 | KAJ7950679.1 Retrovirus-related Pol polyprotein from transposon TNT 1-94 [Quillaja saponaria] | diamond | 1032 | 86.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Quillajaceae | Quillaja | Quillaja saponaria | |
| 26928345 | 26928345 | PRJNA849646_P_NODE_29802_length_250_cov_2.920904_g29684_i0 | PRJNA849646 | 29802 | 250 | 2.920904 | 7.30226 | Gossypium barbadense | 3634 | Plants | Plants | 50.1 | 4.55e-5 | NR | PPS17938.1 | 3634 | g29684 | i0 | 57.1 | 0.42 | 35 | 15 | 42 | 0 | 24 | 128 | 136 | 170 | PPS17938.1 hypothetical protein GOBAR_AA02643 [Gossypium barbadense] | diamond | 105 | 50.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malvales | Malvaceae | Gossypium | Gossypium barbadense | |
| 27434354 | 27434354 | PRJNA849646_P_NODE_24583_length_260_cov_1.256684_g24465_i0 | PRJNA849646 | 24583 | 260 | 1.256684 | 3.2673784 | Acer saccharum | 4024 | Plants | Plants | 43.5 | 0.0249 | NR | KAK0570868.1 | 4024 | g24465 | i0 | 56 | 0.288461538461538 | 25 | 11 | 28.8 | 0 | 31 | 105 | 212 | 236 | KAK0570868.1 hypothetical protein LWI29_007685 [Acer saccharum] | diamond | 75 | 43.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Sapindaceae | Acer | Acer saccharum | |
| 27528826 | 27528826 | PRJNA849646_P_NODE_35663_length_244_cov_1.532164_g35545_i0 | PRJNA849646 | 35663 | 244 | 1.532164 | 3.73848016 | Carya illinoinensis | 32201 | Plants | Plants | 120 | 1.08e-29 | NR | XP_042944684.1 | 32201 | g35545 | i0 | 64.6 | 3.88524590163934 | 79 | 28 | 97.1 | 0 | 8 | 244 | 552 | 630 | XP_042944684.1 uncharacterized protein LOC122278571 [Carya illinoinensis] | diamond | 948 | 120 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Juglandaceae | Carya | Carya illinoinensis | |
| 27655357 | 27655357 | PRJNA849646_P_NODE_24024_length_261_cov_1.292553_g23906_i0 | PRJNA849646 | 24024 | 261 | 1.292553 | 3.37356333 | Panicum miliaceum | 4540 | Plants | Plants | 76.3 | 5.16e-14 | NR | RLM49020.1 | 4540 | g23906 | i0 | 48.1 | 0.885057471264368 | 77 | 39 | 88.5 | 1 | 234 | 4 | 18 | 93 | RLM49020.1 hypothetical protein C2845_PMPSC055709 [Panicum miliaceum] | diamond | 231 | 76.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Panicum | Panicum miliaceum | |
| 27876107 | 27876107 | PRJNA849646_P_NODE_3685_length_311_cov_3.117647_g3567_i0 | PRJNA849646 | 3685 | 311 | 3.117647 | 9.69588217 | Aegilops tauschii subsp. strangulata | 200361 | Plants | Plants | 63.9 | 2.34e-9 | NR | XP_040245475.1 | 200361 | g3567 | i0 | 46.8 | 1.05144694533762 | 109 | 50 | 98.4 | 2 | 6 | 311 | 74 | 181 | XP_040245475.1 uncharacterized protein CG45076-like [Aegilops tauschii subsp. strangulata] | diamond | 327 | 63.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Aegilops | Aegilops tauschii | |
| 27970848 | 27970848 | PRJNA849646_P_NODE_28045_length_253_cov_1.711111_g27927_i0 | PRJNA849646 | 28045 | 253 | 1.711111 | 4.32911083 | Macadamia integrifolia | 60698 | Plants | Plants | 80.1 | 3.39e-16 | NR | XP_042486607.1 | 60698 | g27927 | i0 | 66.1 | 0.735177865612648 | 62 | 21 | 73.5 | 0 | 37 | 222 | 28 | 89 | XP_042486607.1 uncharacterized protein LOC122066849 [Macadamia integrifolia] | diamond | 186 | 80.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Proteales | Proteaceae | Macadamia | Macadamia integrifolia | |
| 28168662 | 28168662 | PRJNA849646_P_NODE_3645_length_311_cov_3.903361_g3527_i0 | PRJNA849646 | 3645 | 311 | 3.903361 | 12.13945271 | Magnoliopsida | 3398 | Plants | Plants | 49.7 | 3.08e-4 | NR | WZY99706.1 | 3708 | g3527 | i0 | 44.7 | 1.38906752411576 | 85 | 39 | 76.2 | 2 | 60 | 296 | 825 | 907 | WZY99706.1 hypothetical protein YC2023_072035 [Brassica napus] | diamond | 432 | 49.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica napus | |
| 28539472 | 28539472 | PRJNA849646_P_NODE_32287_length_248_cov_0.880000_g32169_i0 | PRJNA849646 | 32287 | 248 | 0.88 | 2.1824 | Sphagnum balticum | 128184 | Plants | Plants | 75.1 | 1.62e-13 | NR | CAM5998736.1 | 128184 | g32169 | i0 | 50.7 | 1.69354838709677 | 67 | 32 | 79.8 | 1 | 28 | 225 | 153 | 219 | CAM5998736.1 unnamed protein product [Sphagnum balticum] | diamond | 420 | 75.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum balticum | |
| 28728702 | 28728702 | PRJNA849646_P_NODE_38927_length_240_cov_2.508982_g38809_i0 | PRJNA849646 | 38927 | 240 | 2.508982 | 6.0215568 | Heracleum sosnowskyi | 360622 | Plants | Plants | 108 | 9.62e-26 | NR | KAK1394734.1 | 360622 | g38809 | i0 | 80.3 | 9.525 | 76 | 14 | 95 | 1 | 12 | 239 | 299 | 373 | KAK1394734.1 hypothetical protein POM88_013790 [Heracleum sosnowskyi] | diamond | 2286 | 108 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Apiales | Apiaceae | Heracleum | Heracleum sosnowskyi | |
| 29233935 | 29233935 | PRJNA849646_P_NODE_15329_length_277_cov_2.122549_g15211_i0 | PRJNA849646 | 15329 | 277 | 2.122549 | 5.87946073 | Aegilops tauschii subsp. strangulata | 200361 | Plants | Plants | 110 | 6.610000000000001e-26 | NR | XP_020177078.1 | 200361 | g15211 | i0 | 77.3 | 2.85920577617329 | 66 | 15 | 71.5 | 0 | 199 | 2 | 134 | 199 | XP_020177078.1 uncharacterized protein LOC109762617 [Aegilops tauschii subsp. strangulata] | diamond | 792 | 110 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Aegilops | Aegilops tauschii | |
| 29612391 | 29612391 | PRJNA849646_P_NODE_42670_length_217_cov_4.472222_g42552_i0 | PRJNA849646 | 42670 | 217 | 4.472222 | 9.70472174 | Aegilops tauschii subsp. strangulata | 200361 | Plants | Plants | 58.5 | 7.06e-8 | NR | XP_040251614.1 | 200361 | g42552 | i0 | 70.9 | 0.76036866359447 | 55 | 16 | 76 | 0 | 214 | 50 | 81 | 135 | XP_040251614.1 putative uncharacterized protein ENSP00000383309 [Aegilops tauschii subsp. strangulata] | diamond | 165 | 58.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Aegilops | Aegilops tauschii | |
| 29683847 | 29683847 | PRJNA849646_P_NODE_20570_length_267_cov_2.206186_g20452_i0 | PRJNA849646 | 20570 | 267 | 2.206186 | 5.89051662 | Eukaryota | 2759 | Plants | Plants | 138 | 2.64e-38 | NR | KAF3671423.1 | 4072 | g20452 | i0 | 79.5 | 43.5056179775281 | 88 | 18 | 98.9 | 0 | 264 | 1 | 127 | 214 | KAF3671423.1 60S ribosomal protein L26 [Capsicum annuum] | diamond | 11616 | 138 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Capsicum | Capsicum annuum | |
| 29897054 | 29897054 | PRJNA849646_P_NODE_43231_length_205_cov_4.098485_g43113_i0 | PRJNA849646 | 43231 | 205 | 4.098485 | 8.40189425 | Nicotiana sylvestris | 4096 | Plants | Plants | 120 | 8.49e-33 | NR | XP_070020334.1 | 4096 | g43113 | i0 | 90.9 | 3.8780487804878 | 66 | 6 | 96.6 | 0 | 200 | 3 | 39 | 104 | XP_070020334.1 uncharacterized protein [Nicotiana sylvestris] | diamond | 795 | 120 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Nicotiana | Nicotiana sylvestris | |
| 31066189 | 31066189 | PRJNA849646_P_NODE_22095_length_264_cov_2.225131_g21977_i0 | PRJNA849646 | 22095 | 264 | 2.225131 | 5.87434584 | Trifolium repens | 3899 | Plants | Plants | 51.6 | 3.69e-5 | NR | KAK2371173.1 | 3899 | g21977 | i0 | 54.2 | 3.67045454545455 | 48 | 21 | 53.4 | 1 | 182 | 42 | 401 | 448 | KAK2371173.1 hypothetical protein QL285_084151 [Trifolium repens] | diamond | 969 | 51.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Trifolium | Trifolium repens | |
| 31318769 | 31318769 | PRJNA849646_P_NODE_15735_length_276_cov_2.581281_g15617_i0 | PRJNA849646 | 15735 | 276 | 2.581281 | 7.12433556 | Lolium multiflorum | 4521 | Plants | Plants | 149 | 8.509999999999999e-40 | NR | KAK1599878.1 | 4521 | g15617 | i0 | 78 | 9.89130434782609 | 91 | 20 | 98.9 | 0 | 275 | 3 | 396 | 486 | KAK1599878.1 hypothetical protein QYE76_018480 [Lolium multiflorum] | diamond | 2730 | 149 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Lolium | Lolium multiflorum | |
| 31888086 | 31888086 | PRJNA849646_P_NODE_4657_length_310_cov_3.506329_g4539_i0 | PRJNA849646 | 4657 | 310 | 3.506329 | 10.8696199 | Triticum dicoccoides | 85692 | Plants | Plants | 102 | 9.01e-23 | NR | XP_037450704.1 | 85692 | g4539 | i0 | 60.6 | 1.00645161290323 | 104 | 28 | 98.7 | 3 | 308 | 3 | 122 | 214 | XP_037450704.1 signal recognition particle receptor subunit alpha-like [Triticum dicoccoides] | diamond | 312 | 102 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum dicoccoides | |
| 31888087 | 31888087 | PRJNA849646_P_NODE_5097_length_310_cov_3.164557_g4979_i0 | PRJNA849646 | 5097 | 310 | 3.164557 | 9.8101267 | Aegilops tauschii subsp. strangulata | 200361 | Plants | Plants | 90.9 | 6.52e-19 | NR | XP_020178799.2 | 200361 | g4979 | i0 | 45 | 4.95483870967742 | 129 | 43 | 97.7 | 1 | 6 | 308 | 234 | 362 | XP_020178799.2 uncharacterized protein LOC109764369 [Aegilops tauschii subsp. strangulata] | diamond | 1536 | 90.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Aegilops | Aegilops tauschii | |
| 32331527 | 32331527 | PRJNA849646_P_NODE_11239_length_285_cov_2.141509_g11121_i0 | PRJNA849646 | 11239 | 285 | 2.141509 | 6.10330065 | Sesamum indicum | 4182 | Plants | Plants | 43.9 | 0.0232 | NR | XP_011076532.1 | 4182 | g11121 | i0 | 35.1 | 0.778947368421053 | 74 | 47 | 77.9 | 1 | 59 | 280 | 53 | 125 | XP_011076532.1 protein NRT1/ PTR FAMILY 5.5-like [Sesamum indicum] | diamond | 222 | 43.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Pedaliaceae | Sesamum | Sesamum indicum | |
| 32741779 | 32741779 | PRJNA849646_P_NODE_26800_length_255_cov_2.434066_g26682_i0 | PRJNA849646 | 26800 | 255 | 2.434066 | 6.2068683 | Picea sitchensis | 3332 | Plants | Plants | 95.5 | 2.919999999999999e-23 | NR | ABR17957.1 | 3332 | g26682 | i0 | 65.6 | 1.50588235294118 | 61 | 21 | 71.8 | 0 | 64 | 246 | 3 | 63 | ABR17957.1 unknown [Picea sitchensis] | diamond | 384 | 95.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea sitchensis |
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);;