contig_metadata
6 rows where bioproject = "PRJNA533623" and tax_phylum = "Thermoproteota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14534712 | 14534712 | PRJNA533623_P_NODE_15272_length_603_cov_9.924354_g13567_i0 | PRJNA533623 | 15272 | 603 | 9.924354 | 59.84385462 | Pyrobaculum aerophilum | 13773 | Archaea | Archaea | 994 | 0 | NTclustered | gi|18308975|gb|AE009441.1| | 178306 | g13567 | i0 | 97.284 | 0.976782752902156 | 589 | 11 | 97 | 3 | 20 | 603 | 172624 | 172036 | Pyrobaculum aerophilum str. IM2, complete genome | blastn | 589 | 994 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum aerophilum | ||
| 14535898 | 14535898 | PRJNA533623_P_NODE_65952_length_233_cov_2.261628_g64171_i0 | PRJNA533623 | 65952 | 233 | 2.261628 | 5.26959324 | Pyrobaculum aerophilum | 13773 | Archaea | Archaea | 322 | 1.44e-83 | NTclustered | gi|18308975|gb|AE009441.1| | 178306 | g64171 | i0 | 96.41 | 0.836909871244635 | 195 | 7 | 84 | 0 | 22 | 216 | 230470 | 230664 | Pyrobaculum aerophilum str. IM2, complete genome | blastn | 195 | 322 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum aerophilum | ||
| 26888147 | 26888147 | PRJNA533623_P_NODE_42341_length_331_cov_18.240741_g40567_i0 | PRJNA533623 | 42341 | 331 | 18.240741 | 60.37685271 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 198 | 2.35e-61 | NR | MDP9305909.1 | 2056631 | g40567 | i0 | 92.9 | 0.88821752265861 | 98 | 7 | 88.8 | 0 | 22 | 315 | 29 | 126 | MDP9305909.1 AmmeMemoRadiSam system protein B [Thermoproteota archaeon] | diamond | 294 | 198 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 28025387 | 28025387 | PRJNA533623_P_NODE_56465_length_267_cov_4.762136_g54685_i0 | PRJNA533623 | 56465 | 267 | 4.762136 | 12.71490312 | Thermofilaceae archaeon | 2268203 | Archaea | Archaea | 87 | 2.8e-19 | NR | MEM2592530.1 | 2268203 | g54685 | i0 | 100 | 0.471910112359551 | 42 | 0 | 47.2 | 0 | 21 | 146 | 125 | 166 | MEM2592530.1 DUF2750 domain-containing protein [Thermofilaceae archaeon] | diamond | 126 | 87 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermofilales | Thermofilaceae | Thermofilaceae archaeon | |||
| 29004563 | 29004563 | PRJNA533623_P_NODE_38088_length_356_cov_13.484746_g36316_i0 | PRJNA533623 | 38088 | 356 | 13.484746 | 48.00569576 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 105 | 1.0099999999999999e-23 | NR | MEM3365499.1 | 2282146 | g36316 | i0 | 77.9 | 0.573033707865168 | 68 | 15 | 57.3 | 0 | 233 | 30 | 203 | 270 | MEM3365499.1 hypothetical protein [Candidatus Methanomethyliaceae archaeon] | diamond | 204 | 105 | 1 | Archaea | Thermoproteati | Thermoproteota | Methanosuratincolia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 30520083 | 30520083 | PRJNA533623_P_NODE_3113_length_1228_cov_11.529563_g2173_i0 | PRJNA533623 | 3113 | 1228 | 11.529563 | 141.58303364 | Thermoprotei archaeon | 2250277 | Archaea | Archaea | 67 | 5.16e-8 | NR | MEM3833456.1 | 2250277 | g2173 | i0 | 22.2 | 0.759771986970684 | 311 | 210 | 72.1 | 7 | 1203 | 319 | 34 | 328 | MEM3833456.1 amino acid ABC transporter substrate-binding protein [Thermoprotei archaeon] | diamond | 933 | 67 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoprotei 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);;