contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJNA1188114" and tax_phylum = "Verrucomicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13073589 | 13073589 | PRJNA1188114_P_NODE_19571_length_161_cov_0.910714_g19519_i0 | PRJNA1188114 | 19571 | 161 | 0.910714 | 1.46624954 | Luteolibacter | 518753 | Bacteria | Bacteria | 103 | 1.39e-25 | NR | MEO7099747.1 | 1962973 | g19519 | i0 | 88.7 | 5.92546583850932 | 53 | 6 | 98.8 | 0 | 1 | 159 | 84 | 136 | MEO7099747.1 response regulator transcription factor [Luteolibacter sp.] | diamond | 954 | 104 | 0.990384615384615 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. | |
| 26787658 | 26787658 | PRJNA1188114_P_NODE_14261_length_165_cov_1.465517_g14209_i0 | PRJNA1188114 | 14261 | 165 | 1.465517 | 2.41810305 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 113 | 2e-27 | NR | MDQ6632165.1 | 2026799 | g14209 | i0 | 94.4 | 4.90909090909091 | 54 | 3 | 98.2 | 0 | 163 | 2 | 304 | 357 | MDQ6632165.1 DUF1553 domain-containing protein [Verrucomicrobiota bacterium] | diamond | 810 | 113 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 26914079 | 26914079 | PRJNA1188114_P_NODE_4502_length_212_cov_1.251534_g4450_i0 | PRJNA1188114 | 4502 | 212 | 1.251534 | 2.65325208 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 120 | 3.689999999999999e-31 | NR | RYD65414.1 | 2026800 | g4450 | i0 | 77.1 | 0.990566037735849 | 70 | 16 | 99.1 | 0 | 3 | 212 | 232 | 301 | RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] | diamond | 210 | 120 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 27988377 | 27988377 | PRJNA1188114_P_NODE_16125_length_164_cov_0.886957_g16073_i0 | PRJNA1188114 | 16125 | 164 | 0.886957 | 1.45460948 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 41.6 | 0.0333 | NR | MFH1499603.1 | 2026799 | g16073 | i0 | 81 | 0.384146341463415 | 21 | 4 | 38.4 | 0 | 58 | 120 | 1 | 21 | MFH1499603.1 O-antigen ligase family protein [Verrucomicrobiota bacterium] | diamond | 63 | 41.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28051448 | 28051448 | PRJNA1188114_P_NODE_10345_length_174_cov_1.112000_g10293_i0 | PRJNA1188114 | 10345 | 174 | 1.112 | 1.93488 | Luteolibacter sp. LG18 | 2819286 | Bacteria | Bacteria | 82.4 | 7.15e-17 | NR | WP_338288046.1 | 2819286 | g10293 | i0 | 67.9 | 1.93103448275862 | 56 | 18 | 96.6 | 0 | 5 | 172 | 152 | 207 | WP_338288046.1 type II secretion system F family protein [Luteolibacter sp. LG18] | diamond | 336 | 82.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. LG18 | |
| 28367095 | 28367095 | PRJNA1188114_P_NODE_6446_length_189_cov_3.100000_g6394_i0 | PRJNA1188114 | 6446 | 189 | 3.1 | 5.859 | Synoicihabitans lomoniglobus | 2909285 | Bacteria | Bacteria | 89.4 | 6.84e-19 | NR | WP_330929723.1 | 2909285 | g6394 | i0 | 59.7 | 0.984126984126984 | 62 | 25 | 98.4 | 0 | 2 | 187 | 518 | 579 | WP_330929723.1 endo-1,4-beta-xylanase [Synoicihabitans lomoniglobus] | diamond | 186 | 89.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Synoicihabitans | Synoicihabitans lomoniglobus | |
| 28493621 | 28493621 | PRJNA1188114_P_NODE_14027_length_166_cov_0.871795_g13975_i0 | PRJNA1188114 | 14027 | 166 | 0.871795 | 1.4471797 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 82.8 | 9.56e-17 | NR | MFM7102256.1 | 2026799 | g13975 | i0 | 83.6 | 2.98192771084337 | 55 | 9 | 99.4 | 0 | 2 | 166 | 406 | 460 | MFM7102256.1 tetratricopeptide repeat protein [Verrucomicrobiota bacterium] | diamond | 495 | 82.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29440445 | 29440445 | PRJNA1188114_P_NODE_6610_length_189_cov_1.342857_g6558_i0 | PRJNA1188114 | 6610 | 189 | 1.342857 | 2.53799973 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 112 | 7.65e-28 | NR | HEU5078630.1 | 2006848 | g6558 | i0 | 85.7 | 1 | 63 | 9 | 100 | 0 | 189 | 1 | 173 | 235 | HEU5078630.1 Ldh family oxidoreductase [Opitutaceae bacterium] | diamond | 189 | 112 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 30767478 | 30767478 | PRJNA1188114_P_NODE_9654_length_176_cov_2.173228_g9602_i0 | PRJNA1188114 | 9654 | 176 | 2.173228 | 3.82488128 | Opitutus sp. | 1913982 | Bacteria | Bacteria | 93.2 | 1.99e-20 | NR | HWL15758.1 | 1913982 | g9602 | i0 | 72.4 | 1.97727272727273 | 58 | 16 | 98.9 | 0 | 175 | 2 | 236 | 293 | HWL15758.1 MFS transporter [Opitutus sp.] | diamond | 348 | 93.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. | |
| 31399755 | 31399755 | PRJNA1188114_P_NODE_17976_length_162_cov_0.902655_g17924_i0 | PRJNA1188114 | 17976 | 162 | 0.902655 | 1.4623011 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 98.2 | 7.139999999999999e-23 | NR | MDB6078283.1 | 2562705 | g17924 | i0 | 81.1 | 0.981481481481482 | 53 | 10 | 98.1 | 0 | 3 | 161 | 212 | 264 | MDB6078283.1 LysR family transcriptional regulator [Akkermansiaceae bacterium] | diamond | 159 | 98.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae 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);;