RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA643700", tax_kingdom = "Pseudomonadati" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 8 ✖

tax_kingdom 1

  • Pseudomonadati · 8 ✖

bioproject 1

  • PRJNA643700 · 8 ✖

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
3168885 3168885 PRJNA643700_P_NODE_179023_length_299_cov_1.248000_g177467_i0 PRJNA643700 179023 299 1.248 3.73152 Archangium gephyra 48 Bacteria Bacteria 510 3.82e-140   NTclustered gi|827418478|gb|CP011509.1| 48 g177467 i0 97.643 220.060200668896 297 7 99 0 1 297 1063510 1063214 Archangium gephyra strain DSM 2261, complete genome blastn 65798 510 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium gephyra
8811569 8811569 PRJNA643700_P_NODE_299947_length_210_cov_1.012422_g298391_i0 PRJNA643700 299947 210 1.012422 2.1260862 Archangiaceae 39 Bacteria Bacteria 388 1.24e-103   NTclustered gi|2579665545|gb|CP043492.1| 43 g298391 i0 100 246.485714285714 210 0 100 0 1 210 453344 453135 Cystobacter fuscus strain Cbf 8 chromosome, complete genome blastn 51762 388 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Cystobacter Cystobacter fuscus
9546865 9546865 PRJNA643700_P_NODE_401168_length_166_cov_1.777778_g399612_i0 PRJNA643700 401168 166 1.777778 2.95111148 Archangium gephyra 48 Bacteria Bacteria 296 5.82e-76   NTclustered gi|2809295724|gb|CP102578.1| 48 g399612 i0 98.795 271.180722891566 166 2 100 0 1 166 336520 336355 Archangium gephyra strain SDU49 chromosome, complete genome blastn 45016 296 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium gephyra
26638008 26638008 PRJNA643700_P_NODE_183361_length_294_cov_2.424490_g181805_i0 PRJNA643700 183361 294 2.42449 7.1280006 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 44.3 0.0168   NR MBM4379077.1 2026735 g181805 i0 43.5 0.63265306122449 62 31 61.2 2 108 287 7 66 MBM4379077.1 methyltransferase domain-containing protein [Deltaproteobacteria bacterium] diamond 186 44.3 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
28313074 28313074 PRJNA643700_P_NODE_409686_length_165_cov_0.896552_g408130_i0 PRJNA643700 409686 165 0.896552 1.4793108 Myxococcota bacterium 2818507 Bacteria Bacteria 67.4 2.51e-11   NR MEC7241042.1 2818507 g408130 i0 63 0.836363636363636 46 17 83.6 0 140 3 27 72 MEC7241042.1 3-deoxy-7-phosphoheptulonate synthase class II [Myxococcota bacterium] diamond 138 67.4 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
29733559 29733559 PRJNA643700_P_NODE_294210_length_213_cov_1.225610_g292654_i0 PRJNA643700 294210 213 1.22561 2.6105493 Myxococcales bacterium 2026763 Bacteria Bacteria 40.4 0.0424   NR MBX2800725.1 2026763 g292654 i0 37.7 0.971830985915493 69 28 90.1 2 5 196 9 67 MBX2800725.1 transposase [Myxococcales bacterium] diamond 207 40.4 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
30492068 30492068 PRJNA643700_P_NODE_113573_length_389_cov_6.491176_g112019_i0 PRJNA643700 113573 389 6.491176 25.25067464 Myxococcota bacterium 2818507 Bacteria Bacteria 46.2 0.00958   NR MEZ4316278.1 2818507 g112019 i0 44.4 0.48586118251928 63 33 48.6 2 11 199 225 285 MEZ4316278.1 hypothetical protein [Myxococcota bacterium] diamond 189 46.2 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
32893702 32893702 PRJNA643700_P_NODE_252700_length_238_cov_0.740741_g251144_i0 PRJNA643700 252700 238 0.740741 1.76296358 Stigmatella aurantiaca DW4/3-1 378806 Bacteria Bacteria 43.9 0.0141   NR EAU62172.1 378806 g251144 i0 45.1 0.642857142857143 51 21 61.8 3 8 154 9 54 EAU62172.1 conserved hypothetical protein, partial [Stigmatella aurantiaca DW4/3-1] diamond 153 43.9 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Stigmatella Stigmatella aurantiaca

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