RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJEB9859 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
144933 144933 PRJEB9859_P_NODE_301_length_570_cov_4.353050_g283_i0 PRJEB9859 301 570 4.35305 24.812385 Eukaryota 2759 Plants Plants 207 1.43e-63   NR KAG0553620.1 3225 g283 i0 63.7 89.6894736842105 171 61 90 1 569 57 93 262 KAG0553620.1 hypothetical protein KC19_12G026000 [Ceratodon purpureus] diamond 51123 209 0.990430622009569 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Pseudoditrichales Ditrichaceae Ceratodon Ceratodon purpureus
999038 999038 PRJEB9859_P_NODE_501_length_477_cov_10.243304_g475_i0 PRJEB9859 501 477 10.243304 48.86056008 Nymphaea colorata 210225 Plants Plants 152 3.33e-44   NR XP_031472781.1 210225 g475 i0 57.8 0.849056603773585 135 53 82.4 1 30 422 13 147 XP_031472781.1 LOW QUALITY PROTEIN: uncharacterized protein LOC116245286 [Nymphaea colorata] diamond 405 152 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata
3971239 3971239 PRJEB9859_P_NODE_5024_length_245_cov_1.027778_g4989_i0 PRJEB9859 5024 245 1.027778 2.5180561 Perilla frutescens var. hirtella 608512 Plants Plants 89 7.3e-19   NR KAH6835591.1 608512 g4989 i0 73.3 9.79591836734694 60 16 73.5 0 242 63 273 332 KAH6835591.1 Ribosomal protein L6 family [Perilla frutescens var. hirtella] diamond 2400 89 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lamiaceae Perilla Perilla frutescens
27065866 27065866 PRJEB9859_P_NODE_4162_length_251_cov_9.891892_g4127_i0 PRJEB9859 4162 251 9.891892 24.82864892 Erythroxylum novogranatense 1862640 Plants Plants 85.1 4.43e-17   NR KAJ8772838.1 1862640 g4127 i0 64.9 0.681274900398406 57 18 68.1 1 246 76 297 351 KAJ8772838.1 hypothetical protein K2173_028015 [Erythroxylum novogranatense] diamond 171 85.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Erythroxylaceae Erythroxylum Erythroxylum novogranatense
27476740 27476740 PRJEB9859_P_NODE_2383_length_303_cov_1.240876_g2348_i0 PRJEB9859 2383 303 1.240876 3.75985428 Sphagnum balticum 128184 Plants Plants 72.4 1.99e-13   NR CAM6004648.1 128184 g2348 i0 45.6 0.673267326732673 68 37 67.3 0 301 98 95 162 CAM6004648.1 unnamed protein product [Sphagnum balticum] diamond 204 72.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
27571469 27571469 PRJEB9859_P_NODE_684_length_439_cov_4.029268_g651_i0 PRJEB9859 684 439 4.029268 17.68848652 Anisodus acutangulus 402998 Plants Plants 91.7 8.240000000000001e-21   NR KAJ8551981.1 402998 g651 i0 61.9 1.54441913439636 113 41 77.2 1 433 95 1 111 KAJ8551981.1 hypothetical protein K7X08_028424 [Anisodus acutangulus] diamond 678 91.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Anisodus Anisodus acutangulus
28297609 28297609 PRJEB9859_P_NODE_5786_length_241_cov_1.047170_g5751_i0 PRJEB9859 5786 241 1.04717 2.5236797 Hordeum vulgare subsp. vulgare 112509 Plants Plants 119 4.18e-29   NR BAJ97973.1 112509 g5751 i0 80.8 0.970954356846473 78 15 97.1 0 1 234 645 722 BAJ97973.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 234 119 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
29024269 29024269 PRJEB9859_P_NODE_1448_length_354_cov_1.960000_g1413_i0 PRJEB9859 1448 354 1.96 6.9384 Psophocarpus tetragonolobus 3891 Plants Plants 51.2 1.31e-4   NR KAK7395747.1 3891 g1413 i0 41.4 0.983050847457627 58 33 49.2 1 105 278 415 471 KAK7395747.1 hypothetical protein VNO78_16314 [Psophocarpus tetragonolobus] diamond 348 51.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Psophocarpus Psophocarpus tetragonolobus
29679252 29679252 PRJEB9859_P_NODE_3330_length_271_cov_3.272727_g3295_i0 PRJEB9859 3330 271 3.272727 8.86909017 Viridiplantae 33090 Plants Plants 87.4 7.29e-19   NR GER33450.1 4170 g3295 i0 71.2 25.549815498155 59 17 65.3 0 265 89 162 220 GER33450.1 60S ribosomal protein l9, partial [Striga asiatica] diamond 6924 87.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Orobanchaceae Striga Striga asiatica
30153102 30153102 PRJEB9859_P_NODE_292_length_573_cov_5.115809_g276_i0 PRJEB9859 292 573 5.115809 29.31358557 Magnoliopsida 3398 Plants Plants 46.2 0.00363   NR KAK7326255.1 3886 g276 i0 54.3 0.916230366492147 35 16 18.3 0 123 227 29 63 KAK7326255.1 hypothetical protein VNO80_33070 [Phaseolus coccineus] diamond 525 46.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Phaseolus Phaseolus coccineus
30192250 30192250 PRJEB9859_P_NODE_1592_length_344_cov_3.742857_g1557_i0 PRJEB9859 1592 344 3.742857 12.87542808 Arabidopsis thaliana 3702 Plants Plants 80.1 4.85e-17   NR NP_001118871.1 3702 g1557 i0 52 0.654069767441861 75 36 65.4 0 324 100 8 82 NP_001118871.1 Zinc-binding ribosomal protein family protein [Arabidopsis thaliana] diamond 225 80.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis thaliana
30634498 30634498 PRJEB9859_P_NODE_6573_length_220_cov_6.560209_g6538_i0 PRJEB9859 6573 220 6.560209 14.4324598 Sesbania bispinosa 485725 Plants Plants 75.5 6.32e-14   NR KAJ1424638.1 485725 g6538 i0 58.9 0.763636363636364 56 21 76.4 1 219 52 287 340 KAJ1424638.1 Peptidase C1A, papain C-terminal [Sesbania bispinosa] diamond 168 75.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Sesbania Sesbania bispinosa
30974986 30974986 PRJEB9859_P_NODE_5214_length_244_cov_1.032558_g5179_i0 PRJEB9859 5214 244 1.032558 2.51944152 Magnoliopsida 3398 Plants Plants 51.2 3.5e-5   NR GAU29245.1 3900 g5179 i0 40 8.31147540983607 75 42 92.2 2 1 225 128 199 GAU29245.1 hypothetical protein TSUD_362350 [Trifolium subterraneum] diamond 2028 51.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Trifolium Trifolium subterraneum

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