RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJDB12578" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJDB12578 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
15305704 15305704 PRJDB12578_S_NODE_186853_length_173_cov_1.258065_g163795_i0 PRJDB12578 186853 173 1.258065 2.17645245 Desulfovibrionaceae 194924 Bacteria Bacteria 99.4 2.93e-23   NR CAK7055204.1 885 g163795 i0 78.9 8.82658959537572 57 12 98.8 0 3 173 202 258 CAK7055204.1 MAG: Delta-aminolevulinic acid dehydratase [Desulfovibrio sp.] diamond 1527 100 0.994 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
28674701 28674701 PRJDB12578_S_NODE_215067_length_162_cov_0.876106_g192009_i0 PRJDB12578 215067 162 0.876106 1.41929172 Desulfovibrionaceae bacterium 2049043 Bacteria Bacteria 49.7 1.75e-5   NR PWL62770.1 2049043 g192009 i0 68.8 0.592592592592593 32 10 59.3 0 65 160 10 41 PWL62770.1 MAG: 7-cyano-7-deazaguanine reductase [Desulfovibrionaceae bacterium] diamond 96 49.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae   Desulfovibrionaceae bacterium
28953176 28953176 PRJDB12578_S_NODE_184168_length_175_cov_1.222222_g161110_i0 PRJDB12578 184168 175 1.222222 2.1388885 Desulfovibrionaceae 194924 Bacteria Bacteria 61.6 1.92e-9   NR MFR8276335.1 44742 g161110 i0 66.7 5.74285714285714 57 19 97.7 0 175 5 161 217 MFR8276335.1 methyl-accepting chemotaxis protein [Desulfovibrio fairfieldensis] diamond 1005 62 0.993548387096774 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio fairfieldensis
29969185 29969185 PRJDB12578_S_NODE_211651_length_163_cov_0.894737_g188593_i0 PRJDB12578 211651 163 0.894737 1.45842131 Lawsonia intracellularis 29546 Bacteria Bacteria 66.2 1.39e-11   NR WP_011526779.1 29546 g188593 i0 83.3 0.552147239263804 30 5 55.2 0 162 73 162 191 WP_011526779.1 rubrerythrin [Lawsonia intracellularis] diamond 90 66.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Lawsonia Lawsonia intracellularis
30126909 30126909 PRJDB12578_S_NODE_129232_length_228_cov_0.865922_g106174_i0 PRJDB12578 129232 228 0.865922 1.97430216 Desulfobulbaceae bacterium 2053307 Bacteria Bacteria 43.9 0.0118   NR MCB2183425.1 2053307 g106174 i0 41.2 0.671052631578947 51 30 67.1 0 68 220 509 559 MCB2183425.1 hypothetical protein [Desulfobulbaceae bacterium] diamond 153 43.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae   Desulfobulbaceae bacterium
30190273 30190273 PRJDB12578_S_NODE_205412_length_165_cov_0.887931_g182354_i0 PRJDB12578 205412 165 0.887931 1.46508615 Lawsonia intracellularis 29546 Bacteria Bacteria 97.4 8.13e-24   NR WP_083687789.1 29546 g182354 i0 81.8 1 55 10 100 0 1 165 106 160 WP_083687789.1 SycD/LcrH family type III secretion system chaperone [Lawsonia intracellularis] diamond 165 97.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Lawsonia Lawsonia intracellularis
30474838 30474838 PRJDB12578_S_NODE_127093_length_231_cov_1.417582_g104035_i0 PRJDB12578 127093 231 1.417582 3.27461442 Lawsonia intracellularis 29546 Bacteria Bacteria 107 3.4899999999999998e-25   NR WP_011526545.1 29546 g104035 i0 74.6 0.922077922077922 71 17 92.2 1 17 229 3 72 WP_011526545.1 outer membrane homotrimeric porin [Lawsonia intracellularis] diamond 213 107 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Lawsonia Lawsonia intracellularis
30500492 30500492 PRJDB12578_S_NODE_202593_length_166_cov_0.871795_g179535_i0 PRJDB12578 202593 166 0.871795 1.4471797 Desulfovibrio 872 Bacteria Bacteria 96.7 1.0999999999999998e-24   NR PWL63554.1 2049043 g179535 i0 77.8 4.87951807228916 54 12 97.6 0 3 164 11 64 PWL63554.1 MAG: 30S ribosomal protein S16 [Desulfovibrionaceae bacterium] diamond 810 97.1 0.995880535530381 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae   Desulfovibrionaceae bacterium
30506386 30506386 PRJDB12578_S_NODE_188073_length_172_cov_1.674797_g165015_i0 PRJDB12578 188073 172 1.674797 2.88065084 Lawsonia intracellularis 29546 Bacteria Bacteria 110 2.51e-28   NR WP_011526689.1 29546 g165015 i0 98.2 0.976744186046512 56 1 97.7 0 170 3 44 99 WP_011526689.1 GntR family transcriptional regulator [Lawsonia intracellularis] diamond 168 110 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Lawsonia Lawsonia intracellularis
30695812 30695812 PRJDB12578_S_NODE_136374_length_218_cov_1.514793_g113316_i0 PRJDB12578 136374 218 1.514793 3.30224874 Lawsonia intracellularis 29546 Bacteria Bacteria 54.3 2.21e-6   NR WP_076628025.1 29546 g113316 i0 80 0.412844036697248 30 6 41.3 0 216 127 450 479 WP_076628025.1 amino acid permease [Lawsonia intracellularis] diamond 90 54.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Lawsonia Lawsonia intracellularis
30727430 30727430 PRJDB12578_S_NODE_70254_length_494_cov_2.849438_g47264_i0 PRJDB12578 70254 494 2.849438 14.07622372 Lawsonia intracellularis 29546 Bacteria Bacteria 116 9.47e-27   NR WP_076628963.1 29546 g47264 i0 39 0.995951417004049 164 81 97.8 3 494 12 889 1036 WP_076628963.1 autotransporter outer membrane beta-barrel domain-containing protein [Lawsonia intracellularis] diamond 492 116 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Lawsonia Lawsonia intracellularis
32650067 32650067 PRJDB12578_S_NODE_194060_length_169_cov_0.866667_g171002_i0 PRJDB12578 194060 169 0.866667 1.46466723 Pseudomonadati 3379134 Bacteria Bacteria 51.2 2.9e-6   NR CAK7048284.1 885 g171002 i0 92.3 3.63905325443787 26 2 46.2 0 90 167 1 26 CAK7048284.1 MAG: 30S ribosomal protein S8 [Desulfovibrio sp.] diamond 615 51.6 0.992248062015504 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
32687592 32687592 PRJDB12578_S_NODE_128880_length_228_cov_1.720670_g105822_i0 PRJDB12578 128880 228 1.72067 3.9231276 Lawsonia intracellularis 29546 Bacteria Bacteria 125 1.64e-33   NR WP_011526823.1 29546 g105822 i0 85.5 2.75 69 10 90.8 0 211 5 1 69 WP_011526823.1 flagellar basal-body rod protein FlgF [Lawsonia intracellularis] diamond 627 125 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Lawsonia Lawsonia intracellularis

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