contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJEB75227" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 995687 | 995687 | PRJEB75227_P_NODE_9641_length_248_cov_1.462857_g9470_i0 | PRJEB75227 | 9641 | 248 | 1.462857 | 3.62788536 | Magnoliopsida | 3398 | Plants | Plants | 100 | 2.04e-22 | NR | KAH8521218.1 | 3696 | g9470 | i0 | 54.3 | 40.2096774193548 | 81 | 37 | 98 | 0 | 244 | 2 | 197 | 277 | KAH8521218.1 hypothetical protein H0E87_002322 [Populus deltoides] | diamond | 9972 | 100 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Populus | Populus deltoides | |
| 1410269 | 1410269 | PRJEB75227_P_NODE_8742_length_251_cov_1.387640_g8571_i0 | PRJEB75227 | 8742 | 251 | 1.38764 | 3.4829764 | Lamiales | 4143 | Plants | Plants | 122 | 7.799999999999999e-31 | NR | CAA2997075.1 | 158383 | g8571 | i0 | 75.9 | 4.94820717131474 | 83 | 18 | 99.2 | 2 | 1 | 249 | 332 | 412 | CAA2997075.1 proline-rich receptor kinase PERK6 [Olea europaea subsp. europaea] | diamond | 1242 | 122 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Oleaceae | Olea | Olea europaea | |
| 26590703 | 26590703 | PRJEB75227_P_NODE_5821_length_290_cov_1.313364_g5650_i0 | PRJEB75227 | 5821 | 290 | 1.313364 | 3.8087556 | Allium cepa | 4679 | Plants | Plants | 49.3 | 3.14e-4 | NR | ABB55296.1 | 4679 | g5650 | i0 | 63.2 | 0.393103448275862 | 38 | 14 | 39.3 | 0 | 2 | 115 | 76 | 113 | ABB55296.1 hypothetical protein 11.t00005 [Allium cepa] | diamond | 114 | 49.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asparagales | Amaryllidaceae | Allium | Allium cepa | |
| 26710058 | 26710058 | PRJEB75227_P_NODE_7121_length_270_cov_1.187817_g6950_i0 | PRJEB75227 | 7121 | 270 | 1.187817 | 3.2071059 | Eukaryota | 2759 | Plants | Plants | 139 | 4.27e-36 | NR | BAJ98669.1 | 112509 | g6950 | i0 | 78.7 | 15.8222222222222 | 89 | 19 | 98.9 | 0 | 269 | 3 | 322 | 410 | BAJ98669.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 4272 | 140 | 0.992857142857143 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 26939093 | 26939093 | PRJEB75227_P_NODE_2782_length_446_cov_1.254692_g2611_i0 | PRJEB75227 | 2782 | 446 | 1.254692 | 5.59592632 | Stylosanthes scabra | 79078 | Plants | Plants | 97.8 | 1.16e-20 | NR | MED6106902.1 | 79078 | g2611 | i0 | 46.6 | 3.04708520179372 | 118 | 54 | 79.4 | 2 | 439 | 86 | 58 | 166 | MED6106902.1 hypothetical protein [Stylosanthes scabra] | diamond | 1359 | 97.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Stylosanthes | Stylosanthes scabra | |
| 27034152 | 27034152 | PRJEB75227_P_NODE_10202_length_247_cov_0.896552_g10031_i0 | PRJEB75227 | 10202 | 247 | 0.896552 | 2.21448344 | Acer saccharum | 4024 | Plants | Plants | 125 | 2.1199999999999996e-31 | NR | KAK0606017.1 | 4024 | g10031 | i0 | 81.7 | 8.96356275303644 | 82 | 14 | 98.4 | 1 | 245 | 3 | 517 | 598 | KAK0606017.1 hypothetical protein LWI29_033182 [Acer saccharum] | diamond | 2214 | 125 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Sapindaceae | Acer | Acer saccharum | |
| 27097333 | 27097333 | PRJEB75227_P_NODE_7282_length_267_cov_1.489691_g7111_i0 | PRJEB75227 | 7282 | 267 | 1.489691 | 3.97747497 | Erythroxylum novogranatense | 1862640 | Plants | Plants | 43.1 | 0.0364 | NR | KAJ8752504.1 | 1862640 | g7111 | i0 | 46.7 | 0.50561797752809 | 45 | 24 | 50.6 | 0 | 75 | 209 | 260 | 304 | KAJ8752504.1 hypothetical protein K2173_004792 [Erythroxylum novogranatense] | diamond | 135 | 43.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Erythroxylaceae | Erythroxylum | Erythroxylum novogranatense | |
| 27248200 | 27248200 | PRJEB75227_P_NODE_10923_length_244_cov_2.181287_g10752_i0 | PRJEB75227 | 10923 | 244 | 2.181287 | 5.32234028 | Magnoliopsida | 3398 | Plants | Plants | 94.7 | 1.93e-20 | NR | EOY14055.1 | 3641 | g10752 | i0 | 56.8 | 8.96311475409836 | 81 | 35 | 99.6 | 0 | 244 | 2 | 699 | 779 | EOY14055.1 Retrotransposon protein, putative [Theobroma cacao] | diamond | 2187 | 94.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malvales | Malvaceae | Theobroma | Theobroma cacao | |
| 27848076 | 27848076 | PRJEB75227_P_NODE_6004_length_287_cov_1.355140_g5833_i0 | PRJEB75227 | 6004 | 287 | 1.35514 | 3.8892518 | Eukaryota | 2759 | Plants | Plants | 70.5 | 1.1e-11 | NR | PIA40360.1 | 218851 | g5833 | i0 | 50 | 14.383275261324 | 80 | 40 | 83.6 | 0 | 280 | 41 | 398 | 477 | PIA40360.1 hypothetical protein AQUCO_02500212v1 [Aquilegia coerulea] | diamond | 4128 | 71.2 | 0.990168539325843 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ranunculales | Ranunculaceae | Aquilegia | Aquilegia coerulea | |
| 28202572 | 28202572 | PRJEB75227_P_NODE_5546_length_295_cov_3.351351_g5375_i0 | PRJEB75227 | 5546 | 295 | 3.351351 | 9.88648545 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 110 | 3.11e-27 | NR | BAK00797.1 | 112509 | g5375 | i0 | 51.5 | 3.01016949152542 | 99 | 44 | 97.6 | 2 | 7 | 294 | 115 | 212 | BAK00797.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 888 | 110 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 28890091 | 28890091 | PRJEB75227_P_NODE_4088_length_353_cov_1.096429_g3917_i0 | PRJEB75227 | 4088 | 353 | 1.096429 | 3.87039437 | Magnoliopsida | 3398 | Plants | Plants | 154 | 1.46e-44 | NR | P34091.1 | 3544 | g3917 | i0 | 74.5 | 58.7677053824363 | 106 | 26 | 90.1 | 1 | 350 | 33 | 65 | 169 | P34091.1 RecName: Full=Large ribosomal subunit protein eL6; AltName: Full=60S ribosomal protein L6; AltName: Full=YL16-like [Mesembryanthemum crystallinum] | diamond | 20745 | 155 | 0.993548387096774 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Aizoaceae | Mesembryanthemum | Mesembryanthemum crystallinum | |
| 28992470 | 28992470 | PRJEB75227_P_NODE_5308_length_303_cov_1.717391_g5137_i0 | PRJEB75227 | 5308 | 303 | 1.717391 | 5.20369473 | Crotalaria pallida | 3830 | Plants | Plants | 43.9 | 0.0285 | NR | KAK7258446.1 | 3830 | g5137 | i0 | 44.2 | 1.28712871287129 | 43 | 24 | 42.6 | 0 | 142 | 14 | 271 | 313 | KAK7258446.1 hypothetical protein RIF29_24023 [Crotalaria pallida] | diamond | 390 | 43.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Crotalaria | Crotalaria pallida | |
| 29237630 | 29237630 | PRJEB75227_P_NODE_9149_length_250_cov_0.881356_g8978_i0 | PRJEB75227 | 9149 | 250 | 0.881356 | 2.20339 | Populus | 3689 | Plants | Plants | 60.5 | 2.4e-8 | NR | KAI5568966.1 | 3694 | g8978 | i0 | 47.8 | 2.412 | 67 | 35 | 80.4 | 0 | 2 | 202 | 1005 | 1071 | KAI5568966.1 hypothetical protein BDE02_12G047900 [Populus trichocarpa] | diamond | 603 | 60.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Populus | Populus trichocarpa | |
| 29465374 | 29465374 | PRJEB75227_P_NODE_6770_length_275_cov_2.316832_g6599_i0 | PRJEB75227 | 6770 | 275 | 2.316832 | 6.371288 | Diphasiastrum complanatum | 34168 | Plants | Plants | 79.3 | 2.04e-16 | NR | KAJ7532782.1 | 34168 | g6599 | i0 | 45.1 | 3.92727272727273 | 91 | 48 | 99.3 | 1 | 2 | 274 | 8 | 96 | KAJ7532782.1 hypothetical protein O6H91_13G019900 [Diphasiastrum complanatum] | diamond | 1080 | 79.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Lycopodiopsida | Lycopodiales | Lycopodiaceae | Diphasiastrum | Diphasiastrum complanatum | |
| 30160341 | 30160341 | PRJEB75227_P_NODE_10652_length_245_cov_0.906977_g10481_i0 | PRJEB75227 | 10652 | 245 | 0.906977 | 2.22209365 | Ceratodon purpureus | 3225 | Plants | Plants | 46.6 | 0.0015 | NR | KAG0574757.1 | 3225 | g10481 | i0 | 50 | 0.73469387755102 | 28 | 14 | 34.3 | 0 | 4 | 87 | 42 | 69 | KAG0574757.1 hypothetical protein KC19_VG288300 [Ceratodon purpureus] | diamond | 180 | 46.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Pseudoditrichales | Ditrichaceae | Ceratodon | Ceratodon purpureus | |
| 30792431 | 30792431 | PRJEB75227_P_NODE_10434_length_246_cov_0.901734_g10263_i0 | PRJEB75227 | 10434 | 246 | 0.901734 | 2.21826564 | Sphagnum balticum | 128184 | Plants | Plants | 94 | 6.610000000000001e-21 | NR | CAM6000927.1 | 128184 | g10263 | i0 | 56.3 | 0.975609756097561 | 80 | 34 | 96.3 | 1 | 2 | 238 | 208 | 287 | CAM6000927.1 unnamed protein product [Sphagnum balticum] | diamond | 240 | 94 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum balticum | |
| 31013617 | 31013617 | PRJEB75227_P_NODE_10155_length_247_cov_0.896552_g9984_i0 | PRJEB75227 | 10155 | 247 | 0.896552 | 2.21448344 | Taxus chinensis | 29808 | Plants | Plants | 67.8 | 5.87e-11 | NR | KAH9304411.1 | 29808 | g9984 | i0 | 75 | 1.57894736842105 | 40 | 10 | 48.6 | 0 | 3 | 122 | 1080 | 1119 | KAH9304411.1 hypothetical protein KI387_008815 [Taxus chinensis] | diamond | 390 | 67.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Taxaceae | Taxus | Taxus chinensis | |
| 31045581 | 31045581 | PRJEB75227_P_NODE_10855_length_245_cov_0.906977_g10684_i0 | PRJEB75227 | 10855 | 245 | 0.906977 | 2.22209365 | Diospyros lotus | 55363 | Plants | Plants | 116 | 3.87e-28 | NR | XP_052171565.1 | 55363 | g10684 | i0 | 66.7 | 3.96734693877551 | 81 | 27 | 99.2 | 0 | 1 | 243 | 591 | 671 | XP_052171565.1 uncharacterized protein LOC127787547 [Diospyros lotus] | diamond | 972 | 116 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Ebenaceae | Diospyros | Diospyros lotus | |
| 31417387 | 31417387 | PRJEB75227_P_NODE_2116_length_529_cov_1.416667_g1945_i0 | PRJEB75227 | 2116 | 529 | 1.416667 | 7.49416843 | Eukaryota | 2759 | Plants | Plants | 115 | 4.03e-28 | NR | BAK00444.1 | 112509 | g1945 | i0 | 63.4 | 2.51228733459357 | 112 | 30 | 62.9 | 2 | 334 | 2 | 114 | 215 | BAK00444.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 1329 | 115 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 31449094 | 31449094 | PRJEB75227_P_NODE_8076_length_254_cov_1.370166_g7905_i0 | PRJEB75227 | 8076 | 254 | 1.370166 | 3.48022164 | Nymphaea | 4418 | Plants | Plants | 57.8 | 2.22e-7 | NR | XP_031494019.1 | 210225 | g7905 | i0 | 45.1 | 1.93700787401575 | 82 | 38 | 94.5 | 3 | 1 | 240 | 545 | 621 | XP_031494019.1 E3 ubiquitin-protein ligase KEG isoform X2 [Nymphaea colorata] | diamond | 492 | 57.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Nymphaeales | Nymphaeaceae | Nymphaea | Nymphaea colorata | |
| 32240139 | 32240139 | PRJEB75227_P_NODE_8158_length_253_cov_0.916667_g7987_i0 | PRJEB75227 | 8158 | 253 | 0.916667 | 2.31916751 | Eukaryota | 2759 | Plants | Plants | 50.1 | 1.13e-4 | NR | XP_044387701.1 | 4565 | g7987 | i0 | 70.4 | 1.58893280632411 | 27 | 8 | 32 | 0 | 16 | 96 | 798 | 824 | XP_044387701.1 replication protein A 70 kDa DNA-binding subunit C-like [Triticum aestivum] | diamond | 402 | 50.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 32310744 | 32310744 | PRJEB75227_P_NODE_979_length_815_cov_1.921833_g822_i0 | PRJEB75227 | 979 | 815 | 1.921833 | 15.66293895 | Ambrosia artemisiifolia | 4212 | Plants | Plants | 75.9 | 8.08e-13 | NR | KAI7728624.1 | 4212 | g822 | i0 | 33.9 | 0.456441717791411 | 124 | 70 | 43.4 | 4 | 112 | 465 | 29 | 146 | KAI7728624.1 hypothetical protein M8C21_028663 [Ambrosia artemisiifolia] | diamond | 372 | 75.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Ambrosia | Ambrosia artemisiifolia | |
| 32342287 | 32342287 | PRJEB75227_P_NODE_11499_length_243_cov_0.917647_g11328_i0 | PRJEB75227 | 11499 | 243 | 0.917647 | 2.22988221 | Hordeum vulgare | 4513 | Plants | Plants | 43.1 | 0.0241 | NR | KAI4985129.1 | 4513 | g11328 | i0 | 36.9 | 0.802469135802469 | 65 | 38 | 80.2 | 2 | 25 | 219 | 48 | 109 | KAI4985129.1 hypothetical protein ZWY2020_017759 [Hordeum vulgare] | diamond | 195 | 43.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 32500465 | 32500465 | PRJEB75227_P_NODE_11999_length_228_cov_2.012903_g11828_i0 | PRJEB75227 | 11999 | 228 | 2.012903 | 4.5894188400000004 | Taxus chinensis | 29808 | Plants | Plants | 49.3 | 2.38e-5 | NR | KAH9294277.1 | 29808 | g11828 | i0 | 34.3 | 0.881578947368421 | 67 | 43 | 86.8 | 1 | 202 | 5 | 2 | 68 | KAH9294277.1 hypothetical protein KI387_040519, partial [Taxus chinensis] | diamond | 201 | 49.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Taxaceae | Taxus | Taxus chinensis | |
| 32626428 | 32626428 | PRJEB75227_P_NODE_9880_length_248_cov_0.891429_g9709_i0 | PRJEB75227 | 9880 | 248 | 0.891429 | 2.21074392 | Papaver bracteatum | 215227 | Plants | Plants | 55.5 | 3.53e-7 | NR | KAI3855535.1 | 215227 | g9709 | i0 | 38.7 | 0.907258064516129 | 75 | 46 | 90.7 | 0 | 247 | 23 | 88 | 162 | KAI3855535.1 hypothetical protein MKX03_006573 [Papaver bracteatum] | diamond | 225 | 55.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ranunculales | Papaveraceae | Papaver | Papaver bracteatum | |
| 32846864 | 32846864 | PRJEB75227_P_NODE_11120_length_244_cov_0.912281_g10949_i0 | PRJEB75227 | 11120 | 244 | 0.912281 | 2.22596564 | Impatiens glandulifera | 253017 | Plants | Plants | 47 | 2.61e-4 | NR | XP_047331282.1 | 253017 | g10949 | i0 | 39.6 | 0.651639344262295 | 53 | 32 | 65.2 | 0 | 211 | 53 | 4 | 56 | XP_047331282.1 uncharacterized protein LOC124934825 [Impatiens glandulifera] | diamond | 159 | 47 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Balsaminaceae | Impatiens | Impatiens glandulifera |
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);;