RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA1198392" 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 · 12 ✖

bioproject 1

  • PRJNA1198392 · 12 ✖

analysis 1

  • diamond · 12 ✖
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
324523 324523 PRJNA1198392_P_NODE_16401_length_250_cov_0.870056_g16260_i0 PRJNA1198392 16401 250 0.870056 2.17514 Salvia splendens 180675 Plants Plants 149 4.3099999999999986e-43   NR KAG6434738.1 180675 g16260 i0 86.7 27.864 83 11 99.6 0 2 250 39 121 KAG6434738.1 hypothetical protein SASPL_106380 [Salvia splendens] diamond 6966 149 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lamiaceae Salvia Salvia splendens
13078202 13078202 PRJNA1198392_P_NODE_18731_length_246_cov_0.890173_g18590_i0 PRJNA1198392 18731 246 0.890173 2.18982558 Ceratopteris richardii 49495 Plants Plants 77.8 1.43e-14   NR KAH7415353.1 49495 g18590 i0 77.8 15.2560975609756 81 18 98.8 0 2 244 266 346 KAH7415353.1 hypothetical protein KP509_14G039100 [Ceratopteris richardii] diamond 3753 77.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Ceratopteris Ceratopteris richardii
28177701 28177701 PRJNA1198392_P_NODE_15166_length_254_cov_1.701657_g15025_i0 PRJNA1198392 15166 254 1.701657 4.32220878 Juncus effusus 13579 Plants Plants 75.1 1.19e-13   NR KAJ3681105.1 13579 g15025 i0 42.5 2.00787401574803 87 47 99.2 2 252 1 106 192 KAJ3681105.1 hypothetical protein LUZ60_015594 [Juncus effusus] diamond 510 75.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Juncaceae Juncus Juncus effusus
28588599 28588599 PRJNA1198392_P_NODE_20367_length_243_cov_0.905882_g20226_i0 PRJNA1198392 20367 243 0.905882 2.20129326 Punica granatum 22663 Plants Plants 44.7 0.00713   NR PKI59010.1 22663 g20226 i0 35.3 0.839506172839506 68 40 79 1 224 33 182 249 PKI59010.1 hypothetical protein CRG98_020578 [Punica granatum] diamond 204 44.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Myrtales Lythraceae Punica Punica granatum
28651580 28651580 PRJNA1198392_P_NODE_18707_length_246_cov_0.890173_g18566_i0 PRJNA1198392 18707 246 0.890173 2.18982558 Cardamine amara subsp. amara 228776 Plants Plants 73.9 3.65e-13   NR KAL1194816.1 228776 g18566 i0 51.3 9.41463414634146 76 32 86.6 1 221 9 334 409 KAL1194816.1 Retrovirus-related Pol polyprotein from transposon TNT 1-94 [Cardamine amara subsp. amara] diamond 2316 73.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Cardamine Cardamine amara
28714783 28714783 PRJNA1198392_P_NODE_12547_length_269_cov_3.938776_g12406_i0 PRJNA1198392 12547 269 3.938776 10.59530744 Momordica charantia 3673 Plants Plants 73.6 7.36e-13   NR XP_022144587.1 3673 g12406 i0 48.7 0.869888475836431 78 34 87 2 253 20 671 742 XP_022144587.1 serine/threonine-protein kinase CTR1-like isoform X2 [Momordica charantia] diamond 234 73.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cucurbitales Cucurbitaceae Momordica Momordica charantia
28733711 28733711 PRJNA1198392_P_NODE_12267_length_271_cov_1.434343_g12126_i0 PRJNA1198392 12267 271 1.434343 3.88706953 Streptophyta 35493 Plants Plants 57 5.07e-7   NR KAJ7544256.1 34168 g12126 i0 65.9 9.74169741697417 44 15 48.7 0 145 14 653 696 KAJ7544256.1 hypothetical protein O6H91_09G070900 [Diphasiastrum complanatum] diamond 2640 57 1 Eukaryota Embryophyta Viridiplantae Streptophyta Lycopodiopsida Lycopodiales Lycopodiaceae Diphasiastrum Diphasiastrum complanatum
30009519 30009519 PRJNA1198392_P_NODE_7091_length_308_cov_0.982979_g6950_i0 PRJNA1198392 7091 308 0.982979 3.02757532 Oryza sativa 4530 Plants Plants 141 8.149999999999999e-40   NR KAB8089558.1 4530 g6950 i0 70.9 1.86038961038961 103 29 99.4 1 1 306 47 149 KAB8089558.1 hypothetical protein EE612_014527, partial [Oryza sativa] diamond 573 141 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa
30799085 30799085 PRJNA1198392_P_NODE_11654_length_274_cov_1.532338_g11513_i0 PRJNA1198392 11654 274 1.532338 4.19860612 Salix suchowensis 1278906 Plants Plants 43.5 0.0275   NR KAJ6375252.1 1278906 g11513 i0 29.3 0.821167883211679 75 44 72.3 1 61 258 18 92 KAJ6375252.1 hypothetical protein OIU77_000268 [Salix suchowensis] diamond 225 43.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Salicaceae Salix Salix suchowensis
30944651 30944651 PRJNA1198392_P_NODE_14534_length_258_cov_1.664865_g14393_i0 PRJNA1198392 14534 258 1.664865 4.2953517 Brassicaceae 3700 Plants Plants 74.3 3.35e-13   NR XP_006293755.1 81985 g14393 i0 56.9 6.7906976744186 65 26 75.6 1 20 214 421 483 XP_006293755.1 ubiquitin carboxyl-terminal hydrolase 19 [Capsella rubella] diamond 1752 74.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Capsella Capsella rubella
31368345 31368345 PRJNA1198392_P_NODE_19676_length_244_cov_0.900585_g19535_i0 PRJNA1198392 19676 244 0.900585 2.1974274 Vitis vinifera 29760 Plants Plants 75.5 1.09e-13   NR CAN82845.1 29760 g19535 i0 45.7 2.98770491803279 81 44 99.6 0 244 2 29 109 CAN82845.1 hypothetical protein VITISV_005762 [Vitis vinifera] diamond 729 75.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Vitales Vitaceae Vitis Vitis vinifera
31399920 31399920 PRJNA1198392_P_NODE_18836_length_245_cov_2.656977_g18695_i0 PRJNA1198392 18836 245 2.656977 6.50959365 Capsicum chinense 80379 Plants Plants 44.3 0.00994   NR PHU30644.1 80379 g18695 i0 77.3 0.269387755102041 22 5 26.9 0 231 166 250 271 PHU30644.1 hypothetical protein BC332_02737 [Capsicum chinense] diamond 66 44.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Capsicum Capsicum chinense

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