RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA879314 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
26897261 26897261 PRJNA879314_P_NODE_6821_length_249_cov_0.886364_g6771_i0 PRJNA879314 6821 249 0.886364 2.20704636 Buddleja alternifolia 168488 Plants Plants 42.7 0.0399   NR KAG8388504.1 168488 g6771 i0 40 0.662650602409639 55 31 66.3 2 15 179 383 435 KAG8388504.1 hypothetical protein BUALT_Bualt02G0132500 [Buddleja alternifolia] diamond 165 42.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Scrophulariaceae Buddleja Buddleja alternifolia
27781988 27781988 PRJNA879314_P_NODE_7824_length_247_cov_1.741379_g7774_i0 PRJNA879314 7824 247 1.741379 4.30120613 Glycine max 3847 Plants Plants 114 8.4e-29   NR KAG5153492.1 3847 g7774 i0 82.3 70.4817813765182 62 11 75.3 0 61 246 112 173 KAG5153492.1 hypothetical protein JHK82_011461 [Glycine max] diamond 17409 114 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Glycine Glycine max
27844821 27844821 PRJNA879314_P_NODE_10564_length_243_cov_0.917647_g10514_i0 PRJNA879314 10564 243 0.917647 2.22988221 Zizania palustris 103762 Plants Plants 73.6 5.14e-13   NR KAG8100027.1 103762 g10514 i0 48.1 6.65432098765432 77 39 95.1 1 239 9 406 481 KAG8100027.1 hypothetical protein GUJ93_ZPchr0013g36498 [Zizania palustris] diamond 1617 73.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Zizania Zizania palustris
27844837 27844837 PRJNA879314_P_NODE_6824_length_249_cov_0.886364_g6774_i0 PRJNA879314 6824 249 0.886364 2.20704636 Juncus effusus 13579 Plants Plants 66.2 3.09e-11   NR KAJ3669617.1 13579 g6774 i0 47.9 1.73493975903614 71 36 85.5 1 36 248 33 102 KAJ3669617.1 hypothetical protein LUZ60_011567 [Juncus effusus] diamond 432 66.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Juncaceae Juncus Juncus effusus
29108051 29108051 PRJNA879314_P_NODE_4548_length_253_cov_0.866667_g4498_i0 PRJNA879314 4548 253 0.866667 2.19266751 Oryza sativa Japonica Group 39947 Plants Plants 52.8 7.01e-6   NR BAD25952.1 39947 g4498 i0 52.6 0.450592885375494 38 18 45.1 0 198 85 39 76 BAD25952.1 hypothetical protein [Oryza sativa Japonica Group] diamond 114 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa
29834179 29834179 PRJNA879314_P_NODE_8251_length_247_cov_0.896552_g8201_i0 PRJNA879314 8251 247 0.896552 2.21448344 Panicum virgatum 38727 Plants Plants 43.9 0.00916   NR KAG2598357.1 38727 g8201 i0 50 0.607287449392713 50 24 60.7 1 32 181 68 116 KAG2598357.1 hypothetical protein PVAP13_5KG364807 [Panicum virgatum] diamond 150 43.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Panicum Panicum virgatum

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