contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA1120060" and tax_phylum = "Candidatus Goldiibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27921157 | 27921157 | PRJNA1120060_P_NODE_1495505_length_293_cov_4.331818_g1477517_i0 | PRJNA1120060 | 1495505 | 293 | 4.331818 | 12.69222674 | Candidatus Goldiibacteriota bacterium | 2725315 | Bacteria | Bacteria | 54.7 | 7.49e-7 | NR | MCX7697896.1 | 2725315 | g1477517 | i0 | 37.3 | 2.66211604095563 | 83 | 50 | 82.9 | 1 | 247 | 5 | 8 | 90 | MCX7697896.1 ribonuclease HI family protein [Candidatus Goldiibacteriota bacterium] | diamond | 780 | 54.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Goldiibacteriota | Candidatus Goldiibacteriota bacterium | ||||||
| 30447816 | 30447816 | PRJNA1120060_P_NODE_1655293_length_287_cov_1.242991_g1637295_i0 | PRJNA1120060 | 1655293 | 287 | 1.242991 | 3.56738417 | Candidatus Goldiibacteriota bacterium | 2725315 | Bacteria | Bacteria | 47 | 6.28e-4 | NR | MCX7697896.1 | 2725315 | g1637295 | i0 | 41.2 | 2.14285714285714 | 68 | 38 | 69 | 1 | 78 | 275 | 8 | 75 | MCX7697896.1 ribonuclease HI family protein [Candidatus Goldiibacteriota bacterium] | diamond | 615 | 47 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Goldiibacteriota | Candidatus Goldiibacteriota bacterium | ||||||
| 30954172 | 30954172 | PRJNA1120060_P_NODE_2882034_length_244_cov_1.473684_g2863945_i0 | PRJNA1120060 | 2882034 | 244 | 1.473684 | 3.59578896 | Candidatus Goldiibacteriota bacterium | 2725315 | Bacteria | Bacteria | 48.1 | 1.43e-4 | NR | MCX7697896.1 | 2725315 | g2863945 | i0 | 44.8 | 0.713114754098361 | 58 | 30 | 68.9 | 1 | 172 | 5 | 8 | 65 | MCX7697896.1 ribonuclease HI family protein [Candidatus Goldiibacteriota bacterium] | diamond | 174 | 48.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Goldiibacteriota | Candidatus Goldiibacteriota bacterium | ||||||
| 31175343 | 31175343 | PRJNA1120060_P_NODE_469455_length_373_cov_1.403333_g451891_i0 | PRJNA1120060 | 469455 | 373 | 1.403333 | 5.23443209 | Candidatus Goldiibacteriota bacterium | 2725315 | Bacteria | Bacteria | 77.4 | 2.75e-15 | NR | MCX7697896.1 | 2725315 | g451891 | i0 | 39.7 | 7.54423592493298 | 121 | 70 | 95.7 | 2 | 3 | 359 | 9 | 128 | MCX7697896.1 ribonuclease HI family protein [Candidatus Goldiibacteriota bacterium] | diamond | 2814 | 77.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Goldiibacteriota | Candidatus Goldiibacteriota bacterium | ||||||
| 31269857 | 31269857 | PRJNA1120060_P_NODE_2571255_length_252_cov_0.821229_g2553180_i0 | PRJNA1120060 | 2571255 | 252 | 0.821229 | 2.06949708 | Candidatus Goldiibacteriota bacterium | 2725315 | Bacteria | Bacteria | 47.8 | 2.15e-4 | NR | MCX7697896.1 | 2725315 | g2553180 | i0 | 41.2 | 2.51190476190476 | 68 | 38 | 78.6 | 1 | 51 | 248 | 8 | 75 | MCX7697896.1 ribonuclease HI family protein [Candidatus Goldiibacteriota bacterium] | diamond | 633 | 47.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Goldiibacteriota | Candidatus Goldiibacteriota bacterium | ||||||
| 31523670 | 31523670 | PRJNA1120060_P_NODE_523376_length_362_cov_2.342561_g505739_i0 | PRJNA1120060 | 523376 | 362 | 2.342561 | 8.48007082 | Candidatus Goldiibacteriota bacterium | 2725315 | Bacteria | Bacteria | 48.9 | 2.59e-4 | NR | HRU38914.1 | 2725315 | g505739 | i0 | 42.9 | 0.464088397790055 | 56 | 32 | 46.4 | 0 | 192 | 359 | 73 | 128 | HRU38914.1 ribonuclease HI family protein [Candidatus Goldiibacteriota bacterium] | diamond | 168 | 48.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Goldiibacteriota | Candidatus Goldiibacteriota bacterium | ||||||
| 32440986 | 32440986 | PRJNA1120060_P_NODE_3184259_length_232_cov_2.849057_g3166153_i0 | PRJNA1120060 | 3184259 | 232 | 2.849057 | 6.60981224 | Candidatus Goldiibacteriota bacterium | 2725315 | Bacteria | Bacteria | 42.7 | 0.0143 | NR | MCX8094430.1 | 2725315 | g3166153 | i0 | 48.8 | 1.18965517241379 | 43 | 21 | 54.3 | 1 | 131 | 6 | 9 | 51 | MCX8094430.1 ribonuclease HI family protein [Candidatus Goldiibacteriota bacterium] | diamond | 276 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Goldiibacteriota | Candidatus Goldiibacteriota bacterium | ||||||
| 32725081 | 32725081 | PRJNA1120060_P_NODE_63240_length_660_cov_2.630324_g50730_i0 | PRJNA1120060 | 63240 | 660 | 2.630324 | 17.3601384 | Candidatus Goldiibacteriota bacterium | 2725315 | Bacteria | Bacteria | 75.5 | 2.14e-13 | NR | MCX7697896.1 | 2725315 | g50730 | i0 | 40.8 | 2.20454545454545 | 120 | 68 | 53.6 | 2 | 154 | 507 | 9 | 127 | MCX7697896.1 ribonuclease HI family protein [Candidatus Goldiibacteriota bacterium] | diamond | 1455 | 75.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Goldiibacteriota | Candidatus Goldiibacteriota 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);;