RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA861969" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 9 ✖

bioproject 1

  • PRJNA861969 · 9 ✖

analysis 1

  • blastn · 9 ✖

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
2121778 2121778 PRJNA861969_P_NODE_29782_length_254_cov_1.574586_g29551_i0 PRJNA861969 29782 254 1.574586 3.99944844 Deinococcus aquaticus 328692 Bacteria Bacteria 159 1.32e-34   NTclustered gi|2444120906|gb|CP115165.1| 328692 g29551 i0 84.81 0.622047244094488 158 24 62 0 1 158 298355 298512 Deinococcus aquaticus strain PB-314 chromosome, complete genome blastn 158 159 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus
2511938 2511938 PRJNA861969_P_NODE_26842_length_267_cov_1.376289_g26611_i0 PRJNA861969 26842 267 1.376289 3.67469163 Thermaceae 188786 Bacteria Bacteria 244 3.76e-60   NTclustered gi|2440484278|gb|CP046617.1| 88190 g26611 i0 99.259 14.8464419475655 135 1 76 0 1 135 2038041 2037907 Thermus antranikianii strain JCM 19900 chromosome, complete genome blastn 3964 246 0.991869918699187 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus antranikianii
3397002 3397002 PRJNA861969_P_NODE_22823_length_285_cov_2.000000_g22592_i0 PRJNA861969 22823 285 2 5.7 Trueperaceae bacterium 2026798 Bacteria Bacteria 363 1.07e-95   NTclustered gi|2108366028|gb|CP070651.1| 2026798 g22592 i0 90.036 231.642105263158 281 27 98 1 1 280 6807 6527 MAG: Trueperaceae bacterium isolate bin86 chromosome blastn 66018 363 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
4674840 4674840 PRJNA861969_P_NODE_28984_length_257_cov_2.244565_g28753_i0 PRJNA861969 28984 257 2.244565 5.76853205 Deinococcus wulumuqiensis 980427 Bacteria Bacteria 475 1.1699999999999999e-129   NTclustered gi|1435316362|gb|CP031158.1| 980427 g28753 i0 100 3.90661478599222 257 0 100 0 1 257 1731008 1731264 Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome blastn 1004 475 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis
13599991 13599991 PRJNA861969_P_NODE_24471_length_278_cov_1.297561_g24240_i0 PRJNA861969 24471 278 1.297561 3.60721958 Thermus brockianus 56956 Bacteria Bacteria 185 2.4199999999999998e-42   NTclustered gi|1102955210|gb|CP016312.1| 56956 g24240 i0 81.092 31.2769784172662 238 39 97 6 44 278 1534272 1534038 Thermus brockianus strain GE-1 chromosome, complete genome blastn 8695 185 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus brockianus
13599999 13599999 PRJNA861969_P_NODE_24851_length_276_cov_1.517241_g24620_i0 PRJNA861969 24851 276 1.517241 4.18758516 Deinococcus sp. AB2017081 3093660 Bacteria Bacteria 350 8.04e-92   NTclustered gi|2636768990|gb|CP140098.1| 3093660 g24620 i0 89.568 31.0579710144928 278 25 100 4 1 276 795798 796073 Deinococcus sp. AB2017081 chromosome, complete genome blastn 8572 350 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. AB2017081
14874565 14874565 PRJNA861969_P_NODE_38612_length_244_cov_0.900585_g38381_i0 PRJNA861969 38612 244 0.900585 2.1974274 Deinococcus wulumuqiensis 980427 Bacteria Bacteria 237 5.6600000000000005e-58   NTclustered gi|1819263924|gb|CP049359.1| 1288484 g38381 i0 92.262 0.688524590163934 168 12 68 1 76 242 118116 118283 Deinococcus wulumuqiensis R12 plasmid unnamed2, complete sequence blastn 168 237 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis
15264426 15264426 PRJNA861969_P_NODE_38292_length_244_cov_0.900585_g38061_i0 PRJNA861969 38292 244 0.900585 2.1974274 Thermus 270 Bacteria Bacteria 446 8.639999999999999e-121   NTclustered gi|2440484278|gb|CP046617.1| 88190 g38061 i0 99.59 11.4672131147541 244 1 100 0 1 244 241254 241497 Thermus antranikianii strain JCM 19900 chromosome, complete genome blastn 2798 446 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus antranikianii
19972883 19972883 PRJNA861969_P_NODE_24396_length_278_cov_1.502439_g24165_i0 PRJNA861969 24396 278 1.502439 4.17678042 Thermus brockianus 56956 Bacteria Bacteria 298 2.98e-76   NTclustered gi|1102955210|gb|CP016312.1| 56956 g24165 i0 85.971 2.88129496402878 278 39 100 0 1 278 453747 454024 Thermus brockianus strain GE-1 chromosome, complete genome blastn 801 298 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus brockianus

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