contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA799842" and tax_phylum = "Candidatus Bathyarchaeota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2071845 | 2071845 | PRJNA799842_P_NODE_97702_length_294_cov_1.199095_g96129_i0 | PRJNA799842 | 97702 | 294 | 1.199095 | 3.5253393 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 159 | 1.56e-34 | NTclustered | gi|2874253637|emb|OY968763.1| | 2026714 | g96129 | i0 | 77.174 | 0.938775510204082 | 276 | 61 | 94 | 2 | 1 | 275 | 942839 | 942565 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD01299.bin.2.105 genome assembly, chromosome: 1 | blastn | 276 | 159 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 3344417 | 3344417 | PRJNA799842_P_NODE_136183_length_251_cov_0.865169_g134610_i0 | PRJNA799842 | 136183 | 251 | 0.865169 | 2.17157419 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 60.2 | 1.36e-4 | NTclustered | gi|2874253955|emb|OY970280.1| | 2026714 | g134610 | i0 | 85.714 | 0.223107569721116 | 56 | 8 | 22 | 0 | 191 | 246 | 1721998 | 1722053 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD03726.bin.1.102 genome assembly, chromosome: 1 | blastn | 56 | 60.2 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 3344432 | 3344432 | PRJNA799842_P_NODE_137003_length_251_cov_0.865169_g135430_i0 | PRJNA799842 | 137003 | 251 | 0.865169 | 2.17157419 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 220 | 5.89e-53 | NTclustered | gi|2874253764|emb|OY969706.1| | 2026714 | g135430 | i0 | 82.54 | 1.00398406374502 | 252 | 42 | 100 | 2 | 1 | 251 | 2370338 | 2370588 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD02416.bin.c.15 genome assembly, chromosome: 1 | blastn | 252 | 220 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 3344854 | 3344854 | PRJNA799842_P_NODE_160943_length_246_cov_0.890173_g159370_i0 | PRJNA799842 | 160943 | 246 | 0.890173 | 2.18982558 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 135 | 2.14e-27 | NTclustered | gi|2874253955|emb|OY970280.1| | 2026714 | g159370 | i0 | 86.4 | 1.73577235772358 | 125 | 16 | 51 | 1 | 120 | 244 | 1260955 | 1261078 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD03726.bin.1.102 genome assembly, chromosome: 1 | blastn | 427 | 135 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 3345098 | 3345098 | PRJNA799842_P_NODE_173603_length_244_cov_0.900585_g172030_i0 | PRJNA799842 | 173603 | 244 | 0.900585 | 2.1974274 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 167 | 7.529999999999998e-37 | NTclustered | gi|2874253637|emb|OY968763.1| | 2026714 | g172030 | i0 | 81.25 | 0.852459016393443 | 208 | 38 | 85 | 1 | 28 | 234 | 417505 | 417298 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD01299.bin.2.105 genome assembly, chromosome: 1 | blastn | 208 | 167 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 3345327 | 3345327 | PRJNA799842_P_NODE_186603_length_241_cov_0.916667_g185030_i0 | PRJNA799842 | 186603 | 241 | 0.916667 | 2.20916747 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 150 | 7.48e-32 | NTclustered | gi|2874253637|emb|OY968763.1| | 2026714 | g185030 | i0 | 78.481 | 0.983402489626556 | 237 | 46 | 97 | 5 | 3 | 236 | 838391 | 838625 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD01299.bin.2.105 genome assembly, chromosome: 1 | blastn | 237 | 150 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 4621941 | 4621941 | PRJNA799842_P_NODE_146224_length_249_cov_0.875000_g144651_i0 | PRJNA799842 | 146224 | 249 | 0.875 | 2.17875 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 252 | 2.07e-62 | NTclustered | gi|2874253637|emb|OY968763.1| | 2026714 | g144651 | i0 | 85.259 | 1.00803212851406 | 251 | 30 | 99 | 5 | 4 | 249 | 779618 | 779866 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD01299.bin.2.105 genome assembly, chromosome: 1 | blastn | 251 | 252 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 5897141 | 5897141 | PRJNA799842_P_NODE_145145_length_249_cov_0.875000_g143572_i0 | PRJNA799842 | 145145 | 249 | 0.875 | 2.17875 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 191 | 4.58e-44 | NTclustered | gi|2874254015|emb|OY970340.1| | 2026714 | g143572 | i0 | 83.568 | 0.855421686746988 | 213 | 26 | 82 | 6 | 1 | 204 | 986844 | 986632 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD04492.bin.c.5 genome assembly, chromosome: 1 | blastn | 213 | 191 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 8446999 | 8446999 | PRJNA799842_P_NODE_167447_length_245_cov_0.895349_g165874_i0 | PRJNA799842 | 167447 | 245 | 0.895349 | 2.19360505 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 200 | 7.46e-47 | NTclustered | gi|2874253718|emb|OY969560.1| | 2026714 | g165874 | i0 | 81.857 | 1.93469387755102 | 237 | 43 | 97 | 0 | 9 | 245 | 43634 | 43398 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD01872.bin.2.150 genome assembly, chromosome: 1 | blastn | 474 | 200 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 8447105 | 8447105 | PRJNA799842_P_NODE_173787_length_244_cov_0.900585_g172214_i0 | PRJNA799842 | 173787 | 244 | 0.900585 | 2.1974274 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 78.7 | 3.63e-10 | NTclustered | gi|2108177613|gb|CP070714.1| | 2026714 | g172214 | i0 | 79.13 | 0.471311475409836 | 115 | 22 | 47 | 2 | 26 | 139 | 804893 | 805006 | MAG: Candidatus Bathyarchaeota archaeon isolate bin490 chromosome | blastn | 115 | 78.7 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 10996959 | 10996959 | PRJNA799842_P_NODE_117029_length_271_cov_1.166667_g115456_i0 | PRJNA799842 | 117029 | 271 | 1.166667 | 3.16166757 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 200 | 8.39e-47 | NTclustered | gi|2874253764|emb|OY969706.1| | 2026714 | g115456 | i0 | 82.083 | 3.68634686346863 | 240 | 37 | 87 | 6 | 1 | 237 | 2619136 | 2618900 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD02416.bin.c.15 genome assembly, chromosome: 1 | blastn | 999 | 200 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 22472691 | 22472691 | PRJNA799842_P_NODE_74458_length_333_cov_0.861538_g72885_i0 | PRJNA799842 | 74458 | 333 | 0.861538 | 2.86892154 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 228 | 4.8599999999999986e-55 | NTclustered | gi|2874253637|emb|OY968763.1| | 2026714 | g72885 | i0 | 78.979 | 1 | 333 | 70 | 100 | 0 | 1 | 333 | 335856 | 335524 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD01299.bin.2.105 genome assembly, chromosome: 1 | blastn | 333 | 228 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 25020557 | 25020557 | PRJNA799842_P_NODE_172100_length_244_cov_0.900585_g170527_i0 | PRJNA799842 | 172100 | 244 | 0.900585 | 2.1974274 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 333 | 7.019999999999999e-87 | NTclustered | gi|2874253764|emb|OY969706.1| | 2026714 | g170527 | i0 | 91.701 | 2.99180327868852 | 241 | 19 | 98 | 1 | 2 | 241 | 675103 | 674863 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD02416.bin.c.15 genome assembly, chromosome: 1 | blastn | 730 | 333 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota 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);;