RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA169559 · 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
26978973 26978973 PRJNA169559_P_NODE_21142_length_356_cov_1.993884_g19081_i0 PRJNA169559 21142 356 1.993884 7.09822704 Silvibacterium dinghuense 1560006 Bacteria Bacteria 62 3.38e-9   NR WP_164981590.1 1560006 g19081 i0 47.1 1.71910112359551 68 35 57.3 1 230 27 90 156 WP_164981590.1 GyrI-like domain-containing protein [Silvibacterium dinghuense] diamond 612 62 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Silvibacterium Silvibacterium dinghuense
27755379 27755379 PRJNA169559_P_NODE_44144_length_222_cov_2.165803_g42067_i0 PRJNA169559 44144 222 2.165803 4.80808266 Bacteria 2 Bacteria Bacteria 61.2 8.55e-9   NR PYX09814.1 1978231 g42067 i0 72.5 8.10810810810811 40 11 54.1 0 120 1 83 122 PYX09814.1 MAG: aspartate aminotransferase family protein [Acidobacteriota bacterium] diamond 1800 61.6 0.993506493506494 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28305636 28305636 PRJNA169559_P_NODE_7606_length_616_cov_3.011925_g6039_i0 PRJNA169559 7606 616 3.011925 18.553458 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 75.1 8.17e-12   NR HTX34442.1 2212468 g6039 i0 32.9 1.52922077922078 146 79 70.6 3 159 593 226 353 HTX34442.1 NHL repeat-containing protein [Bryobacteraceae bacterium] diamond 942 75.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
28558390 28558390 PRJNA169559_P_NODE_9647_length_546_cov_67.818182_g6613_i2 PRJNA169559 9647 546 67.818182 370.28727372 Acidobacteriota bacterium 1978231 Bacteria Bacteria 91.3 3.55e-20   NR MDQ7008653.1 1978231 g6613 i2 62.7 2.25824175824176 83 30 45.1 1 414 169 25 107 MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] diamond 1233 91.3 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28621520 28621520 PRJNA169559_P_NODE_3287_length_917_cov_3.291667_g2232_i0 PRJNA169559 3287 917 3.291667 30.18458639 Acidobacteriota bacterium 1978231 Bacteria Bacteria 80.5 1.24e-12   NR MEK6288952.1 1978231 g2232 i0 32.9 1.50490730643402 231 133 73.9 7 779 102 94 307 MEK6288952.1 Calx-beta domain-containing protein [Acidobacteriota bacterium] diamond 1380 80.5 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29095117 29095117 PRJNA169559_P_NODE_40408_length_234_cov_1.409756_g38331_i0 PRJNA169559 40408 234 1.409756 3.29882904 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 42.4 0.0463   NR HYS54496.1 2651171 g38331 i0 35.1 0.948717948717949 74 46 94.9 2 226 5 458 529 HYS54496.1 hypothetical protein [Thermoanaerobaculia bacterium] diamond 222 42.4 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
29316014 29316014 PRJNA169559_P_NODE_32829_length_254_cov_1.382222_g30753_i0 PRJNA169559 32829 254 1.382222 3.51084388 Terriglobus aquaticus 940139 Bacteria Bacteria 48.1 1.46e-4   NR WP_263414657.1 940139 g30753 i0 59.5 1.31102362204724 37 15 43.7 0 143 253 53 89 WP_263414657.1 RidA family protein [Terriglobus aquaticus] diamond 333 48.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terriglobus Terriglobus aquaticus
29473606 29473606 PRJNA169559_P_NODE_9550_length_549_cov_11.861538_g7826_i0 PRJNA169559 9550 549 11.861538 65.11984362 Acidobacteriota bacterium 1978231 Bacteria Bacteria 132 2.58e-36   NR MDQ7008653.1 1978231 g7826 i0 76.8 0.519125683060109 95 22 51.9 0 464 180 17 111 MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] diamond 285 132 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29820964 29820964 PRJNA169559_P_NODE_9511_length_550_cov_67.372361_g6613_i1 PRJNA169559 9511 550 67.372361 370.5479855 Acidobacteriota bacterium 1978231 Bacteria Bacteria 91.3 3.66e-20   NR MDQ7008653.1 1978231 g6613 i1 62.7 2.24181818181818 83 30 44.7 1 418 173 25 107 MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] diamond 1233 91.3 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30010892 30010892 PRJNA169559_P_NODE_12831_length_468_cov_79.763098_g6613_i5 PRJNA169559 12831 468 79.763098 373.29129864 Acidobacteriota bacterium 1978231 Bacteria Bacteria 91.3 1.61e-20   NR MDQ7008653.1 1978231 g6613 i5 62.7 2.63461538461538 83 30 52.6 1 336 91 25 107 MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] diamond 1233 91.3 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30863742 30863742 PRJNA169559_P_NODE_32794_length_254_cov_1.662222_g30718_i0 PRJNA169559 32794 254 1.662222 4.22204388 Terriglobus aquaticus 940139 Bacteria Bacteria 63.5 1.58e-10   NR WP_263414657.1 940139 g30718 i0 62.5 1.12204724409449 48 18 56.7 0 110 253 42 89 WP_263414657.1 RidA family protein [Terriglobus aquaticus] diamond 285 63.5 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terriglobus Terriglobus aquaticus
30958695 30958695 PRJNA169559_P_NODE_10274_length_528_cov_70.210421_g6613_i4 PRJNA169559 10274 528 70.210421 370.71102288 Acidobacteriota bacterium 1978231 Bacteria Bacteria 91.3 2.98e-20   NR MDQ7008653.1 1978231 g6613 i4 62.7 2.33522727272727 83 30 46.6 1 396 151 25 107 MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] diamond 1233 91.3 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31464637 31464637 PRJNA169559_P_NODE_396_length_3151_cov_5.296925_g145_i0 PRJNA169559 396 3151 5.296925 166.90610675 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 178 1.98e-41   NR HYT66950.1 2910147 g145 i0 45.8 0.237067597588067 249 117 23.2 7 1260 1991 115 350 HYT66950.1 DUF4394 domain-containing protein [Vicinamibacterales bacterium] diamond 747 178 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
31591096 31591096 PRJNA169559_P_NODE_2976_length_960_cov_3.266380_g1967_i0 PRJNA169559 2976 960 3.26638 31.357248 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 56.6 8.78e-5   NR HVI73141.1 2283092 g1967 i0 31.9 1.48125 163 90 49.4 4 822 349 11 157 HVI73141.1 Calx-beta domain-containing protein [Pyrinomonadaceae bacterium] diamond 1422 56.6 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
31748926 31748926 PRJNA169559_P_NODE_10237_length_529_cov_69.940000_g6613_i3 PRJNA169559 10237 529 69.94 369.9826 Acidobacteriota bacterium 1978231 Bacteria Bacteria 91.3 2.98e-20   NR MDQ7008653.1 1978231 g6613 i3 62.7 2.33081285444234 83 30 46.5 1 133 378 25 107 MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] diamond 1233 91.3 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32002166 32002166 PRJNA169559_P_NODE_8238_length_591_cov_62.446619_g6613_i0 PRJNA169559 8238 591 62.446619 369.05951829 Acidobacteriota bacterium 1978231 Bacteria Bacteria 94 4.88e-21   NR MDQ7008653.1 1978231 g6613 i0 56.3 1.59390862944162 103 43 51.8 2 384 79 6 107 MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] diamond 942 94 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32128919 32128919 PRJNA169559_P_NODE_13098_length_463_cov_3.317972_g11204_i0 PRJNA169559 13098 463 3.317972 15.36221036 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 46.2 0.0212   NR HEV8435020.1 2651171 g11204 i0 29.6 0.809935205183585 125 74 77.8 4 384 25 444 559 HEV8435020.1 hypothetical protein [Thermoanaerobaculia bacterium] diamond 375 46.2 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
32192096 32192096 PRJNA169559_P_NODE_398_length_3135_cov_5.364456_g145_i1 PRJNA169559 398 3135 5.364456 168.1756956 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 178 1.95e-41   NR HYT66950.1 2910147 g145 i1 45.8 0.238277511961722 249 117 23.3 7 1892 1161 115 350 HYT66950.1 DUF4394 domain-containing protein [Vicinamibacterales bacterium] diamond 747 178 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
32540277 32540277 PRJNA169559_P_NODE_24199_length_312_cov_2.151943_g22123_i0 PRJNA169559 24199 312 2.151943 6.71406216 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 51.2 8.91e-5   NR HLJ49807.1 2212468 g22123 i0 39.8 0.894230769230769 93 54 87.5 2 273 1 56 148 HLJ49807.1 ankyrin repeat domain-containing protein [Bryobacteraceae bacterium] diamond 279 51.2 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae 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);;