RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 15 ✖

bioproject 1

  • PRJNA1005695 · 15 ✖

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
6104282 6104282 PRJNA1005695_P_NODE_29465_length_275_cov_1.990099_g28613_i0 PRJNA1005695 29465 275 1.990099 5.47277225 PVC group 1783257 Bacteria Bacteria 100 2e-22   NR KPK28946.1 1703401 g28613 i0 55.8 5.70545454545455 86 38 93.8 0 3 260 642 727 KPK28946.1 MAG: acetyl CoA synthetase subunit alpha [Desulfobacterales bacterium SG8_35_2] diamond 1569 100 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium SG8_35_2
6104334 6104334 PRJNA1005695_P_NODE_39865_length_242_cov_1.775148_g39013_i0 PRJNA1005695 39865 242 1.775148 4.29585816 Pseudomonadati 3379134 Bacteria Bacteria 254 5.57e-63   NTclustered gi|2893358418|emb|OZ220710.1| 2202153 g39013 i0 86.325 645.111570247934 234 31 97 1 1 234 2289401 2289633 MAG: Thermodesulfobacteriota bacterium isolate dce1034a-8f23-488c-aa07-39e6c80a0035 genome assembly, chromosome: 1 blastn 156117 254 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
6531711 6531711 PRJNA1005695_P_NODE_30846_length_269_cov_0.943878_g29994_i0 PRJNA1005695 30846 269 0.943878 2.53903182 Geopsychrobacteraceae bacterium 3065857 Bacteria Bacteria 150 8.489999999999998e-32   NTclustered gi|2621703259|emb|OY762430.1| 3065857 g29994 i0 78.067 93.4386617100372 269 38 98 13 6 269 5392 5140 MAG: Geopsychrobacteraceae bacterium isolate 31ebb314-3b6f-4c34-9fd3-1c731cc0fcc3 genome assembly, chromosome: 1 blastn 25135 150 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Geopsychrobacteraceae   Geopsychrobacteraceae bacterium
10356688 10356688 PRJNA1005695_P_NODE_29329_length_276_cov_1.399015_g28477_i0 PRJNA1005695 29329 276 1.399015 3.8612814 Thermodesulfomicrobium sp. WS 3004129 Bacteria Bacteria 54.7 0.007   NTclustered gi|2416254156|dbj|AP027130.1| 3004129 g28477 i0 100 0.105072463768116 29 0 11 0 75 103 2120417 2120445 Thermodesulfomicrobium sp. WS DNA, complete genome blastn 29 54.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfomicrobiaceae Thermodesulfomicrobium Thermodesulfomicrobium sp. WS
14182080 14182080 PRJNA1005695_P_NODE_12252_length_440_cov_5.297003_g11400_i0 PRJNA1005695 12252 440 5.297003 23.3068132 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 612 1.56e-170   NTclustered gi|2575803239|emb|OY729416.1| 2202153 g11400 i0 91.837 198.170454545455 441 33 100 3 1 440 75911 76349 MAG: Thermodesulfobacteriota bacterium isolate ba02c5ff-97d3-4768-ae28-618c4039653d genome assembly, chromosome: 1 blastn 87195 612 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
23105903 23105903 PRJNA1005695_P_NODE_42679_length_197_cov_6.193548_g41827_i0 PRJNA1005695 42679 197 6.193548 12.20128956 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 228 2.6399999999999995e-55   NTclustered gi|2575803239|emb|OY729416.1| 2202153 g41827 i0 90.698 148.086294416244 172 14 87 2 26 197 75734 75903 MAG: Thermodesulfobacteriota bacterium isolate ba02c5ff-97d3-4768-ae28-618c4039653d genome assembly, chromosome: 1 blastn 29173 228 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
27666520 27666520 PRJNA1005695_P_NODE_39064_length_244_cov_0.912281_g38212_i0 PRJNA1005695 39064 244 0.912281 2.22596564 Desulfuromonas sp. 892 Bacteria Bacteria 152 5.979999999999998e-42   NR MFA6686428.1 892 g38212 i0 86.4 1.99180327868852 81 11 99.6 0 1 243 377 457 MFA6686428.1 hypothetical protein [Desulfuromonas sp.] diamond 486 152 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas sp.
27982114 27982114 PRJNA1005695_P_NODE_32785_length_260_cov_1.994652_g31933_i0 PRJNA1005695 32785 260 1.994652 5.1860952 Desulfuromonas sp. 892 Bacteria Bacteria 107 6.43e-25   NR MFA6686428.1 892 g31933 i0 70.8 0.830769230769231 72 21 83.1 0 40 255 1 72 MFA6686428.1 hypothetical protein [Desulfuromonas sp.] diamond 216 107 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas sp.
28953653 28953653 PRJNA1005695_P_NODE_39568_length_243_cov_0.917647_g38716_i0 PRJNA1005695 39568 243 0.917647 2.22988221 Pseudomonadati 3379134 Bacteria Bacteria 43.1 0.0165   NR WP_300811008.1 167968 g38716 i0 71.4 2.41975308641975 28 8 34.6 0 1 84 139 166 WP_300811008.1 thiol peroxidase [uncultured Desulfovibrio sp.] diamond 588 43.5 0.990804597701149 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio uncultured Desulfovibrio sp.
29844928 29844928 PRJNA1005695_P_NODE_5511_length_675_cov_2.034884_g4696_i0 PRJNA1005695 5511 675 2.034884 13.735467 Desulfuromonas sp. 892 Bacteria Bacteria 295 1.84e-97   NR MFA6686427.1 892 g4696 i0 65.2 0.982222222222222 221 77 98.2 0 674 12 71 291 MFA6686427.1 AvaI/BsoBI family type II restriction endonuclease [Desulfuromonas sp.] diamond 663 295 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas sp.
30160615 30160615 PRJNA1005695_P_NODE_23292_length_311_cov_2.735294_g22440_i0 PRJNA1005695 23292 311 2.735294 8.50676434 Desulfococcus multivorans 897 Bacteria Bacteria 45.4 0.00791   NR ACP50615.1 897 g22440 i0 36.6 0.790996784565916 82 40 79.1 2 280 35 90 159 ACP50615.1 Na+ pumping decarboxylase beta-subunit, partial [Desulfococcus multivorans] diamond 246 45.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfococcaceae Desulfococcus Desulfococcus multivorans
30792724 30792724 PRJNA1005695_P_NODE_38674_length_245_cov_0.906977_g37822_i0 PRJNA1005695 38674 245 0.906977 2.22209365 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 64.7 1.41e-10   NR MCB9481683.1 2049433 g37822 i0 46.3 1.9469387755102 80 42 96.7 1 239 3 3 82 MCB9481683.1 chalcone isomerase family protein [Desulfobacteraceae bacterium] diamond 477 64.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
31551697 31551697 PRJNA1005695_P_NODE_34656_length_253_cov_0.866667_g33804_i0 PRJNA1005695 34656 253 0.866667 2.19266751 Candidatus Dadabacteria bacterium 2080303 Bacteria Bacteria 163 1.31e-49   NR MCA9808972.1 2080303 g33804 i0 96.4 0.99604743083004 84 3 99.6 0 252 1 1 84 MCA9808972.1 6,7-dimethyl-8-ribityllumazine synthase [Candidatus Dadabacteria bacterium] diamond 252 163 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Candidatus Dadabacteria       Candidatus Dadabacteria bacterium
31614672 31614672 PRJNA1005695_P_NODE_33016_length_259_cov_2.408602_g32164_i0 PRJNA1005695 33016 259 2.408602 6.23827918 Desulfococcaceae bacterium 3024398 Bacteria Bacteria 86.7 1.05e-17   NR MFP4347903.1 3024398 g32164 i0 57 2.98841698841699 86 27 99.6 4 2 259 211 286 MFP4347903.1 pyridoxal phosphate-dependent aminotransferase [Desulfococcaceae bacterium] diamond 774 86.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfococcaceae   Desulfococcaceae bacterium
32532430 32532430 PRJNA1005695_P_NODE_6619_length_611_cov_1.979554_g5789_i0 PRJNA1005695 6619 611 1.979554 12.09507494 Geoalkalibacter ferrihydriticus 392333 Bacteria Bacteria 101 2.95e-23   NR WP_040099194.1 392333 g5789 i0 42 2.77414075286416 150 72 72.7 4 9 452 21 157 WP_040099194.1 peroxiredoxin [Geoalkalibacter ferrihydriticus] diamond 1695 101 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Geoalkalibacteraceae Geoalkalibacter Geoalkalibacter ferrihydriticus

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