contig_metadata
9 rows where bioproject = "PRJNA758088" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26641421 | 26641421 | PRJNA758088_P_NODE_301441_length_249_cov_0.875000_g294470_i0 | PRJNA758088 | 301441 | 249 | 0.875 | 2.17875 | Nitrosarchaeum sp. | 2026886 | Archaea | Archaea | 116 | 3.63e-28 | NR | MFB5612793.1 | 2026886 | g294470 | i0 | 73.2 | 0.987951807228916 | 82 | 22 | 98.8 | 0 | 3 | 248 | 505 | 586 | MFB5612793.1 molecular chaperone DnaK [Nitrosarchaeum sp.] | diamond | 246 | 116 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. | ||
| 26736070 | 26736070 | PRJNA758088_P_NODE_310661_length_248_cov_0.874286_g303690_i0 | PRJNA758088 | 310661 | 248 | 0.874286 | 2.16822928 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 87.8 | 5.47e-18 | NR | MDT8781956.1 | 2026714 | g303690 | i0 | 57.7 | 2.47983870967742 | 71 | 28 | 85.9 | 1 | 246 | 34 | 563 | 631 | MDT8781956.1 N-6 DNA methylase [Candidatus Bathyarchaeota archaeon] | diamond | 615 | 87.8 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 26768152 | 26768152 | PRJNA758088_P_NODE_359461_length_242_cov_0.875740_g352490_i0 | PRJNA758088 | 359461 | 242 | 0.87574 | 2.1192908 | Nitrosopumilaceae archaeon | 2202732 | Archaea | Archaea | 62.4 | 4.26e-9 | NR | HET6457666.1 | 2202732 | g352490 | i0 | 58.7 | 2.24380165289256 | 46 | 19 | 57 | 0 | 219 | 82 | 366 | 411 | HET6457666.1 hypothetical protein [Nitrosopumilaceae archaeon] | diamond | 543 | 62.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 27274262 | 27274262 | PRJNA758088_P_NODE_149983_length_344_cov_1.136531_g143012_i0 | PRJNA758088 | 149983 | 344 | 1.136531 | 3.90966664 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 98.2 | 1.64e-24 | NR | MCY1156862.1 | 1971748 | g143012 | i0 | 96.1 | 0.444767441860465 | 51 | 2 | 44.5 | 0 | 153 | 1 | 1 | 51 | MCY1156862.1 hypothetical protein [Nitrososphaera sp.] | diamond | 153 | 98.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 30684767 | 30684767 | PRJNA758088_P_NODE_316933_length_247_cov_0.885057_g309962_i0 | PRJNA758088 | 316933 | 247 | 0.885057 | 2.18609079 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 165 | 7e-47 | NR | MCJ7637739.1 | 2169593 | g309962 | i0 | 98.8 | 5.90283400809717 | 81 | 1 | 98.4 | 0 | 3 | 245 | 380 | 460 | MCJ7637739.1 VWA domain-containing protein [Nitrososphaeraceae archaeon] | diamond | 1458 | 165 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 31601775 | 31601775 | PRJNA758088_P_NODE_86156_length_455_cov_1.206806_g79187_i0 | PRJNA758088 | 86156 | 455 | 1.206806 | 5.4909673 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 47.8 | 0.005 | NR | HKO41141.1 | 2169593 | g79187 | i0 | 28.6 | 0.646153846153846 | 98 | 64 | 64.6 | 2 | 81 | 374 | 231 | 322 | HKO41141.1 M28 family metallopeptidase [Nitrososphaeraceae archaeon] | diamond | 294 | 47.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 31854554 | 31854554 | PRJNA758088_P_NODE_221837_length_286_cov_1.187793_g214866_i0 | PRJNA758088 | 221837 | 286 | 1.187793 | 3.39708798 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 132 | 1.7399999999999997e-35 | NR | MCY1154899.1 | 1971748 | g214866 | i0 | 97 | 1.40559440559441 | 67 | 2 | 70.3 | 0 | 86 | 286 | 1 | 67 | MCY1154899.1 nadA [Nitrososphaera sp.] | diamond | 402 | 132 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 32361127 | 32361127 | PRJNA758088_P_NODE_186879_length_311_cov_0.970588_g179908_i0 | PRJNA758088 | 186879 | 311 | 0.970588 | 3.01852868 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 72.8 | 2.23e-12 | NR | MDW3615091.1 | 2169593 | g179908 | i0 | 35.6 | 3.02893890675241 | 104 | 66 | 99.4 | 1 | 3 | 311 | 284 | 387 | MDW3615091.1 reverse transcriptase family protein [Nitrososphaeraceae archaeon] | diamond | 942 | 72.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 32623427 | 32623427 | PRJNA758088_P_NODE_361520_length_241_cov_0.916667_g354549_i0 | PRJNA758088 | 361520 | 241 | 0.916667 | 2.20916747 | Thermoproteati | 1783275 | Archaea | Archaea | 121 | 3.38e-30 | NR | HJU33531.1 | 1971748 | g354549 | i0 | 86.8 | 4.23236514522822 | 68 | 9 | 84.6 | 0 | 239 | 36 | 432 | 499 | HJU33531.1 tRNA guanosine(15) transglycosylase TgtA [Nitrososphaera sp.] | diamond | 1020 | 121 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera 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);;