RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA983848 · 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
2547266 2547266 PRJNA983848_P_NODE_87222_length_328_cov_2.447059_g81339_i0 PRJNA983848 87222 328 2.447059 8.02635352 Deinococcus 1298 Bacteria Bacteria 606 5.249999999999998e-169   NTclustered gi|2113031129|gb|OK500351.1| 47478 g81339 i0 100 106 328 0 100 0 1 328 797 470 Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence blastn 34768 606 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
15299337 15299337 PRJNA983848_P_NODE_111252_length_285_cov_1.490566_g105369_i0 PRJNA983848 111252 285 1.490566 4.2481131 Truepera 332248 Bacteria Bacteria 455 1.72e-123   NTclustered gi|470486385|ref|NR_076754.1| 332249 g105369 i0 95.455 460.505263157895 286 12 100 1 1 285 688 973 Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence blastn 131244 457 0.99562363238512 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
16574120 16574120 PRJNA983848_P_NODE_72713_length_368_cov_2.925424_g66830_i0 PRJNA983848 72713 368 2.925424 10.76556032 Deinococcus 1298 Bacteria Bacteria 579 1.2999999999999999e-160   NTclustered gi|2152123021|gb|CP086380.1| 32062 g66830 i0 94.906 406.809782608696 373 14 100 5 1 368 2084381 2084753 Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome blastn 149706 579 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiophilus
20397927 20397927 PRJNA983848_P_NODE_155396_length_244_cov_1.222222_g149513_i0 PRJNA983848 155396 244 1.222222 2.98222168 Deinococcus 1298 Bacteria Bacteria 446 8.639999999999999e-121   NTclustered gi|545345498|gb|KF508730.1| 158789 g149513 i0 99.59 104.52868852459 244 1 100 0 1 244 208 451 Uncultured Deinococcus sp. clone 8466 16S ribosomal RNA gene, partial sequence blastn 25505 446 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus uncultured Deinococcus sp.
25197503 25197503 PRJNA983848_P_NODE_95700_length_311_cov_0.983193_g89817_i0 PRJNA983848 95700 311 0.983193 3.05773023 Tepiditoga spiralis 2108365 Bacteria Bacteria 54.7 0.008   NTclustered gi|1898704378|dbj|AP018712.1| 2108365 g89817 i0 100 0.183279742765273 29 0 9 0 261 289 2036691 2036663 Tepiditoga spiralis sy52 DNA, complete genome blastn 57 54.7 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Tepiditoga Tepiditoga spiralis
25497941 25497941 PRJNA983848_P_NODE_128160_length_263_cov_2.794737_g122277_i0 PRJNA983848 128160 263 2.794737 7.35015831 Deinococcus 1298 Bacteria Bacteria 431 2.639999999999999e-116   NTclustered gi|821341785|gb|CP011389.1| 1309411 g122277 i0 96.198 268.817490494297 263 10 100 0 1 263 1885990 1886252 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 70699 431 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)

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