RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA685060" and tax_clade = "Embryophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Embryophyta · 17 ✖

bioproject 1

  • PRJNA685060 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
26650447 26650447 PRJNA685060_P_NODE_17701_length_241_cov_0.916667_g17611_i0 PRJNA685060 17701 241 0.916667 2.20916747 Poaceae 4479 Plants Plants 48.5 3.33e-4   NR NP_001407105.1 39947 g17611 i0 56.8 1.61825726141079 44 19 54.8 0 241 110 124 167 NP_001407105.1 transport inhibitor response 1-like protein Os05g0150500 [Oryza sativa Japonica Group] diamond 390 48.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa
26987169 26987169 PRJNA685060_P_NODE_2782_length_592_cov_1.240848_g2692_i0 PRJNA685060 2782 592 1.240848 7.34582016 Eutrema salsugineum 72664 Plants Plants 47.8 0.00855   NR ESQ29963.1 72664 g2692 i0 34.5 0.603040540540541 119 73 60.3 2 363 7 56 169 ESQ29963.1 hypothetical protein EUTSA_v10011750mg [Eutrema salsugineum] diamond 357 47.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Eutrema Eutrema salsugineum
28156246 28156246 PRJNA685060_P_NODE_16065_length_245_cov_0.866279_g15975_i0 PRJNA685060 16065 245 0.866279 2.12238355 Zizania palustris 103762 Plants Plants 82 5.7e-16   NR KAG8088071.1 103762 g15975 i0 54.2 0.881632653061225 72 33 88.2 0 219 4 600 671 KAG8088071.1 hypothetical protein GUJ93_ZPchr0010g8483 [Zizania palustris] diamond 216 82 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Zizania Zizania palustris
28262181 28262181 PRJNA685060_P_NODE_10426_length_292_cov_0.899543_g10336_i0 PRJNA685060 10426 292 0.899543 2.62666556 Stephania 147243 Plants Plants 58.5 1.96e-7   NR KAK9094803.1 152367 g10336 i0 33.3 4.16095890410959 81 47 83.2 2 2 244 288 361 KAK9094803.1 hypothetical protein Scep_026272 [Stephania cephalantha] diamond 1215 58.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ranunculales Menispermaceae Stephania Stephania cephalantha
28376967 28376967 PRJNA685060_P_NODE_16786_length_243_cov_0.905882_g16696_i0 PRJNA685060 16786 243 0.905882 2.20129326 Oryza sativa Japonica Group 39947 Plants Plants 100 1.72e-22   NR BAC84429.1 39947 g16696 i0 64 1.85185185185185 75 27 92.6 0 240 16 355 429 BAC84429.1 hypothetical protein [Oryza sativa Japonica Group] diamond 450 100 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa
28566471 28566471 PRJNA685060_P_NODE_15387_length_246_cov_0.890173_g15297_i0 PRJNA685060 15387 246 0.890173 2.18982558 Elymus magellanicus 2892461 Plants Plants 50.8 1.7e-5   NR UEE83578.1 2892461 g15297 i0 44.6 0.682926829268293 56 31 68.3 0 235 68 97 152 UEE83578.1 hypothetical protein [Elymus magellanicus] diamond 168 50.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Elymus Elymus magellanicus
28787350 28787350 PRJNA685060_P_NODE_5407_length_413_cov_1.729412_g5317_i0 PRJNA685060 5407 413 1.729412 7.14247156 Oldenlandia corymbosa var. corymbosa 529605 Plants Plants 52 1.27e-4   NR CAI9091112.1 529605 g5317 i0 37.2 1.36561743341404 94 55 67.6 3 116 394 6 96 CAI9091112.1 OLC1v1026052C2 [Oldenlandia corymbosa var. corymbosa] diamond 564 52 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Gentianales Rubiaceae Oldenlandia Oldenlandia corymbosa
29008899 29008899 PRJNA685060_P_NODE_4228_length_472_cov_2.060150_g4138_i0 PRJNA685060 4228 472 2.06015 9.723908 Selaginella moellendorffii 88036 Plants Plants 73.6 2.37e-12   NR EFJ27613.1 88036 g4138 i0 37.6 2.27542372881356 101 57 64.2 3 443 141 53 147 EFJ27613.1 LIP1, ras family GTPase [Selaginella moellendorffii] diamond 1074 73.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Lycopodiopsida Selaginellales Selaginellaceae Selaginella Selaginella moellendorffii
29260953 29260953 PRJNA685060_P_NODE_8129_length_333_cov_1.523077_g8039_i0 PRJNA685060 8129 333 1.523077 5.07184641 Lactuca sativa 4236 Plants Plants 55.1 4.52e-6   NR XP_023737491.1 4236 g8039 i0 44.9 0.621621621621622 69 38 62.2 0 260 54 157 225 XP_023737491.1 polyubiquitin-like [Lactuca sativa] diamond 207 55.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Lactuca Lactuca sativa
29513532 29513532 PRJNA685060_P_NODE_10550_length_290_cov_1.073733_g10460_i0 PRJNA685060 10550 290 1.073733 3.1138257 Dichanthelium oligosanthes 888268 Plants Plants 70.1 2.33e-12   NR OEL30188.1 888268 g10460 i0 42.5 0.755172413793103 73 42 75.5 0 71 289 22 94 OEL30188.1 Serine/threonine-protein phosphatase PP1 [Dichanthelium oligosanthes] diamond 219 70.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Dichanthelium Dichanthelium oligosanthes
30240228 30240228 PRJNA685060_P_NODE_3512_length_524_cov_1.654102_g3422_i0 PRJNA685060 3512 524 1.654102 8.66749448 Citrus sinensis 2711 Plants Plants 90.1 2.39e-17   NR KAH9670915.1 2711 g3422 i0 43.1 1.99236641221374 116 65 66.4 1 483 136 745 859 KAH9670915.1 hypothetical protein KPL70_017154 [Citrus sinensis] diamond 1044 90.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus sinensis
30662505 30662505 PRJNA685060_P_NODE_3213_length_552_cov_1.647182_g3123_i0 PRJNA685060 3213 552 1.647182 9.09244464 Eukaryota 2759 Plants Plants 133 1.08e-33   NR WCJ39890.1 38846 g3123 i0 40.1 3.95108695652174 177 93 96.2 3 543 13 67 230 WCJ39890.1 Histone-binding protein MSI1 [Euphorbia peplus] diamond 2181 133 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Euphorbiaceae Euphorbia Euphorbia peplus
31346280 31346280 PRJNA685060_P_NODE_4456_length_460_cov_0.994832_g4366_i0 PRJNA685060 4456 460 0.994832 4.5762272 Diphasiastrum complanatum 34168 Plants Plants 50.1 0.00106   NR KAJ7521864.1 34168 g4366 i0 25.3 2.21739130434783 170 93 91.3 4 456 37 2307 2472 KAJ7521864.1 hypothetical protein O6H91_19G071900 [Diphasiastrum complanatum] diamond 1020 50.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Lycopodiopsida Lycopodiales Lycopodiaceae Diphasiastrum Diphasiastrum complanatum
31357875 31357875 PRJNA685060_P_NODE_17776_length_241_cov_0.863095_g17686_i0 PRJNA685060 17776 241 0.863095 2.08005895 Musa 4640 Plants Plants 50.4 5.66e-5   NR THU42881.1 52838 g17686 i0 63.6 0.821576763485477 33 12 41.1 0 213 115 213 245 THU42881.1 hypothetical protein C4D60_Mb00t00730 [Musa balbisiana] diamond 198 50.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Zingiberales Musaceae Musa Musa balbisiana
31472868 31472868 PRJNA685060_P_NODE_8796_length_320_cov_1.518219_g8706_i0 PRJNA685060 8796 320 1.518219 4.8583008 Selaginella moellendorffii 88036 Plants Plants 55.8 2.28e-6   NR XP_024520005.1 88036 g8706 i0 40.6 0.646875 69 40 64.7 1 11 217 204 271 XP_024520005.1 protein arginine N-methyltransferase 5 [Selaginella moellendorffii] diamond 207 55.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Lycopodiopsida Selaginellales Selaginellaceae Selaginella Selaginella moellendorffii
32275364 32275364 PRJNA685060_P_NODE_16278_length_244_cov_0.900585_g16188_i0 PRJNA685060 16278 244 0.900585 2.1974274 Poaceae 4479 Plants Plants 100 2.61e-24   NR KAF7092798.1 4565 g16188 i0 63 6.97131147540984 81 30 99.6 0 243 1 73 153 KAF7092798.1 hypothetical protein CFC21_095253 [Triticum aestivum] diamond 1701 100 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
32516941 32516941 PRJNA685060_P_NODE_13419_length_251_cov_0.865169_g13329_i0 PRJNA685060 13419 251 0.865169 2.17157419 Oryza sativa Japonica Group 39947 Plants Plants 56.2 6.65e-7   NR ABA98203.1 39947 g13329 i0 60.5 0.51394422310757 43 17 51.4 0 109 237 1 43 ABA98203.1 retrotransposon protein, putative, Ty3-gypsy subclass [Oryza sativa Japonica Group] diamond 129 56.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;