contig_metadata
24 rows where bioproject = "PRJNA1174234", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 316117 | 316117 | PRJNA1174234_P_NODE_13021_length_381_cov_3.250000_g12825_i0 | PRJNA1174234 | 13021 | 381 | 3.25 | 12.3825 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 483 | 1.09e-131 | NTclustered | gi|76574288|gb|DQ139436.1| | 171953 | g12825 | i0 | 91.061 | 93.2834645669291 | 358 | 30 | 94 | 2 | 25 | 381 | 372 | 16 | Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence | blastn | 35541 | 483 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 2866885 | 2866885 | PRJNA1174234_P_NODE_14583_length_361_cov_0.989583_g14387_i0 | PRJNA1174234 | 14583 | 361 | 0.989583 | 3.57239463 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 130 | 6.15e-33 | NR | HTB18087.1 | 2212468 | g14387 | i0 | 68.2 | 2.19390581717452 | 88 | 28 | 73.1 | 0 | 360 | 97 | 405 | 492 | HTB18087.1 aldehyde dehydrogenase family protein [Bryobacteraceae bacterium] | diamond | 792 | 130 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 4143129 | 4143129 | PRJNA1174234_P_NODE_7924_length_488_cov_1.660241_g7728_i0 | PRJNA1174234 | 7924 | 488 | 1.660241 | 8.10197608 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 73.1 | 3.65e-8 | NTclustered | gi|2874254091|emb|OY970174.1| | 171953 | g7728 | i0 | 84.416 | 0.305327868852459 | 77 | 8 | 15 | 2 | 246 | 320 | 2496911 | 2496985 | MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1 | blastn | 149 | 73.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 7969300 | 7969300 | PRJNA1174234_P_NODE_10567_length_424_cov_1.509972_g10371_i0 | PRJNA1174234 | 10567 | 424 | 1.509972 | 6.40228128 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 187 | 1.07e-42 | NTclustered | gi|2893358426|emb|OZ220718.1| | 2910147 | g10371 | i0 | 80.077 | 1.76415094339623 | 261 | 44 | 61 | 8 | 1 | 257 | 1182568 | 1182312 | MAG: Vicinamibacterales bacterium isolate 0ce2d42f-2bf0-44bc-a671-070680eb922c genome assembly, chromosome: 1 | blastn | 748 | 187 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 11794657 | 11794657 | PRJNA1174234_P_NODE_15030_length_355_cov_2.641844_g14834_i0 | PRJNA1174234 | 15030 | 355 | 2.641844 | 9.3785462 | Edaphobacter paludis | 3035702 | Bacteria | Bacteria | 73.1 | 2.58e-8 | NTclustered | gi|2737763816|gb|CP121194.1| | 3035702 | g14834 | i0 | 95.556 | 10.2422535211268 | 45 | 2 | 13 | 0 | 311 | 355 | 2761378 | 2761422 | Edaphobacter paludis strain DSM 109919 chromosome, complete genome | blastn | 3636 | 73.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter paludis | ||
| 23268354 | 23268354 | PRJNA1174234_P_NODE_31519_length_247_cov_0.885057_g31323_i0 | PRJNA1174234 | 31519 | 247 | 0.885057 | 2.18609079 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 294 | 3.36e-75 | NTclustered | gi|2874253677|emb|OY969111.1| | 171953 | g31323 | i0 | 88.211 | 1.97570850202429 | 246 | 29 | 99 | 0 | 2 | 247 | 1014396 | 1014641 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1 | blastn | 488 | 294 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 26838424 | 26838424 | PRJNA1174234_P_NODE_11801_length_401_cov_1.408537_g11605_i0 | PRJNA1174234 | 11801 | 401 | 1.408537 | 5.64823337 | Terracidiphilus | 1768185 | Bacteria | Bacteria | 184 | 4.0699999999999986e-55 | NR | HUH63403.1 | 1964191 | g11605 | i0 | 68.2 | 19.7506234413965 | 132 | 42 | 98.8 | 0 | 401 | 6 | 128 | 259 | HUH63403.1 aldolase/citrate lyase family protein [Terracidiphilus sp.] | diamond | 7920 | 184 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terracidiphilus | Terracidiphilus sp. | ||
| 26964734 | 26964734 | PRJNA1174234_P_NODE_27782_length_258_cov_1.248649_g27586_i0 | PRJNA1174234 | 27782 | 258 | 1.248649 | 3.22151442 | Terriglobia | 204432 | Bacteria | Bacteria | 85.1 | 9.79e-19 | NR | HUA92617.1 | 1964191 | g27586 | i0 | 47.1 | 2.96511627906977 | 85 | 44 | 98.8 | 1 | 3 | 257 | 5 | 88 | HUA92617.1 GyrI-like domain-containing protein [Terracidiphilus sp.] | diamond | 765 | 85.5 | 0.9953216374269 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terracidiphilus | Terracidiphilus sp. | ||
| 27028107 | 27028107 | PRJNA1174234_P_NODE_35942_length_241_cov_0.904762_g35746_i0 | PRJNA1174234 | 35942 | 241 | 0.904762 | 2.18047642 | Terriglobia | 204432 | Bacteria | Bacteria | 63.2 | 2.26e-9 | NR | MCU1234982.1 | 2068625 | g35746 | i0 | 68 | 2.55186721991701 | 50 | 15 | 61 | 1 | 235 | 89 | 21 | 70 | MCU1234982.1 Kelch repeat-containing protein [Candidatus Solibacter sp.] | diamond | 615 | 63.5 | 0.995275590551181 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Solibacteraceae | Candidatus Solibacter | Candidatus Solibacter sp. | ||
| 27230121 | 27230121 | PRJNA1174234_P_NODE_16303_length_342_cov_1.144981_g16107_i0 | PRJNA1174234 | 16303 | 342 | 1.144981 | 3.91583502 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 47.4 | 0.00258 | NR | HEX5214908.1 | 2910147 | g16107 | i0 | 32 | 1.07017543859649 | 122 | 61 | 90.4 | 5 | 339 | 31 | 110 | 228 | HEX5214908.1 PQQ-binding-like beta-propeller repeat protein [Vicinamibacterales bacterium] | diamond | 366 | 47.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 27420028 | 27420028 | PRJNA1174234_P_NODE_13703_length_372_cov_1.020067_g13507_i0 | PRJNA1174234 | 13703 | 372 | 1.020067 | 3.79464924 | Geothrix sp. | 1962974 | Bacteria | Bacteria | 67.8 | 5.8e-11 | NR | MCM2249838.1 | 1962974 | g13507 | i0 | 33.9 | 1.95161290322581 | 121 | 73 | 97.6 | 2 | 370 | 8 | 83 | 196 | MCM2249838.1 CAP domain-containing protein [Geothrix sp.] | diamond | 726 | 67.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Geothrix | Geothrix sp. | ||
| 27925011 | 27925011 | PRJNA1174234_P_NODE_34345_length_243_cov_0.905882_g34149_i0 | PRJNA1174234 | 34345 | 243 | 0.905882 | 2.20129326 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 46.2 | 0.0022 | NR | MBU1339793.1 | 1978231 | g34149 | i0 | 32.9 | 0.975308641975309 | 79 | 51 | 97.5 | 1 | 242 | 6 | 151 | 227 | MBU1339793.1 PAS domain-containing protein [Acidobacteriota bacterium] | diamond | 237 | 46.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27956639 | 27956639 | PRJNA1174234_P_NODE_29385_length_251_cov_0.865169_g29189_i0 | PRJNA1174234 | 29385 | 251 | 0.865169 | 2.17157419 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 42.7 | 0.0397 | NR | PYQ54871.1 | 1978231 | g29189 | i0 | 37.5 | 0.764940239043825 | 64 | 38 | 74.1 | 1 | 251 | 66 | 113 | 176 | PYQ54871.1 MAG: hypothetical protein DMF53_28875, partial [Acidobacteriota bacterium] | diamond | 192 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28366895 | 28366895 | PRJNA1174234_P_NODE_24886_length_276_cov_1.004926_g24690_i0 | PRJNA1174234 | 24886 | 276 | 1.004926 | 2.77359576 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 53.5 | 9.02e-6 | NR | MEJ2143646.1 | 1978231 | g24690 | i0 | 45.5 | 0.717391304347826 | 66 | 36 | 71.7 | 0 | 1 | 198 | 546 | 611 | MEJ2143646.1 adenylate/guanylate cyclase domain-containing protein [Acidobacteriota bacterium] | diamond | 198 | 53.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28859698 | 28859698 | PRJNA1174234_P_NODE_17048_length_334_cov_1.306513_g16852_i0 | PRJNA1174234 | 17048 | 334 | 1.306513 | 4.36375342 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 158 | 2.06e-45 | NR | HUH63403.1 | 1964191 | g16852 | i0 | 71.3 | 9.70059880239521 | 108 | 31 | 97 | 0 | 9 | 332 | 127 | 234 | HUH63403.1 aldolase/citrate lyase family protein [Terracidiphilus sp.] | diamond | 3240 | 158 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terracidiphilus | Terracidiphilus sp. | ||
| 29775335 | 29775335 | PRJNA1174234_P_NODE_30631_length_249_cov_0.875000_g30435_i0 | PRJNA1174234 | 30631 | 249 | 0.875 | 2.17875 | Bryobacterales | 332160 | Bacteria | Bacteria | 72.4 | 1.51e-12 | NR | SPF32762.1 | 2043165 | g30435 | i0 | 56.4 | 2 | 55 | 24 | 66.3 | 0 | 174 | 10 | 739 | 793 | SPF32762.1 exported hypothetical protein [Candidatus Sulfopaludibacter sp. SbA4] | diamond | 498 | 72.8 | 0.994505494505495 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Solibacteraceae | Candidatus Sulfopaludibacter | Candidatus Sulfopaludibacter sp. SbA4 | ||
| 29882842 | 29882842 | PRJNA1174234_P_NODE_6131_length_550_cov_1.551363_g5935_i0 | PRJNA1174234 | 6131 | 550 | 1.551363 | 8.5324965 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 116 | 1.08e-27 | NR | MBV9217657.1 | 1978231 | g5935 | i0 | 39.3 | 1.81636363636364 | 163 | 93 | 87.8 | 4 | 14 | 496 | 156 | 314 | MBV9217657.1 S1/P1 nuclease [Acidobacteriota bacterium] | diamond | 999 | 116 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30704036 | 30704036 | PRJNA1174234_P_NODE_5334_length_585_cov_5.728516_g5139_i0 | PRJNA1174234 | 5334 | 585 | 5.728516 | 33.5118186 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 137 | 6.1e-38 | NR | MDQ7008653.1 | 1978231 | g5139 | i0 | 74.8 | 0.528205128205128 | 103 | 26 | 52.8 | 0 | 88 | 396 | 8 | 110 | MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] | diamond | 309 | 137 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31020114 | 31020114 | PRJNA1174234_P_NODE_28935_length_251_cov_1.511236_g28739_i0 | PRJNA1174234 | 28935 | 251 | 1.511236 | 3.79320236 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 55.5 | 1.09e-6 | NR | MFM8394239.1 | 1978231 | g28739 | i0 | 48.2 | 0.669322709163347 | 56 | 28 | 65.7 | 1 | 84 | 248 | 214 | 269 | MFM8394239.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 168 | 55.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31462865 | 31462865 | PRJNA1174234_P_NODE_31976_length_246_cov_2.664740_g31780_i0 | PRJNA1174234 | 31976 | 246 | 2.66474 | 6.5552604 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 53.5 | 4.61e-6 | NR | HLM61293.1 | 2283092 | g31780 | i0 | 45.2 | 0.75609756097561 | 62 | 25 | 64.6 | 1 | 88 | 246 | 5 | 66 | HLM61293.1 TspO/MBR family protein [Pyrinomonadaceae bacterium] | diamond | 186 | 53.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 31557771 | 31557771 | PRJNA1174234_P_NODE_35196_length_242_cov_0.911243_g35000_i0 | PRJNA1174234 | 35196 | 242 | 0.911243 | 2.20520806 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 133 | 4.43e-34 | NR | HEY9467050.1 | 2910147 | g35000 | i0 | 71.3 | 0.991735537190083 | 80 | 23 | 99.2 | 0 | 3 | 242 | 471 | 550 | HEY9467050.1 right-handed parallel beta-helix repeat-containing protein [Vicinamibacterales bacterium] | diamond | 240 | 133 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 31683899 | 31683899 | PRJNA1174234_P_NODE_9837_length_439_cov_2.715847_g9641_i0 | PRJNA1174234 | 9837 | 439 | 2.715847 | 11.92256833 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 132 | 6.9599999999999994e-37 | NR | MDQ7008653.1 | 1978231 | g9641 | i0 | 76.8 | 0.649202733485194 | 95 | 22 | 64.9 | 0 | 90 | 374 | 17 | 111 | MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] | diamond | 285 | 132 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32632672 | 32632672 | PRJNA1174234_P_NODE_640_length_1332_cov_2.432883_g564_i0 | PRJNA1174234 | 640 | 1332 | 2.432883 | 32.40600156 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 53.9 | 7.79e-4 | NR | MBS1873370.1 | 1978231 | g564 | i0 | 35.2 | 0.752252252252252 | 108 | 51 | 24.3 | 4 | 1008 | 1331 | 112 | 200 | MBS1873370.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 1002 | 53.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32651716 | 32651716 | PRJNA1174234_P_NODE_20140_length_308_cov_0.978723_g19944_i0 | PRJNA1174234 | 20140 | 308 | 0.978723 | 3.01446684 | Bacteria | 2 | Bacteria | Bacteria | 120 | 1.51e-31 | NR | MBK7709494.1 | 1978231 | g19944 | i0 | 56.9 | 26.6298701298701 | 102 | 44 | 99.4 | 0 | 2 | 307 | 47 | 148 | MBK7709494.1 uridine kinase [Acidobacteriota bacterium] | diamond | 8202 | 121 | 0.991735537190083 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium |
Advanced export
JSON shape: default, array, newline-delimited
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);;