RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA278119 · 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
1058846 1058846 PRJNA278119_P_NODE_29901_length_181_cov_1.189394_g29652_i0 PRJNA278119 29901 181 1.189394 2.15280314 Deinococcus 1298 Bacteria Bacteria 307 2.97e-79   NTclustered gi|443301156|gb|KC217187.1| 158789 g29652 i0 97.238 101.016574585635 181 5 100 0 1 181 187 7 Uncultured Deinococcus sp. clone DBW-375 16S ribosomal RNA gene, partial sequence blastn 18284 307 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus uncultured Deinococcus sp.
2922028 2922028 PRJNA278119_P_NODE_35263_length_169_cov_0.866667_g35014_i0 PRJNA278119 35263 169 0.866667 1.46466723 Deinococcus geothermalis 68909 Bacteria Bacteria 296 5.9e-76   NTclustered gi|94554390|gb|CP000359.1| 319795 g35014 i0 98.225 20.8402366863905 169 3 100 0 1 169 577261 577093 Deinococcus geothermalis DSM 11300, complete genome blastn 3522 296 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus geothermalis
2922112 2922112 PRJNA278119_P_NODE_42503_length_165_cov_0.879310_g42254_i0 PRJNA278119 42503 165 0.87931 1.4508615 Deinococcus wulumuqiensis 980427 Bacteria Bacteria 300 4.46e-77   NTclustered gi|1819261009|gb|CP049357.1| 1288484 g42254 i0 99.394 4.47878787878788 165 1 100 0 1 165 88768 88932 Deinococcus wulumuqiensis R12 chromosome, complete genome blastn 739 300 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis
3609340 3609340 PRJNA278119_P_NODE_30983_length_178_cov_1.248062_g30734_i0 PRJNA278119 30983 178 1.248062 2.22155036 Deinococcus 1298 Bacteria Bacteria 307 2.91e-79   NTclustered gi|1175903385|gb|KX886830.1| 47478 g30734 i0 97.753 104.005617977528 178 4 100 0 1 178 1254 1077 Deinococcus sp. strain MZDSW-14 16S ribosomal RNA gene, partial sequence blastn 18513 307 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
3609422 3609422 PRJNA278119_P_NODE_42703_length_164_cov_1.591304_g42454_i0 PRJNA278119 42703 164 1.591304 2.60973856 Deinococcus 1298 Bacteria Bacteria 231 1.6399999999999998e-56   NTclustered gi|470478007|ref|NR_076423.1| 68909 g42454 i0 92.169 197.670731707317 166 9 100 4 1 164 485 322 Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence blastn 32418 231 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus geothermalis
6749212 6749212 PRJNA278119_P_NODE_48146_length_154_cov_2.371429_g47897_i0 PRJNA278119 48146 154 2.371429 3.65200066 Deinococcus soli (ex Cha et al. 2016) 1309411 Bacteria Bacteria 274 2.48e-69   NTclustered gi|821341785|gb|CP011389.1| 1309411 g47897 i0 98.71 218.87012987013 155 0 100 2 1 154 1637403 1637250 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 33706 274 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
8024735 8024735 PRJNA278119_P_NODE_40467_length_166_cov_0.888889_g40218_i0 PRJNA278119 40467 166 0.888889 1.47555574 Thermus antranikianii 88190 Bacteria Bacteria 257 2.7400000000000003e-64   NTclustered gi|2049910225|gb|CP076325.1| 88190 g40218 i0 98.621 4.69879518072289 145 2 87 0 22 166 2393105 2392961 MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome blastn 780 257 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus antranikianii
8711419 8711419 PRJNA278119_P_NODE_22547_length_208_cov_1.962264_g22298_i0 PRJNA278119 22547 208 1.962264 4.08150912 Deinococcus 1298 Bacteria Bacteria 385 1.58e-102   NTclustered gi|470486828|ref|NR_076782.1| 502394 g22298 i0 100 207.177884615385 208 0 100 0 1 208 1922 2129 Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence blastn 43093 385 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus gobiensis
14400488 14400488 PRJNA278119_P_NODE_46832_length_162_cov_0.920354_g46583_i0 PRJNA278119 46832 162 0.920354 1.49097348 Deinococcus sp. NW-56 2080419 Bacteria Bacteria 209 7.56e-50   NTclustered gi|1339790003|gb|CP026516.1| 2080419 g46583 i0 90.506 0.975308641975309 158 15 98 0 5 162 213704 213861 Deinococcus sp. NW-56 chromosome, complete genome blastn 158 209 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. NW-56
22735562 22735562 PRJNA278119_P_NODE_20118_length_223_cov_1.132184_g19869_i0 PRJNA278119 20118 223 1.132184 2.52477032 Deinococcus 1298 Bacteria Bacteria 374 3.72e-99   NTclustered gi|2706837832|gb|CP149782.1| 3112952 g19869 i0 96.861 262.941704035874 223 7 100 0 1 223 1454249 1454027 Deinococcus sp. VB142 chromosome 1, complete sequence blastn 58636 374 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. VB142
22735730 22735730 PRJNA278119_P_NODE_44958_length_163_cov_0.912281_g44709_i0 PRJNA278119 44958 163 0.912281 1.48701803 Thermus 270 Bacteria Bacteria 302 1.22e-77   NTclustered gi|2049910225|gb|CP076325.1| 88190 g44709 i0 100 6 163 0 100 0 1 163 1619699 1619537 MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome blastn 978 302 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus antranikianii
24597686 24597686 PRJNA278119_P_NODE_6800_length_457_cov_1.169118_g6554_i0 PRJNA278119 6800 457 1.169118 5.34286926 Deinococcus sp. NW-56 2080419 Bacteria Bacteria 721 0   NTclustered gi|1339790003|gb|CP026516.1| 2080419 g6554 i0 96.347 215.030634573304 438 16 96 0 1 438 2417762 2417325 Deinococcus sp. NW-56 chromosome, complete genome blastn 98269 721 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. NW-56

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