RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJNA1168532" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 2 ✖

bioproject 1

  • PRJNA1168532 · 2 ✖

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
9968372 9968372 PRJNA1168532_S_NODE_129708_length_281_cov_4.369748_g126765_i0 PRJNA1168532 129708 281 4.369748 12.27899188 Deinococcus 1298 Bacteria Bacteria 425 1.32e-114   NTclustered gi|470488003|ref|NR_076846.1| 55148 g126765 i0 93.95 212.651245551601 281 17 100 0 1 281 2270 1990 Deinococcus proteolyticus strain MRP 23S ribosomal RNA gene, complete sequence blastn 59755 425 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus proteolyticus
13793573 13793573 PRJNA1168532_S_NODE_229151_length_201_cov_4.322785_g226208_i0 PRJNA1168532 229151 201 4.322785 8.68879785 Deinococcus 1298 Bacteria Bacteria 307 3.3800000000000005e-79   NTclustered gi|2152123021|gb|CP086380.1| 32062 g226208 i0 97.238 251.412935323383 181 5 90 0 21 201 1813880 1814060 Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome blastn 50534 307 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);;