contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA630162" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 601553 | 601553 | PRJNA630162_P_NODE_125661_length_171_cov_2.762295_g124138_i0 | PRJNA630162 | 125661 | 171 | 2.762295 | 4.72352445 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 217 | 4.8e-52 | NTclustered | gi|42557759|emb|AJ627422.1| | 29281 | g124138 | i0 | 90.361 | 49.0701754385965 | 166 | 15 | 97 | 1 | 6 | 171 | 40365 | 40529 | Uncultured crenarchaeote genomic fragment 54d9 | blastn | 8391 | 217 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 1151317 | 1151317 | PRJNA630162_P_NODE_168841_length_155_cov_3.273585_g167318_i0 | PRJNA630162 | 168841 | 155 | 3.273585 | 5.07405675 | root | 1 | Root_unresolved | Root_unresolved | 255 | 9.05e-64 | NTclustered | gi|325984311|gb|JF262208.1| | 29281 | g167318 | i0 | 97.351 | 97.4193548387097 | 151 | 2 | 96 | 1 | 6 | 154 | 474 | 624 | Uncultured crenarchaeote clone YLA006 16S ribosomal RNA gene, partial sequence | blastn | 15100 | 255 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 1878230 | 1878230 | PRJNA630162_P_NODE_24122_length_373_cov_2.876543_g22603_i0 | PRJNA630162 | 24122 | 373 | 2.876543 | 10.72950539 | Ignicoccus pacificus | 114376 | Archaea | Archaea | 58.4 | 7.63e-4 | NTclustered | gi|2306405303|gb|CP006868.1| | 940294 | g22603 | i0 | 97.059 | 0.246648793565684 | 34 | 1 | 9 | 0 | 183 | 216 | 1509699 | 1509732 | Ignicoccus pacificus DSM 13166, complete genome | blastn | 92 | 58.4 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcaceae | Ignicoccus | Ignicoccus pacificus | ||
| 2426424 | 2426424 | PRJNA630162_P_NODE_133622_length_168_cov_2.563025_g132099_i0 | PRJNA630162 | 133622 | 168 | 2.563025 | 4.305882 | root | 1 | Root_unresolved | Root_unresolved | 63.9 | 6.52e-6 | NTclustered | gi|1405346|dbj|D85508.1|DMY790 | 43687 | g132099 | i0 | 93.182 | 5.25595238095238 | 44 | 2 | 26 | 1 | 34 | 76 | 2557 | 2514 | Metallosphaera sedula gene for 16S rRNA, complete sequence | blastn | 883 | 63.9 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Metallosphaera | Metallosphaera sedula | ||
| 7528967 | 7528967 | PRJNA630162_P_NODE_117906_length_175_cov_2.690476_g116383_i0 | PRJNA630162 | 117906 | 175 | 2.690476 | 4.708333 | Metallosphaera | 41980 | Archaea | Archaea | 73.1 | 1.13e-8 | NTclustered | gi|1405346|dbj|D85508.1|DMY790 | 43687 | g116383 | i0 | 97.674 | 3.68571428571429 | 43 | 0 | 25 | 1 | 84 | 126 | 2515 | 2556 | Metallosphaera sedula gene for 16S rRNA, complete sequence | blastn | 645 | 73.1 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Metallosphaera | Metallosphaera sedula | ||
| 8804155 | 8804155 | PRJNA630162_P_NODE_14247_length_501_cov_2.073009_g12763_i0 | PRJNA630162 | 14247 | 501 | 2.073009 | 10.38577509 | Archaea | 2157 | Archaea | Archaea | 909 | 0 | NTclustered | gi|73762188|gb|DQ159085.1| | 29281 | g12763 | i0 | 100 | 99.9041916167665 | 492 | 0 | 98 | 0 | 2 | 493 | 492 | 1 | Uncultured crenarchaeote clone DK-soil-51 16S ribosomal RNA gene, partial sequence | blastn | 50052 | 913 | 0.995618838992333 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 8804229 | 8804229 | PRJNA630162_P_NODE_166387_length_158_cov_2.082569_g164864_i0 | PRJNA630162 | 166387 | 158 | 2.082569 | 3.29045902 | Thermoproteati | 1783275 | Archaea | Archaea | 279 | 5.500000000000001e-71 | NTclustered | gi|42406200|gb|AY522891.1| | 29281 | g164864 | i0 | 98.734 | 103 | 158 | 0 | 99 | 2 | 2 | 158 | 1315 | 1159 | Uncultured crenarchaeote clone MBS4 16S ribosomal RNA gene, partial sequence | blastn | 16274 | 279 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 9530941 | 9530941 | PRJNA630162_P_NODE_54888_length_238_cov_1.417989_g53365_i0 | PRJNA630162 | 54888 | 238 | 1.417989 | 3.37481382 | Infirmifilum sp. NZ | 2926850 | Archaea | Archaea | 71.3 | 5.9e-8 | NTclustered | gi|2211485873|gb|CP094288.1| | 2926850 | g53365 | i0 | 89.286 | 10.4117647058824 | 56 | 6 | 24 | 0 | 97 | 152 | 912305 | 912250 | Infirmifilum sp. NZ chromosome | blastn | 2478 | 71.3 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermofilales | Thermofilaceae | Infirmifilum | Infirmifilum sp. NZ | ||
| 11354641 | 11354641 | PRJNA630162_P_NODE_149669_length_164_cov_2.800000_g148146_i0 | PRJNA630162 | 149669 | 164 | 2.8 | 4.592 | Thermoproteati | 1783275 | Archaea | Archaea | 294 | 2.06e-75 | NTclustered | gi|194499563|gb|EU856141.1| | 29281 | g148146 | i0 | 100 | 96.9512195121951 | 159 | 0 | 97 | 0 | 6 | 164 | 43 | 201 | Uncultured crenarchaeote clone CS16S_30_4.9 16S ribosomal RNA gene, partial sequence | blastn | 15900 | 294 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 11354857 | 11354857 | PRJNA630162_P_NODE_44689_length_265_cov_1.310185_g43166_i0 | PRJNA630162 | 44689 | 265 | 1.310185 | 3.47199025 | Thermoproteati | 1783275 | Archaea | Archaea | 401 | 2.0899999999999994e-107 | NTclustered | gi|22797874|emb|AJ496176.1| | 29281 | g43166 | i0 | 97.071 | 91.6301886792453 | 239 | 6 | 90 | 1 | 3 | 241 | 8199 | 8436 | Uncultured crenarchaeote 34 kb genomic fragment | blastn | 24282 | 401 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 15180037 | 15180037 | PRJNA630162_P_NODE_85652_length_195_cov_2.849315_g84129_i0 | PRJNA630162 | 85652 | 195 | 2.849315 | 5.55616425 | Archaea | 2157 | Archaea | Archaea | 158 | 3.47e-34 | NTclustered | gi|42557759|emb|AJ627422.1| | 29281 | g84129 | i0 | 92.727 | 14.7435897435897 | 110 | 6 | 55 | 2 | 1 | 108 | 42306 | 42197 | Uncultured crenarchaeote genomic fragment 54d9 | blastn | 2875 | 158 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 19003116 | 19003116 | PRJNA630162_P_NODE_95615_length_188_cov_1.942446_g94092_i0 | PRJNA630162 | 95615 | 188 | 1.942446 | 3.65179848 | Archaea | 2157 | Archaea | Archaea | 305 | 1.12e-78 | NTclustered | gi|197253373|gb|EU910618.1| | 29281 | g94092 | i0 | 96.721 | 97.6702127659574 | 183 | 6 | 97 | 0 | 3 | 185 | 398 | 216 | Uncultured crenarchaeote clone G34 16S small subunit ribosomal RNA gene, partial sequence | blastn | 18362 | 305 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 23553947 | 23553947 | PRJNA630162_P_NODE_106219_length_182_cov_1.278195_g104696_i0 | PRJNA630162 | 106219 | 182 | 1.278195 | 2.3263149 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 316 | 4.97e-82 | NTclustered | gi|156106295|gb|EU098051.1| | 29281 | g104696 | i0 | 98.87 | 97.2527472527473 | 177 | 2 | 97 | 0 | 6 | 182 | 182 | 358 | Uncultured crenarchaeote clone Gua2_05 16S ribosomal RNA gene, partial sequence | blastn | 17700 | 316 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 24827692 | 24827692 | PRJNA630162_P_NODE_116180_length_176_cov_2.283465_g114657_i0 | PRJNA630162 | 116180 | 176 | 2.283465 | 4.0188984 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 283 | 4.839999999999999e-72 | NTclustered | gi|42557759|emb|AJ627422.1| | 29281 | g114657 | i0 | 96.491 | 82.9829545454545 | 171 | 6 | 97 | 0 | 6 | 176 | 40365 | 40535 | Uncultured crenarchaeote genomic fragment 54d9 | blastn | 14605 | 283 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 24828648 | 24828648 | PRJNA630162_P_NODE_52180_length_244_cov_1.651282_g50657_i0 | PRJNA630162 | 52180 | 244 | 1.651282 | 4.0291280799999996 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 99 | 2.79e-16 | NTclustered | gi|42557759|emb|AJ627422.1| | 29281 | g50657 | i0 | 90.541 | 9.95491803278689 | 74 | 7 | 30 | 0 | 131 | 204 | 40477 | 40404 | Uncultured crenarchaeote genomic fragment 54d9 | blastn | 2429 | 99 | 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);;