RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA407368", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 6 ✖

tax_kingdom 1

  • Pseudomonadati · 6 ✖

bioproject 1

  • PRJNA407368 · 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
415062 415062 PRJNA407368_S_NODE_5101_length_245_cov_8.097222_g4999_i0 PRJNA407368 5101 245 8.097222 19.8381939 Trichloromonas sp. 3069249 Bacteria Bacteria 56.6 6.48e-8   NR MDY0270743.1 3069249 g4999 i0 39.3 0.746938775510204 61 37 74.7 0 60 242 55 115 MDY0270743.1 hypothetical protein [Trichloromonas sp.] diamond 183 56.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Trichloromonadaceae Trichloromonas Trichloromonas sp.
7459682 7459682 PRJNA407368_S_NODE_926_length_667_cov_10.985893_g855_i0 PRJNA407368 926 667 10.985893 73.27590631 Pseudomonadati 3379134 Bacteria Bacteria 76.8 3.94e-9   NTclustered gi|301638057|gb|CP002085.1| 644282 g855 i0 85.526 11.4152923538231 76 7 22 3 542 615 125050 125123 Desulfarculus baarsii DSM 2075, complete genome blastn 7614 76.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfarculia Desulfarculales Desulfarculaceae Desulfarculus Desulfarculus baarsii
29239564 29239564 PRJNA407368_S_NODE_2709_length_365_cov_10.476190_g2607_i0 PRJNA407368 2709 365 10.47619 38.2380935 Bacteria 2 Bacteria Bacteria 60.1 1.22e-7   NR MFC1885451.1 2202153 g2607 i0 34.2 10.3479452054795 114 68 92.1 2 20 355 382 490 MFC1885451.1 hypothetical protein [Thermodesulfobacteriota bacterium] diamond 3777 60.5 0.993388429752066 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
30960196 30960196 PRJNA407368_S_NODE_8834_length_170_cov_3.744681_g8732_i0 PRJNA407368 8834 170 3.744681 6.3659577 Desulfoglaeba alkanexedens 361111 Bacteria Bacteria 44.3 0.00401   NR WP_137424113.1 361111 g8732 i0 89.5 0.335294117647059 19 2 33.5 0 114 170 1 19 WP_137424113.1 hypothetical protein [Desulfoglaeba alkanexedens] diamond 57 44.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Syntrophobacteraceae Desulfoglaeba Desulfoglaeba alkanexedens
31687263 31687263 PRJNA407368_S_NODE_3137_length_334_cov_2.295082_g3035_i0 PRJNA407368 3137 334 2.295082 7.66557388 Desulfuromonadales bacterium 2099678 Bacteria Bacteria 50.1 1.45e-5   NR MEI6207278.1 2099678 g3035 i0 44.8 1.04191616766467 58 31 51.2 1 225 55 2 59 MEI6207278.1 hypothetical protein [Desulfuromonadales bacterium] diamond 348 50.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales     Desulfuromonadales bacterium
32400227 32400227 PRJNA407368_S_NODE_5979_length_220_cov_3.366492_g5877_i0 PRJNA407368 5979 220 3.366492 7.4062824 Pseudomonadati 3379134 Bacteria Bacteria 57.4 1.57e-7   NR MDR2744420.1 885 g5877 i0 71 3.96818181818182 31 9 42.3 0 128 220 16 46 MDR2744420.1 DNA adenine methylase [Desulfovibrio sp.] diamond 873 57.8 0.993079584775087 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.

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