contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA773247" and tax_phylum = "Candidatus Shapironibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27337897 | 27337897 | PRJNA773247_P_NODE_1963_length_1422_cov_10.973314_g1923_i0 | PRJNA773247 | 1963 | 1422 | 10.973314 | 156.04052508 | Candidatus Shapirobacteria bacterium | 2053613 | Bacteria | Bacteria | 110 | 3.789999999999999e-23 | NR | MFA7301882.1 | 2053613 | g1923 | i0 | 48.8 | 0.255274261603376 | 121 | 50 | 25.5 | 4 | 18 | 380 | 161 | 269 | MFA7301882.1 hypothetical protein [Candidatus Shapirobacteria bacterium] | diamond | 363 | 110 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium | ||||||
| 29210378 | 29210378 | PRJNA773247_P_NODE_19929_length_321_cov_7.302419_g19845_i0 | PRJNA773247 | 19929 | 321 | 7.302419 | 23.44076499 | Bacteria | 2 | Bacteria | Bacteria | 89.7 | 3.02e-18 | NR | MFA5025545.1 | 2053613 | g19845 | i0 | 69.4 | 1.73831775700935 | 62 | 19 | 57.9 | 0 | 188 | 3 | 10 | 71 | MFA5025545.1 ATP-dependent DNA helicase [Candidatus Shapirobacteria bacterium] | diamond | 558 | 90.1 | 0.995560488346282 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium | ||||||
| 29737241 | 29737241 | PRJNA773247_P_NODE_9270_length_523_cov_3.564444_g9187_i0 | PRJNA773247 | 9270 | 523 | 3.564444 | 18.64204212 | Candidatus Shapirobacteria bacterium | 2053613 | Bacteria | Bacteria | 122 | 1.2399999999999999e-28 | NR | MFA7301986.1 | 2053613 | g9187 | i0 | 37.2 | 0.986615678776291 | 172 | 105 | 97.5 | 3 | 519 | 10 | 134 | 304 | MFA7301986.1 hypothetical protein [Candidatus Shapirobacteria bacterium] | diamond | 516 | 122 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium | ||||||
| 29768922 | 29768922 | PRJNA773247_P_NODE_1491_length_1612_cov_27.323587_g1461_i0 | PRJNA773247 | 1491 | 1612 | 27.323587 | 440.45622244 | Candidatus Shapirobacteria bacterium | 2053613 | Bacteria | Bacteria | 276 | 2.66e-79 | NR | MFA7301986.1 | 2053613 | g1461 | i0 | 34.1 | 0.917493796526055 | 493 | 305 | 90.1 | 9 | 1610 | 159 | 27 | 508 | MFA7301986.1 hypothetical protein [Candidatus Shapirobacteria bacterium] | diamond | 1479 | 276 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium | ||||||
| 29927134 | 29927134 | PRJNA773247_P_NODE_33451_length_244_cov_0.900585_g33367_i0 | PRJNA773247 | 33451 | 244 | 0.900585 | 2.1974274 | Candidatus Shapirobacteria bacterium | 2053613 | Bacteria | Bacteria | 46.2 | 6.31e-4 | NR | MFA7301876.1 | 2053613 | g33367 | i0 | 49.2 | 0.774590163934426 | 63 | 31 | 77.5 | 1 | 222 | 34 | 14 | 75 | MFA7301876.1 hypothetical protein [Candidatus Shapirobacteria bacterium] | diamond | 189 | 46.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium | ||||||
| 31001290 | 31001290 | PRJNA773247_P_NODE_29854_length_252_cov_11.391061_g29770_i0 | PRJNA773247 | 29854 | 252 | 11.391061 | 28.70547372 | Candidatus Shapirobacteria bacterium | 2053613 | Bacteria | Bacteria | 90.5 | 6.71e-19 | NR | MFA7301986.1 | 2053613 | g29770 | i0 | 47.4 | 0.904761904761905 | 76 | 40 | 90.5 | 0 | 243 | 16 | 74 | 149 | MFA7301986.1 hypothetical protein [Candidatus Shapirobacteria bacterium] | diamond | 228 | 90.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria bacterium | ||||||
| 32298291 | 32298291 | PRJNA773247_P_NODE_15679_length_373_cov_11.006667_g15595_i0 | PRJNA773247 | 15679 | 373 | 11.006667 | 41.05486791 | Candidatus Shapirobacteria bacterium | 2053613 | Bacteria | Bacteria | 83.6 | 8.27e-16 | NR | MDD4027033.1 | 2053613 | g15595 | i0 | 50 | 0.756032171581769 | 94 | 47 | 75.6 | 0 | 367 | 86 | 646 | 739 | MDD4027033.1 hypothetical protein [Candidatus Shapirobacteria bacterium] | diamond | 282 | 83.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Shapironibacteriota | Candidatus Shapirobacteria 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);;