RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJEB81171" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 6 ✖

bioproject 1

  • PRJEB81171 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
139449 139449 PRJEB81171_P_NODE_7861_length_252_cov_0.871508_g7734_i0 PRJEB81171 7861 252 0.871508 2.19620016 Deinococcus sp. QL22 2939437 Bacteria Bacteria 416 7.029999999999999e-112   NTclustered gi|2238962615|gb|CP097154.1| 2939437 g7734 i0 96.429 1 252 9 100 0 1 252 59273 59524 Deinococcus sp. QL22 plasmid unnamed6, complete sequence blastn 252 416 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. QL22
139481 139481 PRJEB81171_P_NODE_9521_length_244_cov_0.912281_g9394_i0 PRJEB81171 9521 244 0.912281 2.22596564 Allomeiothermus silvanus 52022 Bacteria Bacteria 440 4.019999999999999e-119   NTclustered gi|296848933|gb|CP002042.1| 526227 g9394 i0 99.18 6.93032786885246 244 2 100 0 1 244 1983728 1983485 Meiothermus silvanus DSM 9946, complete genome blastn 1691 440 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Allomeiothermus Allomeiothermus silvanus
1414070 1414070 PRJEB81171_P_NODE_722_length_765_cov_1.609827_g607_i0 PRJEB81171 722 765 1.609827 12.31517655 Trueperaceae bacterium 2026798 Bacteria Bacteria 1033 0   NTclustered gi|2621701816|emb|OY759346.1| 2026798 g607 i0 91.123 450.681045751634 766 62 100 6 1 765 3601169 3600409 MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1 blastn 344771 1033 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
13750089 13750089 PRJEB81171_P_NODE_9071_length_246_cov_0.901734_g8944_i0 PRJEB81171 9071 246 0.901734 2.21826564 Fervidobacterium 2422 Bacteria Bacteria 366 6.99e-97   NTclustered gi|383108560|gb|CP003260.1| 771875 g8944 i0 93.827 3.97967479674797 243 15 99 0 1 243 1355856 1356098 Fervidobacterium pennivorans DSM 9078, complete genome blastn 979 366 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium pennivorans
20540391 20540391 PRJEB81171_P_NODE_7217_length_259_cov_2.086022_g7090_i0 PRJEB81171 7217 259 2.086022 5.40279698 Deinococcus gobiensis 502394 Bacteria Bacteria 374 4.4299999999999994e-99   NTclustered gi|379998737|gb|CP002191.1| 745776 g7090 i0 92.776 239.702702702703 263 12 100 7 1 259 112459 112200 Deinococcus gobiensis I-0, complete genome blastn 62083 374 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus gobiensis
23091452 23091452 PRJEB81171_P_NODE_8779_length_248_cov_0.880000_g8652_i0 PRJEB81171 8779 248 0.88 2.1824 Deinococcus aquaticus 328692 Bacteria Bacteria 436 5.3e-118   NTclustered gi|2444120906|gb|CP115165.1| 328692 g8652 i0 98.387 2 248 4 100 0 1 248 2262377 2262624 Deinococcus aquaticus strain PB-314 chromosome, complete genome blastn 496 436 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus

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