RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA348537", tax_phylum = "Deinococcota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 4 ✖

tax_phylum 1

  • Deinococcota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA348537 · 4 ✖

analysis 1

tax_clade 0

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
11273625 11273625 PRJNA348537_S_NODE_1269_length_257_cov_9.977477_g1223_i0 PRJNA348537 1269 257 9.977477 25.64211589 Deinococcus 1298 Bacteria Bacteria 466 7.05e-127   NTclustered gi|2113031129|gb|OK500351.1| 47478 g1223 i0 100 101.976653696498 252 0 98 0 6 257 479 730 Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence blastn 26208 466 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
13147127 13147127 PRJNA348537_S_NODE_471_length_395_cov_10.725000_g425_i0 PRJNA348537 471 395 10.725 42.36375 Deinococcus soli (ex Cha et al. 2016) 1309411 Bacteria Bacteria 686 0   NTclustered gi|821341785|gb|CP011389.1| 1309411 g425 i0 97.975 229.470886075949 395 8 100 0 1 395 1886473 1886079 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 90641 686 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
17648057 17648057 PRJNA348537_S_NODE_2754_length_185_cov_3.000000_g2708_i0 PRJNA348537 2754 185 3 5.55 Deinococcus 1298 Bacteria Bacteria 342 8.369999999999999e-90   NTclustered gi|2113031129|gb|OK500351.1| 47478 g2708 i0 100 108 185 0 100 0 1 185 1058 1242 Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence blastn 19980 342 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
22069955 22069955 PRJNA348537_S_NODE_1478_length_239_cov_9.774510_g1432_i0 PRJNA348537 1478 239 9.77451 23.3610789 Deinococcus radiophilus 32062 Bacteria Bacteria 292 1.1599999999999999e-74   NTclustered gi|2152123021|gb|CP086380.1| 32062 g1432 i0 89.61 177.65690376569 231 22 96 2 3 232 1814560 1814789 Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome blastn 42460 292 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiophilus

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