RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA278119" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJNA278119 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
26947402 26947402 PRJNA278119_P_NODE_10942_length_351_cov_1.238411_g10695_i0 PRJNA278119 10942 351 1.238411 4.34682261 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 70.1 3.38e-11   NR HEY7390854.1 2212468 g10695 i0 42.4 0.846153846153846 99 54 84.6 2 3 299 969 1064 HEY7390854.1 hypothetical protein [Bryobacteraceae bacterium] diamond 297 70.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
27579534 27579534 PRJNA278119_P_NODE_25304_length_196_cov_1.945578_g25055_i0 PRJNA278119 25304 196 1.945578 3.81333288 Candidatus Angelobacter sp. 2976921 Bacteria Bacteria 62.4 2.34e-9   NR HZE20197.1 2976921 g25055 i0 50 0.918367346938776 60 30 91.8 0 195 16 256 315 HZE20197.1 hypothetical protein [Candidatus Angelobacter sp.] diamond 180 62.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia     Candidatus Angelobacter Candidatus Angelobacter sp.
27723978 27723978 PRJNA278119_P_NODE_36704_length_168_cov_0.873950_g36455_i0 PRJNA278119 36704 168 0.87395 1.468236 Bacteria 2 Bacteria Bacteria 50.4 1.97e-5   NR OLE49362.1 1803432 g36455 i0 53.2 1.75 47 22 83.9 0 9 149 129 175 OLE49362.1 MAG: hypothetical protein AUG46_00650 [Acidobacteria bacterium 13_1_20CM_3_58_11] diamond 294 50.4 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteria bacterium 13_1_20CM_3_58_11
27737819 27737819 PRJNA278119_P_NODE_464_length_1578_cov_4.763898_g380_i0 PRJNA278119 464 1578 4.763898 75.17431044 Tunturiibacter gelidiferens 3069689 Bacteria Bacteria 52 0.00465   NR NYF54090.1 3069689 g380 i0 26.3 0.260456273764259 137 92 24.9 4 1167 1559 219 352 NYF54090.1 hypothetical protein [Tunturiibacter gelidoferens] diamond 411 52 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Tunturiibacter Tunturiibacter gelidiferens
27849709 27849709 PRJNA278119_P_NODE_17804_length_244_cov_1.174359_g17555_i0 PRJNA278119 17804 244 1.174359 2.86543596 Bacteria 2 Bacteria Bacteria 90.5 2.62e-19   NR HSY34408.1 2052142 g17555 i0 60.9 7.24180327868852 69 27 84.8 0 221 15 145 213 HSY34408.1 aldose epimerase family protein [Acidobacteriaceae bacterium] diamond 1767 90.5 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae bacterium
28716365 28716365 PRJNA278119_P_NODE_44067_length_164_cov_0.904348_g43818_i0 PRJNA278119 44067 164 0.904348 1.48313072 Acidobacteriota bacterium 1978231 Bacteria Bacteria 85.5 5.71e-18   NR MBV8894397.1 1978231 g43818 i0 72.5 1.86585365853659 51 14 93.3 0 155 3 190 240 MBV8894397.1 FAD-binding oxidoreductase [Acidobacteriota bacterium] diamond 306 85.5 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28747841 28747841 PRJNA278119_P_NODE_24967_length_198_cov_1.046980_g24718_i0 PRJNA278119 24967 198 1.04698 2.0730204 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 75.9 4.31e-14   NR HKE21046.1 2212468 g24718 i0 53.8 1.96969696969697 65 30 98.5 0 196 2 82 146 HKE21046.1 Ig-like domain-containing protein [Bryobacteraceae bacterium] diamond 390 75.9 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
29252772 29252772 PRJNA278119_P_NODE_33529_length_171_cov_1.852459_g33280_i0 PRJNA278119 33529 171 1.852459 3.16770489 Acidobacteriota bacterium 1978231 Bacteria Bacteria 86.3 3.75e-20   NR MDQ7008653.1 1978231 g33280 i0 80.4 0.982456140350877 56 11 98.2 0 170 3 29 84 MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] diamond 168 86.3 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29347835 29347835 PRJNA278119_P_NODE_43969_length_164_cov_0.904348_g43720_i0 PRJNA278119 43969 164 0.904348 1.48313072 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 98.2 3.74e-22   NR HEV2864644.1 2283092 g43720 i0 79.6 0.98780487804878 54 11 98.8 0 3 164 1069 1122 HEV2864644.1 GAF domain-containing protein [Pyrinomonadaceae bacterium] diamond 162 98.2 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
29365509 29365509 PRJNA278119_P_NODE_9549_length_380_cov_1.099698_g9302_i0 PRJNA278119 9549 380 1.099698 4.1788524 Pseudomonadati 3379134 Bacteria Bacteria 47.4 0.00408   NR HSP15106.1 2651171 g9302 i0 36.9 4.01052631578947 103 53 79.7 5 324 22 647 739 HSP15106.1 IPT/TIG domain-containing protein [Thermoanaerobaculia bacterium] diamond 1524 47.8 0.99163179916318 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
29537161 29537161 PRJNA278119_P_NODE_41910_length_165_cov_0.896552_g41661_i0 PRJNA278119 41910 165 0.896552 1.4793108 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 107 4.9000000000000005e-27   NR HEX7296208.1 2283092 g41661 i0 92.7 2 55 4 100 0 165 1 114 168 HEX7296208.1 VOC family protein [Pyrinomonadaceae bacterium] diamond 330 107 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
29694749 29694749 PRJNA278119_P_NODE_44970_length_163_cov_0.912281_g44721_i0 PRJNA278119 44970 163 0.912281 1.48701803 Terriglobales bacterium 2282142 Bacteria Bacteria 50.4 2.43e-5   NR HWY55326.1 2282142 g44721 i0 47.2 3 53 28 97.5 0 5 163 38 90 HWY55326.1 protein kinase [Terriglobales bacterium] diamond 489 50.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
29979299 29979299 PRJNA278119_P_NODE_2571_length_763_cov_2.669468_g2349_i0 PRJNA278119 2571 763 2.669468 20.36804084 Acidobacteriota bacterium 1978231 Bacteria Bacteria 127 3.37e-29   NR MDQ7006104.1 1978231 g2349 i0 32.6 1.03800786369594 264 146 99.9 4 2 763 1312 1553 MDQ7006104.1 reverse transcriptase domain-containing protein [Acidobacteriota bacterium] diamond 792 127 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30832362 30832362 PRJNA278119_P_NODE_46714_length_162_cov_0.920354_g46465_i0 PRJNA278119 46714 162 0.920354 1.49097348 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 69.3 8.54e-14   NR HEY0658934.1 2283092 g46465 i0 75 4.31481481481481 44 11 81.5 0 132 1 40 83 HEY0658934.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 699 69.3 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
31053830 31053830 PRJNA278119_P_NODE_3895_length_611_cov_3.629893_g3656_i0 PRJNA278119 3895 611 3.629893 22.17864623 Acidobacteriota bacterium 1978231 Bacteria Bacteria 137 7.97e-38   NR MDQ7008653.1 1978231 g3656 i0 74.8 0.505728314238953 103 26 50.6 0 86 394 8 110 MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] diamond 309 137 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31085155 31085155 PRJNA278119_P_NODE_24535_length_199_cov_2.080000_g24286_i0 PRJNA278119 24535 199 2.08 4.1392 Terriglobia bacterium 2081523 Bacteria Bacteria 44.3 0.00594   NR MBZ5624727.1 2081523 g24286 i0 44.9 0.738693467336683 49 26 73.9 1 48 194 1331 1378 MBZ5624727.1 CHAT domain-containing protein [Terriglobia bacterium] diamond 147 44.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
31274731 31274731 PRJNA278119_P_NODE_19855_length_225_cov_0.994318_g19606_i0 PRJNA278119 19855 225 0.994318 2.2372155 Candidatus Polarisedimenticolaceae bacterium 2910585 Bacteria Bacteria 58.2 1.11e-7   NR HKQ62042.1 2910585 g19606 i0 61.4 1.97333333333333 44 17 58.7 0 153 22 600 643 HKQ62042.1 metallophosphoesterase [Candidatus Polarisedimenticolaceae bacterium] diamond 444 58.2 1 Bacteria   Pseudomonadati Acidobacteriota Candidatus Polarisedimenticolia Candidatus Polarisedimenticolales Candidatus Polarisedimenticolaceae   Candidatus Polarisedimenticolaceae bacterium
31432888 31432888 PRJNA278119_P_NODE_34016_length_170_cov_1.371901_g33767_i0 PRJNA278119 34016 170 1.371901 2.3322317 Acidobacteriaceae bacterium 2052142 Bacteria Bacteria 63.2 5.98e-10   NR MDQ1390905.1 2052142 g33767 i0 65.8 1.34117647058824 38 13 67.1 0 168 55 244 281 MDQ1390905.1 4-hydroxy-2-oxoheptanedioate aldolase [Acidobacteriaceae bacterium] diamond 228 63.2 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae bacterium
31464779 31464779 PRJNA278119_P_NODE_28156_length_186_cov_2.189781_g27907_i0 PRJNA278119 28156 186 2.189781 4.07299266 Acidobacteriota bacterium 1978231 Bacteria Bacteria 103 9.64e-27   NR MDQ7008654.1 1978231 g27907 i0 91.5 0.951612903225806 59 5 95.2 0 185 9 46 104 MDQ7008654.1 hypothetical protein [Acidobacteriota bacterium] diamond 177 103 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32129064 32129064 PRJNA278119_P_NODE_21018_length_217_cov_1.238095_g20769_i0 PRJNA278119 21018 217 1.238095 2.68666615 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 53.9 3.14e-6   NR HEV7487225.1 2651171 g20769 i0 43.2 1.02304147465438 74 40 99.5 1 217 2 159 232 HEV7487225.1 hypothetical protein [Thermoanaerobaculia bacterium] diamond 222 53.9 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
32129078 32129078 PRJNA278119_P_NODE_32818_length_173_cov_1.475806_g32569_i0 PRJNA278119 32818 173 1.475806 2.55314438 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 68.2 1.56e-11   NR MCK6681268.1 2651171 g32569 i0 54.4 5.93063583815029 57 25 97.1 1 172 5 451 507 MCK6681268.1 M4 family metallopeptidase [Thermoanaerobaculia bacterium] diamond 1026 68.2 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
32382064 32382064 PRJNA278119_P_NODE_38739_length_167_cov_0.881356_g38490_i0 PRJNA278119 38739 167 0.881356 1.47186452 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 86.7 1.44e-18   NR HEX7282132.1 2910147 g38490 i0 72.2 0.970059880239521 54 15 97 0 2 163 244 297 HEX7282132.1 transglycosylase SLT domain-containing protein [Vicinamibacterales bacterium] diamond 162 86.7 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
32634541 32634541 PRJNA278119_P_NODE_8300_length_412_cov_1.360882_g8053_i0 PRJNA278119 8300 412 1.360882 5.60683384 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 70.5 5.16e-11   NR HEY0323382.1 2283092 g8053 i0 50.7 1.74757281553398 71 34 51 1 145 354 13 83 HEY0323382.1 molybdopterin cofactor-binding domain-containing protein [Pyrinomonadaceae bacterium] diamond 720 70.5 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);;