contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA680334" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26860791 | 26860791 | PRJNA680334_S_NODE_36261_length_212_cov_2.581006_g35775_i0 | PRJNA680334 | 36261 | 212 | 2.581006 | 5.47173272 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 144 | 2.849999999999999e-41 | NR | MDW0176875.1 | 2169593 | g35775 | i0 | 97.1 | 0.990566037735849 | 70 | 2 | 99.1 | 0 | 210 | 1 | 109 | 178 | MDW0176875.1 extracellular solute-binding protein [Nitrososphaeraceae archaeon] | diamond | 210 | 144 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 26986912 | 26986912 | PRJNA680334_S_NODE_57622_length_183_cov_5.046667_g57136_i0 | PRJNA680334 | 57622 | 183 | 5.046667 | 9.23540061 | archaeon | 1906665 | Archaea | Archaea | 112 | 3.7e-27 | NR | NCQ52301.1 | 1906665 | g57136 | i0 | 83.6 | 1 | 61 | 10 | 100 | 0 | 183 | 1 | 81 | 141 | NCQ52301.1 TraM recognition domain-containing protein [archaeon] | diamond | 183 | 112 | 1 | Archaea | archaeon | ||||||||
| 28692756 | 28692756 | PRJNA680334_S_NODE_79767_length_165_cov_3.090909_g79281_i0 | PRJNA680334 | 79767 | 165 | 3.090909 | 5.09999985 | archaeon | 1906665 | Archaea | Archaea | 78.6 | 1.64e-16 | NR | RYH29614.1 | 1906665 | g79281 | i0 | 77.8 | 0.818181818181818 | 45 | 10 | 81.8 | 0 | 4 | 138 | 126 | 170 | RYH29614.1 MAG: hypothetical protein EON65_07920 [archaeon] | diamond | 135 | 78.6 | 1 | Archaea | archaeon | ||||||||
| 29197907 | 29197907 | PRJNA680334_S_NODE_61789_length_179_cov_4.671233_g61303_i0 | PRJNA680334 | 61789 | 179 | 4.671233 | 8.36150707 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 57.4 | 1.04e-7 | NR | MFA5071071.1 | 2026773 | g61303 | i0 | 43.9 | 0.955307262569832 | 57 | 32 | 95.5 | 0 | 177 | 7 | 15 | 71 | MFA5071071.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 171 | 57.4 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 29619565 | 29619565 | PRJNA680334_S_NODE_83190_length_163_cov_2.100000_g82704_i0 | PRJNA680334 | 83190 | 163 | 2.1 | 3.423 | root | 1 | Root_unresolved | Root_unresolved | 79.7 | 4.26e-17 | NR | MDH4123739.1 | 1906666 | g82704 | i0 | 79.2 | 5.83435582822086 | 53 | 9 | 97.5 | 1 | 3 | 161 | 86 | 136 | MDH4123739.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 951 | 79.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 29955591 | 29955591 | PRJNA680334_S_NODE_73331_length_170_cov_1.218978_g72845_i0 | PRJNA680334 | 73331 | 170 | 1.218978 | 2.0722626 | archaeon | 1906665 | Archaea | Archaea | 64.7 | 2.06e-10 | NR | NCQ52286.1 | 1906665 | g72845 | i0 | 56.4 | 0.970588235294118 | 55 | 24 | 97.1 | 0 | 4 | 168 | 200 | 254 | NCQ52286.1 amino acid ABC transporter substrate-binding protein [archaeon] | diamond | 165 | 64.7 | 1 | Archaea | archaeon | ||||||||
| 30208032 | 30208032 | PRJNA680334_S_NODE_20132_length_254_cov_2.610860_g19646_i0 | PRJNA680334 | 20132 | 254 | 2.61086 | 6.6315844 | archaeon | 1906665 | Archaea | Archaea | 90.5 | 6.72e-19 | NR | NCQ52315.1 | 1906665 | g19646 | i0 | 72.1 | 0.720472440944882 | 61 | 17 | 72 | 0 | 254 | 72 | 618 | 678 | NCQ52315.1 DotA/TraY family protein [archaeon] | diamond | 183 | 90.5 | 1 | Archaea | archaeon | ||||||||
| 30441426 | 30441426 | PRJNA680334_S_NODE_12693_length_292_cov_2.915058_g12207_i0 | PRJNA680334 | 12693 | 292 | 2.915058 | 8.51196936 | Candidatus Lokiarchaeum | 1655637 | Archaea | Archaea | 50.1 | 7.08e-5 | NR | KKK40351.1 | 1538547 | g12207 | i0 | 33.3 | 1.24315068493151 | 63 | 42 | 64.7 | 0 | 83 | 271 | 14 | 76 | KKK40351.1 MAG: Recombination endonuclease VII [Candidatus Lokiarchaeum sp. GC14_75] | diamond | 363 | 50.1 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeales | Promethearchaeaceae | Candidatus Lokiarchaeum | Candidatus Lokiarchaeum sp. GC14_75 | ||
| 32863029 | 32863029 | PRJNA680334_S_NODE_63320_length_178_cov_2.337931_g62834_i0 | PRJNA680334 | 63320 | 178 | 2.337931 | 4.16151718 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 52.4 | 5.76e-6 | NR | MCJ7636234.1 | 2169593 | g62834 | i0 | 48.3 | 1.92134831460674 | 60 | 29 | 97.8 | 1 | 178 | 5 | 185 | 244 | MCJ7636234.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 342 | 52.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon |
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);;