contig_metadata
21 rows where bioproject = "PRJNA556992", tax_clade = "PVC group" and tax_phylum = "Candidatus Omnitrophota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10732575 | 10732575 | PRJNA556992_P_NODE_411969_length_275_cov_2.663366_g409780_i0 | PRJNA556992 | 411969 | 275 | 2.663366 | 7.3242565 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 126 | 1.43e-32 | NR | OGW78804.1 | 1801817 | g409780 | i0 | 61.5 | 16.8763636363636 | 91 | 35 | 99.3 | 0 | 3 | 275 | 155 | 245 | OGW78804.1 MAG: IscS subfamily cysteine desulfurase [Omnitrophica bacterium GWA2_52_8] | diamond | 4641 | 127 | 0.992125984251969 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Omnitrophica bacterium GWA2_52_8 | |||||
| 12010671 | 12010671 | PRJNA556992_P_NODE_684990_length_252_cov_2.145251_g682801_i0 | PRJNA556992 | 684990 | 252 | 2.145251 | 5.40603252 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|2107986226|gb|CP070780.1| | 2035772 | g682801 | i0 | 100 | 0.115079365079365 | 29 | 0 | 12 | 0 | 166 | 194 | 1420565 | 1420537 | MAG: Candidatus Omnitrophota bacterium isolate bin17 chromosome | blastn | 29 | 54.7 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 26793849 | 26793849 | PRJNA556992_P_NODE_596421_length_259_cov_2.177419_g594232_i0 | PRJNA556992 | 596421 | 259 | 2.177419 | 5.63951521 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 128 | 1.28e-32 | NR | MCB9771912.1 | 2035772 | g594232 | i0 | 70.2 | 1.96911196911197 | 84 | 25 | 97.3 | 0 | 2 | 253 | 444 | 527 | MCB9771912.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 510 | 128 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27615839 | 27615839 | PRJNA556992_P_NODE_601604_length_259_cov_1.155914_g599415_i0 | PRJNA556992 | 601604 | 259 | 1.155914 | 2.99381726 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 60.1 | 3.5e-8 | NR | MCM8778356.1 | 2035772 | g599415 | i0 | 55.7 | 0.706563706563707 | 61 | 25 | 68.3 | 2 | 203 | 27 | 975 | 1035 | MCM8778356.1 filamentous hemagglutinin N-terminal domain-containing protein [Candidatus Omnitrophota bacterium] | diamond | 183 | 60.1 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27647137 | 27647137 | PRJNA556992_P_NODE_1002524_length_230_cov_3.414013_g1000334_i0 | PRJNA556992 | 1002524 | 230 | 3.414013 | 7.8522299 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 73.9 | 3.18e-13 | NR | MBN1493543.1 | 2035772 | g1000334 | i0 | 57.7 | 0.678260869565217 | 52 | 22 | 67.8 | 0 | 229 | 74 | 288 | 339 | MBN1493543.1 Ig-like domain-containing protein [Candidatus Omnitrophota bacterium] | diamond | 156 | 73.9 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27805033 | 27805033 | PRJNA556992_P_NODE_1103604_length_212_cov_4.266187_g1101413_i0 | PRJNA556992 | 1103604 | 212 | 4.266187 | 9.04431644 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 61.2 | 6.94e-9 | NR | MDD2680358.1 | 2035772 | g1101413 | i0 | 48.4 | 1.52830188679245 | 62 | 32 | 87.7 | 0 | 187 | 2 | 68 | 129 | MDD2680358.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 324 | 61.2 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 28404720 | 28404720 | PRJNA556992_P_NODE_1025146_length_228_cov_2.464516_g1022956_i0 | PRJNA556992 | 1025146 | 228 | 2.464516 | 5.61909648 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 50.8 | 4.37e-5 | NR | MCM8812158.1 | 2035772 | g1022956 | i0 | 39.7 | 0.894736842105263 | 68 | 39 | 89.5 | 1 | 224 | 21 | 866 | 931 | MCM8812158.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 204 | 50.8 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 28689540 | 28689540 | PRJNA556992_P_NODE_794967_length_246_cov_2.011561_g792777_i0 | PRJNA556992 | 794967 | 246 | 2.011561 | 4.94844006 | Omnitrophica WOR_2 bacterium GWA2_47_8 | 1801840 | Bacteria | Bacteria | 120 | 6.86e-34 | NR | OGX07338.1 | 1801840 | g792777 | i0 | 88.1 | 0.719512195121951 | 59 | 7 | 72 | 0 | 63 | 239 | 1 | 59 | OGX07338.1 MAG: hypothetical protein A2Z88_03575 [Omnitrophica WOR_2 bacterium GWA2_47_8] | diamond | 177 | 120 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Omnitrophica WOR_2 bacterium GWA2_47_8 | |||||
| 28973416 | 28973416 | PRJNA556992_P_NODE_414608_length_275_cov_1.886139_g412419_i0 | PRJNA556992 | 414608 | 275 | 1.886139 | 5.18688225 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 47.4 | 0.00119 | NR | RJP33408.1 | 2035772 | g412419 | i0 | 39.1 | 1.65818181818182 | 69 | 36 | 68.7 | 1 | 268 | 80 | 131 | 199 | RJP33408.1 MAG: tetratricopeptide repeat protein [Candidatus Omnitrophota bacterium] | diamond | 456 | 47.4 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 29352495 | 29352495 | PRJNA556992_P_NODE_802049_length_246_cov_0.890173_g799859_i0 | PRJNA556992 | 802049 | 246 | 0.890173 | 2.18982558 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 97.1 | 3.0900000000000003e-21 | NR | MCG3176915.1 | 2035772 | g799859 | i0 | 57.5 | 3.79268292682927 | 80 | 33 | 97.6 | 1 | 7 | 246 | 121 | 199 | MCG3176915.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 933 | 97.1 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 29667668 | 29667668 | PRJNA556992_P_NODE_619990_length_257_cov_2.527174_g617801_i0 | PRJNA556992 | 619990 | 257 | 2.527174 | 6.49483718 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 54.3 | 3.57e-6 | NR | MBD3245823.1 | 2035772 | g617801 | i0 | 41.5 | 1.22568093385214 | 53 | 31 | 61.9 | 0 | 160 | 2 | 101 | 153 | MBD3245823.1 MFS transporter [Candidatus Omnitrophota bacterium] | diamond | 315 | 54.3 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30236693 | 30236693 | PRJNA556992_P_NODE_821012_length_245_cov_0.895349_g818822_i0 | PRJNA556992 | 821012 | 245 | 0.895349 | 2.19360505 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 107 | 4.98e-25 | NR | MFH1782825.1 | 2035772 | g818822 | i0 | 64.6 | 0.96734693877551 | 79 | 28 | 96.7 | 0 | 1 | 237 | 392 | 470 | MFH1782825.1 IS66 family transposase [Candidatus Omnitrophota bacterium] | diamond | 237 | 107 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30268268 | 30268268 | PRJNA556992_P_NODE_14272_length_887_cov_4.481572_g12545_i0 | PRJNA556992 | 14272 | 887 | 4.481572 | 39.75154364 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 113 | 6.350000000000001e-27 | NR | MCG3177451.1 | 2035772 | g12545 | i0 | 64.6 | 0.541149943630214 | 79 | 28 | 26.7 | 0 | 882 | 646 | 70 | 148 | MCG3177451.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 480 | 113 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30268714 | 30268714 | PRJNA556992_P_NODE_996532_length_231_cov_2.367089_g994342_i0 | PRJNA556992 | 996532 | 231 | 2.367089 | 5.46797559 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 51.2 | 3.3e-5 | NR | MDP3041385.1 | 2035772 | g994342 | i0 | 48.5 | 0.857142857142857 | 66 | 33 | 85.7 | 1 | 211 | 14 | 773 | 837 | MDP3041385.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 198 | 51.2 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 31152642 | 31152642 | PRJNA556992_P_NODE_927795_length_238_cov_2.521212_g925605_i0 | PRJNA556992 | 927795 | 238 | 2.521212 | 6.00048456 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 108 | 8.92e-26 | NR | MCG3175412.1 | 2035772 | g925605 | i0 | 67.1 | 0.995798319327731 | 79 | 25 | 99.6 | 1 | 2 | 238 | 158 | 235 | MCG3175412.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 237 | 108 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 31451917 | 31451917 | PRJNA556992_P_NODE_725256_length_250_cov_0.870056_g723067_i0 | PRJNA556992 | 725256 | 250 | 0.870056 | 2.17514 | PVC group | 1783257 | Bacteria | Bacteria | 122 | 2.32e-31 | NR | MDO8675203.1 | 2035772 | g723067 | i0 | 63.9 | 5.94 | 83 | 30 | 99.6 | 0 | 2 | 250 | 265 | 347 | MDO8675203.1 IS3 family transposase [Candidatus Omnitrophota bacterium] | diamond | 1485 | 123 | 0.991869918699187 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 31690594 | 31690594 | PRJNA556992_P_NODE_942037_length_236_cov_4.558282_g939847_i0 | PRJNA556992 | 942037 | 236 | 4.558282 | 10.75754552 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 71.6 | 2.2e-12 | NR | MDD5440382.1 | 2035772 | g939847 | i0 | 50 | 0.838983050847458 | 66 | 32 | 82.6 | 1 | 200 | 6 | 51 | 116 | MDD5440382.1 saccharopine dehydrogenase C-terminal domain-containing protein [Candidatus Omnitrophota bacterium] | diamond | 198 | 71.6 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 31816903 | 31816903 | PRJNA556992_P_NODE_559197_length_262_cov_2.227513_g557008_i0 | PRJNA556992 | 559197 | 262 | 2.227513 | 5.83608406 | Candidatus Kaelpia imicola | 3041138 | Bacteria | Bacteria | 44.3 | 0.0138 | NR | MDP8216252.1 | 3041138 | g557008 | i0 | 39.2 | 1.63740458015267 | 74 | 42 | 83.6 | 2 | 221 | 3 | 1462 | 1533 | MDP8216252.1 filamentous hemagglutinin N-terminal domain-containing protein [Candidatus Kaelpia imicola] | diamond | 429 | 44.3 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Kaelpia | Candidatus Kaelpia imicola | ||||
| 32070066 | 32070066 | PRJNA556992_P_NODE_526258_length_265_cov_1.598958_g524069_i0 | PRJNA556992 | 526258 | 265 | 1.598958 | 4.2372387 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 50.1 | 7.04e-5 | NR | MCA9405894.1 | 2035772 | g524069 | i0 | 30.3 | 2.64905660377358 | 66 | 46 | 74.7 | 0 | 264 | 67 | 101 | 166 | MCA9405894.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 702 | 50.1 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32210986 | 32210986 | PRJNA556992_P_NODE_1007598_length_229_cov_8.461538_g1005408_i0 | PRJNA556992 | 1007598 | 229 | 8.461538 | 19.37692202 | Bacteria | 2 | Bacteria | Bacteria | 77.4 | 1.65e-14 | NR | RKY29240.1 | 2035772 | g1005408 | i0 | 53.2 | 1.89956331877729 | 77 | 34 | 98.3 | 2 | 3 | 227 | 289 | 365 | RKY29240.1 MAG: IS21 family transposase [Candidatus Omnitrophota bacterium] | diamond | 435 | 77.8 | 0.994858611825193 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32291716 | 32291716 | PRJNA556992_P_NODE_1071639_length_219_cov_6.630137_g1069448_i0 | PRJNA556992 | 1071639 | 219 | 6.630137 | 14.52000003 | Candidatus Kaelpia aquatica | 3041137 | Bacteria | Bacteria | 65.5 | 2.5e-10 | NR | MDP8253584.1 | 3041137 | g1069448 | i0 | 49.2 | 1.73972602739726 | 63 | 32 | 86.3 | 0 | 5 | 193 | 279 | 341 | MDP8253584.1 hypothetical protein [Candidatus Kaelpia aquatica] | diamond | 381 | 65.5 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Kaelpia | Candidatus Kaelpia aquatica |
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);;