contig_metadata
11 rows where bioproject = "PRJEB11523", tax_clade = "PVC group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10216520 | 10216520 | PRJEB11523_P_NODE_4609_length_219_cov_6.776471_g4531_i0 | PRJEB11523 | 4609 | 219 | 6.776471 | 14.84047149 | Luteolibacter luteus | 2728835 | Bacteria | Bacteria | 257 | 3.83e-64 | NTclustered | gi|1835317346|gb|CP051774.1| | 2728835 | g4531 | i0 | 95.122 | 221.433789954338 | 164 | 6 | 74 | 1 | 22 | 183 | 3804904 | 3805067 | Luteolibacter luteus strain G-1-1-1 chromosome, complete genome | blastn | 48494 | 257 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter luteus | |
| 18834307 | 18834307 | PRJEB11523_P_NODE_3275_length_274_cov_22.982222_g3197_i0 | PRJEB11523 | 3275 | 274 | 22.982222 | 62.97128828 | Bacteria | 2 | Bacteria | Bacteria | 90.5 | 8.97e-19 | NR | OJV03634.1 | 1895866 | g3197 | i0 | 51.8 | 3.64598540145985 | 83 | 35 | 90.9 | 2 | 26 | 274 | 877 | 954 | OJV03634.1 MAG: hypothetical protein BGO12_03755 [Verrucomicrobia bacterium 61-8] | diamond | 999 | 90.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobia bacterium 61-8 | |||||
| 28454119 | 28454119 | PRJEB11523_P_NODE_8386_length_162_cov_1.805310_g8308_i0 | PRJEB11523 | 8386 | 162 | 1.80531 | 2.9246022 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 98.2 | 2.91e-22 | NR | HEV7403817.1 | 2811408 | g8308 | i0 | 84.9 | 0.981481481481482 | 53 | 8 | 98.1 | 0 | 3 | 161 | 262 | 314 | HEV7403817.1 glycosyltransferase [Chthoniobacteraceae bacterium] | diamond | 159 | 98.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 28959374 | 28959374 | PRJEB11523_P_NODE_3068_length_287_cov_1.714286_g2990_i0 | PRJEB11523 | 3068 | 287 | 1.714286 | 4.92000082 | Candidatus Udaeobacter sp. | 2665650 | Bacteria | Bacteria | 50.1 | 4.18e-5 | NR | HEY6154670.1 | 2665650 | g2990 | i0 | 37.3 | 0.700348432055749 | 67 | 25 | 70 | 2 | 19 | 219 | 46 | 95 | HEY6154670.1 hypothetical protein [Candidatus Udaeobacter sp.] | diamond | 201 | 50.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Candidatus Udaeobacter | Candidatus Udaeobacter sp. | |
| 29369656 | 29369656 | PRJEB11523_P_NODE_8589_length_161_cov_1.750000_g8511_i0 | PRJEB11523 | 8589 | 161 | 1.75 | 2.8175 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 65.5 | 7.28e-11 | NR | RYD66306.1 | 2026800 | g8511 | i0 | 56.9 | 0.950310559006211 | 51 | 22 | 95 | 0 | 9 | 161 | 147 | 197 | RYD66306.1 MAG: hypothetical protein EOP83_05405 [Verrucomicrobiaceae bacterium] | diamond | 153 | 65.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 29463902 | 29463902 | PRJEB11523_P_NODE_4290_length_230_cov_2.712707_g4212_i0 | PRJEB11523 | 4290 | 230 | 2.712707 | 6.2392261 | Nibricoccus sp. | 2576892 | Bacteria | Bacteria | 100 | 1.4100000000000001e-22 | NR | MFT3868947.1 | 2576892 | g4212 | i0 | 85.3 | 0.88695652173913 | 68 | 10 | 88.7 | 0 | 16 | 219 | 60 | 127 | MFT3868947.1 fibronectin type III domain-containing protein [Nibricoccus sp.] | diamond | 204 | 100 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Nibricoccus | Nibricoccus sp. | |
| 29837004 | 29837004 | PRJEB11523_P_NODE_7691_length_166_cov_0.871795_g7613_i0 | PRJEB11523 | 7691 | 166 | 0.871795 | 1.4471797 | Bacteria | 2 | Bacteria | Bacteria | 95.1 | 4.51e-21 | NR | MEI8044547.1 | 2026799 | g7613 | i0 | 79.6 | 6.83132530120482 | 54 | 11 | 97.6 | 0 | 164 | 3 | 490 | 543 | MEI8044547.1 alpha-amylase family glycosyl hydrolase [Verrucomicrobiota bacterium] | diamond | 1134 | 95.5 | 0.995811518324607 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30506742 | 30506742 | PRJEB11523_P_NODE_2433_length_336_cov_10.163763_g2355_i0 | PRJEB11523 | 2433 | 336 | 10.163763 | 34.15024368 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 69.7 | 2.16e-11 | NR | MES2694486.1 | 2026799 | g2355 | i0 | 47.2 | 0.642857142857143 | 72 | 30 | 57.1 | 1 | 315 | 124 | 214 | 285 | MES2694486.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 216 | 69.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30664655 | 30664655 | PRJEB11523_P_NODE_2313_length_348_cov_12.036789_g2235_i0 | PRJEB11523 | 2313 | 348 | 12.036789 | 41.88802572 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 53.1 | 2.82e-6 | NR | HZV36620.1 | 2499141 | g2235 | i0 | 44.2 | 0.663793103448276 | 77 | 34 | 58.6 | 3 | 48 | 251 | 30 | 106 | HZV36620.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 231 | 53.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 31549964 | 31549964 | PRJEB11523_P_NODE_6156_length_186_cov_5.211679_g6078_i0 | PRJEB11523 | 6156 | 186 | 5.211679 | 9.69372294 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 82 | 1.62e-16 | NR | MDH4454360.1 | 2026799 | g6078 | i0 | 72.3 | 0.758064516129032 | 47 | 13 | 75.8 | 0 | 31 | 171 | 1 | 47 | MDH4454360.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 141 | 82 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32656232 | 32656232 | PRJEB11523_P_NODE_3320_length_271_cov_20.387387_g3242_i0 | PRJEB11523 | 3320 | 271 | 20.387387 | 55.24981877 | Verrucomicrobia bacterium TMED56 | 1986792 | Bacteria | Bacteria | 87 | 1.39e-19 | NR | OUU45232.1 | 1986792 | g3242 | i0 | 51.3 | 0.885608856088561 | 80 | 36 | 85.2 | 1 | 28 | 258 | 50 | 129 | OUU45232.1 MAG: hypothetical protein CBC16_01365 [Verrucomicrobia bacterium TMED56] | diamond | 240 | 87 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobia bacterium TMED56 |
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);;