RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA1047551" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 13 ✖

bioproject 1

  • PRJNA1047551 · 13 ✖

analysis 1

  • blastn · 13 ✖

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
1009825 1009825 PRJNA1047551_S_NODE_2201_length_304_cov_9.765799_g2074_i0 PRJNA1047551 2201 304 9.765799 29.68802896 Deinococcus 1298 Bacteria Bacteria 433 8.66e-117   NTclustered gi|2890653062|gb|CP177252.1| 367282 g2074 i0 92.208 574.131578947368 308 20 100 4 1 304 2672101 2671794 Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome blastn 174536 436 0.993119266055046 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus yunweiensis
2725138 2725138 PRJNA1047551_S_NODE_4563_length_223_cov_3.441489_g4436_i0 PRJNA1047551 4563 223 3.441489 7.67452047 Deinococcus geothermalis 68909 Bacteria Bacteria 412 7.88e-111   NTclustered gi|94554390|gb|CP000359.1| 319795 g4436 i0 100 215.860986547085 223 0 100 0 1 223 326948 326726 Deinococcus geothermalis DSM 11300, complete genome blastn 48137 412 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus geothermalis
7387611 7387611 PRJNA1047551_S_NODE_12786_length_154_cov_1.184874_g12659_i0 PRJNA1047551 12786 154 1.184874 1.82470596 Truepera 332248 Bacteria Bacteria 285 1.14e-72   NTclustered gi|470486385|ref|NR_076754.1| 332249 g12659 i0 100 560.266233766234 154 0 100 0 1 154 2637 2484 Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence blastn 86281 285 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
7387619 7387619 PRJNA1047551_S_NODE_186_length_900_cov_9.906358_g69_i1 PRJNA1047551 186 900 9.9063580000000009 89.157222 Deinococcus 1298 Bacteria Bacteria 1127 0   NTclustered gi|2890653062|gb|CP177252.1| 367282 g69 i1 90.531 399.662222222222 866 63 97 14 1 857 2672144 2672999 Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome blastn 359696 1133 0.994704324801412 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus yunweiensis
11213241 11213241 PRJNA1047551_S_NODE_1909_length_324_cov_11.768166_g1782_i0 PRJNA1047551 1909 324 11.768166 38.12885784 Deinococcus 1298 Bacteria Bacteria 547 3.18e-151   NTclustered gi|1435316362|gb|CP031158.1| 980427 g1782 i0 99.666 219.981481481481 299 1 92 0 1 299 1792351 1792053 Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome blastn 71274 547 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis
13763196 13763196 PRJNA1047551_S_NODE_1971_length_319_cov_10.299296_g1844_i0 PRJNA1047551 1971 319 10.299296 32.85475424 Deinococcus 1298 Bacteria Bacteria 568 2.3999999999999993e-157   NTclustered gi|470478007|ref|NR_076423.1| 68909 g1844 i0 98.746 213.423197492163 319 4 100 0 1 319 1380 1062 Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence blastn 68082 568 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus geothermalis
16312303 16312303 PRJNA1047551_S_NODE_9673_length_170_cov_1.533333_g9546_i0 PRJNA1047551 9673 170 1.533333 2.6066661 Deinococcus 1298 Bacteria Bacteria 121 3.84e-23   NTclustered gi|2444120906|gb|CP115165.1| 328692 g9546 i0 79.762 75.5294117647059 168 32 100 2 1 167 716006 716172 Deinococcus aquaticus strain PB-314 chromosome, complete genome blastn 12840 121 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus
16751468 16751468 PRJNA1047551_S_NODE_174_length_927_cov_16.293722_g112_i0 PRJNA1047551 174 927 16.293722 151.04280294 Trueperaceae bacterium 2026798 Bacteria Bacteria 1171 0   NTclustered gi|2621701816|emb|OY759346.1| 2026798 g112 i0 89.368 582.477885652643 950 75 99 10 3 927 3600154 3601102 MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1 blastn 539957 1171 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
16751474 16751474 PRJNA1047551_S_NODE_1894_length_325_cov_10.906897_g1767_i0 PRJNA1047551 1894 325 10.906897 35.44741525 Deinococcus sp. QL22 2939437 Bacteria Bacteria 494 4.22e-135   NTclustered gi|2238957582|gb|CP097149.1| 2939437 g1767 i0 94.953 167.744615384615 317 13 97 3 1 316 1362216 1362530 Deinococcus sp. QL22 chromosome, complete genome blastn 54517 494 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. QL22
22686681 22686681 PRJNA1047551_S_NODE_118_length_1044_cov_10.044599_g69_i0 PRJNA1047551 118 1044 10.044599 104.86561356 Deinococcus 1298 Bacteria Bacteria 1592 0   NTclustered gi|730601855|gb|CP010028.1| 57497 g69 i0 94.676 323.858237547893 1033 43 98 10 1 1024 69897 68868 Deinococcus swuensis strain DY59, complete genome blastn 338108 1592 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiopugnans
23126870 23126870 PRJNA1047551_S_NODE_2679_length_279_cov_15.696721_g2552_i0 PRJNA1047551 2679 279 15.696721 43.79385159 Trueperaceae bacterium 2026798 Bacteria Bacteria 340 4.899999999999999e-89   NTclustered gi|2108366028|gb|CP070651.1| 2026798 g2552 i0 89.888 123.161290322581 267 24 95 2 15 279 8172 7907 MAG: Trueperaceae bacterium isolate bin86 chromosome blastn 34362 340 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
23962291 23962291 PRJNA1047551_S_NODE_2039_length_314_cov_12.286738_g1912_i0 PRJNA1047551 2039 314 12.286738 38.58035732 Deinococcus 1298 Bacteria Bacteria 481 3.16e-131   NTclustered gi|730601855|gb|CP010028.1| 57497 g1912 i0 94.268 470.585987261146 314 18 100 0 1 314 70253 69940 Deinococcus swuensis strain DY59, complete genome blastn 147764 481 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiopugnans
25236149 25236149 PRJNA1047551_S_NODE_1880_length_326_cov_17.745704_g1753_i0 PRJNA1047551 1880 326 17.745704 57.85099504 Deinococcus 1298 Bacteria Bacteria 575 1.4699999999999996e-159   NTclustered gi|470478007|ref|NR_076423.1| 68909 g1753 i0 99.682 214.5 314 1 96 0 12 325 1630 1317 Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence blastn 69927 575 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus geothermalis

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