RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA624323" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 12 ✖

bioproject 1

  • PRJNA624323 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
4423971 4423971 PRJNA624323_P_NODE_8244_length_249_cov_0.875000_g8082_i0 PRJNA624323 8244 249 0.875 2.17875 Deinococcus soli (ex Cha et al. 2016) 1309411 Bacteria Bacteria 444 3.18e-120   NTclustered gi|821341785|gb|CP011389.1| 1309411 g8082 i0 98.795 38.144578313253 249 3 100 0 1 249 1043776 1043528 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 9498 444 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
6974823 6974823 PRJNA624323_P_NODE_7966_length_251_cov_0.865169_g7804_i0 PRJNA624323 7966 251 0.865169 2.17157419 Deinococcus aquaticus 328692 Bacteria Bacteria 281 2.66e-71   NTclustered gi|2444120906|gb|CP115165.1| 328692 g7804 i0 87.059 166.605577689243 255 25 100 4 1 251 715954 716204 Deinococcus aquaticus strain PB-314 chromosome, complete genome blastn 41818 281 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus
7527997 7527997 PRJNA624323_P_NODE_8286_length_249_cov_0.875000_g8124_i0 PRJNA624323 8286 249 0.875 2.17875 Deinococcus 1298 Bacteria Bacteria 385 1.96e-102   NTclustered gi|1751871007|dbj|AP021849.1| 57498 g8124 i0 95.082 17.2489959839357 244 12 98 0 6 249 1614904 1615147 Deinococcus grandis ATCC 43672 DNA, complete genome blastn 4295 385 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
10078672 10078672 PRJNA624323_P_NODE_5708_length_302_cov_3.903930_g5546_i0 PRJNA624323 5708 302 3.90393 11.7898686 Allomeiothermus 2935559 Bacteria Bacteria 291 5.47e-74   NTclustered gi|470486339|ref|NR_076751.1| 52022 g5546 i0 84.106 160.211920529801 302 46 100 2 1 302 18 317 Meiothermus silvanus strain DSM 9946 23S ribosomal RNA gene, complete sequence blastn 48384 291 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Allomeiothermus Allomeiothermus silvanus
11353559 11353559 PRJNA624323_P_NODE_2189_length_498_cov_9.912941_g2029_i0 PRJNA624323 2189 498 9.912941 49.36644618 Truepera 332248 Bacteria Bacteria 654 0   NTclustered gi|470486385|ref|NR_076754.1| 332249 g2029 i0 90.361 348.666666666667 498 48 100 0 1 498 5 502 Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence blastn 173636 654 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
11353566 11353566 PRJNA624323_P_NODE_4089_length_361_cov_3.868056_g3927_i0 PRJNA624323 4089 361 3.868056 13.96368216 Deinococcus 1298 Bacteria Bacteria 662 0   NTclustered gi|1435316362|gb|CP031158.1| 980427 g3927 i0 99.723 180.135734072022 361 1 100 0 1 361 1792654 1793014 Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome blastn 65029 662 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis
13350577 13350577 PRJNA624323_P_NODE_9471_length_241_cov_0.916667_g9309_i0 PRJNA624323 9471 241 0.916667 2.20916747 Deinococcus actinosclerus 1768108 Bacteria Bacteria 412 8.64e-111   NTclustered gi|972944657|gb|CP013910.1| 1768108 g9309 i0 97.51 10.9709543568465 241 6 100 0 1 241 1383402 1383162 Deinococcus actinosclerus strain BM2 chromosome, complete genome blastn 2644 412 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus actinosclerus
13904070 13904070 PRJNA624323_P_NODE_2531_length_462_cov_4.573265_g2370_i0 PRJNA624323 2531 462 4.573265 21.1284843 Meiothermus 65551 Bacteria Bacteria 619 9.8e-173   NTclustered gi|470485054|ref|NR_076682.1| 277 g2370 i0 90.909 185.982683982684 462 41 100 1 1 462 1452 992 Meiothermus ruber strain DSM 1279 23S ribosomal RNA gene, complete sequence blastn 85924 619 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus Meiothermus ruber
14625280 14625280 PRJNA624323_P_NODE_4172_length_357_cov_3.929577_g4010_i0 PRJNA624323 4172 357 3.929577 14.02858989 Deinococcus sp. NW-56 2080419 Bacteria Bacteria 501 2.79e-137   NTclustered gi|1339790003|gb|CP026516.1| 2080419 g4010 i0 92.437 319.764705882353 357 18 100 4 1 357 544408 544061 Deinococcus sp. NW-56 chromosome, complete genome blastn 114156 501 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. NW-56
17174246 17174246 PRJNA624323_P_NODE_5674_length_303_cov_2.817391_g5512_i0 PRJNA624323 5674 303 2.817391 8.53669473 Deinococcus soli (ex Cha et al. 2016) 1309411 Bacteria Bacteria 375 1.4699999999999999e-99   NTclustered gi|821341785|gb|CP011389.1| 1309411 g5512 i0 89.769 5.76897689768977 303 18 100 8 1 303 2238754 2238465 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 1748 375 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
19001600 19001600 PRJNA624323_P_NODE_415_length_1017_cov_4.504237_g313_i0 PRJNA624323 415 1017 4.504237 45.80809029 Truepera 332248 Bacteria Bacteria 1303 0   NTclustered gi|470486385|ref|NR_076754.1| 332249 g313 i0 89.712 370.577187807276 1040 80 100 19 1 1017 1732 697 Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence blastn 376877 1312 0.993140243902439 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
25376566 25376566 PRJNA624323_P_NODE_3500_length_393_cov_2.984375_g3339_i0 PRJNA624323 3500 393 2.984375 11.72859375 Meiothermus 65551 Bacteria Bacteria 593 4.979999999999999e-165   NTclustered gi|470485054|ref|NR_076682.1| 277 g3339 i0 93.924 160.994910941476 395 20 100 4 1 393 2323 1931 Meiothermus ruber strain DSM 1279 23S ribosomal RNA gene, complete sequence blastn 63271 593 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus Meiothermus ruber

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