RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA498309" 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

  • PRJNA498309 · 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
23433168 23433168 PRJNA498309_P_NODE_38799_length_445_cov_16.828431_g36719_i0 PRJNA498309 38799 445 16.828431 74.88651795 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 249 9.98e-79   NR MBI3759687.1 2026735 g36719 i0 88.7 0.950561797752809 141 16 95.1 0 22 444 282 422 MBI3759687.1 TolC family protein [Deltaproteobacteria bacterium] diamond 423 249 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
26887409 26887409 PRJNA498309_P_NODE_57061_length_341_cov_2.351974_g54913_i0 PRJNA498309 57061 341 2.351974 8.02023134 Myxococcales bacterium 2026763 Bacteria Bacteria 136 6.73e-35   NR MBK7395444.1 2026763 g54913 i0 67.4 0.809384164222874 92 29 80.9 1 24 299 467 557 MBK7395444.1 hypothetical protein [Myxococcales bacterium] diamond 276 136 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
26918865 26918865 PRJNA498309_P_NODE_3882_length_1764_cov_2.780544_g2953_i0 PRJNA498309 3882 1764 2.780544 49.04879616 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 352 2.44e-111   NR MBI5327092.1 2026735 g2953 i0 75.9 0.387755102040816 228 55 38.8 0 1762 1079 272 499 MBI5327092.1 hypothetical protein [Deltaproteobacteria bacterium] diamond 684 352 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
27139912 27139912 PRJNA498309_S_NODE_39062_length_218_cov_517.896175_g36894_i0 PRJNA498309 39062 218 517.896175 1129.0136615 Myxococcales bacterium 2026763 Bacteria Bacteria 60.1 9.36e-9   NR MEA2698107.1 2026763 g36894 i0 42.9 1.73394495412844 63 32 81.2 1 182 6 16 78 MEA2698107.1 hypothetical protein [Myxococcales bacterium] diamond 378 60.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
27203208 27203208 PRJNA498309_P_NODE_31082_length_508_cov_8.252654_g29072_i0 PRJNA498309 31082 508 8.252654 41.92348232 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 84.3 2.24e-15   NR MCP4372961.1 2026735 g29072 i0 35.6 1.83661417322835 160 64 94.5 2 489 10 1762 1882 MCP4372961.1 hypothetical protein [Deltaproteobacteria bacterium] diamond 933 84.3 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
27313947 27313947 PRJNA498309_S_NODE_6783_length_1064_cov_26.015549_g5270_i0 PRJNA498309 6783 1064 26.015549 276.80544136 Bacteria 2 Bacteria Bacteria 336 1.1599999999999999e-110   NR WP_211241634.1 43 g5270 i0 70.5 8.66729323308271 234 69 66 0 702 1 4 237 WP_211241634.1 NADP-dependent oxidoreductase [Cystobacter fuscus] diamond 9222 336 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Cystobacter Cystobacter fuscus
27582479 27582479 PRJNA498309_P_NODE_61284_length_322_cov_1.957895_g59136_i0 PRJNA498309 61284 322 1.957895 6.3044219 Myxococcales bacterium 2026763 Bacteria Bacteria 99.8 9.39e-22   NR MFT3926649.1 2026763 g59136 i0 58 0.754658385093168 81 34 75.5 0 78 320 1 81 MFT3926649.1 protein kinase [Myxococcales bacterium] diamond 243 99.8 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
28119269 28119269 PRJNA498309_S_NODE_6405_length_1110_cov_20.190698_g4920_i0 PRJNA498309 6405 1110 20.190698 224.1167478 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 399 4.9299999999999985e-133   NR MBI5327092.1 2026735 g4920 i0 73.2 1.47027027027027 272 72 73.5 1 1091 276 229 499 MBI5327092.1 hypothetical protein [Deltaproteobacteria bacterium] diamond 1632 399 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
28182219 28182219 PRJNA498309_P_NODE_56766_length_342_cov_5.281967_g54618_i0 PRJNA498309 56766 342 5.281967 18.06432714 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 102 5.28e-23   NR MDP2339769.1 2026735 g54618 i0 55 0.87719298245614 100 43 87.7 1 23 322 186 283 MDP2339769.1 acyltransferase [Deltaproteobacteria bacterium] diamond 300 102 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
28640183 28640183 PRJNA498309_P_NODE_36627_length_462_cov_2.555294_g34567_i0 PRJNA498309 36627 462 2.555294 11.80545828 Pseudomonadati 3379134 Bacteria Bacteria 225 1.68e-70   NR WP_211241634.1 43 g34567 i0 73 8.92207792207792 152 41 98.7 0 5 460 88 239 WP_211241634.1 NADP-dependent oxidoreductase [Cystobacter fuscus] diamond 4122 226 0.995575221238938 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Cystobacter Cystobacter fuscus
28877031 28877031 PRJNA498309_P_NODE_56048_length_345_cov_9.178571_g53900_i0 PRJNA498309 56048 345 9.178571 31.66606995 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 123 3.33e-31   NR TMA52296.1 2026735 g53900 i0 76.5 0.704347826086957 81 19 70.4 0 101 343 176 256 TMA52296.1 MAG: hypothetical protein E6J80_12430, partial [Deltaproteobacteria bacterium] diamond 243 123 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
29319047 29319047 PRJNA498309_P_NODE_30089_length_518_cov_4.313929_g28094_i0 PRJNA498309 30089 518 4.313929 22.34615222 Kofleriaceae bacterium 2212474 Bacteria Bacteria 296 2.5099999999999996e-99   NR HVK87712.1 2212474 g28094 i0 91.1 0.909266409266409 157 14 90.9 0 1 471 79 235 HVK87712.1 hypothetical protein [Kofleriaceae bacterium] diamond 471 296 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae   Kofleriaceae bacterium
29729314 29729314 PRJNA498309_P_NODE_26110_length_562_cov_12.634286_g24160_i0 PRJNA498309 26110 562 12.634286 71.00468732 Corallococcus 83461 Bacteria Bacteria 172 7.76e-51   NR WP_121723575.1 83461 g24160 i0 47.2 1.71886120996441 161 85 85.9 0 504 22 1 161 WP_121723575.1 MULTISPECIES: FMN-binding negative transcriptional regulator [Corallococcus] diamond 966 172 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Corallococcus  
29950698 29950698 PRJNA498309_P_NODE_42131_length_423_cov_1.341969_g40016_i0 PRJNA498309 42131 423 1.341969 5.67652887 Polyangiaceae bacterium 2268199 Bacteria Bacteria 57.8 1.29e-6   NR HWP05252.1 2268199 g40016 i0 86.7 0.673758865248227 30 4 21.3 0 331 420 3 32 HWP05252.1 glycosyltransferase [Polyangiaceae bacterium] diamond 285 57.8 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
30582359 30582359 PRJNA498309_P_NODE_77873_length_257_cov_4.595455_g75724_i0 PRJNA498309 77873 257 4.595455 11.81031935 Polyangiaceae bacterium 2268199 Bacteria Bacteria 83.2 2.21e-17   NR HEX4514982.1 2268199 g75724 i0 50 1.96108949416342 84 42 98.1 0 3 254 54 137 HEX4514982.1 histidine phosphatase family protein [Polyangiaceae bacterium] diamond 504 83.2 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
32005330 32005330 PRJNA498309_P_NODE_71298_length_281_cov_1.721311_g69149_i0 PRJNA498309 71298 281 1.721311 4.83688391 Myxococcota bacterium 2818507 Bacteria Bacteria 61.6 1.3e-8   NR MEM9459086.1 2818507 g69149 i0 44.7 0.811387900355872 76 41 81.1 1 21 248 352 426 MEM9459086.1 right-handed parallel beta-helix repeat-containing protein [Myxococcota bacterium] diamond 228 61.6 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
32652881 32652881 PRJNA498309_P_NODE_45540_length_402_cov_2.558904_g43408_i0 PRJNA498309 45540 402 2.558904 10.28679408 Bacteria candidate phyla 1783234 Bacteria Bacteria 134 7.59e-35   NR MCY4488154.1 2026735 g43408 i0 53 15.7462686567164 115 53 85.8 1 365 21 16 129 MCY4488154.1 cupin domain-containing protein [Deltaproteobacteria bacterium] diamond 6330 134 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria 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);;