RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA851399" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 5 ✖

bioproject 1

  • PRJNA851399 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
9767186 9767186 PRJNA851399_P_NODE_11808_length_223_cov_1.959770_g11355_i0 PRJNA851399 11808 223 1.95977 4.3702871 Deinococcus geothermalis 68909 Bacteria Bacteria 412 7.88e-111   NTclustered gi|94554390|gb|CP000359.1| 319795 g11355 i0 100 217.547085201794 223 0 100 0 1 223 2375313 2375535 Deinococcus geothermalis DSM 11300, complete genome blastn 48513 412 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus geothermalis
10162411 10162411 PRJNA851399_P_NODE_19548_length_179_cov_0.915385_g19095_i0 PRJNA851399 19548 179 0.915385 1.63853915 Allomeiothermus 2935559 Bacteria Bacteria 324 2.91e-84   NTclustered gi|470486339|ref|NR_076751.1| 52022 g19095 i0 99.438 4.2122905027933 178 1 99 0 2 179 2236 2059 Meiothermus silvanus strain DSM 9946 23S ribosomal RNA gene, complete sequence blastn 754 324 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Allomeiothermus Allomeiothermus silvanus
19965893 19965893 PRJNA851399_P_NODE_31656_length_165_cov_0.879310_g31203_i0 PRJNA851399 31656 165 0.87931 1.4508615 Deinococcus geothermalis 68909 Bacteria Bacteria 289 9.66e-74   NTclustered gi|94554390|gb|CP000359.1| 319795 g31203 i0 98.182 1 165 3 100 0 1 165 911807 911643 Deinococcus geothermalis DSM 11300, complete genome blastn 165 289 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus geothermalis
23791530 23791530 PRJNA851399_P_NODE_24479_length_168_cov_1.462185_g24026_i0 PRJNA851399 24479 168 1.462185 2.4564708 Deinococcus aquaticus 328692 Bacteria Bacteria 305 9.81e-79   NTclustered gi|2444120906|gb|CP115165.1| 328692 g24026 i0 99.405 222.75 168 1 100 0 1 168 714825 714658 Deinococcus aquaticus strain PB-314 chromosome, complete genome blastn 37422 305 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus
25065452 25065452 PRJNA851399_P_NODE_23820_length_169_cov_1.700000_g23367_i0 PRJNA851399 23820 169 1.7 2.873 Deinococcus maricopensis 309887 Bacteria Bacteria 263 5.989999999999999e-66   NTclustered gi|319753907|gb|CP002454.1| 709986 g23367 i0 94.675 37.3491124260355 169 9 100 0 1 169 3025062 3024894 Deinococcus maricopensis DSM 21211, complete genome blastn 6312 263 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus maricopensis

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