RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA789095" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 6 ✖

bioproject 1

  • PRJNA789095 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
2047759 2047759 PRJNA789095_P_NODE_81382_length_207_cov_4.671642_g80048_i0 PRJNA789095 81382 207 4.671642 9.67029894 Deinococcus geothermalis 68909 Bacteria Bacteria 383 5.65e-102   NTclustered gi|110746139|gb|CP000358.2| 319795 g80048 i0 100 1 207 0 100 0 1 207 327239 327445 Deinococcus geothermalis DSM 11300 plasmid pDGEO01, complete sequence blastn 207 383 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus geothermalis
12251048 12251048 PRJNA789095_P_NODE_70710_length_246_cov_0.890173_g69376_i0 PRJNA789095 70710 246 0.890173 2.18982558 Deinococcus metallilatus 1211322 Bacteria Bacteria 344 3.27e-90   NTclustered gi|1609451317|gb|CP038512.1| 1211322 g69376 i0 91.87 59.2926829268293 246 20 100 0 1 246 2590117 2589872 Deinococcus metallilatus strain MA1002 chromosome blastn 14586 344 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus metallilatus
13968459 13968459 PRJNA789095_P_NODE_71591_length_245_cov_1.476744_g70257_i0 PRJNA789095 71591 245 1.476744 3.6180228 Truepera 332248 Bacteria Bacteria 206 1.6e-48   NTclustered gi|2573973991|gb|CP133611.1| 332249 g70257 i0 84.541 1.70204081632653 207 32 84 0 35 241 684096 684302 Truepera radiovictrix strain CIP 108686 chromosome, complete genome blastn 417 206 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
16074384 16074384 PRJNA789095_P_NODE_81613_length_204_cov_6.175573_g80279_i0 PRJNA789095 81613 204 6.175573 12.59816892 Deinococcus psychrotolerans 2489213 Bacteria Bacteria 54.7 0.005   NTclustered gi|1527207915|gb|CP034189.1| 2489213 g80279 i0 94.286 0.17156862745098 35 2 17 0 136 170 24867 24833 Deinococcus psychrotolerans strain S14-83 plasmid unnamed5, complete sequence blastn 35 54.7 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus psychrotolerans
16517440 16517440 PRJNA789095_P_NODE_77973_length_232_cov_11.100629_g76639_i0 PRJNA789095 77973 232 11.100629 25.75345928 Thermus 270 Bacteria Bacteria 429 8.2e-116   NTclustered gi|2199643112|dbj|AP025618.1| 274 g76639 i0 100 6 232 0 100 0 1 232 84820 84589 Thermus thermophilus SNM7-6 plasmid pTthSNM7-6b DNA, complete sequence blastn 1392 429 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus thermophilus
24997952 24997952 PRJNA789095_P_NODE_70120_length_247_cov_0.885057_g68786_i0 PRJNA789095 70120 247 0.885057 2.18609079 Deinococcus geothermalis 68909 Bacteria Bacteria 379 9.02e-101   NTclustered gi|94554390|gb|CP000359.1| 319795 g68786 i0 94.332 4.40485829959514 247 14 100 0 1 247 1104034 1103788 Deinococcus geothermalis DSM 11300, complete genome blastn 1088 379 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus geothermalis

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