contig_metadata
7 rows where bioproject = "PRJNA1214993" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11808940 | 11808940 | PRJNA1214993_P_NODE_17230_length_270_cov_1.187817_g17044_i0 | PRJNA1214993 | 17230 | 270 | 1.187817 | 3.2071059 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 143 | 2.1199999999999996e-37 | NR | MBL9115668.1 | 2026800 | g17044 | i0 | 74.4 | 11 | 90 | 23 | 100 | 0 | 1 | 270 | 337 | 426 | MBL9115668.1 NADP-dependent isocitrate dehydrogenase [Verrucomicrobiaceae bacterium] | diamond | 2970 | 143 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 19456383 | 19456383 | PRJNA1214993_P_NODE_20796_length_251_cov_0.865169_g20610_i0 | PRJNA1214993 | 20796 | 251 | 0.865169 | 2.17157419 | Luteolibacter sp. SL250 | 2995170 | Bacteria | Bacteria | 448 | 2.48e-121 | NTclustered | gi|2381117106|gb|CP113054.1| | 2995170 | g20610 | i0 | 98.805 | 288.05577689243 | 251 | 3 | 100 | 0 | 1 | 251 | 1032 | 782 | Luteolibacter sp. SL250 chromosome | blastn | 72302 | 448 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 26945998 | 26945998 | PRJNA1214993_P_NODE_21382_length_250_cov_0.870056_g21196_i0 | PRJNA1214993 | 21382 | 250 | 0.870056 | 2.17514 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 122 | 1.15e-31 | NR | RYD65414.1 | 2026800 | g21196 | i0 | 78.3 | 0.996 | 83 | 16 | 99.6 | 1 | 2 | 250 | 103 | 183 | RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] | diamond | 249 | 122 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 27407779 | 27407779 | PRJNA1214993_P_NODE_11343_length_327_cov_1.228346_g11157_i0 | PRJNA1214993 | 11343 | 327 | 1.228346 | 4.01669142 | Rariglobus | 2706524 | Bacteria | Bacteria | 46.6 | 0.00448 | NR | MFA6286022.1 | 2006848 | g11157 | i0 | 32.3 | 2.55045871559633 | 93 | 63 | 85.3 | 0 | 28 | 306 | 704 | 796 | MFA6286022.1 fibronectin type III domain-containing protein [Opitutaceae bacterium] | diamond | 834 | 47 | 0.991489361702128 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 31652710 | 31652710 | PRJNA1214993_P_NODE_14937_length_287_cov_1.378505_g14751_i0 | PRJNA1214993 | 14937 | 287 | 1.378505 | 3.95630935 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 43.1 | 0.0365 | NR | HEX3818319.1 | 2201154 | g14751 | i0 | 39.1 | 1.44250871080139 | 69 | 38 | 69 | 3 | 65 | 262 | 155 | 222 | HEX3818319.1 CAP domain-containing protein [Chthoniobacterales bacterium] | diamond | 414 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 32475695 | 32475695 | PRJNA1214993_P_NODE_20539_length_251_cov_0.876404_g20353_i0 | PRJNA1214993 | 20539 | 251 | 0.876404 | 2.19977404 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 42.7 | 0.0383 | NR | HUJ72026.1 | 2499141 | g20353 | i0 | 41 | 0.729083665338645 | 61 | 23 | 57.4 | 3 | 13 | 156 | 141 | 201 | HUJ72026.1 4-alpha-glucanotransferase [Verrucomicrobiia bacterium] | diamond | 183 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 32809517 | 32809517 | PRJNA1214993_P_NODE_19120_length_256_cov_1.344262_g18934_i0 | PRJNA1214993 | 19120 | 256 | 1.344262 | 3.44131072 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 148 | 7.55e-40 | NR | MEI6715620.1 | 2026799 | g18934 | i0 | 84.5 | 9.9375 | 84 | 13 | 98.4 | 0 | 2 | 253 | 122 | 205 | MEI6715620.1 fumarate hydratase [Verrucomicrobiota bacterium] | diamond | 2544 | 148 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota 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);;