RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1022139 · 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
1003625 1003625 PRJNA1022139_P_NODE_35181_length_250_cov_0.870056_g35076_i0 PRJNA1022139 35181 250 0.870056 2.17514 Bacteria 2 Bacteria Bacteria 60.2 1.35e-4   NTclustered gi|2281898193|dbj|AP026561.1| 200252 g35076 i0 97.143 1.616 35 1 14 0 112 146 557645 557679 Deinococcus aetherius ST0316 plasmid pDAETH-1 DNA, complete genome blastn 404 60.2 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aetherius
6539821 6539821 PRJNA1022139_P_NODE_22366_length_297_cov_1.013393_g22261_i0 PRJNA1022139 22366 297 1.013393 3.00977721 Deinococcus irradiatisoli 2202254 Bacteria Bacteria 56.5 0.002   NTclustered gi|1392964945|gb|CP029494.1| 2202254 g22261 i0 100 0.101010101010101 30 0 10 0 52 81 933320 933349 Deinococcus irradiatisoli strain 17bor-2 chromosome, complete genome blastn 30 56.5 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus irradiatisoli
13756991 13756991 PRJNA1022139_P_NODE_38371_length_246_cov_1.780347_g38266_i0 PRJNA1022139 38371 246 1.780347 4.37965362 Thermus 270 Bacteria Bacteria 52.8 0.022   NTclustered gi|320149275|gb|CP001962.1| 743525 g38266 i0 100 0.341463414634146 28 0 11 0 2 29 2011832 2011805 Thermus scotoductus SA-01, complete genome blastn 84 52.8 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus scotoductus
14190264 14190264 PRJNA1022139_P_NODE_24132_length_288_cov_1.125581_g24027_i0 PRJNA1022139 24132 288 1.125581 3.24167328 Trueperaceae bacterium 2026798 Bacteria Bacteria 52.8 0.027   NTclustered gi|2621701816|emb|OY759346.1| 2026798 g24027 i0 96.774 0.107638888888889 31 1 11 0 151 181 3065471 3065501 MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1 blastn 31 52.8 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
18013639 18013639 PRJNA1022139_P_NODE_715_length_1326_cov_6.150838_g94_i1 PRJNA1022139 715 1326 6.150838 81.56011188 Deinococcus radiophilus 32062 Bacteria Bacteria 56.5 0.01   NTclustered gi|2152123021|gb|CP086380.1| 32062 g94 i1 96.97 0.0248868778280543 33 1 2 0 1217 1249 815816 815784 Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome blastn 33 56.5 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiophilus
23114122 23114122 PRJNA1022139_P_NODE_99_length_2294_cov_6.821702_g94_i0 PRJNA1022139 99 2294 6.821702 156.48984388 Deinococcus radiophilus 32062 Bacteria Bacteria 56.5 0.018   NTclustered gi|2152123021|gb|CP086380.1| 32062 g94 i0 96.97 0.0143853530950305 33 1 1 0 1217 1249 815816 815784 Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome blastn 33 56.5 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiophilus

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