contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA773247" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16051538 | 16051538 | PRJNA773247_P_NODE_3133_length_1093_cov_2.636275_g3072_i0 | PRJNA773247 | 3133 | 1093 | 2.636275 | 28.81448575 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 660 | 8.249999999999999e-231 | NR | BAJ97973.1 | 112509 | g3072 | i0 | 89 | 0.999085086916743 | 364 | 40 | 99.9 | 0 | 1093 | 2 | 314 | 677 | BAJ97973.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 1092 | 660 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 21151677 | 21151677 | PRJNA773247_P_NODE_5697_length_730_cov_61.864536_g5617_i0 | PRJNA773247 | 5697 | 730 | 61.864536 | 451.6111128 | Oleaceae | 4144 | Plants | Plants | 420 | 1.48e-142 | NR | KAL2484605.1 | 126358 | g5617 | i0 | 93.6 | 1.67671232876712 | 204 | 13 | 83.8 | 0 | 728 | 117 | 342 | 545 | KAL2484605.1 Pectate lyase family protein [Abeliophyllum distichum] | diamond | 1224 | 423 | 0.99290780141844 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Oleaceae | Abeliophyllum | Abeliophyllum distichum | |
| 26831863 | 26831863 | PRJNA773247_P_NODE_26501_length_271_cov_1.727273_g26417_i0 | PRJNA773247 | 26501 | 271 | 1.727273 | 4.68090983 | Oryza sativa Japonica Group | 39947 | Plants | Plants | 43.5 | 0.0111 | NR | ABA96333.1 | 39947 | g26417 | i0 | 38.3 | 0.664206642066421 | 60 | 35 | 64.2 | 1 | 207 | 34 | 64 | 123 | ABA96333.1 hypothetical protein LOC_Os12g13090 [Oryza sativa Japonica Group] | diamond | 180 | 43.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 27179575 | 27179575 | PRJNA773247_P_NODE_30262_length_251_cov_0.865169_g30178_i0 | PRJNA773247 | 30262 | 251 | 0.865169 | 2.17157419 | Oryza glaberrima | 4538 | Plants | Plants | 57.8 | 2.08e-7 | NR | XP_052151619.1 | 4538 | g30178 | i0 | 66 | 0.633466135458167 | 53 | 15 | 61 | 3 | 97 | 249 | 1 | 52 | XP_052151619.1 wall-associated receptor kinase 2-like [Oryza glaberrima] | diamond | 159 | 57.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza glaberrima | |
| 27685465 | 27685465 | PRJNA773247_P_NODE_24024_length_287_cov_2.411215_g23940_i0 | PRJNA773247 | 24024 | 287 | 2.411215 | 6.92018705 | Triticum urartu | 4572 | Plants | Plants | 171 | 1.69e-51 | NR | XP_048545710.1 | 4572 | g23940 | i0 | 88.4 | 1.98606271777003 | 95 | 11 | 99.3 | 0 | 285 | 1 | 82 | 176 | XP_048545710.1 uncharacterized protein LOC125524713 [Triticum urartu] | diamond | 570 | 171 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum urartu | |
| 27937821 | 27937821 | PRJNA773247_P_NODE_12525_length_430_cov_50.551821_g12442_i0 | PRJNA773247 | 12525 | 430 | 50.551821 | 217.3728303 | Corymbia citriodora subsp. variegata | 360336 | Plants | Plants | 181 | 1.52e-53 | NR | KAF7846358.1 | 360336 | g12442 | i0 | 66.9 | 2.54651162790698 | 121 | 40 | 84.4 | 0 | 430 | 68 | 182 | 302 | KAF7846358.1 hypothetical protein BT93_L4503 [Corymbia citriodora subsp. variegata] | diamond | 1095 | 181 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Myrtales | Myrtaceae | Corymbia | Corymbia citriodora | |
| 27969261 | 27969261 | PRJNA773247_P_NODE_10045_length_496_cov_12.042553_g9962_i0 | PRJNA773247 | 10045 | 496 | 12.042553 | 59.73106288 | Sphagnum jensenii | 128206 | Plants | Plants | 151 | 3.7e-40 | NR | CAK9250667.1 | 128206 | g9962 | i0 | 68 | 0.622983870967742 | 103 | 33 | 62.3 | 0 | 5 | 313 | 259 | 361 | CAK9250667.1 unnamed protein product [Sphagnum jensenii] | diamond | 309 | 151 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum jensenii | |
| 28190077 | 28190077 | PRJNA773247_P_NODE_22186_length_301_cov_2.842105_g22102_i0 | PRJNA773247 | 22186 | 301 | 2.842105 | 8.55473605 | Tanacetum cinerariifolium | 118510 | Plants | Plants | 43.9 | 0.0302 | NR | GEW19955.1 | 118510 | g22102 | i0 | 25 | 0.877076411960133 | 88 | 65 | 87.7 | 1 | 289 | 26 | 563 | 649 | GEW19955.1 Ty3/gypsy retrotransposon protein [Tanacetum cinerariifolium] | diamond | 264 | 43.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Tanacetum | Tanacetum cinerariifolium | |
| 29147456 | 29147456 | PRJNA773247_P_NODE_33249_length_244_cov_2.280702_g33165_i0 | PRJNA773247 | 33249 | 244 | 2.280702 | 5.56491288 | Eukaryota | 2759 | Plants | Plants | 48.1 | 4.64e-4 | NR | XP_021321666.1 | 4558 | g33165 | i0 | 35.3 | 4.22950819672131 | 68 | 41 | 79.9 | 1 | 237 | 43 | 339 | 406 | XP_021321666.1 uncharacterized protein LOC8084238 [Sorghum bicolor] | diamond | 1032 | 48.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Sorghum | Sorghum bicolor | |
| 29484601 | 29484601 | PRJNA773247_P_NODE_34770_length_241_cov_1.375000_g34686_i0 | PRJNA773247 | 34770 | 241 | 1.375 | 3.31375 | Colocasia esculenta | 4460 | Plants | Plants | 43.1 | 0.0243 | NR | MQL73336.1 | 4460 | g34686 | i0 | 39.6 | 0.659751037344398 | 53 | 31 | 64.7 | 1 | 194 | 39 | 37 | 89 | MQL73336.1 hypothetical protein [Colocasia esculenta] | diamond | 159 | 43.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Alismatales | Araceae | Colocasia | Colocasia esculenta | |
| 29800543 | 29800543 | PRJNA773247_P_NODE_37211_length_205_cov_6.151515_g37127_i0 | PRJNA773247 | 37211 | 205 | 6.151515 | 12.61060575 | Aegilops tauschii subsp. strangulata | 200361 | Plants | Plants | 59.3 | 2.17e-8 | NR | XP_020162037.1 | 200361 | g37127 | i0 | 66.7 | 0.746341463414634 | 51 | 16 | 74.6 | 1 | 51 | 203 | 1 | 50 | XP_020162037.1 uncharacterized mitochondrial protein AtMg00810-like [Aegilops tauschii subsp. strangulata] | diamond | 153 | 59.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Aegilops | Aegilops tauschii | |
| 30220730 | 30220730 | PRJNA773247_P_NODE_26912_length_268_cov_6.497436_g26828_i0 | PRJNA773247 | 26912 | 268 | 6.497436 | 17.41312848 | root | 1 | Root_unresolved | Root_unresolved | 108 | 2.4e-25 | NR | KAK4833126.1 | 4023 | g26828 | i0 | 62.5 | 1.8134328358209 | 80 | 30 | 89.6 | 0 | 21 | 260 | 211 | 290 | KAK4833126.1 hypothetical protein QYF36_003213 [Acer negundo] | diamond | 486 | 108 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Sapindaceae | Acer | Acer negundo | |
| 30916128 | 30916128 | PRJNA773247_P_NODE_2934_length_1143_cov_44.731776_g2876_i0 | PRJNA773247 | 2934 | 1143 | 44.731776 | 511.28419968 | Eukaryota | 2759 | Plants | Plants | 154 | 3.6599999999999997e-38 | NR | KAG0587589.1 | 3225 | g2876 | i0 | 35.4 | 9.36745406824147 | 316 | 184 | 80.8 | 11 | 47 | 970 | 130 | 433 | KAG0587589.1 hypothetical protein KC19_2G175400 [Ceratodon purpureus] | diamond | 10707 | 154 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Pseudoditrichales | Ditrichaceae | Ceratodon | Ceratodon purpureus | |
| 31390232 | 31390232 | PRJNA773247_P_NODE_19176_length_329_cov_6.242188_g19092_i0 | PRJNA773247 | 19176 | 329 | 6.242188 | 20.53679852 | Malus | 3749 | Plants | Plants | 45.1 | 0.0147 | NR | RXI01597.1 | 3750 | g19092 | i0 | 50 | 0.875379939209726 | 48 | 21 | 43.8 | 2 | 100 | 243 | 185 | 229 | RXI01597.1 hypothetical protein DVH24_014946 [Malus domestica] | diamond | 288 | 45.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rosaceae | Malus | Malus domestica | |
| 32329928 | 32329928 | PRJNA773247_P_NODE_34459_length_242_cov_0.911243_g34375_i0 | PRJNA773247 | 34459 | 242 | 0.911243 | 2.20520806 | Linum tenue | 586396 | Plants | Plants | 53.9 | 4.2e-6 | NR | CAI0449997.1 | 586396 | g34375 | i0 | 43.5 | 1.1404958677686 | 92 | 39 | 97.9 | 2 | 2 | 238 | 562 | 653 | CAI0449997.1 unnamed protein product [Linum tenue] | diamond | 276 | 53.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Linaceae | Linum | Linum tenue | |
| 32529160 | 32529160 | PRJNA773247_P_NODE_10999_length_468_cov_8.321519_g10916_i0 | PRJNA773247 | 10999 | 468 | 8.321519 | 38.94470892 | Magnoliopsida | 3398 | Plants | Plants | 126 | 2.89e-30 | NR | XP_059669628.1 | 4283 | g10916 | i0 | 45 | 8.67948717948718 | 151 | 74 | 96.8 | 2 | 457 | 5 | 332 | 473 | XP_059669628.1 uncharacterized protein LOC132314847 [Cornus florida] | diamond | 4062 | 126 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cornales | Cornaceae | Cornus | Cornus florida | |
| 32623507 | 32623507 | PRJNA773247_P_NODE_15800_length_372_cov_1.585284_g15716_i0 | PRJNA773247 | 15800 | 372 | 1.585284 | 5.89725648 | Eukaryota | 2759 | Plants | Plants | 76.3 | 2.72e-13 | NR | KAI3719467.1 | 4217 | g15716 | i0 | 33.3 | 10.0241935483871 | 123 | 82 | 99.2 | 0 | 371 | 3 | 89 | 211 | KAI3719467.1 hypothetical protein L6452_20366 [Arctium lappa] | diamond | 3729 | 77 | 0.990909090909091 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Arctium | Arctium lappa | |
| 32865983 | 32865983 | PRJNA773247_P_NODE_37480_length_196_cov_4.772358_g37396_i0 | PRJNA773247 | 37480 | 196 | 4.772358 | 9.35382168 | Coptis chinensis | 261450 | Plants | Plants | 44.7 | 0.0036 | NR | KAF9607271.1 | 261450 | g37396 | i0 | 72 | 0.76530612244898 | 25 | 7 | 38.3 | 0 | 181 | 107 | 122 | 146 | KAF9607271.1 hypothetical protein IFM89_033478 [Coptis chinensis] | diamond | 150 | 44.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ranunculales | Ranunculaceae | Coptis | Coptis chinensis |
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);;