RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA1108487", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 12 ✖

tax_kingdom 1

  • Pseudomonadati · 12 ✖

bioproject 1

  • PRJNA1108487 · 12 ✖

analysis 1

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
17598256 17598256 PRJNA1108487_P_NODE_3634_length_360_cov_1.052265_g3568_i0 PRJNA1108487 3634 360 1.052265 3.788154 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 183 2.9999999999999994e-57   NR GJM17624.1 2202153 g3568 i0 74.4 0.975 117 29 97.5 1 9 359 1 116 GJM17624.1 MAG: hypothetical protein DHS20C13_29510 [Thermodesulfobacteriota bacterium] diamond 351 183 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
27510217 27510217 PRJNA1108487_P_NODE_3263_length_377_cov_1.763158_g3197_i0 PRJNA1108487 3263 377 1.763158 6.64710566 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 124 2.44e-30   NR HAO22905.1 2049433 g3197 i0 46.2 0.946949602122016 119 64 94.7 0 21 377 274 392 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 357 124 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
28299397 28299397 PRJNA1108487_P_NODE_9786_length_247_cov_1.793103_g9720_i0 PRJNA1108487 9786 247 1.793103 4.42896441 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 105 4.76e-26   NR GJM17626.1 2202153 g9720 i0 55 0.97165991902834 80 36 97.2 0 1 240 10 89 GJM17626.1 MAG: hypothetical protein DHS20C13_29530 [Thermodesulfobacteriota bacterium] diamond 240 105 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
29625088 29625088 PRJNA1108487_P_NODE_6970_length_273_cov_1.560000_g6904_i0 PRJNA1108487 6970 273 1.56 4.2588 Bilophila sp. 1929485 Bacteria Bacteria 89.7 7.17e-19   NR WP_287546203.1 1929485 g6904 i0 44.4 1.97802197802198 90 50 98.9 0 271 2 63 152 WP_287546203.1 thrombospondin type-1 domain-containing protein [Bilophila sp.] diamond 540 89.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Bilophila Bilophila sp.
29656735 29656735 PRJNA1108487_P_NODE_1810_length_502_cov_1.466200_g1744_i0 PRJNA1108487 1810 502 1.4662 7.360324 Desulfatibacillum aliphaticivorans 218208 Bacteria Bacteria 133 9.74e-33   NR WP_015947357.1 218208 g1744 i0 42.4 6.74103585657371 165 84 98.6 5 6 500 450 603 WP_015947357.1 thrombospondin type-1 domain-containing protein [Desulfatibacillum aliphaticivorans] diamond 3384 134 0.992537313432836 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfatibacillaceae Desulfatibacillum Desulfatibacillum aliphaticivorans
30785673 30785673 PRJNA1108487_P_NODE_3314_length_375_cov_1.033113_g3248_i0 PRJNA1108487 3314 375 1.033113 3.87417375 Pseudomonadati 3379134 Bacteria Bacteria 51.6 4.53e-5   NR MCK5419565.1 2044940 g3248 i0 38.7 1.48 62 38 49.6 0 374 189 112 173 MCK5419565.1 50S ribosomal protein L10 [Desulfobacterales bacterium] diamond 555 51.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
31204721 31204721 PRJNA1108487_P_NODE_8155_length_255_cov_1.362637_g8089_i0 PRJNA1108487 8155 255 1.362637 3.47472435 Desulfobacterales bacterium 2044940 Bacteria Bacteria 47.4 3.08e-4   NR MEJ2168783.1 2044940 g8089 i0 41.1 1.41176470588235 56 33 65.9 0 58 225 3 58 MEJ2168783.1 PGDYG domain-containing protein [Desulfobacterales bacterium] diamond 360 47.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
31331611 31331611 PRJNA1108487_P_NODE_7576_length_264_cov_1.225131_g7510_i0 PRJNA1108487 7576 264 1.225131 3.23434584 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 52.4 1.91e-5   NR HAO22905.1 2049433 g7510 i0 31.8 1.95454545454545 85 58 96.6 0 259 5 333 417 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 516 52.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
31553329 31553329 PRJNA1108487_P_NODE_10396_length_245_cov_0.906977_g10330_i0 PRJNA1108487 10396 245 0.906977 2.22209365 Thermodesulfatator sp. 1874629 Bacteria Bacteria 44.7 0.00453   NR RUM89082.1 1874629 g10330 i0 73.1 0.648979591836735 26 7 31.8 0 14 91 143 168 RUM89082.1 MAG: 50S rRNA methyltransferase, partial [Thermodesulfatator sp.] diamond 159 44.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Thermodesulfobacteria Thermodesulfobacteriales Thermodesulfatatoraceae Thermodesulfatator Thermodesulfatator sp.
31584882 31584882 PRJNA1108487_P_NODE_36_length_2372_cov_3.548934_g27_i0 PRJNA1108487 36 2372 3.548934 84.18071448 Desulfomonilia bacterium 3041274 Bacteria Bacteria 114 1.44e-21   NR HEY9159531.1 3041274 g27 i0 25.7 0.798060708263069 631 345 78.3 24 2338 482 1362 1880 HEY9159531.1 PKD domain-containing protein [Desulfomonilia bacterium] diamond 1893 114 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfomonilia       Desulfomonilia bacterium
32090909 32090909 PRJNA1108487_P_NODE_2398_length_437_cov_2.142857_g2332_i0 PRJNA1108487 2398 437 2.142857 9.36428509 Desulfobacteraceae bacterium 2049433 Bacteria Bacteria 119 5.889999999999999e-28   NR HAO22905.1 2049433 g2332 i0 36.1 0.988558352402746 144 91 98.9 1 433 2 289 431 HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] diamond 432 119 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfobacteraceae   Desulfobacteraceae bacterium
32754412 32754412 PRJNA1108487_P_NODE_3460_length_368_cov_1.057627_g3394_i0 PRJNA1108487 3460 368 1.057627 3.89206736 Desulfatibacillum alkenivorans 259354 Bacteria Bacteria 72.8 4.51e-12   NR WP_073475523.1 259354 g3394 i0 44.6 0.676630434782609 83 43 66 2 361 119 538 619 WP_073475523.1 thrombospondin type-1 domain-containing protein [Desulfatibacillum alkenivorans] diamond 249 72.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfatibacillaceae Desulfatibacillum Desulfatibacillum alkenivorans

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