RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA436017" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA436017 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
26791102 26791102 PRJNA436017_P_NODE_22101_length_174_cov_1.138686_g21803_i0 PRJNA436017 22101 174 1.138686 1.98131364 Candidatus Acidiferrales bacterium 2952895 Bacteria Bacteria 59.3 1.06e-8   NR HXQ24409.1 2952895 g21803 i0 78 0.706896551724138 41 9 70.7 0 50 172 45 85 HXQ24409.1 50S ribosomal protein L10 [Candidatus Acidiferrales bacterium] diamond 123 59.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales     Candidatus Acidiferrales bacterium
27075821 27075821 PRJNA436017_P_NODE_23302_length_169_cov_1.181818_g23004_i0 PRJNA436017 23302 169 1.181818 1.99727242 Acidobacteriota bacterium 1978231 Bacteria Bacteria 76.3 2.05e-14   NR MDJ0840096.1 1978231 g23004 i0 58.9 5.96449704142012 56 23 99.4 0 2 169 225 280 MDJ0840096.1 M20 family metallopeptidase [Acidobacteriota bacterium] diamond 1008 76.3 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27518226 27518226 PRJNA436017_P_NODE_28403_length_153_cov_1.344828_g28105_i0 PRJNA436017 28403 153 1.344828 2.05758684 Acidobacteriota bacterium 1978231 Bacteria Bacteria 63.9 2.13e-10   NR HLP24116.1 1978231 g28105 i0 60 2.98039215686275 50 20 98 0 153 4 150 199 HLP24116.1 HAD-IIB family hydrolase [Acidobacteriota bacterium] diamond 456 63.9 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28212581 28212581 PRJNA436017_P_NODE_10686_length_263_cov_1.362832_g10388_i0 PRJNA436017 10686 263 1.362832 3.58424816 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 119 5.64e-29   NR HEX8286473.1 2283092 g10388 i0 62.1 0.992395437262357 87 33 99.2 0 263 3 427 513 HEX8286473.1 TonB-dependent receptor [Pyrinomonadaceae bacterium] diamond 261 119 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
28939173 28939173 PRJNA436017_P_NODE_3708_length_484_cov_10.228188_g3424_i0 PRJNA436017 3708 484 10.228188 49.50442992 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 55.8 1.39e-6   NR HEY8561019.1 2283092 g3424 i0 63 0.334710743801653 54 17 33.5 2 235 396 76 126 HEY8561019.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 162 55.8 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
29145223 29145223 PRJNA436017_P_NODE_23829_length_167_cov_1.461538_g23531_i0 PRJNA436017 23829 167 1.461538 2.44076846 Bacteria 2 Bacteria Bacteria 47 2.78e-4   NR MDQ3089409.1 1978231 g23531 i0 74.1 2.4251497005988 27 7 48.5 0 167 87 109 135 MDQ3089409.1 energy transducer TonB [Acidobacteriota bacterium] diamond 405 47 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30123697 30123697 PRJNA436017_P_NODE_27792_length_155_cov_1.288136_g27494_i0 PRJNA436017 27792 155 1.288136 1.9966108 Pseudomonadati 3379134 Bacteria Bacteria 90.1 2.04e-19   NR HBL31187.1 1978231 g27494 i0 88.2 5.90322580645161 51 6 98.7 0 154 2 239 289 HBL31187.1 hypothetical protein [Acidobacteriota bacterium] diamond 915 90.9 0.991199119911991 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30282212 30282212 PRJNA436017_P_NODE_29812_length_150_cov_0.973451_g29514_i0 PRJNA436017 29812 150 0.973451 1.4601765 Pseudomonadati 3379134 Bacteria Bacteria 78.6 1.21e-16   NR HZN11135.1 2052146 g29514 i0 72 16.92 50 14 100 0 150 1 42 91 HZN11135.1 tail fiber protein [Blastocatellia bacterium] diamond 2538 78.6 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
30897490 30897490 PRJNA436017_P_NODE_18274_length_192_cov_0.980645_g17976_i0 PRJNA436017 18274 192 0.980645 1.8828384 Bryobacterales bacterium 2026791 Bacteria Bacteria 52.8 5.38e-6   NR MBV9769597.1 2026791 g17976 i0 50.9 3.65625 57 28 89.1 0 17 187 385 441 MBV9769597.1 DegQ family serine endoprotease [Bryobacterales bacterium] diamond 702 52.8 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium
31339729 31339729 PRJNA436017_P_NODE_26076_length_160_cov_0.926829_g25778_i0 PRJNA436017 26076 160 0.926829 1.4829264 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 100 2.4e-26   NR MEO6589170.1 2283092 g25778 i0 98 0.9375 50 1 93.8 0 10 159 1 50 MEO6589170.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 150 100 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
32257561 32257561 PRJNA436017_P_NODE_28398_length_153_cov_1.344828_g28100_i0 PRJNA436017 28398 153 1.344828 2.05758684 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 83.2 5.92e-17   NR MCD9187273.1 2283092 g28100 i0 81.3 0.941176470588235 48 9 94.1 0 148 5 169 216 MCD9187273.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 144 83.2 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);;