contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA946307" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2535689 | 2535689 | PRJNA946307_P_NODE_131542_length_170_cov_1.611570_g130668_i0 | PRJNA946307 | 131542 | 170 | 1.61157 | 2.739669 | Pyrobaculum | 2276 | Archaea | Archaea | 287 | 3.58e-73 | NTclustered | gi|18308975|gb|AE009441.1| | 178306 | g130668 | i0 | 99.367 | 92.9705882352941 | 158 | 1 | 93 | 0 | 13 | 170 | 1091392 | 1091549 | Pyrobaculum aerophilum str. IM2, complete genome | blastn | 15805 | 287 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum aerophilum | ||
| 2536245 | 2536245 | PRJNA946307_P_NODE_3702_length_760_cov_7.447257_g3111_i0 | PRJNA946307 | 3702 | 760 | 7.447257 | 56.5991532 | root | 1 | Root_unresolved | Root_unresolved | 675 | 0 | NTclustered | gi|584613410|emb|HG931446.1| | 29281 | g3111 | i0 | 98.433 | 88.5526315789474 | 383 | 6 | 59 | 0 | 5 | 387 | 535 | 153 | Uncultured crenarchaeote partial 16S rRNA gene, clone 2H6_S51 | blastn | 67300 | 680 | 0.992647058823529 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 3476847 | 3476847 | PRJNA946307_P_NODE_135583_length_168_cov_5.815126_g134709_i0 | PRJNA946307 | 135583 | 168 | 5.815126 | 9.76941168 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 143 | 8.139999999999998e-30 | NTclustered | gi|146262968|gb|EF414271.1| | 29281 | g134709 | i0 | 87.023 | 118.303571428571 | 131 | 12 | 77 | 5 | 4 | 133 | 688 | 562 | Uncultured crenarchaeote clone BS80e2H5 putative amoA protein-like (amoA) mRNA, partial sequence | blastn | 19875 | 143 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 8912639 | 8912639 | PRJNA946307_P_NODE_118447_length_176_cov_1.480315_g117573_i0 | PRJNA946307 | 118447 | 176 | 1.480315 | 2.6053544 | Thermoproteaceae | 2267 | Archaea | Archaea | 300 | 4.8e-77 | NTclustered | gi|148532178|gb|AY538162.2| | 2271 | g117573 | i0 | 99.394 | 93.6306818181818 | 165 | 1 | 94 | 0 | 1 | 165 | 1309 | 1145 | Thermoproteus tenax strain YS44 16S ribosomal RNA gene, partial sequence | blastn | 16479 | 300 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Thermoproteus | Thermoproteus tenax | ||
| 13680144 | 13680144 | PRJNA946307_P_NODE_153891_length_164_cov_0.886957_g153017_i0 | PRJNA946307 | 153891 | 164 | 0.886957 | 1.45460948 | Pyrobaculum aerophilum | 13773 | Archaea | Archaea | 263 | 5.809999999999999e-66 | NTclustered | gi|18308975|gb|AE009441.1| | 178306 | g153017 | i0 | 98.026 | 0.926829268292683 | 152 | 2 | 92 | 1 | 1 | 151 | 1279701 | 1279550 | Pyrobaculum aerophilum str. IM2, complete genome | blastn | 152 | 263 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum aerophilum | ||
| 15288428 | 15288428 | PRJNA946307_P_NODE_31652_length_232_cov_2.792350_g30778_i0 | PRJNA946307 | 31652 | 232 | 2.79235 | 6.478252 | Archaea | 2157 | Archaea | Archaea | 374 | 3.9e-99 | NTclustered | gi|18996831|gb|AF473887.1| | 29281 | g30778 | i0 | 96.903 | 99.073275862069 | 226 | 1 | 95 | 1 | 1 | 220 | 368 | 143 | Uncultured crenarchaeote r-5_08K 16S ribosomal RNA gene, partial sequence | blastn | 22985 | 374 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 22603277 | 22603277 | PRJNA946307_P_NODE_139778_length_167_cov_1.728814_g138904_i0 | PRJNA946307 | 139778 | 167 | 1.728814 | 2.88711938 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 285 | 1.27e-72 | NTclustered | gi|22797874|emb|AJ496176.1| | 29281 | g138904 | i0 | 100 | 15.1377245508982 | 154 | 0 | 92 | 0 | 14 | 167 | 7551 | 7704 | Uncultured crenarchaeote 34 kb genomic fragment | blastn | 2528 | 285 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 25152689 | 25152689 | PRJNA946307_P_NODE_16200_length_320_cov_3.313653_g15329_i0 | PRJNA946307 | 16200 | 320 | 3.313653 | 10.6036896 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 316 | 9.64e-82 | NTclustered | gi|42557759|emb|AJ627422.1| | 29281 | g15329 | i0 | 85.621 | 38.7125 | 306 | 39 | 96 | 5 | 3 | 308 | 40722 | 40422 | Uncultured crenarchaeote genomic fragment 54d9 | blastn | 12388 | 316 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 25152718 | 25152718 | PRJNA946307_P_NODE_16440_length_317_cov_7.078358_g15569_i0 | PRJNA946307 | 16440 | 317 | 7.078358 | 22.43839486 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 259 | 1.63e-64 | NTclustered | gi|42557759|emb|AJ627422.1| | 29281 | g15569 | i0 | 91.489 | 47.7507886435331 | 188 | 16 | 59 | 0 | 116 | 303 | 41690 | 41503 | Uncultured crenarchaeote genomic fragment 54d9 | blastn | 15137 | 259 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote |
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);;