contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA611476" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 589946 | 589946 | PRJNA611476_P_NODE_76561_length_254_cov_1.243094_g75770_i0 | PRJNA611476 | 76561 | 254 | 1.243094 | 3.15745876 | Halobaculum marinum | 3031996 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|2463608140|gb|CP119989.1| | 3031996 | g75770 | i0 | 100 | 0.110236220472441 | 28 | 0 | 11 | 0 | 145 | 172 | 1958609 | 1958636 | Halobaculum marinum strain DT55 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum marinum | |
| 6967636 | 6967636 | PRJNA611476_P_NODE_28266_length_385_cov_1.233974_g27475_i0 | PRJNA611476 | 28266 | 385 | 1.233974 | 4.7507999 | Haloarcula litorea | 3032579 | Archaea | Archaea | 54.7 | 0.01 | NTclustered | gi|2463595526|gb|CP119779.1| | 3032579 | g27475 | i0 | 100 | 0.0753246753246753 | 29 | 0 | 8 | 0 | 37 | 65 | 2316680 | 2316708 | Haloarcula litorea strain GDY20 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula litorea | |
| 8242293 | 8242293 | PRJNA611476_P_NODE_21527_length_431_cov_1.290503_g20736_i0 | PRJNA611476 | 21527 | 431 | 1.290503 | 5.56206793 | Haladaptatus salinisoli | 2884876 | Archaea | Archaea | 54.7 | 0.012 | NTclustered | gi|2124061132|gb|CP085327.1| | 2884876 | g20736 | i0 | 100 | 0.327146171693735 | 29 | 0 | 7 | 0 | 72 | 100 | 2813507 | 2813479 | Haladaptatus salinisoli strain PSR8 chromosome, complete genome | blastn | 141 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus salinisoli | |
| 9517946 | 9517946 | PRJNA611476_P_NODE_52748_length_301_cov_1.013158_g51957_i0 | PRJNA611476 | 52748 | 301 | 1.013158 | 3.04960558 | Halomarina litorea | 2961595 | Archaea | Archaea | 52.8 | 0.028 | NTclustered | gi|2270268913|gb|CP100449.1| | 2961595 | g51957 | i0 | 100 | 0.0930232558139535 | 28 | 0 | 9 | 0 | 127 | 154 | 197409 | 197382 | Halomarina litorea strain BCD28 plasmid unnamed1, complete sequence | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halomarina | Halomarina litorea | |
| 10794374 | 10794374 | PRJNA611476_P_NODE_90749_length_248_cov_0.880000_g89958_i0 | PRJNA611476 | 90749 | 248 | 0.88 | 2.1824 | Vulcanisaeta souniana | 164452 | Archaea | Archaea | 58.4 | 4.82e-4 | NTclustered | gi|2314964910|dbj|AP026830.1| | 1293586 | g89958 | i0 | 97.059 | 0.282258064516129 | 34 | 1 | 14 | 0 | 118 | 151 | 1565066 | 1565033 | Vulcanisaeta souniana JCM 11219 DNA, complete genome | blastn | 70 | 58.4 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Vulcanisaeta | Vulcanisaeta souniana | ||
| 13344204 | 13344204 | PRJNA611476_P_NODE_88051_length_249_cov_0.875000_g87260_i0 | PRJNA611476 | 88051 | 249 | 0.875 | 2.17875 | uncultured marine thaumarchaeote AD1000_100_C06 | 1455887 | Archaea | Archaea | 455 | 1.47e-123 | NTclustered | gi|663500052|gb|KF900324.1| | 1455887 | g87260 | i0 | 99.598 | 1 | 249 | 1 | 100 | 0 | 1 | 249 | 29942 | 29694 | Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence | blastn | 249 | 455 | 1 | Archaea | Thermoproteati | Nitrososphaerota | uncultured marine thaumarchaeote AD1000_100_C06 | ||||||
| 14618345 | 14618345 | PRJNA611476_P_NODE_35012_length_354_cov_1.565836_g34221_i0 | PRJNA611476 | 35012 | 354 | 1.565836 | 5.54305944 | Halobaculum sp. CBA1158 | 2904243 | Archaea | Archaea | 58.4 | 7.2e-4 | NTclustered | gi|2176093559|gb|CP090371.1| | 2904243 | g34221 | i0 | 97.059 | 0.096045197740113 | 34 | 1 | 10 | 0 | 78 | 111 | 667977 | 667944 | Halobaculum sp. CBA1158 chromosome, complete genome | blastn | 34 | 58.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum sp. CBA1158 | |
| 14618801 | 14618801 | PRJNA611476_P_NODE_69712_length_267_cov_1.304124_g68921_i0 | PRJNA611476 | 69712 | 267 | 1.304124 | 3.48201108 | Natronosalvus caseinilyticus | 2953747 | Archaea | Archaea | 52.8 | 0.024 | NTclustered | gi|2006550273|gb|CP071596.1| | 2953747 | g68921 | i0 | 100 | 0.104868913857678 | 28 | 0 | 10 | 0 | 67 | 94 | 140828 | 140801 | Natronosalvus caseinilyticus strain KZCA101 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronosalvus | Natronosalvus caseinilyticus | |
| 15892906 | 15892906 | PRJNA611476_P_NODE_75733_length_255_cov_1.692308_g74942_i0 | PRJNA611476 | 75733 | 255 | 1.692308 | 4.3153854 | Haloglomus salinum | 2962673 | Archaea | Archaea | 58.4 | 4.98e-4 | NTclustered | gi|2273560668|gb|CP101153.1| | 2962673 | g74942 | i0 | 97.059 | 0.133333333333333 | 34 | 1 | 13 | 0 | 135 | 168 | 941651 | 941618 | Haloglomus salinum strain ZY58 chromosome, complete genome | blastn | 34 | 58.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Haloglomus | Haloglomus salinum | |
| 17167169 | 17167169 | PRJNA611476_P_NODE_31454_length_369_cov_1.253378_g30663_i0 | PRJNA611476 | 31454 | 369 | 1.253378 | 4.62496482 | Salinirubellus litoreus | 3131999 | Archaea | Archaea | 71.3 | 9.68e-8 | NTclustered | gi|2700494409|gb|CP147841.1| | 3131999 | g30663 | i0 | 87.097 | 0.569105691056911 | 62 | 8 | 17 | 0 | 198 | 259 | 2706259 | 2706320 | Salinirubellus litoreus strain SYNS196 chromosome, complete genome | blastn | 210 | 71.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Salinirubellus | Salinirubellus litoreus | |
| 18999204 | 18999204 | PRJNA611476_P_NODE_26535_length_395_cov_0.760870_g25744_i0 | PRJNA611476 | 26535 | 395 | 0.76087 | 3.0054365 | Halorubrum | 56688 | Archaea | Archaea | 52.8 | 0.038 | NTclustered | gi|1041620700|dbj|AP017569.1| | 29284 | g25744 | i0 | 96.774 | 0.306329113924051 | 31 | 1 | 8 | 0 | 213 | 243 | 482810 | 482780 | Halorubrum trapanicum DNA, complete genome, strain: CBA1232 | blastn | 121 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum trapanicum | |
| 20274287 | 20274287 | PRJNA611476_P_NODE_34036_length_358_cov_1.350877_g33245_i0 | PRJNA611476 | 34036 | 358 | 1.350877 | 4.83613966 | Haloferax | 2251 | Archaea | Archaea | 54.7 | 0.009 | NTclustered | gi|2890410411|gb|CP177203.1| | 3388425 | g33245 | i0 | 87.755 | 0.273743016759777 | 49 | 2 | 13 | 3 | 95 | 141 | 806337 | 806383 | Haloferax sp. YSMS24 chromosome, complete genome | blastn | 98 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax sp. YSMS24 | |
| 25374417 | 25374417 | PRJNA611476_P_NODE_62160_length_281_cov_1.379808_g61369_i0 | PRJNA611476 | 62160 | 281 | 1.379808 | 3.87726048 | root | 1 | Root_unresolved | Root_unresolved | 58.4 | 5.57e-4 | NTclustered | gi|1804090075|gb|CP048032.1| | 1071085 | g61369 | i0 | 100 | 2.61565836298932 | 31 | 0 | 11 | 0 | 251 | 281 | 1277061 | 1277031 | Haloarchaeon 3A1-DGR strain 3A1-DGR chromosome, complete genome | blastn | 735 | 58.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | haloarchaeon 3A1-DGR |
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);;