contig_metadata
6 rows where bioproject = "PRJNA752278", tax_phylum = "Thermoproteota" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15229184 | 15229184 | PRJNA752278_P_NODE_15472_length_389_cov_0.952532_g15269_i0 | PRJNA752278 | 15472 | 389 | 0.952532 | 3.70534948 | Archaea | 2157 | Archaea | Archaea | 699 | 0 | NTclustered | gi|285310368|emb|FN650250.1| | 29281 | g15269 | i0 | 99.738 | 97.9408740359897 | 381 | 1 | 98 | 0 | 1 | 381 | 173 | 553 | Uncultured crenarchaeote partial 16S rRNA gene, clone SD2T2G59 | blastn | 38099 | 704 | 0.992897727272727 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 15229476 | 15229476 | PRJNA752278_P_NODE_43332_length_283_cov_2.395238_g43129_i0 | PRJNA752278 | 43332 | 283 | 2.395238 | 6.77852354 | Saccharolobus | 2100760 | Archaea | Archaea | 516 | 7.71e-142 | NTclustered | gi|942631|gb|U32322.1|SSU32322 | 2287 | g43129 | i0 | 99.645 | 99.5441696113074 | 282 | 1 | 99 | 0 | 2 | 283 | 1366 | 1647 | Sulfolobus solfataricus 23S rRNA gene, partial sequence | blastn | 28171 | 521 | 0.990403071017274 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Saccharolobus | Saccharolobus solfataricus | ||
| 22404817 | 22404817 | PRJNA752278_P_NODE_39578_length_287_cov_1.766355_g39375_i0 | PRJNA752278 | 39578 | 287 | 1.766355 | 5.06943885 | Acidianus manzaensis | 282676 | Archaea | Archaea | 54.7 | 0.007 | NTclustered | gi|1188286313|gb|CP020477.1| | 282676 | g39375 | i0 | 100 | 0.101045296167247 | 29 | 0 | 10 | 0 | 214 | 242 | 231103 | 231075 | Acidianus manzaensis strain YN-25 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Acidianus | Acidianus manzaensis | ||
| 27505307 | 27505307 | PRJNA752278_P_NODE_40343_length_286_cov_2.262911_g40140_i0 | PRJNA752278 | 40343 | 286 | 2.262911 | 6.47192546 | Metallosphaera | 41980 | Archaea | Archaea | 81.6 | 8.54e-17 | NR | WP_404809754.1 | 41980 | g40140 | i0 | 43.2 | 6.01048951048951 | 95 | 52 | 97.6 | 1 | 286 | 8 | 63 | 157 | WP_404809754.1 MULTISPECIES: ADP-ribose-binding protein [Metallosphaera] | diamond | 1719 | 82.4 | 0.990291262135922 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Metallosphaera | |||
| 31759488 | 31759488 | PRJNA752278_P_NODE_103737_length_241_cov_1.541667_g103534_i0 | PRJNA752278 | 103737 | 241 | 1.541667 | 3.7154174700000002 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 159 | 4.63e-44 | NR | MDQ5860364.1 | 2056631 | g103534 | i0 | 98.8 | 5.96265560165975 | 80 | 1 | 99.6 | 0 | 2 | 241 | 354 | 433 | MDQ5860364.1 acetate--CoA ligase family protein [Thermoproteota archaeon] | diamond | 1437 | 159 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 32234467 | 32234467 | PRJNA752278_P_NODE_7878_length_496_cov_2.345154_g7675_i0 | PRJNA752278 | 7878 | 496 | 2.345154 | 11.63196384 | Thermoprotei archaeon | 2250277 | Archaea | Archaea | 55.1 | 1.38e-5 | NR | RLG82655.1 | 2250277 | g7675 | i0 | 28.1 | 1.6875 | 89 | 61 | 53.2 | 2 | 487 | 224 | 145 | 231 | RLG82655.1 MAG: hypothetical protein DRO40_07150 [Thermoprotei archaeon] | diamond | 837 | 55.1 | 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);;