contig_metadata
9 rows where bioproject = "PRJNA285816" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27168744 | 27168744 | PRJNA285816_S_NODE_21202_length_176_cov_2.834646_g21100_i0 | PRJNA285816 | 21202 | 176 | 2.8346460000000002 | 4.98897696 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 53.9 | 2.35e-7 | NR | HEY7082467.1 | 2169593 | g21100 | i0 | 42.9 | 0.954545454545455 | 56 | 32 | 95.5 | 0 | 170 | 3 | 19 | 74 | HEY7082467.1 protease inhibitor I42 family protein [Nitrososphaeraceae archaeon] | diamond | 168 | 53.9 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 27471148 | 27471148 | PRJNA285816_S_NODE_7503_length_259_cov_1.442857_g7401_i0 | PRJNA285816 | 7503 | 259 | 1.442857 | 3.73699963 | Thermofilum | 2268 | Archaea | Archaea | 48.9 | 2.78e-4 | NR | MEM0093123.1 | 1961369 | g7401 | i0 | 42.9 | 3.52123552123552 | 56 | 31 | 64.9 | 1 | 72 | 239 | 230 | 284 | MEM0093123.1 DUF3782 domain-containing protein [Thermofilum sp.] | diamond | 912 | 48.9 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermofilales | Thermofilaceae | Thermofilum | Thermofilum sp. | ||
| 28842462 | 28842462 | PRJNA285816_S_NODE_19248_length_183_cov_1.156716_g19146_i0 | PRJNA285816 | 19248 | 183 | 1.156716 | 2.11679028 | Candidatus Nitrosocosmicus sp. | 2109671 | Archaea | Archaea | 60.5 | 2.11e-9 | NR | HKX96835.1 | 2109671 | g19146 | i0 | 49.1 | 3.62295081967213 | 53 | 27 | 86.9 | 0 | 178 | 20 | 37 | 89 | HKX96835.1 CHRD domain-containing protein [Candidatus Nitrosocosmicus sp.] | diamond | 663 | 60.5 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus sp. | ||
| 29568744 | 29568744 | PRJNA285816_S_NODE_1570_length_527_cov_1.738494_g1470_i0 | PRJNA285816 | 1570 | 527 | 1.738494 | 9.16186338 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 84 | 2.89e-15 | NR | MEW6587960.1 | 2056631 | g1470 | i0 | 31.7 | 1.04174573055028 | 183 | 111 | 99.1 | 5 | 3 | 524 | 140 | 317 | MEW6587960.1 phosphate ABC transporter substrate-binding protein PstS [Thermoproteota archaeon] | diamond | 549 | 84 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 30502569 | 30502569 | PRJNA285816_S_NODE_21633_length_175_cov_1.650794_g21531_i0 | PRJNA285816 | 21633 | 175 | 1.650794 | 2.8888895 | root | 1 | Root_unresolved | Root_unresolved | 62.4 | 1.62e-9 | NR | AIF00590.1 | 1456004 | g21531 | i0 | 57.4 | 3.41142857142857 | 47 | 20 | 80.6 | 0 | 29 | 169 | 42 | 88 | AIF00590.1 hypothetical protein [uncultured marine thaumarchaeote KM3_136_A11] | diamond | 597 | 62.8 | 0.993630573248408 | Archaea | Thermoproteati | Nitrososphaerota | uncultured marine thaumarchaeote KM3_136_A11 | ||||||
| 31116533 | 31116533 | PRJNA285816_S_NODE_17675_length_188_cov_2.762590_g17573_i0 | PRJNA285816 | 17675 | 188 | 2.76259 | 5.1936692 | Candidatus Nezhaarchaeota archaeon | 2571048 | Archaea | Archaea | 99 | 2.84e-22 | NR | MCS7139856.1 | 2571048 | g17573 | i0 | 68.8 | 7.11702127659574 | 64 | 18 | 98.9 | 1 | 2 | 187 | 550 | 613 | MCS7139856.1 leucine--tRNA ligase [Candidatus Nezhaarchaeota archaeon] | diamond | 1338 | 99 | 1 | Archaea | Thermoproteati | Candidatus Nezhaarchaeota | Candidatus Nezhaarchaeota archaeon | ||||||
| 31496449 | 31496449 | PRJNA285816_S_NODE_2356_length_434_cov_1.366234_g2254_i0 | PRJNA285816 | 2356 | 434 | 1.366234 | 5.92945556 | Candidatus Methanosuratincola sp. | 2495426 | Archaea | Archaea | 87.8 | 2.31e-17 | NR | MBC7120667.1 | 2495426 | g2254 | i0 | 48.2 | 2.52304147465438 | 85 | 44 | 58.8 | 0 | 362 | 108 | 33 | 117 | MBC7120667.1 phosphate ABC transporter substrate-binding protein PstS [Candidatus Methanosuratincola sp.] | diamond | 1095 | 87.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Methanosuratincolia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanosuratincola (ex Vanwonterghem et al. 2016) | Candidatus Methanosuratincola sp. | ||
| 31545688 | 31545688 | PRJNA285816_S_NODE_15356_length_198_cov_1.691275_g15254_i0 | PRJNA285816 | 15356 | 198 | 1.691275 | 3.3487245 | Archaea | 2157 | Archaea | Archaea | 55.1 | 9.46e-7 | NR | AIE99800.1 | 1455991 | g15254 | i0 | 45.5 | 1.8030303030303 | 55 | 26 | 83.3 | 2 | 22 | 186 | 139 | 189 | AIE99800.1 hypothetical protein [uncultured marine thaumarchaeote KM3_11_E10] | diamond | 357 | 55.5 | 0.992792792792793 | Archaea | Thermoproteati | Nitrososphaerota | uncultured marine thaumarchaeote KM3_11_E10 | ||||||
| 32129122 | 32129122 | PRJNA285816_S_NODE_26498_length_166_cov_0.863248_g26396_i0 | PRJNA285816 | 26498 | 166 | 0.863248 | 1.43299168 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 86.3 | 4.2e-18 | NR | MDA7940732.1 | 2024843 | g26396 | i0 | 61.1 | 4.8433734939759 | 54 | 21 | 97.6 | 0 | 166 | 5 | 331 | 384 | MDA7940732.1 multicopper oxidase domain-containing protein [Nitrosopumilus sp.] | diamond | 804 | 86.3 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus 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);;