RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA1032461" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 19 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1032461 · 19 ✖

analysis 1

  • diamond · 19 ✖

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
12920788 12920788 PRJNA1032461_S_NODE_20471_length_163_cov_0.912281_g20373_i0 PRJNA1032461 20471 163 0.912281 1.48701803 Acidobacteriota bacterium 1978231 Bacteria Bacteria 98.2 2.7e-22   NR MCA1624953.1 1978231 g20373 i0 88.9 7.95092024539877 54 6 99.4 0 2 163 119 172 MCA1624953.1 UDP-N-acetylmuramoyl-L-alanine--D-glutamate ligase [Acidobacteriota bacterium] diamond 1296 98.2 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
26686812 26686812 PRJNA1032461_S_NODE_19061_length_164_cov_0.904348_g18963_i0 PRJNA1032461 19061 164 0.904348 1.48313072 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 95.5 2.98e-21   NR HLM60675.1 2283092 g18963 i0 87 8.89024390243902 54 7 98.8 0 163 2 31 84 HLM60675.1 DEAD/DEAH box helicase [Pyrinomonadaceae bacterium] diamond 1458 95.5 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
27098301 27098301 PRJNA1032461_S_NODE_21422_length_162_cov_0.920354_g21324_i0 PRJNA1032461 21422 162 0.920354 1.49097348 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 47 3.94e-4   NR HEX2254149.1 2651171 g21324 i0 50.9 4.7962962962963 53 26 98.1 0 2 160 1984 2036 HEX2254149.1 condensation domain-containing protein [Thermoanaerobaculia bacterium] diamond 777 47 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
27287973 27287973 PRJNA1032461_S_NODE_20683_length_163_cov_0.912281_g20585_i0 PRJNA1032461 20683 163 0.912281 1.48701803 Acidobacteriota bacterium 1978231 Bacteria Bacteria 54.7 6.36e-7   NR MEO8034450.1 1978231 g20585 i0 57.1 0.773006134969325 42 15 77.3 1 30 155 30 68 MEO8034450.1 hypothetical protein [Acidobacteriota bacterium] diamond 126 54.7 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27698897 27698897 PRJNA1032461_S_NODE_20144_length_163_cov_0.912281_g20046_i0 PRJNA1032461 20144 163 0.912281 1.48701803 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 89.4 3.31e-19   NR HEV3199520.1 2212468 g20046 i0 81.1 1.95092024539877 53 10 97.5 0 161 3 96 148 HEV3199520.1 biotin carboxylase N-terminal domain-containing protein [Bryobacteraceae bacterium] diamond 318 89.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
27951208 27951208 PRJNA1032461_S_NODE_17005_length_166_cov_1.222222_g16907_i0 PRJNA1032461 17005 166 1.222222 2.02888852 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 52.8 3.83e-6   NR HLM60470.1 2283092 g16907 i0 60.5 0.77710843373494 43 17 77.7 0 37 165 82 124 HLM60470.1 tetratricopeptide repeat protein [Pyrinomonadaceae bacterium] diamond 129 52.8 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
28456474 28456474 PRJNA1032461_S_NODE_18166_length_165_cov_0.896552_g18068_i0 PRJNA1032461 18166 165 0.896552 1.4793108 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 42.7 0.0128   NR HVS15483.1 2651171 g18068 i0 37.5 0.872727272727273 48 29 85.5 1 163 23 24 71 HVS15483.1 amidophosphoribosyltransferase [Thermoanaerobaculia bacterium] diamond 144 42.7 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
28993407 28993407 PRJNA1032461_S_NODE_17228_length_166_cov_0.888889_g17130_i0 PRJNA1032461 17228 166 0.888889 1.47555574 Acidobacteriota bacterium 1978231 Bacteria Bacteria 61.2 2.24e-9   NR MDQ3711890.1 1978231 g17130 i0 58.8 0.921686746987952 51 21 92.2 0 154 2 1 51 MDQ3711890.1 hypothetical protein [Acidobacteriota bacterium] diamond 153 61.2 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29940530 29940530 PRJNA1032461_S_NODE_18531_length_165_cov_0.896552_g18433_i0 PRJNA1032461 18531 165 0.896552 1.4793108 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 60.8 5.17e-9   NR HLA95885.1 2283092 g18433 i0 57.4 0.981818181818182 54 23 98.2 0 163 2 282 335 HLA95885.1 LPS export ABC transporter periplasmic protein LptC [Pyrinomonadaceae bacterium] diamond 162 60.8 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
29995740 29995740 PRJNA1032461_S_NODE_15671_length_168_cov_0.873950_g15573_i0 PRJNA1032461 15671 168 0.87395 1.468236 Bacteria 2 Bacteria Bacteria 96.7 1.02e-22   NR MDQ3713962.1 1978231 g15573 i0 92.3 3.71428571428571 52 4 92.9 0 11 166 1 52 MDQ3713962.1 NADH-quinone oxidoreductase subunit H [Acidobacteriota bacterium] diamond 624 96.7 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30098212 30098212 PRJNA1032461_S_NODE_11572_length_183_cov_1.791045_g11474_i0 PRJNA1032461 11572 183 1.791045 3.27761235 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 90.1 3.37e-19   NR HEX8195457.1 2283092 g11474 i0 71 6.11475409836066 62 16 98.4 1 2 181 878 939 HEX8195457.1 P-loop NTPase fold protein [Pyrinomonadaceae bacterium] diamond 1119 90.1 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
30509076 30509076 PRJNA1032461_S_NODE_17233_length_166_cov_0.888889_g17135_i0 PRJNA1032461 17233 166 0.888889 1.47555574 Terriglobus sp. 1889013 Bacteria Bacteria 73.9 4.14e-14   NR HEY9137545.1 1889013 g17135 i0 87.2 0.704819277108434 39 5 70.5 0 1 117 214 252 HEY9137545.1 lysophospholipid acyltransferase family protein [Terriglobus sp.] diamond 117 73.9 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terriglobus Terriglobus sp.
30730205 30730205 PRJNA1032461_S_NODE_19574_length_164_cov_0.904348_g19476_i0 PRJNA1032461 19574 164 0.904348 1.48313072 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 80.1 8.58e-16   NR HEX8138063.1 2283092 g19476 i0 66 3.95121951219512 53 18 97 0 160 2 371 423 HEX8138063.1 TonB-dependent receptor [Pyrinomonadaceae bacterium] diamond 648 80.1 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
30951596 30951596 PRJNA1032461_S_NODE_11934_length_181_cov_1.181818_g11836_i0 PRJNA1032461 11934 181 1.181818 2.13909058 Acidobacteriota bacterium 1978231 Bacteria Bacteria 69.7 4.87e-12   NR MEA2490815.1 1978231 g11836 i0 60.3 1.93922651933702 58 23 96.1 0 176 3 318 375 MEA2490815.1 type transport system permease protein [Acidobacteriota bacterium] diamond 351 69.7 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31077944 31077944 PRJNA1032461_S_NODE_15755_length_168_cov_0.873950_g15657_i0 PRJNA1032461 15755 168 0.87395 1.468236 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 85.5 1.14e-17   NR HEX8369390.1 2283092 g15657 i0 66.7 0.964285714285714 54 18 96.4 0 5 166 11 64 HEX8369390.1 DUF4350 domain-containing protein [Pyrinomonadaceae bacterium] diamond 162 85.5 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
31386117 31386117 PRJNA1032461_S_NODE_7076_length_224_cov_1.188571_g6978_i0 PRJNA1032461 7076 224 1.188571 2.66239904 Bacteria 2 Bacteria Bacteria 42.7 0.0293   NR MCL4814791.1 2590576 g6978 i0 33.3 1.75446428571429 72 46 93.8 1 15 224 397 468 MCL4814791.1 hypothetical protein [Vicinamibacteraceae bacterium] diamond 393 42.7 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales Vicinamibacteraceae   Vicinamibacteraceae bacterium
32026645 32026645 PRJNA1032461_S_NODE_17738_length_166_cov_0.880342_g17640_i0 PRJNA1032461 17738 166 0.880342 1.46136772 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 85.5 9.93e-18   NR MET0648213.1 2283092 g17640 i0 80 9.48795180722892 50 10 90.4 0 166 17 404 453 MET0648213.1 glycoside hydrolase family 88 protein [Pyrinomonadaceae bacterium] diamond 1575 85.5 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
32177006 32177006 PRJNA1032461_S_NODE_17298_length_166_cov_0.888889_g17200_i0 PRJNA1032461 17298 166 0.888889 1.47555574 Bacteria 2 Bacteria Bacteria 81.3 8.74e-17   NR MCU1246707.1 1978231 g17200 i0 68.5 7.80722891566265 54 17 97.6 0 1 162 156 209 MCU1246707.1 thioesterase [Acidobacteriota bacterium] diamond 1296 81.6 0.996323529411765 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32847831 32847831 PRJNA1032461_S_NODE_14720_length_169_cov_0.866667_g14622_i0 PRJNA1032461 14720 169 0.866667 1.46466723 Acidobacteriota bacterium 1978231 Bacteria Bacteria 101 6.86e-26   NR MCU1288892.1 1978231 g14622 i0 80.4 3.97633136094675 56 11 99.4 0 169 2 60 115 MCU1288892.1 hypothetical protein [Acidobacteriota bacterium] diamond 672 101 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota 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);;