RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA1035005" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1035005 · 17 ✖

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
1443846 1443846 PRJNA1035005_P_NODE_7962_length_392_cov_1.075235_g7560_i0 PRJNA1035005 7962 392 1.075235 4.2149212 Salidesulfovibrio onnuriiensis 2583823 Bacteria Bacteria 359 1.97e-94   NTclustered gi|1725298512|gb|CP040751.1| 2583823 g7560 i0 83.896 237.09693877551 385 52 97 9 10 388 346443 346823 Salidesulfovibrio onnuriiensis strain IOR2 chromosome, complete genome blastn 92942 359 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Salidesulfovibrio Salidesulfovibrio onnuriiensis
3995532 3995532 PRJNA1035005_P_NODE_62084_length_250_cov_0.881356_g61678_i0 PRJNA1035005 62084 250 0.881356 2.20339 Fundidesulfovibrio soli 2922716 Bacteria Bacteria 462 8.83e-126   NTclustered gi|2200496721|gb|OM850369.1| 2922716 g61678 i0 100 100.204 250 0 100 0 1 250 609 360 Fundidesulfovibrio sp. strain SG60 16S ribosomal RNA gene, partial sequence blastn 25051 462 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Fundidesulfovibrio Fundidesulfovibrio soli
7821678 7821678 PRJNA1035005_P_NODE_71287_length_247_cov_0.896552_g70881_i0 PRJNA1035005 71287 247 0.896552 2.21448344 Desulfovermiculus sp. 2821143 Bacteria Bacteria 120 2.18e-30   NR MBS3780561.1 2821143 g70881 i0 90.6 2.31983805668016 64 6 77.7 0 56 247 171 234 MBS3780561.1 DEAD/DEAH box helicase [Desulfovermiculus sp.] diamond 573 120 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae Desulfovermiculus Desulfovermiculus sp.
10372200 10372200 PRJNA1035005_P_NODE_59049_length_251_cov_0.876404_g58643_i0 PRJNA1035005 59049 251 0.876404 2.19977404 Desulfovibrio fairfieldensis 44742 Bacteria Bacteria 451 1.92e-122   NTclustered gi|987453195|gb|CP014229.1| 44742 g58643 i0 99.2 7.41434262948207 250 2 99 0 1 250 2742994 2742745 Desulfovibrio fairfieldensis strain CCUG 45958 chromosome, complete genome blastn 1861 451 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio fairfieldensis
10372423 10372423 PRJNA1035005_P_NODE_8689_length_380_cov_2.055375_g8287_i0 PRJNA1035005 8689 380 2.055375 7.810425 Candidatus Electrothrix aestuarii 3062594 Bacteria Bacteria 56.5 0.003   NTclustered gi|2755823080|gb|CP159373.1| 3062594 g8287 i0 97.059 0.0894736842105263 34 0 9 1 339 372 874381 874413 MAG: Candidatus Electrothrix aestuarii isolate Rat1 chromosome, complete genome blastn 34 56.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Candidatus Electrothrix Candidatus Electrothrix aestuarii
12922763 12922763 PRJNA1035005_P_NODE_67131_length_248_cov_1.337143_g66725_i0 PRJNA1035005 67131 248 1.337143 3.31611464 Desulfovibrio desulfuricans 876 Bacteria Bacteria 459 1.13e-124   NTclustered gi|2884834435|gb|CP176628.1| 876 g66725 i0 100 106.052419354839 248 0 100 0 1 248 3994 4241 Desulfovibrio desulfuricans strain SFAD67 chromosome, complete genome blastn 26301 459 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
18020927 18020927 PRJNA1035005_P_NODE_67355_length_248_cov_0.891429_g66949_i0 PRJNA1035005 67355 248 0.891429 2.21074392 Thermodesulfomicrobium sp. WS 3004129 Bacteria Bacteria 342 1.1899999999999999e-89   NTclustered gi|2416254156|dbj|AP027130.1| 3004129 g66949 i0 91.532 4.37096774193548 248 21 100 0 1 248 838831 839078 Thermodesulfomicrobium sp. WS DNA, complete genome blastn 1084 342 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Thermodesulfomicrobium Thermodesulfomicrobium sp. WS
21409747 21409747 PRJNA1035005_P_NODE_10097_length_363_cov_1.558621_g9692_i0 PRJNA1035005 10097 363 1.558621 5.65779423 Desulfocurvibacter 2582840 Bacteria Bacteria 390 6.42e-104   NTclustered gi|470489697|ref|NR_076945.1| 873 g9692 i0 86.686 164.787878787879 353 45 97 2 12 363 380 29 Desulfovibrio africanus strain Walvis Bay 23S ribosomal RNA gene, complete sequence blastn 59818 390 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfocurvibacter Desulfocurvibacter africanus
24395286 24395286 PRJNA1035005_P_NODE_9880_length_366_cov_0.989761_g9475_i0 PRJNA1035005 9880 366 0.989761 3.62252526 Desulfolutivibrio sulfodismutans 63561 Bacteria Bacteria 475 1.74e-129   NTclustered gi|1863422180|gb|CP045504.1| 1121464 g9475 i0 90.244 380.827868852459 369 29 100 7 1 366 1154101 1153737 Desulfolutivibrio sulfodismutans DSM 3696 chromosome, complete genome blastn 139383 475 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfolutivibrio Desulfolutivibrio sulfodismutans
26678730 26678730 PRJNA1035005_P_NODE_62641_length_250_cov_0.881356_g62235_i0 PRJNA1035005 62641 250 0.881356 2.20339 Desulfobacterales 213118 Bacteria Bacteria 59.3 5.67e-8   NR ETR68999.1 890399 g62235 i0 43.9 3.048 82 42 98.4 2 3 248 296 373 ETR68999.1 MAG: FAD-dependent pyridine nucleotide-disulfide oxidoreductase [Candidatus Magnetoglobus multicellularis str. Araruama] diamond 762 59.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Candidatus Magnetoglobus Candidatus Magnetoglobus multicellularis
27919540 27919540 PRJNA1035005_P_NODE_43785_length_264_cov_3.094241_g43379_i0 PRJNA1035005 43785 264 3.094241 8.16879624 Caldimicrobium sp. 2024963 Bacteria Bacteria 42.7 0.0457   NR MCS7200316.1 2024963 g43379 i0 63.3 0.340909090909091 30 11 34.1 0 164 75 329 358 MCS7200316.1 class I SAM-dependent rRNA methyltransferase [Caldimicrobium sp.] diamond 90 42.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Thermodesulfobacteria Thermodesulfobacteriales Thermodesulfobacteriaceae Caldimicrobium Caldimicrobium sp.
28511515 28511515 PRJNA1035005_P_NODE_72807_length_246_cov_1.427746_g72401_i0 PRJNA1035005 72807 246 1.427746 3.51225516 Bacteria 2 Bacteria Bacteria 67.8 3.9e-11   NR WP_297955979.1 239745 g72401 i0 42 7.89024390243902 81 41 98.8 1 245 3 125 199 WP_297955979.1 ketopantoate reductase family protein [uncultured Desulfobulbus sp.] diamond 1941 68.2 0.994134897360704 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Desulfobulbus uncultured Desulfobulbus sp.
28985427 28985427 PRJNA1035005_P_NODE_85608_length_242_cov_0.923077_g85202_i0 PRJNA1035005 85608 242 0.923077 2.23384634 Pseudomonadati 3379134 Bacteria Bacteria 136 7.14e-40   NR WP_008868611.1 488939 g85202 i0 77.3 4.59917355371901 75 17 93 0 237 13 13 87 WP_008868611.1 DUF2442 domain-containing protein [Desulfonatronospira thiodismutans] diamond 1113 137 0.992700729927007 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfonatronovibrionaceae Desulfonatronospira Desulfonatronospira thiodismutans
29214383 29214383 PRJNA1035005_P_NODE_42069_length_267_cov_1.309278_g41663_i0 PRJNA1035005 42069 267 1.309278 3.49577226 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 165 2.89e-50   NR MEF8942522.1 2683721 g41663 i0 89.9 1 89 9 100 0 1 267 26 114 MEF8942522.1 type II toxin-antitoxin system antitoxin SocA domain-containing protein [Desulfohalobiaceae bacterium] diamond 267 165 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
29466365 29466365 PRJNA1035005_P_NODE_80710_length_244_cov_0.883041_g80304_i0 PRJNA1035005 80710 244 0.883041 2.15462004 Desulfobacterales bacterium 2044940 Bacteria Bacteria 43.5 0.0209   NR MCF8079870.1 2044940 g80304 i0 43.1 1.77049180327869 65 37 79.9 0 5 199 907 971 MCF8079870.1 AAA family ATPase [Desulfobacterales bacterium] diamond 432 43.5 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
32216542 32216542 PRJNA1035005_P_NODE_15018_length_323_cov_1.708000_g14612_i0 PRJNA1035005 15018 323 1.708 5.51684 Candidatus Magnetoglobus multicellularis str. Araruama 890399 Bacteria Bacteria 143 1.75e-37   NR ETR68999.1 890399 g14612 i0 62.4 0.938080495356037 101 38 93.8 0 6 308 135 235 ETR68999.1 MAG: FAD-dependent pyridine nucleotide-disulfide oxidoreductase [Candidatus Magnetoglobus multicellularis str. Araruama] diamond 303 143 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae Candidatus Magnetoglobus Candidatus Magnetoglobus multicellularis
32501495 32501495 PRJNA1035005_P_NODE_68199_length_248_cov_0.891429_g67793_i0 PRJNA1035005 68199 248 0.891429 2.21074392 Geobacteraceae bacterium 2282154 Bacteria Bacteria 70.1 9.27e-12   NR MCM2357034.1 2282154 g67793 i0 51.9 2.9758064516129 81 36 94.4 2 235 2 575 655 MCM2357034.1 Ig-like domain repeat protein [Geobacteraceae bacterium] diamond 738 70.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Geobacterales Geobacteraceae   Geobacteraceae 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);;