RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1262902" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 7 ✖

bioproject 1

  • PRJNA1262902 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
5466810 5466810 PRJNA1262902_P_NODE_10485_length_245_cov_0.895349_g10443_i0 PRJNA1262902 10485 245 0.895349 2.19360505 Deinococcus sp. AB2017081 3093660 Bacteria Bacteria 436 5.229999999999999e-118   NTclustered gi|2636768990|gb|CP140098.1| 3093660 g10443 i0 98.776 2 245 3 100 0 1 245 2119572 2119816 Deinococcus sp. AB2017081 chromosome, complete genome blastn 490 436 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. AB2017081
8706775 8706775 PRJNA1262902_P_NODE_27_length_1667_cov_20.753450_g20_i0 PRJNA1262902 27 1667 20.75345 345.9600115 Deinococcus 1298 Bacteria Bacteria 1988 0   NTclustered gi|821341785|gb|CP011389.1| 1309411 g20 i0 88.801 292.088182363527 1643 155 98 23 20 1650 1887596 1885971 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 486911 2004 0.992015968063872 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
13117343 13117343 PRJNA1262902_P_NODE_10331_length_245_cov_0.895349_g10289_i0 PRJNA1262902 10331 245 0.895349 2.19360505 Deinococcus aquaticus 328692 Bacteria Bacteria 442 1.1199999999999994e-119   NTclustered gi|2444124175|gb|CP115167.1| 328692 g10289 i0 99.184 2.03265306122449 245 2 100 0 1 245 166483 166727 Deinococcus aquaticus strain PB-314 plasmid pDATS02, complete sequence blastn 498 442 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus
20180072 20180072 PRJNA1262902_P_NODE_136_length_1000_cov_2.813376_g111_i0 PRJNA1262902 136 1000 2.813376 28.13376 Deinococcus 1298 Bacteria Bacteria 1707 0   NTclustered gi|470488003|ref|NR_076846.1| 55148 g111 i0 97.5 417.386 1000 24 99 1 2 1000 504 1503 Deinococcus proteolyticus strain MRP 23S ribosomal RNA gene, complete sequence blastn 417386 1712 0.997079439252336 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus proteolyticus
20765147 20765147 PRJNA1262902_P_NODE_957_length_453_cov_1.621053_g915_i0 PRJNA1262902 957 453 1.621053 7.34337009 Trueperaceae bacterium 2026798 Bacteria Bacteria 573 7.579999999999999e-159   NTclustered gi|2621701816|emb|OY759346.1| 2026798 g915 i0 89.542 395.322295805739 459 38 99 5 1 450 3600736 3601193 MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1 blastn 179081 573 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
21455829 21455829 PRJNA1262902_P_NODE_117_length_1045_cov_3.884774_g36_i1 PRJNA1262902 117 1045 3.884774 40.5958883 Deinococcus 1298 Bacteria Bacteria 1805 0   NTclustered gi|730601855|gb|CP010028.1| 57497 g36 i1 98.441 227.244019138756 1026 14 98 2 21 1045 70370 69346 Deinococcus swuensis strain DY59, complete genome blastn 237470 1805 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiopugnans
24005986 24005986 PRJNA1262902_P_NODE_39_length_1527_cov_16.909904_g20_i1 PRJNA1262902 39 1527 16.909904 258.21423408 Deinococcus 1298 Bacteria Bacteria 2021 0   NTclustered gi|1751874559|dbj|AP021851.1| 57498 g20 i1 91.206 327.616895874263 1501 110 98 22 21 1510 115413 116902 Deinococcus grandis ATCC 43672 plasmid: pDEGR-2 DNA, complete genome blastn 500271 2028 0.9965483234714 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis

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