contig_metadata
17 rows where bioproject = "PRJNA1196384" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 322711 | 322711 | PRJNA1196384_S_NODE_4921_length_183_cov_1.239726_g4857_i0 | PRJNA1196384 | 4921 | 183 | 1.239726 | 2.26869858 | Haloferax volcanii | 2246 | Archaea | Archaea | 289 | 1.0899999999999998e-73 | NTclustered | gi|291372972|gb|CP001957.1| | 309800 | g4857 | i0 | 95.082 | 55.120218579235 | 183 | 9 | 100 | 0 | 1 | 183 | 51948 | 52130 | Haloferax volcanii DS2 plasmid pHV1, complete sequence | blastn | 10087 | 289 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 2318545 | 2318545 | PRJNA1196384_S_NODE_8542_length_150_cov_0.964602_g8478_i0 | PRJNA1196384 | 8542 | 150 | 0.964602 | 1.446903 | archaeon | 1906665 | Archaea | Archaea | 88.2 | 3.42e-20 | NR | RYG65321.1 | 1906665 | g8478 | i0 | 87.8 | 0.98 | 49 | 6 | 98 | 0 | 3 | 149 | 100 | 148 | RYG65321.1 MAG: hypothetical protein EON64_12195 [archaeon] | diamond | 147 | 88.2 | 1 | Archaea | archaeon | ||||||||
| 10526508 | 10526508 | PRJNA1196384_S_NODE_8029_length_153_cov_1.008621_g7965_i0 | PRJNA1196384 | 8029 | 153 | 1.008621 | 1.54319013 | Natrinema longum | 370324 | Archaea | Archaea | 217 | 4.2e-52 | NTclustered | gi|2006040148|gb|CP071463.1| | 370324 | g7965 | i0 | 92.157 | 7.95424836601307 | 153 | 12 | 100 | 0 | 1 | 153 | 1074094 | 1074246 | Natrinema longum strain ABH32 chromosome, complete genome | blastn | 1217 | 217 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema longum | |
| 13076373 | 13076373 | PRJNA1196384_S_NODE_8491_length_150_cov_1.353982_g8427_i0 | PRJNA1196384 | 8491 | 150 | 1.353982 | 2.030973 | archaeon | 1906665 | Archaea | Archaea | 100 | 4.63e-23 | NR | RYG69930.1 | 1906665 | g8427 | i0 | 95.8 | 0.96 | 48 | 2 | 96 | 0 | 2 | 145 | 390 | 437 | RYG69930.1 MAG: hypothetical protein EON64_01505 [archaeon] | diamond | 144 | 100 | 1 | Archaea | archaeon | ||||||||
| 21999430 | 21999430 | PRJNA1196384_S_NODE_2638_length_239_cov_1.148515_g2574_i0 | PRJNA1196384 | 2638 | 239 | 1.148515 | 2.74495085 | archaeon | 1906665 | Archaea | Archaea | 121 | 2.0899999999999996e-31 | NR | RYH05201.1 | 1906665 | g2574 | i0 | 72.5 | 1.00418410041841 | 80 | 21 | 99.2 | 1 | 237 | 1 | 62 | 141 | RYH05201.1 MAG: hypothetical protein EON65_45370 [archaeon] | diamond | 240 | 121 | 1 | Archaea | archaeon | ||||||||
| 24548851 | 24548851 | PRJNA1196384_S_NODE_7460_length_157_cov_0.975000_g7396_i0 | PRJNA1196384 | 7460 | 157 | 0.975 | 1.53075 | archaeon | 1906665 | Archaea | Archaea | 101 | 3.27e-24 | NR | RYH05201.1 | 1906665 | g7396 | i0 | 88.2 | 0.974522292993631 | 51 | 6 | 97.5 | 0 | 1 | 153 | 230 | 280 | RYH05201.1 MAG: hypothetical protein EON65_45370 [archaeon] | diamond | 153 | 101 | 1 | Archaea | archaeon | ||||||||
| 27167104 | 27167104 | PRJNA1196384_S_NODE_6582_length_164_cov_0.921260_g6518_i0 | PRJNA1196384 | 6582 | 164 | 0.92126 | 1.5108664 | Candidatus Methanofastidiosia archaeon | 2099674 | Archaea | Archaea | 95.9 | 1.53e-22 | NR | NYT12920.1 | 2099674 | g6518 | i0 | 88.2 | 5.61585365853659 | 51 | 6 | 93.3 | 0 | 162 | 10 | 169 | 219 | NYT12920.1 2,3-diphosphoglycerate-dependent phosphoglycerate mutase [Candidatus Methanofastidiosia archaeon] | diamond | 921 | 95.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Methanofastidiosia | Candidatus Methanofastidiosia archaeon | ||||
| 27988479 | 27988479 | PRJNA1196384_S_NODE_5085_length_181_cov_1.076389_g5021_i0 | PRJNA1196384 | 5085 | 181 | 1.076389 | 1.94826409 | archaeon | 1906665 | Archaea | Archaea | 79 | 3.16e-17 | NR | RYH18874.1 | 1906665 | g5021 | i0 | 63.3 | 0.994475138121547 | 60 | 20 | 99.4 | 1 | 180 | 1 | 43 | 100 | RYH18874.1 MAG: hypothetical protein EON65_26765 [archaeon] | diamond | 180 | 79 | 1 | Archaea | archaeon | ||||||||
| 28967376 | 28967376 | PRJNA1196384_S_NODE_5008_length_182_cov_1.068966_g4944_i0 | PRJNA1196384 | 5008 | 182 | 1.068966 | 1.94551812 | archaeon | 1906665 | Archaea | Archaea | 53.9 | 1.83e-6 | NR | RYG63737.1 | 1906665 | g4944 | i0 | 56.9 | 0.840659340659341 | 51 | 21 | 84.1 | 1 | 182 | 30 | 267 | 316 | RYG63737.1 MAG: hypothetical protein EON64_15325, partial [archaeon] | diamond | 153 | 53.9 | 1 | Archaea | archaeon | ||||||||
| 29188457 | 29188457 | PRJNA1196384_S_NODE_4449_length_190_cov_1.274510_g4385_i0 | PRJNA1196384 | 4449 | 190 | 1.27451 | 2.421569 | Natronomonas sp. | 2184060 | Archaea | Archaea | 50.1 | 4.66e-5 | NR | WP_310677108.1 | 2184060 | g4385 | i0 | 48 | 0.789473684210526 | 50 | 26 | 78.9 | 0 | 170 | 21 | 240 | 289 | WP_310677108.1 hypothetical protein [Natronomonas sp.] | diamond | 150 | 50.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. | |
| 29472124 | 29472124 | PRJNA1196384_S_NODE_4210_length_194_cov_1.713376_g4146_i0 | PRJNA1196384 | 4210 | 194 | 1.713376 | 3.32394944 | archaeon | 1906665 | Archaea | Archaea | 103 | 7.6e-25 | NR | RYG65161.1 | 1906665 | g4146 | i0 | 71.9 | 1.97938144329897 | 64 | 18 | 99 | 0 | 194 | 3 | 219 | 282 | RYG65161.1 MAG: hypothetical protein EON64_12505 [archaeon] | diamond | 384 | 103 | 1 | Archaea | archaeon | ||||||||
| 30072376 | 30072376 | PRJNA1196384_S_NODE_8532_length_150_cov_1.008850_g8468_i0 | PRJNA1196384 | 8532 | 150 | 1.00885 | 1.513275 | archaeon | 1906665 | Archaea | Archaea | 76.6 | 4.89e-16 | NR | RYG68310.1 | 1906665 | g8468 | i0 | 80.9 | 0.94 | 47 | 9 | 94 | 0 | 146 | 6 | 32 | 78 | RYG68310.1 MAG: hypothetical protein EON64_05455 [archaeon] | diamond | 141 | 76.6 | 1 | Archaea | archaeon | ||||||||
| 30735879 | 30735879 | PRJNA1196384_S_NODE_2114_length_268_cov_1.865801_g2050_i0 | PRJNA1196384 | 2114 | 268 | 1.865801 | 5.00034668 | archaeon | 1906665 | Archaea | Archaea | 138 | 4.68e-40 | NR | RYG63904.1 | 1906665 | g2050 | i0 | 85.7 | 0.940298507462687 | 84 | 12 | 94 | 0 | 266 | 15 | 43 | 126 | RYG63904.1 MAG: hypothetical protein EON64_15030 [archaeon] | diamond | 252 | 138 | 1 | Archaea | archaeon | ||||||||
| 30735882 | 30735882 | PRJNA1196384_S_NODE_6254_length_167_cov_0.900000_g6190_i0 | PRJNA1196384 | 6254 | 167 | 0.9 | 1.503 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 52.4 | 2.86e-6 | NR | MFB0561400.1 | 3067280 | g6190 | i0 | 41.8 | 0.988023952095808 | 55 | 31 | 98.8 | 1 | 2 | 166 | 46 | 99 | MFB0561400.1 class I SAM-dependent methyltransferase [Promethearchaeia archaeon] | diamond | 165 | 52.4 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 32399485 | 32399485 | PRJNA1196384_S_NODE_8439_length_150_cov_2.000000_g8375_i0 | PRJNA1196384 | 8439 | 150 | 2 | 3 | Nitrosopumilus | 338191 | Archaea | Archaea | 80.5 | 4.37e-16 | NR | WP_218843338.1 | 1470067 | g8375 | i0 | 73.5 | 7.84 | 49 | 13 | 98 | 0 | 3 | 149 | 235 | 283 | WP_218843338.1 multicopper oxidase domain-containing protein [Nitrosopumilus ureiphilus] | diamond | 1176 | 80.5 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus ureiphilus | ||
| 32412123 | 32412123 | PRJNA1196384_S_NODE_6939_length_161_cov_1.016129_g6875_i0 | PRJNA1196384 | 6939 | 161 | 1.016129 | 1.63596769 | archaeon | 1906665 | Archaea | Archaea | 44.7 | 0.00256 | NR | RYG67429.1 | 1906665 | g6875 | i0 | 51.2 | 0.801242236024845 | 43 | 21 | 80.1 | 0 | 129 | 1 | 1 | 43 | RYG67429.1 MAG: hypothetical protein EON64_07455 [archaeon] | diamond | 129 | 44.7 | 1 | Archaea | archaeon | ||||||||
| 32443952 | 32443952 | PRJNA1196384_S_NODE_8499_length_150_cov_1.212389_g8435_i0 | PRJNA1196384 | 8499 | 150 | 1.212389 | 1.8185835 | archaeon | 1906665 | Archaea | Archaea | 70.9 | 4.33e-13 | NR | RYH18875.1 | 1906665 | g8435 | i0 | 77.1 | 0.96 | 48 | 11 | 96 | 0 | 145 | 2 | 131 | 178 | RYH18875.1 MAG: hypothetical protein EON65_26770 [archaeon] | diamond | 144 | 70.9 | 1 | Archaea | 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);;