contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA404067" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1689243 | 1689243 | PRJNA404067_P_NODE_13582_length_283_cov_1.927928_g13195_i0 | PRJNA404067 | 13582 | 283 | 1.927928 | 5.45603624 | Nicotiana sylvestris | 4096 | Plants | Plants | 136 | 2.08e-35 | NR | XP_070002786.1 | 4096 | g13195 | i0 | 71.4 | 1.92932862190813 | 91 | 26 | 96.5 | 0 | 283 | 11 | 344 | 434 | XP_070002786.1 uncharacterized protein [Nicotiana sylvestris] | diamond | 546 | 136 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Nicotiana | Nicotiana sylvestris | |
| 9343023 | 9343023 | PRJNA404067_P_NODE_41048_length_192_cov_3.580153_g40661_i0 | PRJNA404067 | 41048 | 192 | 3.580153 | 6.87389376 | Phtheirospermum japonicum | 374723 | Plants | Plants | 77.4 | 1.07e-14 | NR | GFP82576.1 | 374723 | g40661 | i0 | 66 | 8.578125 | 50 | 17 | 78.1 | 0 | 3 | 152 | 307 | 356 | GFP82576.1 cysteine proteinase rd21a [Phtheirospermum japonicum] | diamond | 1647 | 77.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Orobanchaceae | Phtheirospermum | Phtheirospermum japonicum | |
| 26663609 | 26663609 | PRJNA404067_P_NODE_26201_length_220_cov_0.911950_g25814_i0 | PRJNA404067 | 26201 | 220 | 0.91195 | 2.00629 | Rehmannia glutinosa | 99300 | Plants | Plants | 117 | 3.8499999999999996e-31 | NR | KAK6152942.1 | 99300 | g25814 | i0 | 78.1 | 2.98636363636364 | 73 | 16 | 99.5 | 0 | 220 | 2 | 75 | 147 | KAK6152942.1 hypothetical protein DH2020_012581 [Rehmannia glutinosa] | diamond | 657 | 117 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Orobanchaceae | Rehmannia | Rehmannia glutinosa | |
| 26839222 | 26839222 | PRJNA404067_P_NODE_16161_length_258_cov_1.416244_g15774_i0 | PRJNA404067 | 16161 | 258 | 1.416244 | 3.65390952 | Oryza | 4527 | Plants | Plants | 88.6 | 3.36e-18 | NR | CAJ86151.1 | 4530 | g15774 | i0 | 52.9 | 5.90697674418605 | 85 | 37 | 98.8 | 2 | 2 | 256 | 238 | 319 | CAJ86151.1 H0413E07.4 [Oryza sativa] | diamond | 1524 | 88.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 27012114 | 27012114 | PRJNA404067_P_NODE_38862_length_201_cov_0.914286_g38475_i0 | PRJNA404067 | 38862 | 201 | 0.914286 | 1.83771486 | Capsicum annuum | 4072 | Plants | Plants | 48.1 | 2.62e-4 | NR | PHT94165.1 | 4072 | g38475 | i0 | 66.7 | 0.582089552238806 | 39 | 13 | 58.2 | 0 | 201 | 85 | 108 | 146 | PHT94165.1 hypothetical protein T459_02047 [Capsicum annuum] | diamond | 117 | 48.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Capsicum | Capsicum annuum | |
| 27423334 | 27423334 | PRJNA404067_P_NODE_31403_length_209_cov_0.864865_g31016_i0 | PRJNA404067 | 31403 | 209 | 0.864865 | 1.80756785 | Capsicum baccatum | 33114 | Plants | Plants | 46.2 | 7.56e-4 | NR | PHT41175.1 | 33114 | g31016 | i0 | 52 | 0.717703349282297 | 50 | 21 | 67.5 | 2 | 150 | 10 | 1 | 50 | PHT41175.1 Tryptophan synthase alpha chain [Capsicum baccatum] | diamond | 150 | 46.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Capsicum | Capsicum baccatum | |
| 27423335 | 27423335 | PRJNA404067_P_NODE_36543_length_203_cov_0.901408_g36156_i0 | PRJNA404067 | 36543 | 203 | 0.901408 | 1.82985824 | Sphagnum balticum | 128184 | Plants | Plants | 68.6 | 1.74e-12 | NR | CAM6030263.1 | 128184 | g36156 | i0 | 47.3 | 9.07389162561576 | 55 | 29 | 81.3 | 0 | 30 | 194 | 54 | 108 | CAM6030263.1 unnamed protein product [Sphagnum balticum] | diamond | 1842 | 68.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum balticum | |
| 27486248 | 27486248 | PRJNA404067_P_NODE_30003_length_211_cov_1.800000_g29616_i0 | PRJNA404067 | 30003 | 211 | 1.8 | 3.798 | Papaver armeniacum | 357465 | Plants | Plants | 55.8 | 4.21e-8 | NR | KAI3932229.1 | 357465 | g29616 | i0 | 58.5 | 1.16587677725118 | 41 | 17 | 58.3 | 0 | 200 | 78 | 20 | 60 | KAI3932229.1 hypothetical protein MKW92_021572, partial [Papaver armeniacum] | diamond | 246 | 55.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ranunculales | Papaveraceae | Papaver | Papaver armeniacum | |
| 27644320 | 27644320 | PRJNA404067_P_NODE_17844_length_246_cov_3.524324_g17457_i0 | PRJNA404067 | 17844 | 246 | 3.524324 | 8.66983704 | Ipomoea nil | 35883 | Plants | Plants | 46.2 | 0.00216 | NR | XP_019177289.1 | 35883 | g17457 | i0 | 40.6 | 1.68292682926829 | 69 | 39 | 84.1 | 1 | 223 | 17 | 238 | 304 | XP_019177289.1 PREDICTED: uncharacterized protein LOC109172566 isoform X2 [Ipomoea nil] | diamond | 414 | 46.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Convolvulaceae | Ipomoea | Ipomoea nil | |
| 28260530 | 28260530 | PRJNA404067_P_NODE_37166_length_202_cov_1.737589_g36779_i0 | PRJNA404067 | 37166 | 202 | 1.737589 | 3.5099297800000002 | Eukaryota | 2759 | Plants | Plants | 93.6 | 4.8700000000000005e-21 | NR | KAF7846358.1 | 360336 | g36779 | i0 | 63.6 | 1.96039603960396 | 66 | 24 | 98 | 0 | 3 | 200 | 226 | 291 | KAF7846358.1 hypothetical protein BT93_L4503 [Corymbia citriodora subsp. variegata] | diamond | 396 | 94 | 0.995744680851064 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Myrtales | Myrtaceae | Corymbia | Corymbia citriodora | |
| 28307183 | 28307183 | PRJNA404067_P_NODE_35906_length_204_cov_0.832168_g35519_i0 | PRJNA404067 | 35906 | 204 | 0.832168 | 1.69762272 | Capsicum chinense | 80379 | Plants | Plants | 96.7 | 2.36e-21 | NR | PHU20002.1 | 80379 | g35519 | i0 | 66.2 | 0.955882352941177 | 65 | 22 | 95.6 | 0 | 204 | 10 | 636 | 700 | PHU20002.1 Serine carboxypeptidase-like 41 [Capsicum chinense] | diamond | 195 | 96.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Capsicum | Capsicum chinense | |
| 28906831 | 28906831 | PRJNA404067_P_NODE_16728_length_254_cov_2.917098_g16341_i0 | PRJNA404067 | 16728 | 254 | 2.917098 | 7.40942892 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 66.6 | 1.63e-10 | NR | BAK00514.1 | 112509 | g16341 | i0 | 66.7 | 0.531496062992126 | 45 | 15 | 53.1 | 0 | 94 | 228 | 556 | 600 | BAK00514.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 135 | 66.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 28970246 | 28970246 | PRJNA404067_P_NODE_32488_length_207_cov_2.321918_g32101_i0 | PRJNA404067 | 32488 | 207 | 2.321918 | 4.80637026 | Capsicum annuum | 4072 | Plants | Plants | 62.4 | 2.76e-9 | NR | XP_047259759.1 | 4072 | g32101 | i0 | 70.7 | 0.594202898550725 | 41 | 12 | 59.4 | 0 | 49 | 171 | 169 | 209 | XP_047259759.1 uncharacterized protein LOC124892528 [Capsicum annuum] | diamond | 123 | 62.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Capsicum | Capsicum annuum | |
| 29002202 | 29002202 | PRJNA404067_P_NODE_13588_length_283_cov_1.572072_g13201_i0 | PRJNA404067 | 13588 | 283 | 1.572072 | 4.44896376 | Iris pallida | 29817 | Plants | Plants | 52 | 3.12e-5 | NR | KAJ6794991.1 | 29817 | g13201 | i0 | 30.4 | 0.837455830388693 | 79 | 55 | 83.7 | 0 | 240 | 4 | 15 | 93 | KAJ6794991.1 Uncharacterized protein M6B38_228785 [Iris pallida] | diamond | 237 | 52 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asparagales | Iridaceae | Iris | Iris pallida | |
| 29980688 | 29980688 | PRJNA404067_P_NODE_16031_length_259_cov_1.565657_g15644_i0 | PRJNA404067 | 16031 | 259 | 1.565657 | 4.05505163 | Stylosanthes scabra | 79078 | Plants | Plants | 63.2 | 1.81e-10 | NR | MED6214258.1 | 79078 | g15644 | i0 | 75 | 0.787644787644788 | 68 | 10 | 70.7 | 2 | 185 | 3 | 1 | 68 | MED6214258.1 hypothetical protein [Stylosanthes scabra] | diamond | 204 | 63.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Stylosanthes | Stylosanthes scabra | |
| 30170076 | 30170076 | PRJNA404067_P_NODE_31492_length_209_cov_0.864865_g31105_i0 | PRJNA404067 | 31492 | 209 | 0.864865 | 1.80756785 | Capsicum baccatum | 33114 | Plants | Plants | 41.2 | 0.0287 | NR | PHT45025.1 | 33114 | g31105 | i0 | 77.3 | 0.315789473684211 | 22 | 5 | 31.6 | 0 | 68 | 3 | 79 | 100 | PHT45025.1 hypothetical protein CQW23_14183 [Capsicum baccatum] | diamond | 66 | 41.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Capsicum | Capsicum baccatum | |
| 30313832 | 30313832 | PRJNA404067_P_NODE_19672_length_238_cov_1.016949_g19285_i0 | PRJNA404067 | 19672 | 238 | 1.016949 | 2.42033862 | root | 1 | Root_unresolved | Root_unresolved | 77.8 | 2.27e-15 | NR | KAH9306585.1 | 29808 | g19285 | i0 | 60.7 | 2.50840336134454 | 61 | 24 | 76.9 | 0 | 32 | 214 | 26 | 86 | KAH9306585.1 hypothetical protein KI387_010989, partial [Taxus chinensis] | diamond | 597 | 77.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Taxaceae | Taxus | Taxus chinensis | |
| 30454922 | 30454922 | PRJNA404067_P_NODE_33073_length_207_cov_0.876712_g32686_i0 | PRJNA404067 | 33073 | 207 | 0.876712 | 1.81479384 | Capsicum baccatum | 33114 | Plants | Plants | 103 | 9.329999999999999e-24 | NR | PHT36454.1 | 33114 | g32686 | i0 | 74.2 | 1.91304347826087 | 66 | 17 | 95.7 | 0 | 2 | 199 | 50 | 115 | PHT36454.1 hypothetical protein CQW23_24154 [Capsicum baccatum] | diamond | 396 | 103 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Capsicum | Capsicum baccatum | |
| 30643986 | 30643986 | PRJNA404067_P_NODE_31693_length_208_cov_2.034014_g31306_i0 | PRJNA404067 | 31693 | 208 | 2.034014 | 4.23074912 | Lolium multiflorum | 4521 | Plants | Plants | 84.3 | 8.13e-18 | NR | KAK1631292.1 | 4521 | g31306 | i0 | 66.2 | 0.9375 | 65 | 22 | 93.8 | 0 | 202 | 8 | 56 | 120 | KAK1631292.1 hypothetical protein QYE76_005607 [Lolium multiflorum] | diamond | 195 | 84.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Lolium | Lolium multiflorum | |
| 30881960 | 30881960 | PRJNA404067_P_NODE_31454_length_209_cov_0.864865_g31067_i0 | PRJNA404067 | 31454 | 209 | 0.864865 | 1.80756785 | Magnoliopsida | 3398 | Plants | Plants | 68.6 | 1.86e-11 | NR | XP_056695478.1 | 3562 | g31067 | i0 | 55.4 | 5.95693779904306 | 65 | 29 | 93.3 | 0 | 195 | 1 | 415 | 479 | XP_056695478.1 uncharacterized protein LOC110779142 [Spinacia oleracea] | diamond | 1245 | 68.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Chenopodiaceae | Spinacia | Spinacia oleracea | |
| 30960175 | 30960175 | PRJNA404067_P_NODE_35474_length_204_cov_0.895105_g35087_i0 | PRJNA404067 | 35474 | 204 | 0.895105 | 1.8260142 | Daucus carota subsp. sativus | 79200 | Plants | Plants | 138 | 3.9999999999999994e-37 | NR | XP_063942867.1 | 79200 | g35087 | i0 | 89.7 | 7.98529411764706 | 68 | 7 | 100 | 0 | 1 | 204 | 322 | 389 | XP_063942867.1 uncharacterized protein LOC135150479 [Daucus carota subsp. sativus] | diamond | 1629 | 138 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Apiales | Apiaceae | Daucus | Daucus carota | |
| 31117835 | 31117835 | PRJNA404067_P_NODE_37955_length_202_cov_0.865248_g37568_i0 | PRJNA404067 | 37955 | 202 | 0.865248 | 1.74780096 | Triticum aestivum | 4565 | Plants | Plants | 62 | 9.06e-10 | NR | XP_044453448.1 | 4565 | g37568 | i0 | 60 | 0.668316831683168 | 45 | 17 | 66.8 | 1 | 66 | 200 | 86 | 129 | XP_044453448.1 rRNA 2'-O-methyltransferase fibrillarin-like [Triticum aestivum] | diamond | 135 | 62 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 31180935 | 31180935 | PRJNA404067_P_NODE_20535_length_235_cov_1.258621_g20148_i0 | PRJNA404067 | 20535 | 235 | 1.258621 | 2.95775935 | Canavalia gladiata | 3824 | Plants | Plants | 55.8 | 3.37e-7 | NR | KAK7344270.1 | 3824 | g20148 | i0 | 74.2 | 1.94042553191489 | 31 | 8 | 39.6 | 0 | 79 | 171 | 163 | 193 | KAK7344270.1 hypothetical protein VNO77_13699 [Canavalia gladiata] | diamond | 456 | 55.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Canavalia | Canavalia gladiata | |
| 31197568 | 31197568 | PRJNA404067_P_NODE_6355_length_495_cov_1.850230_g5979_i0 | PRJNA404067 | 6355 | 495 | 1.85023 | 9.1586385 | root | 1 | Root_unresolved | Root_unresolved | 101 | 1.63e-21 | NR | KAF3673651.1 | 4072 | g5979 | i0 | 67.1 | 1.72121212121212 | 70 | 23 | 42.4 | 0 | 224 | 15 | 965 | 1034 | KAF3673651.1 putative ATP-dependent zinc metalloprotease FtsH-like isoform X1 [Capsicum annuum] | diamond | 852 | 101 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Capsicum | Capsicum annuum | |
| 32604644 | 32604644 | PRJNA404067_P_NODE_29540_length_212_cov_1.675497_g29153_i0 | PRJNA404067 | 29540 | 212 | 1.675497 | 3.55205364 | Capsicum annuum | 4072 | Plants | Plants | 41.2 | 0.0416 | NR | KAF3660030.1 | 4072 | g29153 | i0 | 54.5 | 0.466981132075472 | 33 | 15 | 46.7 | 0 | 187 | 89 | 102 | 134 | KAF3660030.1 hypothetical protein FXO38_12329 [Capsicum annuum] | diamond | 99 | 41.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Capsicum | Capsicum annuum | |
| 32793309 | 32793309 | PRJNA404067_P_NODE_17480_length_249_cov_1.095745_g17093_i0 | PRJNA404067 | 17480 | 249 | 1.095745 | 2.72840505 | Ficus carica | 3494 | Plants | Plants | 68.2 | 4.47e-11 | NR | GMN54865.1 | 3494 | g17093 | i0 | 71.7 | 3.32530120481928 | 46 | 11 | 55.4 | 1 | 140 | 3 | 1466 | 1509 | GMN54865.1 hypothetical protein TIFTF001_023987 [Ficus carica] | diamond | 828 | 68.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Moraceae | Ficus | Ficus carica |
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);;