RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 6 ✖

bioproject 1

  • PRJNA725806 · 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
711914 711914 PRJNA725806_P_NODE_51441_length_246_cov_5.282297_g51144_i0 PRJNA725806 51441 246 5.282297 12.99445062 Tepiditoga spiralis 2108365 Bacteria Bacteria 52.8 0.022   NTclustered gi|1898704378|dbj|AP018712.1| 2108365 g51144 i0 100 0.113821138211382 28 0 11 0 43 70 2047958 2047931 Tepiditoga spiralis sy52 DNA, complete genome blastn 28 52.8 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Tepiditoga Tepiditoga spiralis
3263061 3263061 PRJNA725806_P_NODE_137223_length_175_cov_1.398551_g136921_i0 PRJNA725806 137223 175 1.398551 2.44746425 Deinococcus aquaticus 328692 Bacteria Bacteria 237 3.7900000000000005e-58   NTclustered gi|2444120906|gb|CP115165.1| 328692 g136921 i0 95.302 0.851428571428571 149 7 85 0 26 174 3055690 3055542 Deinococcus aquaticus strain PB-314 chromosome, complete genome blastn 149 237 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus
6298583 6298583 PRJNA725806_P_NODE_725_length_791_cov_2858.694960_g572_i0 PRJNA725806 725 791 2858.69496 22612.2771336 Bacteria 2 Bacteria Bacteria 883 0   NTclustered gi|155128|gb|J04639.1|TTHTAQP1A 271 g572 i0 100 58.4778761061947 478 0 89 0 39 516 604 127 Thermus aquaticus DNA polymerase (PolI) gene blastn 46256 883 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus
9640231 9640231 PRJNA725806_P_NODE_111028_length_190_cov_1.000000_g110726_i0 PRJNA725806 111028 190 1 1.9 Deinococcus radiomollis 468916 Bacteria Bacteria 211 2.54e-50   NTclustered gi|2865414619|gb|CP129909.1| 468916 g110726 i0 86.772 12.9263157894737 189 25 99 0 1 189 71157 70969 Deinococcus radiomollis strain PO-04-20-132 plasmid unnamed3, complete sequence blastn 2456 211 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiomollis
10915881 10915881 PRJNA725806_P_NODE_177549_length_157_cov_1.216667_g177247_i0 PRJNA725806 177549 157 1.216667 1.91016719 Aminobacterium sp. MB27-C1 3070661 Bacteria Bacteria 56.5 0.001   NTclustered gi|2569590977|gb|CP133089.1| 3070661 g177247 i0 100 0.191082802547771 30 0 19 0 87 116 1565292 1565263 Aminobacterium sp. MB27-C1 chromosome, complete genome blastn 30 56.5 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Aminobacterium Aminobacterium sp. MB27-C1
17289720 17289720 PRJNA725806_P_NODE_109114_length_191_cov_2.467532_g108812_i0 PRJNA725806 109114 191 2.467532 4.71298612 Deinococcus altitudinis 468914 Bacteria Bacteria 320 4.08e-83   NTclustered gi|2865404944|gb|CP129415.1| 468914 g108812 i0 96.891 486.895287958115 193 2 100 4 1 191 413725 413535 Deinococcus altitudinis strain LMG 24022 chromosome, complete genome blastn 92997 320 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus altitudinis

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