RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA883229", 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 · 13 ✖

tax_kingdom 1

  • Pseudomonadati · 13 ✖

bioproject 1

  • PRJNA883229 · 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
12338996 12338996 PRJNA883229_P_NODE_11710_length_249_cov_0.886364_g11664_i0 PRJNA883229 11710 249 0.886364 2.20704636 Desulfovibrio sp. 885 Bacteria Bacteria 128 1.3899999999999998e-32   NR MBQ9453635.1 885 g11664 i0 74.7 1.98795180722892 83 21 100 0 249 1 372 454 MBQ9453635.1 HD domain-containing protein [Desulfovibrio sp.] diamond 495 128 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
15268985 15268985 PRJNA883229_P_NODE_13952_length_245_cov_1.813953_g13906_i0 PRJNA883229 13952 245 1.813953 4.44418485 Pseudomonadati 3379134 Bacteria Bacteria 62.1 3.67e-5   NTclustered gi|308273377|emb|FR695874.1| 201089 g13906 i0 100 286.861224489796 33 0 13 0 89 121 217877 217909 Uncultured Desulfobacterium sp. genomic DNA, clone SelH_gw24b_gw46b blastn 70281 62.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteriaceae Desulfobacterium uncultured Desulfobacterium sp.
16162620 16162620 PRJNA883229_P_NODE_13533_length_246_cov_0.901734_g13487_i0 PRJNA883229 13533 246 0.901734 2.21826564 Desulfovibrio sp. 885 Bacteria Bacteria 87 6.25e-18   NR MBQ9406989.1 885 g13487 i0 71.9 0.780487804878049 64 18 78 0 244 53 332 395 MBQ9406989.1 hypothetical protein [Desulfovibrio sp.] diamond 192 87 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
17438102 17438102 PRJNA883229_P_NODE_13514_length_246_cov_0.901734_g13468_i0 PRJNA883229 13514 246 0.901734 2.21826564 Nitratidesulfovibrio liaohensis 2604158 Bacteria Bacteria 416 6.839999999999999e-112   NTclustered gi|2575677524|gb|CP133659.1| 2604158 g13468 i0 97.154 1 246 7 100 0 1 246 1001969 1001724 Nitratidesulfovibrio liaohensis strain KPS chromosome, complete genome blastn 246 416 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Nitratidesulfovibrio Nitratidesulfovibrio liaohensis
21262010 21262010 PRJNA883229_P_NODE_9337_length_252_cov_0.871508_g9291_i0 PRJNA883229 9337 252 0.871508 2.19620016 Desulfonema limicola 45656 Bacteria Bacteria 54.7 0.006   NTclustered gi|2007129425|gb|CP061799.1| 45656 g9291 i0 100 0.115079365079365 29 0 12 0 195 223 5017940 5017968 Desulfonema limicola strain 5ac10 chromosome, complete genome blastn 29 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfococcaceae Desulfonema Desulfonema limicola
28539925 28539925 PRJNA883229_P_NODE_11487_length_249_cov_0.886364_g11441_i0 PRJNA883229 11487 249 0.886364 2.20704636 Desulfovibrionaceae bacterium 2049043 Bacteria Bacteria 67.4 1.03e-11   NR MBQ7586384.1 2049043 g11441 i0 48.8 0.987951807228916 82 34 89.2 1 224 3 1 82 MBQ7586384.1 hypothetical protein [Desulfovibrionaceae bacterium] diamond 246 67.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae   Desulfovibrionaceae bacterium
28981948 28981948 PRJNA883229_P_NODE_13128_length_247_cov_0.896552_g13082_i0 PRJNA883229 13128 247 0.896552 2.21448344 Desulfomicrobium sp. 52017 Bacteria Bacteria 112 1.32e-27   NR HCU68624.1 52017 g13082 i0 76.1 0.813765182186235 67 16 81.4 0 202 2 1 67 HCU68624.1 radical SAM protein [Desulfomicrobium sp.] diamond 201 112 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Desulfomicrobium Desulfomicrobium sp.
29273676 29273676 PRJNA883229_P_NODE_15729_length_243_cov_0.917647_g15683_i0 PRJNA883229 15729 243 0.917647 2.22988221 Pseudomonadati 3379134 Bacteria Bacteria 50.1 9.11e-5   NR WP_066806128.1 1716143 g15683 i0 75.9 1.90123456790123 29 7 35.8 0 100 14 5 33 WP_066806128.1 type I-C CRISPR-associated endonuclease Cas1c [Pseudodesulfovibrio indicus] diamond 462 50.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio Pseudodesulfovibrio indicus
29834225 29834225 PRJNA883229_P_NODE_11631_length_249_cov_0.886364_g11585_i0 PRJNA883229 11631 249 0.886364 2.20704636 Desulfovibrio sp. 885 Bacteria Bacteria 167 2.89e-49   NR MBQ7457283.1 885 g11585 i0 98.8 0.987951807228916 82 1 98.8 0 248 3 160 241 MBQ7457283.1 HipA domain-containing protein [Desulfovibrio sp.] diamond 246 167 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
30750548 30750548 PRJNA883229_P_NODE_16634_length_242_cov_0.923077_g16588_i0 PRJNA883229 16634 242 0.923077 2.23384634 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 147 2.72e-40   NR MFB3884328.1 2202153 g16588 i0 85 2.97520661157025 80 12 99.2 0 1 240 31 110 MFB3884328.1 exodeoxyribonuclease VII large subunit [Thermodesulfobacteriota bacterium] diamond 720 147 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
30813613 30813613 PRJNA883229_P_NODE_8034_length_260_cov_1.262032_g7988_i0 PRJNA883229 8034 260 1.262032 3.2812832 Desulfovibrio sp. 885 Bacteria Bacteria 68.9 2.57e-11   NR MFG6374827.1 885 g7988 i0 43.2 0.853846153846154 74 38 84.2 2 6 224 197 267 MFG6374827.1 flagellin [Desulfovibrio sp.] diamond 222 68.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
31445831 31445831 PRJNA883229_P_NODE_12076_length_248_cov_0.891429_g12030_i0 PRJNA883229 12076 248 0.891429 2.21074392 Desulfovibrio sp. 885 Bacteria Bacteria 80.1 1.4e-16   NR MCR5259210.1 885 g12030 i0 100 0.943548387096774 39 0 47.2 0 130 246 1 39 MCR5259210.1 2,4-dihydroxyhept-2-ene-1,7-dioic acid aldolase [Desulfovibrio sp.] diamond 234 80.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
31675060 31675060 PRJNA883229_P_NODE_14677_length_244_cov_1.766082_g14631_i0 PRJNA883229 14677 244 1.766082 4.30924008 Desulfovibrio 872 Bacteria Bacteria 129 2.4e-33   NR MBE6442088.1 876 g14631 i0 92.6 6.97131147540984 81 6 99.6 0 243 1 238 318 MBE6442088.1 HlyD family type I secretion periplasmic adaptor subunit [Desulfovibrio desulfuricans] diamond 1701 129 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans

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