RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA666695" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 7 ✖

bioproject 1

  • PRJNA666695 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
2437766 2437766 PRJNA666695_S_NODE_136342_length_187_cov_3.116438_g135248_i0 PRJNA666695 136342 187 3.116438 5.82773906 Deinococcus 1298 Bacteria Bacteria 346 6.56e-91   NTclustered gi|2113031129|gb|OK500351.1| 47478 g135248 i0 100 103.823529411765 187 0 100 0 1 187 214 28 Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence blastn 19415 346 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
3714612 3714612 PRJNA666695_S_NODE_30203_length_355_cov_12.222930_g29109_i0 PRJNA666695 30203 355 12.22293 43.3914015 Bacteria 2 Bacteria Bacteria 58.4 7.22e-4   NTclustered gi|1751871007|dbj|AP021849.1| 57498 g29109 i0 87.755 0.611267605633803 49 6 14 0 272 320 1264762 1264714 Deinococcus grandis ATCC 43672 DNA, complete genome blastn 217 58.4 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
10091331 10091331 PRJNA666695_S_NODE_175208_length_161_cov_3.066667_g174114_i0 PRJNA666695 175208 161 3.066667 4.93733387 Deinococcus 1298 Bacteria Bacteria 237 3.44e-58   NTclustered gi|821341785|gb|CP011389.1| 1309411 g174114 i0 93.21 281.111801242236 162 10 100 1 1 161 1637763 1637924 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 45259 237 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
10091707 10091707 PRJNA666695_S_NODE_54128_length_284_cov_4.934156_g53034_i0 PRJNA666695 54128 284 4.934156 14.01300304 Thermosipho 2420 Bacteria Bacteria 52.8 0.026   NTclustered gi|1042792521|gb|CP007121.1| 1437364 g53034 i0 96.875 0.225352112676056 32 0 11 1 22 53 314545 314575 Thermosipho sp. 1070 chromosome, complete genome blastn 64 52.8 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Thermosipho Thermosipho sp. 1070
13916803 13916803 PRJNA666695_S_NODE_191551_length_152_cov_2.369369_g190457_i0 PRJNA666695 191551 152 2.369369 3.60144088 Deinococcus 1298 Bacteria Bacteria 281 1.46e-71   NTclustered gi|821341785|gb|CP011389.1| 1309411 g190457 i0 100 185.039473684211 152 0 100 0 1 152 1636181 1636332 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 28126 281 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
17740487 17740487 PRJNA666695_S_NODE_144794_length_181_cov_2.292857_g143700_i0 PRJNA666695 144794 181 2.292857 4.15007117 Deinococcus 1298 Bacteria Bacteria 335 1.36e-87   NTclustered gi|821341785|gb|CP011389.1| 1309411 g143700 i0 100 205 181 0 100 0 1 181 1636755 1636935 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 37105 335 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
21034764 21034764 PRJNA666695_S_NODE_36597_length_331_cov_2.062069_g35503_i0 PRJNA666695 36597 331 2.062069 6.82544839 Deinococcus soli (ex Cha et al. 2016) 1309411 Bacteria Bacteria 606 5.299999999999998e-169   NTclustered gi|821341785|gb|CP011389.1| 1309411 g35503 i0 99.698 209.075528700906 331 1 100 0 1 331 1638529 1638859 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 69204 606 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)

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