RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA656952" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA656952 · 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
14651254 14651254 PRJNA656952_P_NODE_29792_length_256_cov_1.683060_g29605_i0 PRJNA656952 29792 256 1.68306 4.3086336 Acidobacteriota bacterium 1978231 Bacteria Bacteria 160 3.98e-45   NR MDQ4120138.1 1978231 g29605 i0 91.8 0.99609375 85 7 99.6 0 1 255 236 320 MDQ4120138.1 UDP-N-acetylglucosamine 1-carboxyvinyltransferase [Acidobacteriota bacterium] diamond 255 160 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
26923185 26923185 PRJNA656952_P_NODE_27802_length_265_cov_1.869792_g27615_i0 PRJNA656952 27802 265 1.869792 4.9549488 Acidobacteriota bacterium 1978231 Bacteria Bacteria 145 5.35e-38   NR MSO84244.1 1978231 g27615 i0 75 1.94716981132075 88 22 99.6 0 2 265 808 895 MSO84244.1 DUF1553 domain-containing protein [Acidobacteriota bacterium] diamond 516 145 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27776470 27776470 PRJNA656952_P_NODE_36904_length_247_cov_0.885057_g36717_i0 PRJNA656952 36904 247 0.885057 2.18609079 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 151 1.94e-41   NR HWT02761.1 2283092 g36717 i0 86.4 2.95141700404858 81 11 98.4 0 3 245 369 449 HWT02761.1 FAD-binding oxidoreductase [Pyrinomonadaceae bacterium] diamond 729 151 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
28186520 28186520 PRJNA656952_P_NODE_43726_length_241_cov_0.916667_g43539_i0 PRJNA656952 43726 241 0.916667 2.20916747 Candidatus Acidiferrum sp. 3069120 Bacteria Bacteria 97.4 1.08e-21   NR HEY1471567.1 3069120 g43539 i0 82.8 1.44398340248963 58 10 72.2 0 67 240 2 59 HEY1471567.1 acetate kinase [Candidatus Acidiferrum sp.] diamond 348 97.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales   Candidatus Acidiferrum Candidatus Acidiferrum sp.
28439474 28439474 PRJNA656952_P_NODE_22686_length_289_cov_1.087963_g22499_i0 PRJNA656952 22686 289 1.087963 3.14421307 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 132 5.249999999999998e-35   NR HEX9930184.1 2283092 g22499 i0 84.8 3.280276816609 79 12 82 0 2 238 256 334 HEX9930184.1 zf-HC2 domain-containing protein [Pyrinomonadaceae bacterium] diamond 948 132 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
28912712 28912712 PRJNA656952_P_NODE_31988_length_251_cov_0.865169_g31801_i0 PRJNA656952 31988 251 0.865169 2.17157419 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 89.4 1.63e-18   NR HWS86656.1 2283092 g31801 i0 83 1.9003984063745 53 9 63.3 0 250 92 679 731 HWS86656.1 S8 family serine peptidase [Pyrinomonadaceae bacterium] diamond 477 89.4 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
29102541 29102541 PRJNA656952_P_NODE_40468_length_244_cov_0.900585_g40281_i0 PRJNA656952 40468 244 0.900585 2.1974274 Terriglobales bacterium 2282142 Bacteria Bacteria 100 2.68e-23   NR HUL15446.1 2282142 g40281 i0 66.3 0.983606557377049 80 24 97.1 3 237 1 37 114 HUL15446.1 RHS repeat-associated core domain-containing protein [Terriglobales bacterium] diamond 240 100 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
29544303 29544303 PRJNA656952_P_NODE_38250_length_245_cov_1.627907_g38063_i0 PRJNA656952 38250 245 1.627907 3.98837215 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 51.2 2.48e-5   NR HEX8560580.1 2283092 g38063 i0 78.6 0.342857142857143 28 6 34.3 0 160 243 1 28 HEX8560580.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 84 51.2 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
30397785 30397785 PRJNA656952_P_NODE_43993_length_241_cov_0.916667_g43806_i0 PRJNA656952 43993 241 0.916667 2.20916747 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 56.6 9.83e-8   NR MEQ1923753.1 2283092 g43806 i0 79.4 2.86307053941909 34 4 42.3 1 138 239 1 31 MEQ1923753.1 F0F1 ATP synthase subunit beta [Pyrinomonadaceae bacterium] diamond 690 56.6 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
30429288 30429288 PRJNA656952_P_NODE_36813_length_247_cov_0.885057_g36626_i0 PRJNA656952 36813 247 0.885057 2.18609079 Blastocatellia bacterium 2052146 Bacteria Bacteria 139 1.24e-38   NR HKA17866.1 2052146 g36626 i0 82.9 0.995951417004049 82 14 99.6 0 2 247 142 223 HKA17866.1 nucleotidyl transferase AbiEii/AbiGii toxin family protein [Blastocatellia bacterium] diamond 246 139 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
30788684 30788684 PRJNA656952_P_NODE_40434_length_244_cov_0.900585_g40247_i0 PRJNA656952 40434 244 0.900585 2.1974274 Pseudomonadati 3379134 Bacteria Bacteria 74.3 2.72e-13   NR MFN7541960.1 1978231 g40247 i0 50 7.70901639344262 80 39 98.4 1 242 3 500 578 MFN7541960.1 response regulator [Acidobacteriota bacterium] diamond 1881 74.3 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30808045 30808045 PRJNA656952_P_NODE_39314_length_245_cov_0.895349_g39127_i0 PRJNA656952 39314 245 0.895349 2.19360505 Acidobacteriota bacterium 1978231 Bacteria Bacteria 143 9.77e-38   NR MDQ4121115.1 1978231 g39127 i0 87.7 0.991836734693878 81 10 99.2 0 244 2 88 168 MDQ4121115.1 sigma 54-interacting transcriptional regulator [Acidobacteriota bacterium] diamond 243 143 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30934518 30934518 PRJNA656952_P_NODE_34474_length_249_cov_0.875000_g34287_i0 PRJNA656952 34474 249 0.875 2.17875 Acidobacteriota bacterium 1978231 Bacteria Bacteria 124 7.54e-32   NR PYV92483.1 1978231 g34287 i0 73.5 1.98795180722892 83 22 100 0 249 1 231 313 PYV92483.1 MAG: glycerate kinase [Acidobacteriota bacterium] diamond 495 124 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30997690 30997690 PRJNA656952_P_NODE_40594_length_244_cov_0.865497_g40407_i0 PRJNA656952 40594 244 0.865497 2.11181268 Terriglobia bacterium 2081523 Bacteria Bacteria 43.5 0.00663   NR HUZ46833.1 2081523 g40407 i0 42.3 0.639344262295082 52 29 62.7 1 31 183 18 69 HUZ46833.1 hypothetical protein [Terriglobia bacterium] diamond 156 43.5 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
31851234 31851234 PRJNA656952_P_NODE_37977_length_246_cov_0.890173_g37790_i0 PRJNA656952 37977 246 0.890173 2.18982558 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 134 3.25e-34   NR MET0646938.1 2283092 g37790 i0 77.8 2.95121951219512 81 18 98.8 0 244 2 219 299 MET0646938.1 putative baseplate assembly protein [Pyrinomonadaceae bacterium] diamond 726 134 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
32357903 32357903 PRJNA656952_P_NODE_36059_length_247_cov_0.885057_g35872_i0 PRJNA656952 36059 247 0.885057 2.18609079 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 95.5 9.75e-21   NR HEX2640653.1 2283092 g35872 i0 54.9 1.9919028340081 82 37 99.6 0 2 247 383 464 HEX2640653.1 M20/M25/M40 family metallo-hydrolase [Pyrinomonadaceae bacterium] diamond 492 95.5 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
32767891 32767891 PRJNA656952_P_NODE_25620_length_275_cov_1.524752_g25433_i0 PRJNA656952 25620 275 1.524752 4.193068 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 152 3.2299999999999995e-42   NR HEX8195188.1 2283092 g25433 i0 86.7 1.96363636363636 90 12 98.2 0 3 272 312 401 HEX8195188.1 1-deoxy-D-xylulose-5-phosphate reductoisomerase [Pyrinomonadaceae bacterium] diamond 540 152 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae 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);;