contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA879067" and tax_kingdom = "Thermoproteati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16158513 | 16158513 | PRJNA879067_P_NODE_69593_length_390_cov_3.324921_g66108_i0 | PRJNA879067 | 69593 | 390 | 3.324921 | 12.9671919 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 126 | 2.33e-35 | NR | MDF2738432.1 | 2169593 | g66108 | i0 | 91.5 | 0.907692307692308 | 59 | 5 | 45.4 | 0 | 221 | 45 | 1 | 59 | MDF2738432.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 354 | 126 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 27055375 | 27055375 | PRJNA879067_P_NODE_15322_length_1209_cov_8.209507_g12690_i0 | PRJNA879067 | 15322 | 1209 | 8.209507 | 99.25293963 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 212 | 1.26e-61 | NR | MDW3611096.1 | 2169593 | g12690 | i0 | 96.3 | 0.267990074441687 | 108 | 4 | 26.8 | 0 | 1188 | 865 | 187 | 294 | MDW3611096.1 DNA repair and recombination protein RadA [Nitrososphaeraceae archaeon] | diamond | 324 | 212 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 27813632 | 27813632 | PRJNA879067_P_NODE_103384_length_251_cov_0.865169_g99898_i0 | PRJNA879067 | 103384 | 251 | 0.865169 | 2.17157419 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 70.9 | 2.92e-13 | NR | HTY77714.1 | 3045160 | g99898 | i0 | 74.4 | 0.51394422310757 | 43 | 11 | 51.4 | 0 | 1 | 129 | 80 | 122 | HTY77714.1 TRAP transporter small permease [Candidatus Bathyarchaeia archaeon] | diamond | 129 | 70.9 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 29486556 | 29486556 | PRJNA879067_P_NODE_102530_length_253_cov_1.205556_g99044_i0 | PRJNA879067 | 102530 | 253 | 1.205556 | 3.05005668 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 58.9 | 5.61e-9 | NR | HET9806997.1 | 2169593 | g99044 | i0 | 62.8 | 0.509881422924901 | 43 | 16 | 51 | 0 | 130 | 2 | 6 | 48 | HET9806997.1 P-loop NTPase fold protein [Nitrososphaeraceae archaeon] | diamond | 129 | 58.9 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 29644271 | 29644271 | PRJNA879067_P_NODE_34270_length_697_cov_3.482372_g30889_i0 | PRJNA879067 | 34270 | 697 | 3.482372 | 24.27213284 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 65.9 | 1.53e-10 | NR | MDW3605092.1 | 2169593 | g30889 | i0 | 91.4 | 0.288378766140603 | 35 | 3 | 15.1 | 0 | 524 | 628 | 1 | 35 | MDW3605092.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 201 | 65.9 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 29834140 | 29834140 | PRJNA879067_P_NODE_79831_length_340_cov_0.996255_g76345_i0 | PRJNA879067 | 79831 | 340 | 0.996255 | 3.387267 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 125 | 1.0599999999999998e-31 | NR | MDA7940732.1 | 2024843 | g76345 | i0 | 65.4 | 2.12647058823529 | 81 | 28 | 71.5 | 0 | 14 | 256 | 319 | 399 | MDA7940732.1 multicopper oxidase domain-containing protein [Nitrosopumilus sp.] | diamond | 723 | 125 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 31097784 | 31097784 | PRJNA879067_P_NODE_70655_length_385_cov_0.900641_g67170_i0 | PRJNA879067 | 70655 | 385 | 0.900641 | 3.46746785 | Desulfurococcales archaeon | 2480821 | Archaea | Archaea | 68.9 | 3.39e-12 | NR | MEB3780172.1 | 2480821 | g67170 | i0 | 43.5 | 0.662337662337662 | 85 | 42 | 66.2 | 1 | 3 | 257 | 33 | 111 | MEB3780172.1 YbjQ family protein [Desulfurococcales archaeon] | diamond | 255 | 68.9 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcales archaeon | ||||
| 31825110 | 31825110 | PRJNA879067_P_NODE_76997_length_352_cov_2.856631_g73511_i0 | PRJNA879067 | 76997 | 352 | 2.856631 | 10.05534112 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 101 | 2.41e-22 | NR | MEM3063527.1 | 2026795 | g73511 | i0 | 47.3 | 0.954545454545455 | 112 | 59 | 95.5 | 0 | 337 | 2 | 357 | 468 | MEM3063527.1 DNA polymerase [Nitrososphaerota archaeon] | diamond | 336 | 101 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 32686895 | 32686895 | PRJNA879067_P_NODE_92760_length_288_cov_1.790698_g89274_i0 | PRJNA879067 | 92760 | 288 | 1.790698 | 5.15721024 | root | 1 | Root_unresolved | Root_unresolved | 65.9 | 1.14e-10 | NR | HYF75015.1 | 2109671 | g89274 | i0 | 66.7 | 3.20833333333333 | 45 | 11 | 46.9 | 1 | 288 | 154 | 75 | 115 | HYF75015.1 nucleoside 2-deoxyribosyltransferase domain-containing protein [Candidatus Nitrosocosmicus sp.] | diamond | 924 | 65.9 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus 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);;