RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA1022392", tax_phylum = "Thermodesulfobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 18 ✖

tax_phylum 1

  • Thermodesulfobacteriota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1022392 · 18 ✖

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
2712724 2712724 PRJNA1022392_P_NODE_52163_length_187_cov_2.892857_g51494_i0 PRJNA1022392 52163 187 2.892857 5.40964259 uncultured Mailhella sp. 1981031 Bacteria Bacteria 274 3.14e-69   NTclustered gi|2729058701|emb|OZ007001.1| 1981031 g51494 i0 93.048 8.9144385026738 187 13 100 0 1 187 227991 227805 MAG: uncultured Mailhella sp. isolate metabat2_pooled_hifiasm.920 MAG genome assembly, chromosome: 1 blastn 1667 274 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Mailhella uncultured Mailhella sp.
9089953 9089953 PRJNA1022392_P_NODE_60228_length_177_cov_1.415385_g59559_i0 PRJNA1022392 60228 177 1.415385 2.50523145 Desulfovibrio desulfuricans 876 Bacteria Bacteria 270 3.7899999999999986e-68   NTclustered gi|2172810686|gb|CP077745.1| 876 g59559 i0 94.318 2.98305084745763 176 10 99 0 1 176 2302117 2302292 Desulfovibrio desulfuricans strain Edelweiss chromosome, complete genome blastn 528 270 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
15464723 15464723 PRJNA1022392_P_NODE_28993_length_206_cov_4.094340_g28324_i0 PRJNA1022392 28993 206 4.09434 8.4343404 Desulfovibrio desulfuricans 876 Bacteria Bacteria 281 2.11e-71   NTclustered gi|2172810686|gb|CP077745.1| 876 g28324 i0 89.352 3.15533980582524 216 13 100 1 1 206 2644035 2644250 Desulfovibrio desulfuricans strain Edelweiss chromosome, complete genome blastn 650 281 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Desulfovibrio Desulfovibrio desulfuricans
20563505 20563505 PRJNA1022392_P_NODE_56177_length_182_cov_2.192593_g55508_i0 PRJNA1022392 56177 182 2.192593 3.99051926 Thermodesulfobacterium commune 1741 Bacteria Bacteria 337 3.82e-88   NTclustered gi|668351138|gb|CP008796.1| 289377 g55508 i0 100 1 182 0 100 0 1 182 1391597 1391778 Thermodesulfobacterium commune DSM 2178, complete genome blastn 182 337 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Thermodesulfobacteria Thermodesulfobacteriales Thermodesulfobacteriaceae Thermodesulfobacterium Thermodesulfobacterium commune
26686683 26686683 PRJNA1022392_P_NODE_76961_length_159_cov_3.973214_g76292_i0 PRJNA1022392 76961 159 3.973214 6.31741026 Desulfobacterales bacterium 2044940 Bacteria Bacteria 55.1 3.22e-8   NR MBS3809325.1 2044940 g76292 i0 96 0.471698113207547 25 1 47.2 0 1 75 58 82 MBS3809325.1 hypothetical protein [Desulfobacterales bacterium] diamond 75 55.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
27919378 27919378 PRJNA1022392_P_NODE_80085_length_157_cov_2.227273_g79416_i0 PRJNA1022392 80085 157 2.227273 3.49681861 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 64.3 8.05e-12   NR MEF8823176.1 2683721 g79416 i0 96.9 1.22292993630573 32 1 61.1 0 156 61 57 88 MEF8823176.1 50S ribosomal protein L27 [Desulfohalobiaceae bacterium] diamond 192 64.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
27919380 27919380 PRJNA1022392_P_NODE_82085_length_155_cov_2.194444_g81416_i0 PRJNA1022392 82085 155 2.194444 3.4013882 Desulfovibrionaceae bacterium 2049043 Bacteria Bacteria 61.2 3.33e-9   NR MCL1962486.1 2049043 g81416 i0 56.9 0.987096774193548 51 22 98.7 0 1 153 4507 4557 MCL1962486.1 Ig-like domain-containing protein [Desulfovibrionaceae bacterium] diamond 153 61.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae   Desulfovibrionaceae bacterium
27951067 27951067 PRJNA1022392_P_NODE_10765_length_341_cov_2.758503_g10108_i0 PRJNA1022392 10765 341 2.758503 9.40649523 Desulfobulbaceae bacterium 2053307 Bacteria Bacteria 133 9.139999999999999e-35   NR MCP4340929.1 2053307 g10108 i0 79.5 0.730205278592375 83 17 73 0 4 252 55 137 MCP4340929.1 hypothetical protein [Desulfobulbaceae bacterium] diamond 249 133 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae   Desulfobulbaceae bacterium
28077226 28077226 PRJNA1022392_P_NODE_80625_length_157_cov_0.927273_g79956_i0 PRJNA1022392 80625 157 0.927273 1.45581861 Desulfovermiculus sp. 2821143 Bacteria Bacteria 79.3 8.51e-16   NR MDZ7761692.1 2821143 g79956 i0 75 0.993630573248408 52 13 99.4 0 2 157 103 154 MDZ7761692.1 hypothetical protein [Desulfovermiculus sp.] diamond 156 79.3 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae Desulfovermiculus Desulfovermiculus sp.
28519467 28519467 PRJNA1022392_P_NODE_56107_length_182_cov_2.466667_g55438_i0 PRJNA1022392 56107 182 2.466667 4.48933394 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 44.7 0.0034   NR MEF8824490.1 2683721 g55438 i0 77.8 0.445054945054945 27 6 44.5 0 6 86 1 27 MEF8824490.1 efflux RND transporter periplasmic adaptor subunit [Desulfohalobiaceae bacterium] diamond 81 44.7 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
30192893 30192893 PRJNA1022392_P_NODE_72332_length_163_cov_1.612069_g71663_i0 PRJNA1022392 72332 163 1.612069 2.62767247 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 70.9 3.17e-14   NR MEF8823180.1 2683721 g71663 i0 84.6 0.717791411042945 39 6 71.8 0 163 47 63 101 MEF8823180.1 MoaD/ThiS family protein [Desulfohalobiaceae bacterium] diamond 117 70.9 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
30666897 30666897 PRJNA1022392_P_NODE_70353_length_165_cov_0.864407_g69684_i0 PRJNA1022392 70353 165 0.864407 1.42627155 Malonomonas rubra 57040 Bacteria Bacteria 41.2 0.0457   NR WP_303721996.1 57040 g69684 i0 37.5 0.872727272727273 48 29 85.5 1 164 24 688 735 WP_303721996.1 AMP-binding protein [Malonomonas rubra] diamond 144 41.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Geopsychrobacteraceae Malonomonas Malonomonas rubra
31520452 31520452 PRJNA1022392_P_NODE_48916_length_191_cov_4.986111_g48247_i0 PRJNA1022392 48916 191 4.986111 9.52347201 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 45.8 0.00153   NR MFC1840384.1 2202153 g48247 i0 67.9 0.958115183246073 28 9 44 0 176 93 515 542 MFC1840384.1 tannase/feruloyl esterase family alpha/beta hydrolase [Thermodesulfobacteriota bacterium] diamond 183 45.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
31678338 31678338 PRJNA1022392_P_NODE_75117_length_161_cov_1.359649_g74448_i0 PRJNA1022392 75117 161 1.359649 2.18903489 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 93.6 1.43e-20   NR MCF8030351.1 2683721 g74448 i0 86.5 0.968944099378882 52 7 96.9 0 158 3 498 549 MCF8030351.1 fatty acid--CoA ligase [Desulfohalobiaceae bacterium] diamond 156 93.6 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
31710123 31710123 PRJNA1022392_P_NODE_61817_length_175_cov_1.429688_g61148_i0 PRJNA1022392 61817 175 1.429688 2.501954 Desulfobacterales bacterium 2044940 Bacteria Bacteria 113 2.27e-27   NR MBS3731542.1 2044940 g61148 i0 100 0.977142857142857 57 0 97.7 0 173 3 440 496 MBS3731542.1 cysteine--tRNA ligase [Desulfobacterales bacterium] diamond 171 113 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales     Desulfobacterales bacterium
32216402 32216402 PRJNA1022392_P_NODE_79378_length_158_cov_0.918919_g78709_i0 PRJNA1022392 79378 158 0.918919 1.45189202 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 100 1.23e-25   NR MEF8889185.1 2683721 g78709 i0 92.3 0.987341772151899 52 4 98.7 0 1 156 51 102 MEF8889185.1 30S ribosomal protein S9 [Desulfohalobiaceae bacterium] diamond 156 100 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
32753294 32753294 PRJNA1022392_P_NODE_58460_length_179_cov_2.143939_g57791_i0 PRJNA1022392 58460 179 2.143939 3.83765081 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 113 7.61e-29   NR MEF8941678.1 2683721 g57791 i0 83.1 0.988826815642458 59 10 98.9 0 3 179 98 156 MEF8941678.1 alpha/beta fold hydrolase [Desulfohalobiaceae bacterium] diamond 177 113 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae bacterium
32847707 32847707 PRJNA1022392_P_NODE_83580_length_152_cov_2.942857_g82911_i0 PRJNA1022392 83580 152 2.942857 4.47314264 Desulfohalobiaceae bacterium 2683721 Bacteria Bacteria 92.8 9.23e-22   NR MEF8822635.1 2683721 g82911 i0 84 0.986842105263158 50 8 98.7 0 152 3 90 139 MEF8822635.1 50S ribosomal protein L25 [Desulfohalobiaceae bacterium] diamond 150 92.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae   Desulfohalobiaceae 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);;