contig_metadata
5 rows where bioproject = "PRJNA914897", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4723404 | 4723404 | PRJNA914897_P_NODE_26324_length_316_cov_0.950617_g25900_i0 | PRJNA914897 | 26324 | 316 | 0.950617 | 3.00394972 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 518 | 2.4299999999999998e-142 | NTclustered | gi|22797874|emb|AJ496176.1| | 29281 | g25900 | i0 | 96.203 | 30.8860759493671 | 316 | 12 | 100 | 0 | 1 | 316 | 6600 | 6915 | Uncultured crenarchaeote 34 kb genomic fragment | blastn | 9760 | 518 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 7629094 | 7629094 | PRJNA914897_P_NODE_37926_length_249_cov_0.875000_g37502_i0 | PRJNA914897 | 37926 | 249 | 0.875 | 2.17875 | Archaea | 2157 | Archaea | Archaea | 460 | 3.16e-125 | NTclustered | gi|225382324|gb|FJ790595.1| | 29281 | g37502 | i0 | 100 | 100.004016064257 | 249 | 0 | 100 | 0 | 1 | 249 | 892 | 1140 | Uncultured crenarchaeote clone QA38 16S ribosomal RNA gene, partial sequence | blastn | 24901 | 460 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 28130111 | 28130111 | PRJNA914897_P_NODE_1085_length_1624_cov_4.018698_g963_i0 | PRJNA914897 | 1085 | 1624 | 4.018698 | 65.26365552 | Vulcanisaeta sp. | 2020871 | Archaea | Archaea | 241 | 1.1999999999999998e-69 | NR | MFP3236626.1 | 2020871 | g963 | i0 | 34.4 | 0.777709359605911 | 421 | 265 | 77 | 7 | 278 | 1528 | 16 | 429 | MFP3236626.1 aspartate aminotransferase family protein [Vulcanisaeta sp.] | diamond | 1263 | 241 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Vulcanisaeta | Vulcanisaeta sp. | ||
| 28540707 | 28540707 | PRJNA914897_P_NODE_3227_length_1101_cov_3.748054_g2967_i0 | PRJNA914897 | 3227 | 1101 | 3.748054 | 41.26607454 | Desulfurococcaceae archaeon | 2184738 | Archaea | Archaea | 188 | 8.78e-52 | NR | MEM1627864.1 | 2184738 | g2967 | i0 | 36.3 | 4.27792915531335 | 314 | 178 | 84.5 | 9 | 987 | 58 | 134 | 429 | MEM1627864.1 translation elongation factor EF-1 subunit alpha [Desulfurococcaceae archaeon] | diamond | 4710 | 188 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcaceae | Desulfurococcaceae archaeon | |||
| 32585661 | 32585661 | PRJNA914897_P_NODE_35799_length_255_cov_0.945055_g35375_i0 | PRJNA914897 | 35799 | 255 | 0.945055 | 2.40989025 | Ignisphaera sp. | 2268142 | Archaea | Archaea | 43.5 | 0.0224 | NR | MEM4010254.1 | 2268142 | g35375 | i0 | 37 | 0.858823529411765 | 73 | 40 | 80 | 2 | 250 | 47 | 284 | 355 | MEM4010254.1 beta-galactosidase BgaS [Ignisphaera sp.] | diamond | 219 | 43.5 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcaceae | Ignisphaera | Ignisphaera 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);;