contig_metadata
14 rows where bioproject = "PRJNA884104", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27844975 | 27844975 | PRJNA884104_S_NODE_77624_length_246_cov_0.890173_g76881_i0 | PRJNA884104 | 77624 | 246 | 0.890173 | 2.18982558 | Armatimonadetes bacterium CG_4_1 | 2033014 | Bacteria | Bacteria | 171 | 1.8999999999999997e-48 | NR | PIY44557.1 | 1973909 | g76881 | i0 | 100 | 1 | 82 | 0 | 100 | 0 | 246 | 1 | 67 | 148 | PIY44557.1 MAG: hypothetical protein COZ05_07900 [Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10] | diamond | 246 | 171 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10 | ||||||
| 28666191 | 28666191 | PRJNA884104_S_NODE_70807_length_250_cov_0.870056_g70064_i0 | PRJNA884104 | 70807 | 250 | 0.870056 | 2.17514 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 61.6 | 8.78e-9 | NR | MCS7310059.1 | 2033014 | g70064 | i0 | 35.6 | 1.08 | 90 | 50 | 98.4 | 2 | 246 | 1 | 110 | 199 | MCS7310059.1 serpin family protein [Armatimonadota bacterium] | diamond | 270 | 61.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28855305 | 28855305 | PRJNA884104_S_NODE_608_length_2263_cov_3.994977_g508_i0 | PRJNA884104 | 608 | 2263 | 3.994977 | 90.40632951 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 65.1 | 1.42e-6 | NR | MBV6459601.1 | 2682144 | g508 | i0 | 31.3 | 0.212107821475917 | 160 | 82 | 19 | 3 | 747 | 1175 | 1247 | 1395 | MBV6459601.1 hypothetical protein [Fimbriimonadaceae bacterium] | diamond | 480 | 65.1 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 29052982 | 29052982 | PRJNA884104_S_NODE_64888_length_258_cov_2.497297_g64145_i0 | PRJNA884104 | 64888 | 258 | 2.497297 | 6.44302626 | FCB group | 1783270 | Bacteria | Bacteria | 45.1 | 0.00671 | NR | MDR3691126.1 | 1936159 | g64145 | i0 | 45.5 | 1.97674418604651 | 66 | 31 | 76.7 | 3 | 247 | 50 | 39 | 99 | MDR3691126.1 beta-galactosidase [Fimbriimonas sp.] | diamond | 510 | 45.4 | 0.993392070484582 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 29108184 | 29108184 | PRJNA884104_S_NODE_69108_length_251_cov_0.865169_g68365_i0 | PRJNA884104 | 69108 | 251 | 0.865169 | 2.17157419 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 44.7 | 0.00805 | NR | MBI5708666.1 | 2033014 | g68365 | i0 | 37.3 | 1.45816733067729 | 59 | 35 | 70.5 | 1 | 187 | 11 | 129 | 185 | MBI5708666.1 hypothetical protein [Armatimonadota bacterium] | diamond | 366 | 44.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29202970 | 29202970 | PRJNA884104_S_NODE_66129_length_256_cov_1.125683_g65386_i0 | PRJNA884104 | 66129 | 256 | 1.125683 | 2.88174848 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 43.9 | 0.0161 | NR | MBS1715489.1 | 2033014 | g65386 | i0 | 47.1 | 0.796875 | 68 | 28 | 76.2 | 2 | 60 | 254 | 285 | 347 | MBS1715489.1 adenylate/guanylate cyclase domain-containing protein [Armatimonadota bacterium] | diamond | 204 | 43.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29581389 | 29581389 | PRJNA884104_S_NODE_80970_length_244_cov_0.900585_g80227_i0 | PRJNA884104 | 80970 | 244 | 0.900585 | 2.1974274 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 55.8 | 8.25e-7 | NR | MDW8108014.1 | 2033014 | g80227 | i0 | 44.3 | 1.69672131147541 | 61 | 33 | 75 | 1 | 234 | 52 | 220 | 279 | MDW8108014.1 serpin family protein [Armatimonadota bacterium] | diamond | 414 | 55.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29770963 | 29770963 | PRJNA884104_S_NODE_13551_length_547_cov_1.246835_g12818_i0 | PRJNA884104 | 13551 | 547 | 1.246835 | 6.82018745 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 49.3 | 0.00348 | NR | MBS1716455.1 | 2033014 | g12818 | i0 | 26.5 | 0.910420475319927 | 166 | 105 | 86.1 | 5 | 523 | 53 | 57 | 214 | MBS1716455.1 right-handed parallel beta-helix repeat-containing protein [Armatimonadota bacterium] | diamond | 498 | 49.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30023994 | 30023994 | PRJNA884104_S_NODE_21191_length_438_cov_3.994521_g20448_i0 | PRJNA884104 | 21191 | 438 | 3.994521 | 17.49600198 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 45.4 | 0.00644 | NR | HEY3378629.1 | 2033014 | g20448 | i0 | 64.7 | 0.232876712328767 | 34 | 12 | 23.3 | 0 | 429 | 328 | 55 | 88 | HEY3378629.1 ankyrin repeat domain-containing protein [Armatimonadota bacterium] | diamond | 102 | 45.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30908625 | 30908625 | PRJNA884104_S_NODE_25054_length_405_cov_1.364458_g24311_i0 | PRJNA884104 | 25054 | 405 | 1.364458 | 5.5260549 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 99.4 | 4.7399999999999997e-23 | NR | MCS7223208.1 | 2033014 | g24311 | i0 | 65.8 | 0.585185185185185 | 79 | 27 | 58.5 | 0 | 237 | 1 | 11 | 89 | MCS7223208.1 macro domain-containing protein [Armatimonadota bacterium] | diamond | 237 | 99.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32205173 | 32205173 | PRJNA884104_S_NODE_64798_length_259_cov_1.048387_g64055_i0 | PRJNA884104 | 64798 | 259 | 1.048387 | 2.71532233 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 49.7 | 9.82e-5 | NR | MBV6457520.1 | 2682144 | g64055 | i0 | 43.3 | 1.50579150579151 | 60 | 34 | 69.5 | 0 | 235 | 56 | 134 | 193 | MBV6457520.1 hypothetical protein [Fimbriimonadaceae bacterium] | diamond | 390 | 49.7 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 32300401 | 32300401 | PRJNA884104_S_NODE_33339_length_355_cov_1.365248_g32596_i0 | PRJNA884104 | 33339 | 355 | 1.365248 | 4.8466304 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 92.8 | 2.62e-19 | NR | MBS1704353.1 | 2033014 | g32596 | i0 | 53.5 | 0.726760563380282 | 86 | 40 | 72.7 | 0 | 97 | 354 | 17 | 102 | MBS1704353.1 4-hydroxybutyrate CoA-transferase [Armatimonadota bacterium] | diamond | 258 | 92.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32426666 | 32426666 | PRJNA884104_S_NODE_78779_length_245_cov_0.895349_g78036_i0 | PRJNA884104 | 78779 | 245 | 0.895349 | 2.19360505 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 130 | 5.849999999999998e-35 | NR | MBS1718921.1 | 2033014 | g78036 | i0 | 69.1 | 1.98367346938776 | 81 | 25 | 99.2 | 0 | 3 | 245 | 149 | 229 | MBS1718921.1 glycosyltransferase family 2 protein [Armatimonadota bacterium] | diamond | 486 | 130 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32592711 | 32592711 | PRJNA884104_S_NODE_27179_length_390_cov_1.066246_g26436_i0 | PRJNA884104 | 27179 | 390 | 1.066246 | 4.1583594 | PVC group | 1783257 | Bacteria | Bacteria | 65.5 | 1.36e-9 | NR | MBI1332933.1 | 2033014 | g26436 | i0 | 44.7 | 2.33846153846154 | 76 | 41 | 57.7 | 1 | 390 | 166 | 186 | 261 | MBI1332933.1 choice-of-anchor A family protein [Armatimonadota bacterium] | diamond | 912 | 65.5 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota 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);;