contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA380660" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6779993 | 6779993 | PRJNA380660_P_NODE_7106_length_273_cov_4.409836_g6706_i0 | PRJNA380660 | 7106 | 273 | 4.409836 | 12.03885228 | Cupressales | 1446379 | Plants | Plants | 115 | 1.0600000000000002e-27 | NR | XP_057874035.2 | 3369 | g6706 | i0 | 66.7 | 1.64835164835165 | 90 | 9 | 98.9 | 1 | 272 | 3 | 120 | 188 | XP_057874035.2 uncharacterized protein LOC131080002 [Cryptomeria japonica] | diamond | 450 | 115 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 7452187 | 7452187 | PRJNA380660_P_NODE_11686_length_175_cov_1.835616_g11286_i0 | PRJNA380660 | 11686 | 175 | 1.835616 | 3.212328 | Eukaryota | 2759 | Plants | Plants | 97.1 | 8.049999999999999e-23 | NR | KAH9624809.1 | 39905 | g11286 | i0 | 77.6 | 28.8342857142857 | 58 | 13 | 99.4 | 0 | 2 | 175 | 89 | 146 | KAH9624809.1 hypothetical protein KSS87_018125 [Heliosperma pusillum] | diamond | 5046 | 97.4 | 0.996919917864476 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Caryophyllaceae | Heliosperma | Heliosperma pusillum | |
| 8726923 | 8726923 | PRJNA380660_P_NODE_10147_length_205_cov_1.500000_g9747_i0 | PRJNA380660 | 10147 | 205 | 1.5 | 3.075 | Eukaryota | 2759 | Plants | Plants | 90.1 | 4.49e-19 | NR | KAF0920702.1 | 110450 | g9747 | i0 | 58.8 | 4.97560975609756 | 68 | 28 | 99.5 | 0 | 205 | 2 | 370 | 437 | KAF0920702.1 hypothetical protein E2562_036405 [Oryza meyeriana var. granulata] | diamond | 1020 | 90.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza meyeriana | |
| 11880933 | 11880933 | PRJNA380660_P_NODE_1730_length_645_cov_2.991883_g1408_i0 | PRJNA380660 | 1730 | 645 | 2.991883 | 19.29764535 | Poaceae | 4479 | Plants | Plants | 197 | 3.8499999999999996e-54 | NR | XP_048549226.1 | 4572 | g1408 | i0 | 54.2 | 34.3720930232558 | 212 | 80 | 95.3 | 7 | 645 | 31 | 1359 | 1560 | XP_048549226.1 DNA-directed RNA polymerase II subunit RPB1-like [Triticum urartu] | diamond | 22170 | 197 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum urartu | |
| 13155985 | 13155985 | PRJNA380660_P_NODE_2511_length_533_cov_2.543651_g2152_i0 | PRJNA380660 | 2511 | 533 | 2.543651 | 13.55765983 | Eukaryota | 2759 | Plants | Plants | 270 | 1.69e-89 | NR | NP_001365641.1 | 3218 | g2152 | i0 | 77.1 | 8.59474671669794 | 170 | 32 | 91.7 | 1 | 42 | 530 | 1 | 170 | NP_001365641.1 60S ribosomal protein L15-1-like [Physcomitrium patens] | diamond | 4581 | 270 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Funariales | Funariaceae | Physcomitrium | Physcomitrium patens | |
| 18253901 | 18253901 | PRJNA380660_P_NODE_5735_length_323_cov_3.051020_g5336_i0 | PRJNA380660 | 5735 | 323 | 3.05102 | 9.8547946 | root | 1 | Root_unresolved | Root_unresolved | 147 | 1.7799999999999994e-42 | NR | BBH03815.1 | 3755 | g5336 | i0 | 78.5 | 60.7430340557276 | 93 | 18 | 84.5 | 1 | 28 | 300 | 66 | 158 | BBH03815.1 SufE/NifU family protein [Prunus dulcis] | diamond | 19620 | 147 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rosaceae | Prunus | Prunus dulcis | |
| 26680421 | 26680421 | PRJNA380660_P_NODE_3481_length_440_cov_4.102190_g3094_i0 | PRJNA380660 | 3481 | 440 | 4.10219 | 18.049636 | Viridiplantae | 33090 | Plants | Plants | 49.7 | 0.00118 | NR | KAI3924665.1 | 357465 | g3094 | i0 | 37.9 | 3.15681818181818 | 95 | 46 | 61.4 | 3 | 5 | 274 | 1106 | 1192 | KAI3924665.1 hypothetical protein MKW92_052550 [Papaver armeniacum] | diamond | 1389 | 49.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ranunculales | Papaveraceae | Papaver | Papaver armeniacum | |
| 27154820 | 27154820 | PRJNA380660_P_NODE_2182_length_573_cov_2.056985_g1841_i0 | PRJNA380660 | 2182 | 573 | 2.056985 | 11.78652405 | Eukaryota | 2759 | Plants | Plants | 88.2 | 3.52e-17 | NR | KAJ7514177.1 | 34168 | g1841 | i0 | 37.4 | 2.59162303664921 | 107 | 66 | 56 | 1 | 4 | 324 | 62 | 167 | KAJ7514177.1 hypothetical protein O6H91_23G031800 [Diphasiastrum complanatum] | diamond | 1485 | 88.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Lycopodiopsida | Lycopodiales | Lycopodiaceae | Diphasiastrum | Diphasiastrum complanatum | |
| 27328008 | 27328008 | PRJNA380660_P_NODE_10983_length_190_cov_1.503106_g10583_i0 | PRJNA380660 | 10983 | 190 | 1.503106 | 2.8559014 | Genlisea aurea | 192259 | Plants | Plants | 85.1 | 2.19e-19 | NR | EPS73337.1 | 192259 | g10583 | i0 | 64.9 | 23.5105263157895 | 57 | 20 | 90 | 0 | 20 | 190 | 45 | 101 | EPS73337.1 hypothetical protein M569_01422, partial [Genlisea aurea] | diamond | 4467 | 85.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Lentibulariaceae | Genlisea | Genlisea aurea | |
| 28797142 | 28797142 | PRJNA380660_P_NODE_6027_length_311_cov_1.833333_g5627_i0 | PRJNA380660 | 6027 | 311 | 1.833333 | 5.70166563 | Eukaryota | 2759 | Plants | Plants | 100 | 5.87e-22 | NR | XP_024188199.1 | 74649 | g5627 | i0 | 54.6 | 19.8617363344051 | 97 | 42 | 93.6 | 2 | 13 | 303 | 23 | 117 | XP_024188199.1 probable ADP-ribosylation factor GTPase-activating protein AGD14 [Rosa chinensis] | diamond | 6177 | 101 | 0.99009900990099 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rosaceae | Rosa | Rosa chinensis | |
| 29159436 | 29159436 | PRJNA380660_P_NODE_1169_length_801_cov_2.913212_g902_i0 | PRJNA380660 | 1169 | 801 | 2.913212 | 23.33482812 | Quercus suber | 58331 | Plants | Plants | 48.1 | 0.0307 | NR | KAK7837842.1 | 58331 | g902 | i0 | 37.8 | 0.277153558052434 | 74 | 44 | 27 | 1 | 583 | 368 | 796 | 869 | KAK7837842.1 regulator of telomere elongation helicase 1 like protein [Quercus suber] | diamond | 222 | 48.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus suber | |
| 29727282 | 29727282 | PRJNA380660_P_NODE_12030_length_168_cov_2.136691_g11630_i0 | PRJNA380660 | 12030 | 168 | 2.136691 | 3.58964088 | Zingiber officinale | 94328 | Plants | Plants | 55.5 | 3.37e-7 | NR | XP_042391489.1 | 94328 | g11630 | i0 | 58.5 | 5.125 | 41 | 17 | 73.2 | 0 | 167 | 45 | 58 | 98 | XP_042391489.1 putative HVA22-like protein g isoform X2 [Zingiber officinale] | diamond | 861 | 55.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Zingiberales | Zingiberaceae | Zingiber | Zingiber officinale | |
| 30313727 | 30313727 | PRJNA380660_P_NODE_12612_length_156_cov_2.078740_g12212_i0 | PRJNA380660 | 12612 | 156 | 2.07874 | 3.2428344 | Streptophyta | 35493 | Plants | Plants | 85.1 | 1.24e-17 | NR | KAG0599366.1 | 3225 | g12212 | i0 | 68.6 | 24.5192307692308 | 51 | 16 | 98.1 | 0 | 3 | 155 | 358 | 408 | KAG0599366.1 hypothetical protein M758_12G146800 [Ceratodon purpureus] | diamond | 3825 | 85.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Pseudoditrichales | Ditrichaceae | Ceratodon | Ceratodon purpureus | |
| 30422976 | 30422976 | PRJNA380660_P_NODE_9813_length_210_cov_2.309392_g9413_i0 | PRJNA380660 | 9813 | 210 | 2.309392 | 4.8497232 | Lithospermum erythrorhizon | 34254 | Plants | Plants | 42.4 | 0.0336 | NR | KAG9139972.1 | 34254 | g9413 | i0 | 40.8 | 0.7 | 49 | 28 | 68.6 | 1 | 28 | 171 | 370 | 418 | KAG9139972.1 hypothetical protein Leryth_010497 [Lithospermum erythrorhizon] | diamond | 147 | 42.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Boraginales | Boraginaceae | Lithospermum | Lithospermum erythrorhizon | |
| 30548900 | 30548900 | PRJNA380660_P_NODE_4013_length_407_cov_2.034392_g3618_i0 | PRJNA380660 | 4013 | 407 | 2.034392 | 8.27997544 | Tripterygium wilfordii | 458696 | Plants | Plants | 97.1 | 4.290000000000001e-21 | NR | XP_038710395.1 | 458696 | g3618 | i0 | 42.3 | 2.97788697788698 | 130 | 45 | 95.1 | 3 | 406 | 20 | 197 | 297 | XP_038710395.1 WD repeat-containing protein VIP3-like [Tripterygium wilfordii] | diamond | 1212 | 97.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Celastrales | Celastraceae | Tripterygium | Tripterygium wilfordii | |
| 31197453 | 31197453 | PRJNA380660_P_NODE_11675_length_175_cov_2.342466_g11275_i0 | PRJNA380660 | 11675 | 175 | 2.342466 | 4.0993155 | Eukaryota | 2759 | Plants | Plants | 103 | 2.65e-24 | NR | XP_030482642.1 | 3483 | g11275 | i0 | 87.3 | 69.8057142857143 | 55 | 7 | 94.3 | 0 | 9 | 173 | 270 | 324 | XP_030482642.1 methionine aminopeptidase 2B isoform X2 [Cannabis sativa] | diamond | 12216 | 103 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Cannabis | Cannabis sativa | |
| 31338899 | 31338899 | PRJNA380660_P_NODE_7856_length_252_cov_1.668161_g7456_i0 | PRJNA380660 | 7856 | 252 | 1.668161 | 4.20376572 | Cryptomeria japonica | 3369 | Plants | Plants | 80.5 | 8.27e-17 | NR | GLJ44752.1 | 3369 | g7456 | i0 | 58.3 | 0.857142857142857 | 72 | 27 | 85.7 | 1 | 221 | 6 | 1 | 69 | GLJ44752.1 hypothetical protein SUGI_0941060 [Cryptomeria japonica] | diamond | 216 | 80.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 31451004 | 31451004 | PRJNA380660_P_NODE_7576_length_260_cov_2.341991_g7176_i0 | PRJNA380660 | 7576 | 260 | 2.341991 | 6.0891766 | Eukaryota | 2759 | Plants | Plants | 47.4 | 8.87e-4 | NR | KAG9143141.1 | 34254 | g7176 | i0 | 40 | 3.11538461538462 | 55 | 32 | 63.5 | 1 | 8 | 172 | 126 | 179 | KAG9143141.1 hypothetical protein Leryth_024161 [Lithospermum erythrorhizon] | diamond | 810 | 47.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Boraginales | Boraginaceae | Lithospermum | Lithospermum erythrorhizon | |
| 32020322 | 32020322 | PRJNA380660_P_NODE_6598_length_291_cov_1.599237_g6198_i0 | PRJNA380660 | 6598 | 291 | 1.599237 | 4.65377967 | root | 1 | Root_unresolved | Root_unresolved | 48.1 | 7.85e-4 | NR | XP_050214808.1 | 3986 | g6198 | i0 | 41.4 | 6.12371134020619 | 58 | 25 | 50.5 | 1 | 251 | 105 | 244 | 301 | XP_050214808.1 RHOMBOID-like protein 1 [Mercurialis annua] | diamond | 1782 | 48.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Euphorbiaceae | Mercurialis | Mercurialis annua | |
| 32146894 | 32146894 | PRJNA380660_P_NODE_8078_length_246_cov_1.949309_g7678_i0 | PRJNA380660 | 8078 | 246 | 1.949309 | 4.79530014 | Eukaryota | 2759 | Plants | Plants | 58.2 | 1.38e-7 | NR | OAY66175.1 | 4615 | g7678 | i0 | 55.6 | 6.70731707317073 | 45 | 20 | 54.9 | 0 | 241 | 107 | 97 | 141 | OAY66175.1 Protein REVEILLE 1 [Ananas comosus] | diamond | 1650 | 58.5 | 0.994871794871795 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Bromeliaceae | Ananas | Ananas comosus | |
| 32446451 | 32446451 | PRJNA380660_P_NODE_799_length_976_cov_4.071806_g594_i0 | PRJNA380660 | 799 | 976 | 4.071806 | 39.74082656 | Amaranthus tricolor | 29722 | Plants | Plants | 71.2 | 1.34e-9 | NR | XP_057535902.1 | 29722 | g594 | i0 | 37.7 | 0.350409836065574 | 114 | 59 | 31.4 | 2 | 671 | 976 | 3 | 116 | XP_057535902.1 importin subunit alpha-like [Amaranthus tricolor] | diamond | 342 | 71.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Amaranthaceae | Amaranthus | Amaranthus tricolor | |
| 32495046 | 32495046 | PRJNA380660_P_NODE_10439_length_200_cov_2.023392_g10039_i0 | PRJNA380660 | 10439 | 200 | 2.023392 | 4.046784 | Magnoliopsida | 3398 | Plants | Plants | 43.9 | 0.00815 | NR | KMZ59149.1 | 29655 | g10039 | i0 | 54.8 | 2.34 | 42 | 19 | 63 | 0 | 198 | 73 | 333 | 374 | KMZ59149.1 COP9 signalosome complex subunit 4, partial [Zostera marina] | diamond | 468 | 43.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Alismatales | Zosteraceae | Zostera | Zostera marina | |
| 32635476 | 32635476 | PRJNA380660_P_NODE_4400_length_385_cov_3.064607_g4004_i0 | PRJNA380660 | 4400 | 385 | 3.064607 | 11.79873695 | Eleusine coracana subsp. coracana | 191504 | Plants | Plants | 67.4 | 3.27e-10 | NR | KAK3166043.1 | 191504 | g4004 | i0 | 33.3 | 3.09350649350649 | 102 | 56 | 76.4 | 3 | 1 | 294 | 243 | 336 | KAK3166043.1 hypothetical protein QOZ80_1AG0040810 [Eleusine coracana subsp. coracana] | diamond | 1191 | 67.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Eleusine | Eleusine coracana |
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);;