contig_metadata
24 rows where analysis = "diamond" and bioproject = "PRJNA242641"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4194529 | 4194529 | PRJNA242641_S_NODE_1664_length_179_cov_3.406667_g1636_i0 | PRJNA242641 | 1664 | 179 | 3.406667 | 6.09793393 | root | 1 | Root_unresolved | Root_unresolved | 84.7 | 1e-19 | NR | MBO8630984.1 | 1280 | g1636 | i0 | 79.7 | 6.90502793296089 | 59 | 12 | 98.9 | 0 | 179 | 3 | 17 | 75 | MBO8630984.1 hypothetical protein [Staphylococcus aureus] | diamond | 1236 | 85.5 | 0.990643274853801 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Staphylococcus | Staphylococcus aureus | ||
| 22044014 | 22044014 | PRJNA242641_S_NODE_1618_length_182_cov_2.163399_g1590_i0 | PRJNA242641 | 1618 | 182 | 2.163399 | 3.93738618 | Macadamia integrifolia | 60698 | Plants | Plants | 94.4 | 7.06e-22 | NR | XP_042482877.1 | 60698 | g1590 | i0 | 78 | 1.92857142857143 | 59 | 13 | 97.3 | 0 | 4 | 180 | 119 | 177 | XP_042482877.1 bidirectional sugar transporter SWEET4-like [Macadamia integrifolia] | diamond | 351 | 94.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Proteales | Proteaceae | Macadamia | Macadamia integrifolia | |
| 23319488 | 23319488 | PRJNA242641_S_NODE_39_length_973_cov_9.208686_g34_i0 | PRJNA242641 | 39 | 973 | 9.208686 | 89.60051478 | Ralstonia pickettii OR214 | 1264675 | Bacteria | Bacteria | 451 | 3.04e-154 | NR | ENZ77661.1 | 1264675 | g34 | i0 | 95.7 | 0.724563206577595 | 235 | 10 | 72.5 | 0 | 229 | 933 | 1 | 235 | ENZ77661.1 hypothetical protein OR214_02664 [Ralstonia pickettii OR214] | diamond | 705 | 451 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Ralstonia | Ralstonia pickettii | ||
| 27786888 | 27786888 | PRJNA242641_S_NODE_2384_length_152_cov_2.926829_g2356_i0 | PRJNA242641 | 2384 | 152 | 2.926829 | 4.44878008 | Eukaryota | 2759 | Plants | Plants | 98.2 | 4.539999999999999e-23 | NR | KRH10324.2 | 3847 | g2356 | i0 | 98 | 55.1447368421053 | 49 | 1 | 96.7 | 0 | 1 | 147 | 226 | 274 | KRH10324.2 hypothetical protein GLYMA_15G042100v4 [Glycine max] | diamond | 8382 | 98.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine max | |
| 27832054 | 27832054 | PRJNA242641_S_NODE_1824_length_172_cov_1.909091_g1796_i0 | PRJNA242641 | 1824 | 172 | 1.909091 | 3.28363652 | Cinnamomum micranthum f. kanehirae | 337451 | Plants | Plants | 119 | 4.75e-32 | NR | RWR87517.1 | 337451 | g1796 | i0 | 94.7 | 0.994186046511628 | 57 | 3 | 99.4 | 0 | 171 | 1 | 126 | 182 | RWR87517.1 hypothetical protein CKAN_01646200 [Cinnamomum micranthum f. kanehirae] | diamond | 171 | 119 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Laurales | Lauraceae | Cinnamomum | Cinnamomum micranthum | |
| 27863592 | 27863592 | PRJNA242641_S_NODE_1805_length_173_cov_2.263889_g1777_i0 | PRJNA242641 | 1805 | 173 | 2.263889 | 3.91652797 | Morus notabilis | 981085 | Plants | Plants | 60.8 | 9.46e-10 | NR | EXB22120.1 | 981085 | g1777 | i0 | 51.7 | 7.47398843930636 | 58 | 25 | 95.4 | 1 | 170 | 6 | 9 | 66 | EXB22120.1 hypothetical protein L484_002434 [Morus notabilis] | diamond | 1293 | 60.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Moraceae | Morus | Morus notabilis | |
| 27863593 | 27863593 | PRJNA242641_S_NODE_2425_length_151_cov_3.049180_g2397_i0 | PRJNA242641 | 2425 | 151 | 3.04918 | 4.6042618 | Nyssa sinensis | 561372 | Plants | Plants | 55.1 | 3.11e-7 | NR | KAA8548089.1 | 561372 | g2397 | i0 | 79.3 | 0.576158940397351 | 29 | 6 | 57.6 | 0 | 3 | 89 | 204 | 232 | KAA8548089.1 hypothetical protein F0562_004650 [Nyssa sinensis] | diamond | 87 | 55.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cornales | Nyssaceae | Nyssa | Nyssa sinensis | |
| 28116175 | 28116175 | PRJNA242641_S_NODE_865_length_247_cov_2.564220_g837_i0 | PRJNA242641 | 865 | 247 | 2.56422 | 6.3336234 | Cinnamomum micranthum f. kanehirae | 337451 | Plants | Plants | 137 | 7.46e-38 | NR | RWR90609.1 | 337451 | g837 | i0 | 98.4 | 0.765182186234818 | 63 | 1 | 76.5 | 0 | 2 | 190 | 234 | 296 | RWR90609.1 class I chitinase [Cinnamomum micranthum f. kanehirae] | diamond | 189 | 137 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Laurales | Lauraceae | Cinnamomum | Cinnamomum micranthum | |
| 28147993 | 28147993 | PRJNA242641_S_NODE_2385_length_152_cov_2.731707_g2357_i0 | PRJNA242641 | 2385 | 152 | 2.731707 | 4.15219464 | Coptis chinensis | 261450 | Plants | Plants | 41.2 | 0.00899 | NR | KAF9609808.1 | 261450 | g2357 | i0 | 52.4 | 2.76315789473684 | 42 | 20 | 82.9 | 0 | 128 | 3 | 25 | 66 | KAF9609808.1 hypothetical protein IFM89_018662 [Coptis chinensis] | diamond | 420 | 41.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ranunculales | Ranunculaceae | Coptis | Coptis chinensis | |
| 28305698 | 28305698 | PRJNA242641_S_NODE_2466_length_150_cov_2.347107_g2438_i0 | PRJNA242641 | 2466 | 150 | 2.347107 | 3.5206605 | Cinnamomum micranthum f. kanehirae | 337451 | Plants | Plants | 83.2 | 4.41e-18 | NR | RWR87517.1 | 337451 | g2438 | i0 | 89.8 | 0.98 | 49 | 5 | 98 | 0 | 3 | 149 | 67 | 115 | RWR87517.1 hypothetical protein CKAN_01646200 [Cinnamomum micranthum f. kanehirae] | diamond | 147 | 83.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Laurales | Lauraceae | Cinnamomum | Cinnamomum micranthum | |
| 28400448 | 28400448 | PRJNA242641_S_NODE_1966_length_166_cov_4.364964_g1938_i0 | PRJNA242641 | 1966 | 166 | 4.364964 | 7.24584024 | Paracoccus spongiarum | 3064387 | Bacteria | Bacteria | 42.7 | 0.00584 | NR | WP_305962362.1 | 3064387 | g1938 | i0 | 45.7 | 0.831325301204819 | 46 | 25 | 83.1 | 0 | 22 | 159 | 53 | 98 | WP_305962362.1 YraN family protein [Paracoccus spongiarum] | diamond | 138 | 42.7 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Alphaproteobacteria | Rhodobacterales | Paracoccaceae | Paracoccus | Paracoccus spongiarum | ||
| 28873992 | 28873992 | PRJNA242641_S_NODE_2348_length_153_cov_2.306452_g2320_i0 | PRJNA242641 | 2348 | 153 | 2.306452 | 3.52887156 | Macadamia integrifolia | 60698 | Plants | Plants | 73.9 | 7.5e-15 | NR | XP_042492697.1 | 60698 | g2320 | i0 | 64 | 2.86274509803922 | 50 | 18 | 98 | 0 | 3 | 152 | 37 | 86 | XP_042492697.1 anther-specific protein LAT52-like [Macadamia integrifolia] | diamond | 438 | 73.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Proteales | Proteaceae | Macadamia | Macadamia integrifolia | |
| 29473682 | 29473682 | PRJNA242641_S_NODE_2450_length_150_cov_6.694215_g2422_i0 | PRJNA242641 | 2450 | 150 | 6.694215 | 10.0413225 | Ralstonia solanacearum | 305 | Bacteria | Bacteria | 79 | 1.35e-15 | NR | WP_064297723.1 | 305 | g2422 | i0 | 71.4 | 0.98 | 49 | 14 | 98 | 0 | 148 | 2 | 171 | 219 | WP_064297723.1 zonular occludens toxin domain-containing protein [Ralstonia solanacearum] | diamond | 147 | 79 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Ralstonia | Ralstonia solanacearum | ||
| 29870614 | 29870614 | PRJNA242641_S_NODE_431_length_356_cov_5.113150_g403_i0 | PRJNA242641 | 431 | 356 | 5.11315 | 18.202814 | Magnoliopsida | 3398 | Plants | Plants | 75.1 | 2.71e-15 | NR | XP_011033291.1 | 75702 | g403 | i0 | 69 | 3.93539325842697 | 58 | 18 | 48.9 | 0 | 268 | 95 | 1 | 58 | XP_011033291.1 PREDICTED: arabinogalactan peptide 23-like [Populus euphratica] | diamond | 1401 | 75.5 | 0.994701986754967 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Populus | Populus euphratica | |
| 30439493 | 30439493 | PRJNA242641_S_NODE_333_length_397_cov_4.236413_g305_i0 | PRJNA242641 | 333 | 397 | 4.236413 | 16.81855961 | Escallonia | 23075 | Plants | Plants | 75.1 | 2.75e-13 | NR | KAK2977287.1 | 112253 | g305 | i0 | 50 | 1.05793450881612 | 70 | 35 | 52.9 | 0 | 319 | 110 | 154 | 223 | KAK2977287.1 hypothetical protein RJ640_013052 [Escallonia rubra] | diamond | 420 | 75.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Escalloniales | Escalloniaceae | Escallonia | Escallonia rubra | |
| 30723594 | 30723594 | PRJNA242641_S_NODE_1914_length_168_cov_2.604317_g1886_i0 | PRJNA242641 | 1914 | 168 | 2.604317 | 4.37525256 | Ralstonia | 48736 | Bacteria | Bacteria | 120 | 6.299999999999999e-31 | NR | WP_296360505.1 | 54061 | g1886 | i0 | 98.2 | 2 | 56 | 1 | 100 | 0 | 1 | 168 | 74 | 129 | WP_296360505.1 zonular occludens toxin domain-containing protein [Ralstonia sp.] | diamond | 336 | 120 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Ralstonia | Ralstonia sp. | ||
| 31021900 | 31021900 | PRJNA242641_S_NODE_715_length_272_cov_3.144033_g687_i0 | PRJNA242641 | 715 | 272 | 3.144033 | 8.5517697600000009 | Tripterygium wilfordii | 458696 | Plants | Plants | 80.9 | 6.93e-18 | NR | KAF5736885.1 | 458696 | g687 | i0 | 51.4 | 0.772058823529412 | 70 | 33 | 77.2 | 1 | 8 | 217 | 1 | 69 | KAF5736885.1 hypothetical protein HS088_TW14G01040 [Tripterygium wilfordii] | diamond | 210 | 80.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Celastrales | Celastraceae | Tripterygium | Tripterygium wilfordii | |
| 31798301 | 31798301 | PRJNA242641_S_NODE_617_length_293_cov_2.890152_g589_i0 | PRJNA242641 | 617 | 293 | 2.890152 | 8.46814536 | Magnoliopsida | 3398 | Plants | Plants | 41.6 | 0.032 | NR | CAN75584.1 | 29760 | g589 | i0 | 50 | 0.614334470989761 | 32 | 16 | 32.8 | 0 | 291 | 196 | 36 | 67 | CAN75584.1 hypothetical protein VITISV_017139 [Vitis vinifera] | diamond | 180 | 41.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Vitales | Vitaceae | Vitis | Vitis vinifera | |
| 32065440 | 32065440 | PRJNA242641_S_NODE_418_length_360_cov_5.253776_g390_i0 | PRJNA242641 | 418 | 360 | 5.253776 | 18.9135936 | Escallonia herrerae | 1293975 | Plants | Plants | 72 | 1.88e-13 | NR | KAK3024565.1 | 1293975 | g390 | i0 | 48.6 | 1.16666666666667 | 70 | 36 | 58.3 | 0 | 79 | 288 | 23 | 92 | KAK3024565.1 hypothetical protein RJ639_043505 [Escallonia herrerae] | diamond | 420 | 72 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Escalloniales | Escalloniaceae | Escallonia | Escallonia herrerae | |
| 32192154 | 32192154 | PRJNA242641_S_NODE_998_length_231_cov_7.806931_g970_i0 | PRJNA242641 | 998 | 231 | 7.806931 | 18.03401061 | uncultured Ralstonia sp. | 114715 | Bacteria | Bacteria | 45.8 | 2.76e-4 | NR | WP_298938061.1 | 114715 | g970 | i0 | 60 | 0.779220779220779 | 60 | 19 | 77.9 | 2 | 50 | 229 | 1 | 55 | WP_298938061.1 major capsid protein [uncultured Ralstonia sp.] | diamond | 180 | 45.8 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Burkholderiaceae | Ralstonia | uncultured Ralstonia sp. | ||
| 32287308 | 32287308 | PRJNA242641_S_NODE_2039_length_163_cov_3.171642_g2011_i0 | PRJNA242641 | 2039 | 163 | 3.171642 | 5.16977646 | Papaver bracteatum | 215227 | Plants | Plants | 65.5 | 2.44e-12 | NR | KAI3845845.1 | 215227 | g2011 | i0 | 74.4 | 1.58282208588957 | 43 | 11 | 79.1 | 0 | 34 | 162 | 1 | 43 | KAI3845845.1 hypothetical protein MKX03_033294 [Papaver bracteatum] | diamond | 258 | 65.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ranunculales | Papaveraceae | Papaver | Papaver bracteatum | |
| 32445433 | 32445433 | PRJNA242641_S_NODE_1599_length_183_cov_1.636364_g1571_i0 | PRJNA242641 | 1599 | 183 | 1.636364 | 2.99454612 | Striga hermonthica | 68872 | Plants | Plants | 54.7 | 2.65e-7 | NR | CAA0812701.1 | 68872 | g1571 | i0 | 59.1 | 2.65573770491803 | 44 | 18 | 72.1 | 0 | 133 | 2 | 109 | 152 | CAA0812701.1 Late Embryogenesis Abundant 4-5 [Striga hermonthica] | diamond | 486 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Orobanchaceae | Striga | Striga hermonthica | |
| 32540356 | 32540356 | PRJNA242641_S_NODE_1979_length_166_cov_1.678832_g1951_i0 | PRJNA242641 | 1979 | 166 | 1.678832 | 2.78686112 | Nelumbo nucifera | 4432 | Plants | Plants | 94.7 | 1.24e-22 | NR | XP_019053519.1 | 4432 | g1951 | i0 | 77.8 | 4.87951807228916 | 54 | 12 | 97.6 | 0 | 3 | 164 | 36 | 89 | XP_019053519.1 PREDICTED: pre-rRNA-processing protein TSR2 homolog isoform X1 [Nelumbo nucifera] | diamond | 810 | 94.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Proteales | Nelumbonaceae | Nelumbo | Nelumbo nucifera | |
| 32666123 | 32666123 | PRJNA242641_S_NODE_1820_length_172_cov_3.034965_g1792_i0 | PRJNA242641 | 1820 | 172 | 3.034965 | 5.2201398 | Tetracentron sinense | 13715 | Plants | Plants | 49.3 | 6.46e-5 | NR | KAF8408881.1 | 13715 | g1792 | i0 | 50 | 0.802325581395349 | 46 | 23 | 80.2 | 0 | 171 | 34 | 7 | 52 | KAF8408881.1 hypothetical protein HHK36_004950 [Tetracentron sinense] | diamond | 138 | 49.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Trochodendrales | Trochodendraceae | Tetracentron | Tetracentron sinense |
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);;