contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA1111082" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10418805 | 10418805 | PRJNA1111082_P_NODE_3549_length_409_cov_1.860119_g3504_i0 | PRJNA1111082 | 3549 | 409 | 1.860119 | 7.60788671 | Cichorium endivia | 114280 | Plants | Plants | 143 | 7.799999999999998e-39 | NR | KAI3485524.1 | 114280 | g3504 | i0 | 96.2 | 0.572127139364303 | 78 | 3 | 57.2 | 0 | 235 | 2 | 1 | 78 | KAI3485524.1 hypothetical protein L1887_51145 [Cichorium endivia] | diamond | 234 | 143 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Cichorium | Cichorium endivia | |
| 11693937 | 11693937 | PRJNA1111082_P_NODE_2030_length_517_cov_2.842342_g1985_i0 | PRJNA1111082 | 2030 | 517 | 2.842342 | 14.69490814 | Cryptomeria japonica | 3369 | Plants | Plants | 150 | 1.71e-41 | NR | XP_059064750.1 | 3369 | g1985 | i0 | 56.4 | 4.07350096711799 | 133 | 58 | 77.2 | 0 | 5 | 403 | 144 | 276 | XP_059064750.1 uncharacterized protein LOC131856829 [Cryptomeria japonica] | diamond | 2106 | 150 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 15517884 | 15517884 | PRJNA1111082_P_NODE_1733_length_551_cov_0.907950_g1688_i0 | PRJNA1111082 | 1733 | 551 | 0.90795 | 5.0028045 | Physcomitrium patens | 3218 | Plants | Plants | 236 | 2.6e-75 | NR | XP_024388543.1 | 3218 | g1688 | i0 | 83 | 0.767695099818512 | 141 | 23 | 76.8 | 1 | 425 | 3 | 1 | 140 | XP_024388543.1 chlorophyll a-b binding protein CP24 10A, chloroplastic-like [Physcomitrium patens] | diamond | 423 | 236 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Funariales | Funariaceae | Physcomitrium | Physcomitrium patens | |
| 18066972 | 18066972 | PRJNA1111082_P_NODE_35_length_1800_cov_3.204980_g29_i0 | PRJNA1111082 | 35 | 1800 | 3.20498 | 57.68964 | Cryptomeria japonica | 3369 | Plants | Plants | 181 | 1.09e-45 | NR | GLJ24250.1 | 3369 | g29 | i0 | 51.5 | 2.195 | 167 | 78 | 27.8 | 1 | 586 | 1086 | 312 | 475 | GLJ24250.1 hypothetical protein SUGI_0462370 [Cryptomeria japonica] | diamond | 3951 | 181 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 26846521 | 26846521 | PRJNA1111082_P_NODE_3461_length_414_cov_0.865103_g3416_i0 | PRJNA1111082 | 3461 | 414 | 0.865103 | 3.58152642 | Ceratodon purpureus | 3225 | Plants | Plants | 223 | 1.39e-69 | NR | KAG0602598.1 | 3225 | g3416 | i0 | 77.5 | 3.98550724637681 | 138 | 31 | 100 | 0 | 414 | 1 | 93 | 230 | KAG0602598.1 hypothetical protein M758_10G026000 [Ceratodon purpureus] | diamond | 1650 | 223 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Pseudoditrichales | Ditrichaceae | Ceratodon | Ceratodon purpureus | |
| 27004411 | 27004411 | PRJNA1111082_P_NODE_9822_length_259_cov_2.311828_g9777_i0 | PRJNA1111082 | 9822 | 259 | 2.311828 | 5.98763452 | Cryptomeria japonica | 3369 | Plants | Plants | 105 | 7.2399999999999995e-28 | NR | GLJ13794.1 | 3369 | g9777 | i0 | 85 | 0.694980694980695 | 60 | 9 | 69.5 | 0 | 67 | 246 | 1 | 60 | GLJ13794.1 hypothetical protein SUGI_0220180 [Cryptomeria japonica] | diamond | 180 | 105 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 27067676 | 27067676 | PRJNA1111082_P_NODE_1382_length_597_cov_4.690840_g1337_i0 | PRJNA1111082 | 1382 | 597 | 4.69084 | 28.0043148 | Cryptomeria japonica | 3369 | Plants | Plants | 80.9 | 3.09e-14 | NR | GLJ10983.1 | 3369 | g1337 | i0 | 74.5 | 0.708542713567839 | 47 | 12 | 23.6 | 0 | 495 | 355 | 279 | 325 | GLJ10983.1 hypothetical protein SUGI_0139510 [Cryptomeria japonica] | diamond | 423 | 80.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 27162392 | 27162392 | PRJNA1111082_P_NODE_202_length_1149_cov_7.690520_g178_i0 | PRJNA1111082 | 202 | 1149 | 7.69052 | 88.3640748 | Cryptomeria japonica | 3369 | Plants | Plants | 284 | 1.46e-85 | NR | XP_059078007.1 | 3369 | g178 | i0 | 47.7 | 0.869451697127937 | 333 | 162 | 85.4 | 5 | 164 | 1144 | 9 | 335 | XP_059078007.1 uncharacterized protein LOC131876587 [Cryptomeria japonica] | diamond | 999 | 284 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 27289020 | 27289020 | PRJNA1111082_P_NODE_11683_length_246_cov_1.803468_g11638_i0 | PRJNA1111082 | 11683 | 246 | 1.803468 | 4.43653128 | Helianthus annuus | 4232 | Plants | Plants | 43.1 | 0.0246 | NR | KAJ0712330.1 | 4232 | g11638 | i0 | 36.4 | 0.670731707317073 | 55 | 33 | 64.6 | 1 | 22 | 180 | 56 | 110 | KAJ0712330.1 putative transcription factor interactor and regulator CCHC(Zn) family [Helianthus annuus] | diamond | 165 | 43.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Helianthus | Helianthus annuus | |
| 27383963 | 27383963 | PRJNA1111082_P_NODE_3623_length_405_cov_2.972892_g3578_i0 | PRJNA1111082 | 3623 | 405 | 2.972892 | 12.0402126 | Chamaecyparis obtusa | 13415 | Plants | Plants | 85.1 | 3.13e-16 | NR | Q7M1E7.1 | 13415 | g3578 | i0 | 54.4 | 0.888888888888889 | 57 | 26 | 42.2 | 0 | 153 | 323 | 458 | 514 | Q7M1E7.1 RecName: Full=Polygalacturonase; Short=PG; AltName: Full=Major pollen allergen Cha o 2; AltName: Full=Pectinase; AltName: Allergen=Cha o 2; Flags: Precursor [Chamaecyparis obtusa] | diamond | 360 | 85.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Chamaecyparis | Chamaecyparis obtusa | |
| 27383968 | 27383968 | PRJNA1111082_P_NODE_903_length_704_cov_5.147385_g860_i0 | PRJNA1111082 | 903 | 704 | 5.147385 | 36.2375904 | Cryptomeria japonica | 3369 | Plants | Plants | 214 | 2e-67 | NR | XP_059069601.1 | 3369 | g860 | i0 | 83.8 | 0.553977272727273 | 130 | 21 | 55.4 | 0 | 143 | 532 | 1 | 130 | XP_059069601.1 uncharacterized protein LOC131029362 [Cryptomeria japonica] | diamond | 390 | 214 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 27541777 | 27541777 | PRJNA1111082_P_NODE_204_length_1148_cov_3.435349_g180_i0 | PRJNA1111082 | 204 | 1148 | 3.435349 | 39.43780652 | Vigna unguiculata | 3917 | Plants | Plants | 101 | 8.24e-20 | NR | XP_027916089.1 | 3917 | g180 | i0 | 49.6 | 0.977351916376307 | 123 | 53 | 30.1 | 4 | 753 | 409 | 246 | 367 | XP_027916089.1 putative nuclease HARBI1 [Vigna unguiculata] | diamond | 1122 | 101 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Vigna | Vigna unguiculata | |
| 28204587 | 28204587 | PRJNA1111082_P_NODE_10946_length_250_cov_0.881356_g10901_i0 | PRJNA1111082 | 10946 | 250 | 0.881356 | 2.20339 | Physcomitrium patens | 3218 | Plants | Plants | 89.4 | 1.62e-18 | NR | XP_024370345.1 | 3218 | g10901 | i0 | 60.9 | 0.828 | 69 | 27 | 82.8 | 0 | 208 | 2 | 439 | 507 | XP_024370345.1 uncharacterized protein LOC112279836 [Physcomitrium patens] | diamond | 207 | 89.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Funariales | Funariaceae | Physcomitrium | Physcomitrium patens | |
| 28267757 | 28267757 | PRJNA1111082_P_NODE_6_length_2760_cov_4.011537_g4_i0 | PRJNA1111082 | 6 | 2760 | 4.011537 | 110.7184212 | Cryptomeria japonica | 3369 | Plants | Plants | 99 | 5.33e-18 | NR | XP_057828258.1 | 3369 | g4 | i0 | 42.2 | 0.118478260869565 | 109 | 63 | 11.8 | 0 | 2354 | 2680 | 238 | 346 | XP_057828258.1 uncharacterized protein LOC131039491 [Cryptomeria japonica] | diamond | 327 | 99 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 28362518 | 28362518 | PRJNA1111082_P_NODE_10786_length_251_cov_0.876404_g10741_i0 | PRJNA1111082 | 10786 | 251 | 0.876404 | 2.19977404 | Ilex paraguariensis | 185542 | Plants | Plants | 111 | 1.93e-26 | NR | CAK9170777.1 | 185542 | g10741 | i0 | 63.9 | 2.8804780876494 | 83 | 30 | 99.2 | 0 | 2 | 250 | 2 | 84 | CAK9170777.1 unnamed protein product, partial [Ilex paraguariensis] | diamond | 723 | 111 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Aquifoliales | Aquifoliaceae | Ilex | Ilex paraguariensis | |
| 29080184 | 29080184 | PRJNA1111082_P_NODE_12408_length_243_cov_0.917647_g12363_i0 | PRJNA1111082 | 12408 | 243 | 0.917647 | 2.22988221 | Orobanchaceae | 91896 | Plants | Plants | 125 | 3.0699999999999996e-31 | NR | KAK6117849.1 | 99300 | g12363 | i0 | 81.7 | 2.02469135802469 | 82 | 14 | 100 | 1 | 243 | 1 | 1251 | 1332 | KAK6117849.1 hypothetical protein DH2020_048412 [Rehmannia glutinosa] | diamond | 492 | 126 | 0.992063492063492 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Orobanchaceae | Rehmannia | Rehmannia glutinosa | |
| 29404633 | 29404633 | PRJNA1111082_P_NODE_109_length_1374_cov_6.690238_g94_i0 | PRJNA1111082 | 109 | 1374 | 6.690238 | 91.92387012 | Cryptomeria japonica | 3369 | Plants | Plants | 198 | 1.6999999999999998e-57 | NR | XP_059067800.1 | 3369 | g94 | i0 | 52.3 | 1.29039301310044 | 197 | 94 | 43 | 0 | 1354 | 764 | 1 | 197 | XP_059067800.1 uncharacterized protein LOC131858543 [Cryptomeria japonica] | diamond | 1773 | 198 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 29995993 | 29995993 | PRJNA1111082_P_NODE_11151_length_249_cov_0.886364_g11106_i0 | PRJNA1111082 | 11151 | 249 | 0.886364 | 2.20704636 | Bryopsida | 3214 | Plants | Plants | 84.3 | 9.37e-19 | NR | XP_024388540.1 | 3218 | g11106 | i0 | 91.8 | 1.18072289156627 | 49 | 4 | 59 | 0 | 1 | 147 | 77 | 125 | XP_024388540.1 uncharacterized protein LOC112288525 [Physcomitrium patens] | diamond | 294 | 84.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Funariales | Funariaceae | Physcomitrium | Physcomitrium patens | |
| 30225713 | 30225713 | PRJNA1111082_P_NODE_12_length_2275_cov_4.826975_g9_i0 | PRJNA1111082 | 12 | 2275 | 4.826975 | 109.81368125 | Cryptomeria japonica | 3369 | Plants | Plants | 206 | 1.3099999999999995e-55 | NR | XP_057841299.2 | 3369 | g9 | i0 | 50.7 | 0.275604395604396 | 209 | 94 | 26.4 | 1 | 1231 | 632 | 159 | 367 | XP_057841299.2 uncharacterized protein LOC131050994 [Cryptomeria japonica] | diamond | 627 | 206 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 30289323 | 30289323 | PRJNA1111082_P_NODE_10692_length_251_cov_1.842697_g10647_i0 | PRJNA1111082 | 10692 | 251 | 1.842697 | 4.62516947 | Cryptomeria japonica | 3369 | Plants | Plants | 57.4 | 1.61e-7 | NR | GLJ49602.1 | 3369 | g10647 | i0 | 79.4 | 1.62549800796813 | 34 | 7 | 40.6 | 0 | 66 | 167 | 180 | 213 | GLJ49602.1 hypothetical protein SUGI_1052380 [Cryptomeria japonica] | diamond | 408 | 57.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 30415663 | 30415663 | PRJNA1111082_P_NODE_73_length_1546_cov_4.747454_g61_i0 | PRJNA1111082 | 73 | 1546 | 4.747454 | 73.39563884 | Taxus chinensis | 29808 | Plants | Plants | 114 | 7.91e-23 | NR | KAH9292214.1 | 29808 | g61 | i0 | 41.4 | 0.327943078913325 | 169 | 98 | 32.6 | 1 | 690 | 1193 | 79 | 247 | KAH9292214.1 hypothetical protein KI387_042602, partial [Taxus chinensis] | diamond | 507 | 114 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Taxaceae | Taxus | Taxus chinensis | |
| 30447094 | 30447094 | PRJNA1111082_P_NODE_2113_length_508_cov_2.726437_g2068_i0 | PRJNA1111082 | 2113 | 508 | 2.7264370000000002 | 13.85029996 | Cryptomeria japonica | 3369 | Plants | Plants | 107 | 5.0700000000000006e-27 | NR | GLJ43965.1 | 3369 | g2068 | i0 | 88.3 | 0.708661417322835 | 60 | 7 | 35.4 | 0 | 2 | 181 | 24 | 83 | GLJ43965.1 hypothetical protein SUGI_0916580 [Cryptomeria japonica] | diamond | 360 | 107 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 30921046 | 30921046 | PRJNA1111082_P_NODE_4134_length_384_cov_1.212219_g4089_i0 | PRJNA1111082 | 4134 | 384 | 1.212219 | 4.65492096 | Nepenthes gracilis | 150966 | Plants | Plants | 68.2 | 3.67e-11 | NR | GMH25999.1 | 150966 | g4089 | i0 | 58.5 | 2.5390625 | 53 | 22 | 41.4 | 0 | 311 | 153 | 32 | 84 | GMH25999.1 hypothetical protein Nepgr_027842 [Nepenthes gracilis] | diamond | 975 | 68.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Nepenthaceae | Nepenthes | Nepenthes gracilis | |
| 31901067 | 31901067 | PRJNA1111082_P_NODE_2737_length_459_cov_4.033679_g2692_i0 | PRJNA1111082 | 2737 | 459 | 4.033679 | 18.51458661 | Cryptomeria japonica | 3369 | Plants | Plants | 72.8 | 1.23e-13 | NR | GLJ05318.1 | 3369 | g2692 | i0 | 59.5 | 0.516339869281046 | 79 | 30 | 51.6 | 2 | 237 | 1 | 5 | 81 | GLJ05318.1 hypothetical protein SUGI_0015930 [Cryptomeria japonica] | diamond | 237 | 72.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 32375807 | 32375807 | PRJNA1111082_P_NODE_2279_length_493_cov_2.895238_g2234_i0 | PRJNA1111082 | 2279 | 493 | 2.895238 | 14.27352334 | Cryptomeria japonica | 3369 | Plants | Plants | 82.4 | 1.71e-17 | NR | GLJ18978.1 | 3369 | g2234 | i0 | 65.1 | 0.383367139959432 | 63 | 21 | 37.7 | 1 | 105 | 290 | 1 | 63 | GLJ18978.1 hypothetical protein SUGI_0339310 [Cryptomeria japonica] | diamond | 189 | 82.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 32470823 | 32470823 | PRJNA1111082_P_NODE_1379_length_598_cov_4.156190_g1334_i0 | PRJNA1111082 | 1379 | 598 | 4.15619 | 24.8540162 | Cryptomeria japonica | 3369 | Plants | Plants | 159 | 1.87e-46 | NR | XP_057829398.1 | 3369 | g1334 | i0 | 70.9 | 0.58695652173913 | 117 | 32 | 57.7 | 1 | 57 | 401 | 1 | 117 | XP_057829398.1 uncharacterized protein LOC131040477 [Cryptomeria japonica] | diamond | 351 | 159 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica |
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);;