RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA1067443" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1067443 · 17 ✖

analysis 1

  • diamond · 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
181326 181326 PRJNA1067443_P_NODE_1001_length_573_cov_16.514000_g983_i0 PRJNA1067443 1001 573 16.514 94.62522 Myxococcaceae bacterium 2484252 Bacteria Bacteria 78.6 3.16e-13   NR MDB5217722.1 2484252 g983 i0 61.8 0.397905759162304 76 23 36.6 2 212 3 4 79 MDB5217722.1 outer rane efflux protein [Myxococcaceae bacterium] diamond 228 78.6 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae   Myxococcaceae bacterium
5284548 5284548 PRJNA1067443_P_NODE_9405_length_289_cov_1.375000_g9387_i0 PRJNA1067443 9405 289 1.375 3.97375 Bacteria 2 Bacteria Bacteria 155 4.04e-43   NR HVK78547.1 2212474 g9387 i0 77.2 15.0934256055363 92 21 95.5 0 4 279 80 171 HVK78547.1 wax ester/triacylglycerol synthase family O-acyltransferase [Kofleriaceae bacterium] diamond 4362 155 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae   Kofleriaceae bacterium
12492407 12492407 PRJNA1067443_P_NODE_6830_length_321_cov_13.209677_g6812_i0 PRJNA1067443 6830 321 13.209677 42.40306317 Hyalangium minutum 394096 Bacteria Bacteria 192 5.619999999999999e-55   NR WP_075305819.1 394096 g6812 i0 91.9 1.85046728971963 99 8 92.5 0 319 23 415 513 WP_075305819.1 GMC family oxidoreductase N-terminal domain-containing protein [Hyalangium minutum] diamond 594 192 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Hyalangium Hyalangium minutum
26963807 26963807 PRJNA1067443_P_NODE_21102_length_243_cov_1.647059_g21084_i0 PRJNA1067443 21102 243 1.647059 4.00235337 Pseudomonadati 3379134 Bacteria Bacteria 100 2.2700000000000003e-22   NR WP_225409620.1 394097 g21084 i0 68.8 16.5061728395062 64 20 79 0 51 242 76 139 WP_225409620.1 methanol/ethanol family PQQ-dependent dehydrogenase [Stigmatella hybrida] diamond 4011 100 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Stigmatella Stigmatella hybrida
27320232 27320232 PRJNA1067443_P_NODE_18843_length_247_cov_0.885057_g18825_i0 PRJNA1067443 18843 247 0.885057 2.18609079 Labilithrix sp. 1971228 Bacteria Bacteria 137 2.07e-35   NR HVH40816.1 1971228 g18825 i0 87.8 3.98380566801619 82 10 99.6 0 246 1 444 525 HVH40816.1 hypothetical protein [Labilithrix sp.] diamond 984 137 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix sp.
27351988 27351988 PRJNA1067443_P_NODE_17523_length_249_cov_0.875000_g17505_i0 PRJNA1067443 17523 249 0.875 2.17875 Archangium sp. 1872627 Bacteria Bacteria 77.4 9.37e-15   NR MFT3711376.1 1872627 g17505 i0 90.2 0.493975903614458 41 4 49.4 0 247 125 247 287 MFT3711376.1 hypothetical protein [Archangium sp.] diamond 123 77.4 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium sp.
27825491 27825491 PRJNA1067443_P_NODE_17544_length_249_cov_0.875000_g17526_i0 PRJNA1067443 17544 249 0.875 2.17875 Labilithrix sp. 1971228 Bacteria Bacteria 50.4 6.73e-5   NR MBX3229614.1 1971228 g17526 i0 86.7 0.36144578313253 30 4 36.1 0 129 40 11 40 MBX3229614.1 GGDEF domain-containing protein [Labilithrix sp.] diamond 90 50.4 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix sp.
28457021 28457021 PRJNA1067443_P_NODE_9126_length_291_cov_2.321101_g9108_i0 PRJNA1067443 9126 291 2.321101 6.75440391 Polyangiales bacterium 3034171 Bacteria Bacteria 85.9 7.07e-18   NR HEY2734316.1 3034171 g9108 i0 77.6 1.01030927835052 49 11 50.5 0 147 1 28 76 HEY2734316.1 TIGR00730 family Rossman fold protein [Polyangiales bacterium] diamond 294 85.9 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales     Polyangiales bacterium
29080042 29080042 PRJNA1067443_P_NODE_22488_length_241_cov_0.916667_g22470_i0 PRJNA1067443 22488 241 0.916667 2.20916747 Bacteria 2 Bacteria Bacteria 73.6 1.68e-13   NR MCC7534845.1 2026735 g22470 i0 86.8 5.67634854771784 38 5 47.3 0 241 128 219 256 MCC7534845.1 type 1 glutamine amidotransferase domain-containing protein [Deltaproteobacteria bacterium] diamond 1368 73.6 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
29687939 29687939 PRJNA1067443_P_NODE_22650_length_241_cov_0.916667_g22632_i0 PRJNA1067443 22650 241 0.916667 2.20916747 Myxococcota bacterium 2818507 Bacteria Bacteria 157 4.22e-45   NR MEZ0311097.1 2818507 g22632 i0 96.2 0.983402489626556 79 3 98.3 0 239 3 230 308 MEZ0311097.1 zinc-binding dehydrogenase [Myxococcota bacterium] diamond 237 157 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
29719570 29719570 PRJNA1067443_P_NODE_18810_length_247_cov_0.885057_g18792_i0 PRJNA1067443 18810 247 0.885057 2.18609079 Aetherobacter fasciculatus 888830 Bacteria Bacteria 89.4 6.36e-20   NR WP_346373891.1 888830 g18792 i0 66.2 2.52631578947368 68 23 82.6 0 206 3 111 178 WP_346373891.1 TetR/AcrR family transcriptional regulator [Aetherobacter fasciculatus] diamond 624 89.4 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Aetherobacter Aetherobacter fasciculatus
29972488 29972488 PRJNA1067443_P_NODE_20291_length_245_cov_0.895349_g20273_i0 PRJNA1067443 20291 245 0.895349 2.19360505 Myxococcota bacterium 2818507 Bacteria Bacteria 135 9.15e-35   NR HSI03893.1 2818507 g20273 i0 82.7 0.991836734693878 81 14 99.2 0 3 245 227 307 HSI03893.1 MMPL family transporter [Myxococcota bacterium] diamond 243 135 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
30920566 30920566 PRJNA1067443_P_NODE_19354_length_246_cov_0.890173_g19336_i0 PRJNA1067443 19354 246 0.890173 2.18982558 Myxococcota bacterium 2818507 Bacteria Bacteria 82.4 5.71e-18   NR MEZ0314045.1 2818507 g19336 i0 76 0.609756097560976 50 12 61 0 150 1 1 50 MEZ0314045.1 response regulator [Myxococcota bacterium] diamond 150 82.4 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
30983707 30983707 PRJNA1067443_P_NODE_11554_length_276_cov_1.339901_g11536_i0 PRJNA1067443 11554 276 1.339901 3.69812676 Archangium sp. 1872627 Bacteria Bacteria 169 1.3899999999999999e-46   NR MFT3712095.1 1872627 g11536 i0 93.3 0.978260869565217 90 6 97.8 0 3 272 269 358 MFT3712095.1 DUF4175 family protein [Archangium sp.] diamond 270 169 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium sp.
31236226 31236226 PRJNA1067443_P_NODE_20635_length_244_cov_0.900585_g20617_i0 PRJNA1067443 20635 244 0.900585 2.1974274 Myxococcota bacterium 2818507 Bacteria Bacteria 133 5.639999999999999e-37   NR HEX2485170.1 2818507 g20617 i0 76.3 5.9016393442623 80 19 98.4 0 242 3 87 166 HEX2485170.1 PIG-L deacetylase family protein [Myxococcota bacterium] diamond 1440 133 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
32185444 32185444 PRJNA1067443_P_NODE_22118_length_242_cov_0.911243_g22100_i0 PRJNA1067443 22118 242 0.911243 2.20520806 Polyangiaceae bacterium 2268199 Bacteria Bacteria 142 3.3299999999999996e-37   NR HEU5076633.1 2268199 g22100 i0 82.5 0.991735537190083 80 14 99.2 0 240 1 469 548 HEU5076633.1 PAS domain-containing protein [Polyangiaceae bacterium] diamond 240 142 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
32272012 32272012 PRJNA1067443_P_NODE_7158_length_316_cov_8.234568_g7140_i0 PRJNA1067443 7158 316 8.234568 26.02123488 Myxococcales 29 Bacteria Bacteria 160 3.09e-43   NR PZR13283.1 48 g7140 i0 73.3 2.85759493670886 105 24 95.9 1 1 303 298 402 PZR13283.1 MAG: helicase [Archangium gephyra] diamond 903 161 0.993788819875776 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium gephyra

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