RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA1068830" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1068830 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
7835367 7835367 PRJNA1068830_P_NODE_46207_length_324_cov_0.932271_g45504_i0 PRJNA1068830 46207 324 0.932271 3.02055804 Taurinivorans muris 2787751 Bacteria Bacteria 162 3.649999999999999e-46   NR WP_334314746.1 2787751 g45504 i0 73.8 0.990740740740741 107 28 99.1 0 3 323 180 286 WP_334314746.1 AAA family ATPase [Taurinivorans muris] diamond 321 162 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Taurinivorans Taurinivorans muris
16760826 16760826 PRJNA1068830_P_NODE_88234_length_242_cov_0.923077_g87531_i0 PRJNA1068830 88234 242 0.923077 2.23384634 Desulfobacterales bacterium 2044940 Bacteria Bacteria 134 2.9199999999999996e-35   NR MCK7502960.1 2044940 g87531 i0 77.5 0.991735537190083 80 18 99.2 0 3 242 42 121 MCK7502960.1 transposase [Desulfobacterales bacterium] diamond 240 134 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
26972346 26972346 PRJNA1068830_P_NODE_82662_length_246_cov_0.901734_g81959_i0 PRJNA1068830 82662 246 0.901734 2.21826564 uncultured Desulfovibrio sp. 167968 Bacteria Bacteria 159 6.9e-45   NR WP_302616639.1 167968 g81959 i0 100 1.97560975609756 81 0 98.8 0 244 2 351 431 WP_302616639.1 type I-U CRISPR-associated protein Csx17, partial [uncultured Desulfovibrio sp.] diamond 486 159 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio uncultured Desulfovibrio sp.
27035716 27035716 PRJNA1068830_P_NODE_56642_length_289_cov_1.444444_g55939_i0 PRJNA1068830 56642 289 1.444444 4.17444316 Taurinivorans muris 2787751 Bacteria Bacteria 134 1.6299999999999998e-35   NR WP_334314743.1 2787751 g55939 i0 76.6 0.975778546712803 94 22 97.6 0 288 7 207 300 WP_334314743.1 hypothetical protein [Taurinivorans muris] diamond 282 134 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Taurinivorans Taurinivorans muris
28101054 28101054 PRJNA1068830_P_NODE_73925_length_252_cov_0.871508_g73222_i0 PRJNA1068830 73925 252 0.871508 2.19620016 Desulfovibrio 872 Bacteria Bacteria 108 2.23e-25   NR MCX4310312.1 885 g73222 i0 60.7 6.94047619047619 84 33 100 0 252 1 944 1027 MCX4310312.1 SNF2-related protein [Desulfovibrio sp.] diamond 1749 109 0.990825688073395 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio sp.
28741087 28741087 PRJNA1068830_P_NODE_66987_length_264_cov_1.764398_g66284_i0 PRJNA1068830 66987 264 1.764398 4.65801072 Geobacteraceae bacterium 2282154 Bacteria Bacteria 112 7.920000000000001e-27   NR NVN99279.1 2282154 g66284 i0 55.7 1.95454545454545 88 38 100 1 264 1 222 308 NVN99279.1 DEAD/DEAH box helicase [Geobacteraceae bacterium] diamond 516 112 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae   Geobacteraceae bacterium
29088503 29088503 PRJNA1068830_P_NODE_68288_length_261_cov_1.792553_g67585_i0 PRJNA1068830 68288 261 1.792553 4.67856333 Desulfovibrionaceae bacterium 2049043 Bacteria Bacteria 43.9 0.0109   NR MBQ7606958.1 2049043 g67585 i0 39.3 0.64367816091954 56 30 59.8 1 48 203 57 112 MBQ7606958.1 C40 family peptidase [Desulfovibrionaceae bacterium] diamond 168 43.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae   Desulfovibrionaceae bacterium
29656302 29656302 PRJNA1068830_P_NODE_30510_length_413_cov_1.414706_g29807_i0 PRJNA1068830 30510 413 1.414706 5.84273578 Taurinivorans muris 2787751 Bacteria Bacteria 122 1.56e-30   NR WP_334315617.1 2787751 g29807 i0 43.6 0.799031476997579 110 62 79.9 0 413 84 218 327 WP_334315617.1 radical SAM protein [Taurinivorans muris] diamond 330 122 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Taurinivorans Taurinivorans muris
30067267 30067267 PRJNA1068830_P_NODE_65932_length_267_cov_1.206186_g65229_i0 PRJNA1068830 65932 267 1.206186 3.22051662 Mailhella sp. 1981029 Bacteria Bacteria 80.5 1.4e-16   NR MDE7011794.1 1981029 g65229 i0 86.4 0.49438202247191 44 6 49.4 0 265 134 138 181 MDE7011794.1 recombinase family protein [Mailhella sp.] diamond 132 80.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Mailhella Mailhella sp.
30415251 30415251 PRJNA1068830_P_NODE_84473_length_245_cov_0.901163_g83770_i0 PRJNA1068830 84473 245 0.901163 2.20784935 uncultured Desulfovibrio sp. 167968 Bacteria Bacteria 104 2.3e-27   NR WP_300908601.1 167968 g83770 i0 100 0.648979591836735 53 0 64.9 0 1 159 30 82 WP_300908601.1 hypothetical protein [uncultured Desulfovibrio sp.] diamond 159 104 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio uncultured Desulfovibrio sp.
30604377 30604377 PRJNA1068830_P_NODE_66673_length_265_cov_1.447917_g65970_i0 PRJNA1068830 66673 265 1.447917 3.83698005 Candidatus Electrothrix sp. ATG1_2 ATG1 2249221 Bacteria Bacteria 51.6 1.29e-5   NR MCI5141168.1 2249221 g65970 i0 32.2 0.984905660377358 87 58 98.5 1 3 263 57 142 MCI5141168.1 cupin domain-containing protein [Candidatus Electrothrix sp. ATG1] diamond 261 51.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Candidatus Electrothrix Candidatus Electrothrix sp. ATG1_2 ATG1
30690725 30690725 PRJNA1068830_P_NODE_82553_length_246_cov_0.901734_g81850_i0 PRJNA1068830 82553 246 0.901734 2.21826564 Bacteria 2 Bacteria Bacteria 113 3.27e-27   NR WP_039740578.1 345632 g81850 i0 72.5 31.3536585365854 80 22 97.6 0 7 246 436 515 WP_039740578.1 NADP-dependent glyceraldehyde-3-phosphate dehydrogenase [Geobacter pickeringii] diamond 7713 114 0.991228070175439 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae Geobacter Geobacter pickeringii
31204304 31204304 PRJNA1068830_P_NODE_43635_length_335_cov_1.118321_g42932_i0 PRJNA1068830 43635 335 1.118321 3.74637535 Taurinivorans muris 2787751 Bacteria Bacteria 73.6 1.03e-12   NR WP_334315617.1 2787751 g42932 i0 32.1 0.976119402985075 109 73 97.6 1 2 328 74 181 WP_334315617.1 radical SAM protein [Taurinivorans muris] diamond 327 73.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Taurinivorans Taurinivorans muris
32185502 32185502 PRJNA1068830_P_NODE_89298_length_239_cov_3.771084_g88595_i0 PRJNA1068830 89298 239 3.771084 9.01289076 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 42.4 0.0492   NR MCG6905665.1 2049433 g88595 i0 42.9 0.702928870292887 56 27 64 1 212 60 36 91 MCG6905665.1 fused MFS/spermidine synthase [Desulfobacteraceae bacterium] diamond 168 42.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
32398572 32398572 PRJNA1068830_P_NODE_62439_length_275_cov_1.386139_g61736_i0 PRJNA1068830 62439 275 1.386139 3.81188225 Bacteria 2 Bacteria Bacteria 168 2.62e-51   NR WP_300882454.1 167968 g61736 i0 100 1.92 88 0 96 0 11 274 1 88 WP_300882454.1 helix-turn-helix domain-containing protein [uncultured Desulfovibrio sp.] diamond 528 168 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio uncultured Desulfovibrio sp.
32690886 32690886 PRJNA1068830_P_NODE_81420_length_247_cov_0.896552_g80717_i0 PRJNA1068830 81420 247 0.896552 2.21448344 uncultured Desulfovibrio sp. 167968 Bacteria Bacteria 101 1.97e-24   NR WP_300907495.1 167968 g80717 i0 100 0.595141700404858 49 0 59.5 0 246 100 183 231 WP_300907495.1 nucleotidyl transferase AbiEii/AbiGii toxin family protein [uncultured Desulfovibrio sp.] diamond 147 101 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio uncultured 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);;