RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA1118794" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1118794 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
1505448 1505448 PRJNA1118794_P_NODE_38022_length_273_cov_1.370000_g37272_i0 PRJNA1118794 38022 273 1.37 3.7401 Leptospiraceae bacterium 2026757 Bacteria Bacteria 184 1.5199999999999995e-55   NR MBL8032855.1 2026757 g37272 i0 97.8 1 91 2 100 0 1 273 89 179 MBL8032855.1 alpha-ketoacid dehydrogenase subunit beta [Leptospiraceae bacterium] diamond 273 184 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
27321022 27321022 PRJNA1118794_P_NODE_69823_length_242_cov_1.414201_g69073_i0 PRJNA1118794 69823 242 1.414201 3.42236642 Spirochaetales bacterium 2026792 Bacteria Bacteria 160 2.88e-44   NR MBN1616260.1 2026792 g69073 i0 98.8 0.991735537190083 80 1 99.2 0 2 241 26 105 MBN1616260.1 phenylalanine--tRNA ligase subunit beta [Spirochaetales bacterium] diamond 240 160 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
27343803 27343803 PRJNA1118794_P_NODE_51023_length_250_cov_0.870056_g50273_i0 PRJNA1118794 51023 250 0.870056 2.17514 Pseudomonadati 3379134 Bacteria Bacteria 53.9 4.69e-6   NR WP_288959214.1 162155 g50273 i0 70.6 1.656 34 10 40.8 0 2 103 358 391 WP_288959214.1 caspase family protein [uncultured Treponema sp.] diamond 414 53.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema uncultured Treponema sp.
27731757 27731757 PRJNA1118794_P_NODE_65804_length_244_cov_0.900585_g65054_i0 PRJNA1118794 65804 244 0.900585 2.1974274 Spirochaetota bacterium 2202144 Bacteria Bacteria 52.8 8.64e-6   NR NLV67628.1 2202144 g65054 i0 43.5 1.5 46 26 56.6 0 180 43 65 110 NLV67628.1 M15 family metallopeptidase [Spirochaetota bacterium] diamond 366 52.8 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28457813 28457813 PRJNA1118794_P_NODE_67706_length_243_cov_0.905882_g66956_i0 PRJNA1118794 67706 243 0.905882 2.20129326 Treponema maltophilum 51160 Bacteria Bacteria 138 7.93e-39   NR WP_016526296.1 51160 g66956 i0 94 0.827160493827161 67 4 82.7 0 243 43 157 223 WP_016526296.1 hypothetical protein [Treponema maltophilum] diamond 201 138 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema maltophilum
29057676 29057676 PRJNA1118794_P_NODE_53728_length_249_cov_0.875000_g52978_i0 PRJNA1118794 53728 249 0.875 2.17875 Treponema denticola 158 Bacteria Bacteria 68.9 2.36e-11   NR WP_002669708.1 158 g52978 i0 61.1 1.91566265060241 54 21 65.1 0 81 242 1 54 WP_002669708.1 preprotein translocase subunit SecA [Treponema denticola] diamond 477 68.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
29175071 29175071 PRJNA1118794_P_NODE_55369_length_248_cov_1.320000_g54619_i0 PRJNA1118794 55369 248 1.32 3.2736 root 1 Root_unresolved Root_unresolved 125 2.4999999999999998e-31   NR WP_002703092.1 157 g54619 i0 72.8 215.129032258065 81 22 98 0 5 247 342 422 WP_002703092.1 MULTISPECIES: molecular chaperone DnaK [Treponema] diamond 53352 126 0.992063492063492 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema  
29499506 29499506 PRJNA1118794_P_NODE_31350_length_289_cov_0.879630_g30600_i0 PRJNA1118794 31350 289 0.87963 2.5421307 Turneriella sp. 2717305 Bacteria Bacteria 187 2.39e-56   NR MFO1470840.1 2717305 g30600 i0 97.9 0.996539792387543 96 2 99.7 0 2 289 6 101 MFO1470840.1 lipase secretion chaperone [Turneriella sp.] diamond 288 187 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Turneriella Turneriella sp.
30415959 30415959 PRJNA1118794_P_NODE_48693_length_251_cov_0.865169_g47943_i0 PRJNA1118794 48693 251 0.865169 2.17157419 Spirochaetota bacterium 2202144 Bacteria Bacteria 181 4.289999999999999e-55   NR TXG86145.1 2202144 g47943 i0 100 0.99203187250996006 83 0 99.2 0 3 251 54 136 TXG86145.1 MAG: hypothetical protein E6R13_00920 [Spirochaetota bacterium] diamond 249 181 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
31449654 31449654 PRJNA1118794_P_NODE_42856_length_262_cov_2.301587_g42106_i0 PRJNA1118794 42856 262 2.301587 6.03015794 Treponema 157 Bacteria Bacteria 69.7 5.37e-12   NR MBQ9205232.1 166 g42106 i0 49.3 5.50763358778626 67 34 76.7 0 259 59 179 245 MBQ9205232.1 CAP domain-containing protein [Treponema sp.] diamond 1443 69.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32691660 32691660 PRJNA1118794_P_NODE_42760_length_263_cov_1.131579_g42010_i0 PRJNA1118794 42760 263 1.131579 2.97605277 Spirochaetota bacterium 2202144 Bacteria Bacteria 87 9.18e-18   NR MBP7585203.1 2202144 g42010 i0 54 0.992395437262357 87 32 99.2 1 1 261 307 385 MBP7585203.1 ATP-binding protein [Spirochaetota bacterium] diamond 261 87 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32723335 32723335 PRJNA1118794_P_NODE_9040_length_469_cov_1.383838_g8292_i0 PRJNA1118794 9040 469 1.383838 6.49020022 Spirochaetota bacterium 2202144 Bacteria Bacteria 45.4 0.0252   NR MBN1531716.1 2202144 g8292 i0 45.1 0.326226012793177 51 24 32.6 2 3 155 58 104 MBN1531716.1 hypothetical protein [Spirochaetota bacterium] diamond 153 45.4 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium

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