contig_metadata
6 rows where bioproject = "PRJNA890871" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7243372 | 7243372 | PRJNA890871_P_NODE_81606_length_243_cov_0.905882_g81471_i0 | PRJNA890871 | 81606 | 243 | 0.905882 | 2.20129326 | Candidatus Nitrosotenuis cloacae | 1603555 | Archaea | Archaea | 333 | 6.989999999999999e-87 | NTclustered | gi|808354332|gb|CP011097.2| | 1603555 | g81471 | i0 | 91.358 | 1 | 243 | 21 | 100 | 0 | 1 | 243 | 873114 | 873356 | Candidatus Nitrosotenuis cloacae strain SAT1, complete genome | blastn | 243 | 333 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis cloacae | |||||
| 12344192 | 12344192 | PRJNA890871_P_NODE_75010_length_246_cov_0.890173_g74875_i0 | PRJNA890871 | 75010 | 246 | 0.890173 | 2.18982558 | Pyrobaculum aerophilum | 13773 | Archaea | Archaea | 455 | 1.4500000000000002e-123 | NTclustered | gi|18308975|gb|AE009441.1| | 178306 | g74875 | i0 | 100 | 1 | 246 | 0 | 100 | 0 | 1 | 246 | 929505 | 929260 | Pyrobaculum aerophilum str. IM2, complete genome | blastn | 246 | 455 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum aerophilum | ||
| 23816635 | 23816635 | PRJNA890871_P_NODE_40599_length_281_cov_1.480769_g40464_i0 | PRJNA890871 | 40599 | 281 | 1.480769 | 4.16096089 | Pyrobaculum aerophilum | 13773 | Archaea | Archaea | 520 | 5.909999999999999e-143 | NTclustered | gi|18308975|gb|AE009441.1| | 178306 | g40464 | i0 | 100 | 75.5658362989324 | 281 | 0 | 100 | 0 | 1 | 281 | 1094990 | 1094710 | Pyrobaculum aerophilum str. IM2, complete genome | blastn | 21234 | 520 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum aerophilum | ||
| 28358082 | 28358082 | PRJNA890871_P_NODE_47786_length_270_cov_0.832487_g47651_i0 | PRJNA890871 | 47786 | 270 | 0.832487 | 2.2477149 | root | 1 | Root_unresolved | Root_unresolved | 112 | 2.29e-28 | NR | MDX1532620.1 | 2202732 | g47651 | i0 | 53.4 | 2.94444444444444 | 88 | 41 | 97.8 | 0 | 2 | 265 | 64 | 151 | MDX1532620.1 tRNA(His) guanylyltransferase Thg1 family protein [Nitrosopumilaceae archaeon] | diamond | 795 | 113 | 0.991150442477876 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 29494907 | 29494907 | PRJNA890871_P_NODE_37130_length_287_cov_4.242991_g36995_i0 | PRJNA890871 | 37130 | 287 | 4.242991 | 12.17738417 | Stenosarchaea group | 2290931 | Archaea | Archaea | 45.4 | 9.91e-4 | NR | MEK0338457.1 | 2024843 | g36995 | i0 | 55.6 | 0.752613240418119 | 36 | 16 | 37.6 | 0 | 12 | 119 | 38 | 73 | MEK0338457.1 hypothetical protein [Nitrosopumilus sp.] | diamond | 216 | 45.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 31864817 | 31864817 | PRJNA890871_P_NODE_84737_length_241_cov_2.494048_g84602_i0 | PRJNA890871 | 84737 | 241 | 2.494048 | 6.01065568 | root | 1 | Root_unresolved | Root_unresolved | 88.6 | 5.63e-19 | NR | MFI5405737.1 | 2268197 | g84602 | i0 | 75.9 | 2.29045643153527 | 54 | 13 | 67.2 | 0 | 37 | 198 | 237 | 290 | MFI5405737.1 7-carboxy-7-deazaguanine synthase QueE [Nitrososphaerales archaeon] | diamond | 552 | 88.6 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales 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);;