contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA605033" and tax_kingdom = "Methanobacteriati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10073213 | 10073213 | PRJNA605033_P_NODE_11388_length_412_cov_2.628647_g9857_i0 | PRJNA605033 | 11388 | 412 | 2.628647 | 10.83002564 | Thermococcus | 2263 | Archaea | Archaea | 256 | 1.69e-78 | NR | MEO2152736.1 | 35749 | g9857 | i0 | 98.5 | 17.8252427184466 | 136 | 2 | 99 | 0 | 3 | 410 | 511 | 646 | MEO2152736.1 DNA polymerase domain-containing protein [Thermococcus sp.] | diamond | 7344 | 256 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. | ||
| 19708237 | 19708237 | PRJNA605033_P_NODE_1576_length_1291_cov_2.747611_g758_i0 | PRJNA605033 | 1576 | 1291 | 2.747611 | 35.47165801 | Thermococcus | 2263 | Archaea | Archaea | 807 | 1.87e-276 | NR | WP_014121997.1 | 246969 | g758 | i0 | 88 | 2.16576297443842 | 466 | 20 | 99.9 | 3 | 2 | 1291 | 1 | 466 | WP_014121997.1 DNA polymerase domain-containing protein [Thermococcus sp. AM4] | diamond | 2796 | 807 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. AM4 | ||
| 24809335 | 24809335 | PRJNA605033_P_NODE_64140_length_222_cov_4.679144_g62571_i0 | PRJNA605033 | 64140 | 222 | 4.679144 | 10.38769968 | Halovenus aranensis | 890420 | Archaea | Archaea | 67.8 | 3.8e-11 | NR | SDJ86709.1 | 890420 | g62571 | i0 | 46.6 | 0.986486486486487 | 73 | 30 | 98.6 | 1 | 220 | 2 | 271 | 334 | SDJ86709.1 Transposase DDE domain-containing protein [Halovenus aranensis] | diamond | 219 | 67.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halovenus | Halovenus aranensis | |
| 26935006 | 26935006 | PRJNA605033_P_NODE_153282_length_191_cov_3.147436_g151713_i0 | PRJNA605033 | 153282 | 191 | 3.147436 | 6.01160276 | Thermococcus | 2263 | Archaea | Archaea | 133 | 2.07e-34 | NR | WP_167728776.1 | 163002 | g151713 | i0 | 100 | 4.94764397905759 | 63 | 0 | 99 | 0 | 2 | 190 | 1761 | 1823 | WP_167728776.1 DNA polymerase domain-containing protein [Thermococcus sp. 9N3] | diamond | 945 | 133 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. 9N3 | ||
| 28596069 | 28596069 | PRJNA605033_P_NODE_109247_length_222_cov_1.807487_g107678_i0 | PRJNA605033 | 109247 | 222 | 1.807487 | 4.01262114 | Methanospirillum sp. | 45200 | Archaea | Archaea | 50.1 | 7.37e-5 | NR | MBP9009538.1 | 45200 | g107678 | i0 | 41.1 | 1.97297297297297 | 73 | 20 | 98.6 | 1 | 219 | 1 | 199 | 248 | MBP9009538.1 DNA cytosine methyltransferase [Methanospirillum sp.] | diamond | 438 | 50.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanospirillaceae | Methanospirillum | Methanospirillum sp. | |
| 30585416 | 30585416 | PRJNA605033_P_NODE_180613_length_174_cov_6.985612_g179044_i0 | PRJNA605033 | 180613 | 174 | 6.985612 | 12.15496488 | Pyrococcus furiosus | 2261 | Archaea | Archaea | 110 | 1.47e-26 | NR | 4AHC_A | 2261 | g179044 | i0 | 96.5 | 0.982758620689655 | 57 | 2 | 98.3 | 0 | 172 | 2 | 131 | 187 | 4AHC_A Chain A, DNA POLYMERASE [Pyrococcus furiosus] | diamond | 171 | 110 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Pyrococcus | Pyrococcus furiosus | ||
| 32229986 | 32229986 | PRJNA605033_P_NODE_170558_length_180_cov_1.379310_g168989_i0 | PRJNA605033 | 170558 | 180 | 1.37931 | 2.482758 | Halobaculum sp. | 1891221 | Archaea | Archaea | 40 | 0.0495 | NR | MFB6177911.1 | 1891221 | g168989 | i0 | 35.8 | 0.883333333333333 | 53 | 28 | 78.3 | 1 | 177 | 37 | 49 | 101 | MFB6177911.1 AAA family ATPase [Halobaculum sp.] | diamond | 159 | 40 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum sp. |
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);;