RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA289590" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA289590 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
22048821 22048821 PRJNA289590_P_NODE_14898_length_234_cov_1.405405_g14674_i0 PRJNA289590 14898 234 1.405405 3.2886477 Pseudomonadati 3379134 Bacteria Bacteria 150 1.36e-41   NR WP_028579926.1 231447 g14674 i0 90.9 19.7435897435897 77 7 98.7 0 233 3 165 241 WP_028579926.1 nucleotide 5'-monophosphate nucleosidase PpnN [Desulfogranum japonicum] diamond 4620 151 0.993377483443709 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfogranum Desulfogranum japonicum
28053200 28053200 PRJNA289590_P_NODE_15745_length_227_cov_2.078652_g15521_i0 PRJNA289590 15745 227 2.078652 4.71854004 Smithella sp. 2053614 Bacteria Bacteria 44.3 0.00795   NR MDI6743381.1 2053614 g15521 i0 29.3 0.991189427312775 75 53 99.1 0 226 2 17 91 MDI6743381.1 hypothetical protein [Smithella sp.] diamond 225 44.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Smithellaceae Smithella Smithella sp.
28116367 28116367 PRJNA289590_P_NODE_3445_length_567_cov_1.783784_g3229_i0 PRJNA289590 3445 567 1.783784 10.11405528 Geobacter sp. 46610 Bacteria Bacteria 49.7 0.00211   NR MSM40557.1 46610 g3229 i0 50 0.222222222222222 42 21 22.2 0 2 127 79 120 MSM40557.1 hypothetical protein [Geobacter sp.] diamond 126 49.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter sp.
29252873 29252873 PRJNA289590_P_NODE_5489_length_419_cov_1.091892_g5265_i0 PRJNA289590 5489 419 1.091892 4.57502748 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 51.6 2.64e-5   NR RJP93717.1 2049433 g5265 i0 34.7 0.68019093078759 95 59 67.3 2 88 369 2 94 RJP93717.1 MAG: hypothetical protein C4518_05915 [Desulfobacteraceae bacterium] diamond 285 51.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
29442296 29442296 PRJNA289590_P_NODE_22310_length_187_cov_1.130435_g22086_i0 PRJNA289590 22310 187 1.130435 2.11391345 Desulfogranum mediterraneum 160661 Bacteria Bacteria 70.1 9.81e-13   NR WP_028584170.1 160661 g22086 i0 60.8 1.62032085561497 51 20 81.8 0 154 2 1 51 WP_028584170.1 PolC-type DNA polymerase III [Desulfogranum mediterraneum] diamond 303 70.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfogranum Desulfogranum mediterraneum
29505596 29505596 PRJNA289590_P_NODE_26790_length_168_cov_0.873950_g26566_i0 PRJNA289590 26790 168 0.87395 1.468236 Desulfomicrobium orale 132132 Bacteria Bacteria 47.4 3.07e-4   NR WP_083518101.1 132132 g26566 i0 48.7 2.23214285714286 39 20 69.6 0 3 119 322 360 WP_083518101.1 DNA-processing protein DprA [Desulfomicrobium orale] diamond 375 47.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium orale
31545698 31545698 PRJNA289590_P_NODE_26136_length_169_cov_0.866667_g25912_i0 PRJNA289590 26136 169 0.866667 1.46466723 Pseudomonadati 3379134 Bacteria Bacteria 72 6.49e-13   NR HAJ28528.1 48412 g25912 i0 62.5 11.9289940828402 56 21 99.4 0 168 1 437 492 HAJ28528.1 adenosine deaminase [Syntrophus sp. (in: bacteria)] diamond 2016 72 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophia Syntrophales Syntrophaceae Syntrophus Syntrophus sp. (in: bacteria)

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