RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1264536 · 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
24590209 24590209 PRJNA1264536_P_NODE_5000_length_247_cov_0.896552_g4926_i0 PRJNA1264536 5000 247 0.896552 2.21448344 Lamiales 4143 Plants Plants 115 9.82e-30   NR KAK6144149.1 99300 g4926 i0 64.6 4.97975708502024 82 29 99.6 0 1 246 42 123 KAK6144149.1 hypothetical protein DH2020_020969 [Rehmannia glutinosa] diamond 1230 115 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Orobanchaceae Rehmannia Rehmannia glutinosa
27958320 27958320 PRJNA1264536_P_NODE_3925_length_273_cov_1.355000_g3851_i0 PRJNA1264536 3925 273 1.355 3.69915 Dendrobium catenatum 906689 Plants Plants 45.8 4.04e-4   NR PKU80056.1 906689 g3851 i0 37.7 0.582417582417582 53 33 58.2 0 80 238 6 58 PKU80056.1 hypothetical protein MA16_Dca027574 [Dendrobium catenatum] diamond 159 45.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asparagales Orchidaceae Dendrobium Dendrobium catenatum
28134129 28134129 PRJNA1264536_P_NODE_5145_length_245_cov_1.360465_g5071_i0 PRJNA1264536 5145 245 1.360465 3.33313925 Eukaryota 2759 Plants Plants 110 2.12e-28   NR XP_012833735.1 4155 g5071 i0 87.5 11.8530612244898 56 7 68.6 0 77 244 1 56 XP_012833735.1 PREDICTED: peptidyl-prolyl cis-trans isomerase [Erythranthe guttata] diamond 2904 111 0.990990990990991 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Phrymaceae Erythranthe Erythranthe guttata
28937197 28937197 PRJNA1264536_P_NODE_5108_length_246_cov_0.901734_g5034_i0 PRJNA1264536 5108 246 0.901734 2.21826564 Rubroshorea leprosula 152421 Plants Plants 61.6 7.69e-9   NR GKV23780.1 152421 g5034 i0 41 2.96341463414634 78 36 95.1 1 11 244 56 123 GKV23780.1 hypothetical protein SLEP1_g33476 [Rubroshorea leprosula] diamond 729 61.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Dipterocarpaceae Rubroshorea Rubroshorea leprosula
29144688 29144688 PRJNA1264536_P_NODE_4009_length_269_cov_1.081633_g3935_i0 PRJNA1264536 4009 269 1.081633 2.90959277 Eukaryota 2759 Plants Plants 51.2 8.33e-6   NR KMZ70815.1 29655 g3935 i0 37.7 2.0185873605948 69 39 72.5 1 242 48 5 73 KMZ70815.1 Zinc finger matrin type 5 [Zostera marina] diamond 543 51.6 0.992248062015504 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Alismatales Zosteraceae Zostera Zostera marina
30769096 30769096 PRJNA1264536_P_NODE_3254_length_308_cov_1.970213_g3180_i0 PRJNA1264536 3254 308 1.970213 6.06825604 Hordeum vulgare subsp. vulgare 112509 Plants Plants 178 2.77e-54   NR BAJ97069.1 112509 g3180 i0 86.3 0.993506493506494 102 14 99.4 0 307 2 10 111 BAJ97069.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 306 178 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare

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