RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA983838" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 5 ✖

bioproject 1

  • PRJNA983838 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
5099740 5099740 PRJNA983838_P_NODE_78664_length_304_cov_0.900433_g76297_i0 PRJNA983838 78664 304 0.900433 2.73731632 Deinococcus 1298 Bacteria Bacteria 562 1.06e-155   NTclustered gi|1487580586|gb|MK027351.1| 47478 g76297 i0 100 102.023026315789 304 0 100 0 1 304 77 380 Deinococcus sp. strain RMD51.1A 16S ribosomal RNA gene, partial sequence blastn 31015 562 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
7649360 7649360 PRJNA983838_P_NODE_103726_length_253_cov_3.561111_g101359_i0 PRJNA983838 103726 253 3.561111 9.00961083 Truepera 332248 Bacteria Bacteria 351 2.02e-92   NTclustered gi|470486385|ref|NR_076754.1| 332249 g101359 i0 91.7 393.533596837945 253 21 100 0 1 253 833 581 Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence blastn 99564 351 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
11475105 11475105 PRJNA983838_P_NODE_124049_length_211_cov_4.898551_g121681_i0 PRJNA983838 124049 211 4.898551 10.33594261 Deinococcus 1298 Bacteria Bacteria 390 3.459999999999999e-104   NTclustered gi|1192789104|gb|KY744731.1| 47478 g121681 i0 100 102.127962085308 211 0 100 0 1 211 623 413 Deinococcus sp. strain 16B18A 16S ribosomal RNA gene, partial sequence blastn 21549 390 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
20092425 20092425 PRJNA983838_P_NODE_89236_length_279_cov_2.072816_g86869_i0 PRJNA983838 89236 279 2.072816 5.78315664 Deinococcus taeanensis 2737050 Bacteria Bacteria 503 5.9e-138   NTclustered gi|2105694697|gb|CP083456.1| 2737050 g86869 i0 100 204.752688172043 272 0 97 0 8 279 1594 1323 Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence blastn 57126 503 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus taeanensis
23917883 23917883 PRJNA983838_P_NODE_47979_length_446_cov_2.131367_g45613_i0 PRJNA983838 47979 446 2.131367 9.50589682 Deinococcus ficus 317577 Bacteria Bacteria 808 0   NTclustered gi|1220362168|gb|CP021081.1| 317577 g45613 i0 99.327 216.284753363229 446 3 100 0 1 446 2342190 2341745 Deinococcus ficus strain CC-FR2-10, complete genome blastn 96463 808 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus

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