RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA1097627" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 8 ✖

bioproject 1

  • PRJNA1097627 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
205241 205241 PRJNA1097627_P_NODE_166901_length_247_cov_0.885057_g166608_i0 PRJNA1097627 166901 247 0.885057 2.18609079 Deinococcus wulumuqiensis 980427 Bacteria Bacteria 329 9.21e-86   NTclustered gi|1819264112|gb|CP049360.1| 1288484 g166608 i0 90.688 1 247 23 100 0 1 247 10457 10703 Deinococcus wulumuqiensis R12 plasmid unnamed3, complete sequence blastn 247 329 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis
1478752 1478752 PRJNA1097627_P_NODE_142262_length_251_cov_0.865169_g141969_i0 PRJNA1097627 142262 251 0.865169 2.17157419 Deinococcus aquaticus 328692 Bacteria Bacteria 414 2.52e-111   NTclustered gi|2444120906|gb|CP115165.1| 328692 g141969 i0 96.414 1.98804780876494 251 9 100 0 1 251 2137226 2137476 Deinococcus aquaticus strain PB-314 chromosome, complete genome blastn 499 414 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus
2295192 2295192 PRJNA1097627_P_NODE_173642_length_245_cov_1.790698_g173349_i0 PRJNA1097627 173642 245 1.790698 4.3872101 Deinococcus 1298 Bacteria Bacteria 254 5.65e-63   NTclustered gi|1220362168|gb|CP021081.1| 317577 g173349 i0 100 213.024489795918 137 0 100 0 1 137 2341046 2340910 Deinococcus ficus strain CC-FR2-10, complete genome blastn 52191 254 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus
3570328 3570328 PRJNA1097627_P_NODE_90683_length_280_cov_1.057971_g90390_i0 PRJNA1097627 90683 280 1.057971 2.9623188 Deinococcus 1298 Bacteria Bacteria 512 9.85e-141   NTclustered gi|2706837832|gb|CP149782.1| 3112952 g90390 i0 99.643 17.2071428571429 280 1 100 0 1 280 124627 124348 Deinococcus sp. VB142 chromosome 1, complete sequence blastn 4818 512 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. VB142
9130099 9130099 PRJNA1097627_P_NODE_107168_length_269_cov_1.403061_g106875_i0 PRJNA1097627 107168 269 1.403061 3.77423409 Deinococcus aquaticus 328692 Bacteria Bacteria 372 1.67e-98   NTclustered gi|2444120906|gb|CP115165.1| 328692 g106875 i0 92.045 7.35687732342007 264 21 98 0 6 269 2154583 2154320 Deinococcus aquaticus strain PB-314 chromosome, complete genome blastn 1979 372 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus
10407487 10407487 PRJNA1097627_P_NODE_142869_length_251_cov_0.865169_g142576_i0 PRJNA1097627 142869 251 0.865169 2.17157419 Deinococcus soli (ex Cha et al. 2016) 1309411 Bacteria Bacteria 353 5.569999999999998e-93   NTclustered gi|821341785|gb|CP011389.1| 1309411 g142576 i0 92.032 2.00398406374502 251 20 100 0 1 251 2054095 2053845 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 503 353 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
21421782 21421782 PRJNA1097627_P_NODE_188297_length_243_cov_0.905882_g188004_i0 PRJNA1097627 188297 243 0.905882 2.20129326 Deinococcus 1298 Bacteria Bacteria 444 3.09e-120   NTclustered gi|470486828|ref|NR_076782.1| 502394 g188004 i0 99.588 357.864197530864 243 1 100 0 1 243 464 706 Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence blastn 86961 444 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus gobiensis
21881505 21881505 PRJNA1097627_P_NODE_154818_length_249_cov_0.875000_g154525_i0 PRJNA1097627 154818 249 0.875 2.17875 Deinococcus wulumuqiensis 980427 Bacteria Bacteria 455 1.47e-123   NTclustered gi|1819261009|gb|CP049357.1| 1288484 g154525 i0 99.598 22.3815261044177 249 1 100 0 1 249 571966 572214 Deinococcus wulumuqiensis R12 chromosome, complete genome blastn 5573 455 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis

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