contig_metadata
21 rows where bioproject = "PRJNA399711" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25563276 | 25563276 | PRJNA399711_S_NODE_36937_length_222_cov_2.275676_g36795_i0 | PRJNA399711 | 36937 | 222 | 2.275676 | 5.05200072 | Methanosphaera sp. ISO3-F5 | 1452353 | Archaea | Archaea | 52.8 | 0.02 | NTclustered | gi|2695672541|gb|CP118754.2| | 1452353 | g36795 | i0 | 100 | 0.126126126126126 | 28 | 0 | 13 | 0 | 174 | 201 | 141713 | 141740 | Methanosphaera sp. ISO3-F5 plasmid pNP174, complete sequence | blastn | 28 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera sp. ISO3-F5 | |
| 25697956 | 25697956 | PRJNA399711_S_NODE_10458_length_341_cov_2.496711_g10316_i0 | PRJNA399711 | 10458 | 341 | 2.496711 | 8.51378451 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 70.5 | 1.29e-11 | NR | MEK9698159.1 | 2163009 | g10316 | i0 | 52.3 | 1.38123167155425 | 65 | 31 | 57.2 | 0 | 337 | 143 | 29 | 93 | MEK9698159.1 hypothetical protein [Candidatus Poseidoniales archaeon] | diamond | 471 | 70.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 26106159 | 26106159 | PRJNA399711_S_NODE_100133_length_155_cov_1.720339_g99991_i0 | PRJNA399711 | 100133 | 155 | 1.720339 | 2.66652545 | Vulcanisaeta moutnovskia 768-28 | 985053 | Archaea | Archaea | 52.8 | 0.013 | NTclustered | gi|323706731|gb|CP002529.1| | 985053 | g99991 | i0 | 100 | 0.180645161290323 | 28 | 0 | 18 | 0 | 30 | 57 | 336100 | 336127 | Vulcanisaeta moutnovskia 768-28, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Vulcanisaeta | Vulcanisaeta moutnovskia | ||
| 26242509 | 26242509 | PRJNA399711_S_NODE_107126_length_151_cov_2.877193_g106984_i0 | PRJNA399711 | 107126 | 151 | 2.877193 | 4.34456143 | Halobaculum limi | 3031916 | Archaea | Archaea | 52.8 | 0.012 | NTclustered | gi|2471356524|gb|CP120468.1| | 3031916 | g106984 | i0 | 100 | 0.185430463576159 | 28 | 0 | 19 | 0 | 35 | 62 | 499995 | 499968 | Halobaculum limi strain YSMS11 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum limi | |
| 26518085 | 26518085 | PRJNA399711_S_NODE_95920_length_157_cov_3.991667_g95778_i0 | PRJNA399711 | 95920 | 157 | 3.991667 | 6.26691719 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 244 | 1.99e-60 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g95778 | i0 | 94.872 | 0.993630573248408 | 156 | 8 | 99 | 0 | 1 | 156 | 2030528 | 2030373 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 156 | 244 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 28023068 | 28023068 | PRJNA399711_P_NODE_11685_length_188_cov_2.006623_g11619_i0 | PRJNA399711 | 11685 | 188 | 2.006623 | 3.77245124 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 86.7 | 3.31e-18 | NR | MCK9569285.1 | 2026773 | g11619 | i0 | 67.2 | 0.925531914893617 | 58 | 19 | 92.6 | 0 | 176 | 3 | 223 | 280 | MCK9569285.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 174 | 86.7 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 28275442 | 28275442 | PRJNA399711_P_NODE_7406_length_214_cov_3.519774_g7340_i0 | PRJNA399711 | 7406 | 214 | 3.519774 | 7.53231636 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 44.3 | 0.00742 | NR | MAG28463.1 | 2026773 | g7340 | i0 | 43.3 | 0.939252336448598 | 67 | 35 | 91.1 | 2 | 5 | 199 | 523 | 588 | MAG28463.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 201 | 44.3 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 30454888 | 30454888 | PRJNA399711_P_NODE_11633_length_188_cov_2.860927_g11567_i0 | PRJNA399711 | 11633 | 188 | 2.860927 | 5.37854276 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 42 | 0.0335 | NR | MEM2001436.1 | 3058293 | g11567 | i0 | 50 | 0.51063829787234 | 32 | 16 | 51.1 | 0 | 7 | 102 | 100 | 131 | MEM2001436.1 glycosyltransferase [Candidatus Methanomethylicaceae archaeon] | diamond | 96 | 42 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 30675569 | 30675569 | PRJNA399711_P_NODE_18793_length_166_cov_2.325581_g18727_i0 | PRJNA399711 | 18793 | 166 | 2.325581 | 3.86046446 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 93.6 | 5.779999999999999e-23 | NR | MCJ7636226.1 | 2169593 | g18727 | i0 | 96 | 1.80722891566265 | 50 | 2 | 90.4 | 0 | 2 | 151 | 33 | 82 | MCJ7636226.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 300 | 93.6 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 30833693 | 30833693 | PRJNA399711_P_NODE_14114_length_177_cov_30.185714_g14048_i0 | PRJNA399711 | 14114 | 177 | 30.185714 | 53.42871378 | Candidatus Jordarchaeales archaeon | 3058035 | Archaea | Archaea | 40.4 | 0.0348 | NR | MEM1513227.1 | 3058035 | g14048 | i0 | 52.8 | 0.610169491525424 | 36 | 16 | 59.3 | 1 | 33 | 137 | 71 | 106 | MEM1513227.1 hypothetical protein [Candidatus Jordarchaeales archaeon] | diamond | 108 | 40.4 | 1 | Archaea | Promethearchaeati | Candidatus Jordarchaeia | Candidatus Jordarchaeales | Candidatus Jordarchaeales archaeon | |||||
| 32934556 | 32934556 | PRJNA399711_S_NODE_11009_length_335_cov_7.932886_g10867_i0 | PRJNA399711 | 11009 | 335 | 7.932886 | 26.5751681 | Methanocaldococcus jannaschii | 2190 | Archaea | Archaea | 75.1 | 4.52e-15 | NR | WP_064496856.1 | 2190 | g10867 | i0 | 76.2 | 0.564179104477612 | 63 | 15 | 56.4 | 0 | 48 | 236 | 28 | 90 | WP_064496856.1 hypothetical protein [Methanocaldococcus jannaschii] | diamond | 189 | 75.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanocaldococcaceae | Methanocaldococcus | Methanocaldococcus jannaschii | |
| 33003391 | 33003391 | PRJNA399711_S_NODE_82699_length_166_cov_2.364341_g82557_i0 | PRJNA399711 | 82699 | 166 | 2.364341 | 3.92480606 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 117 | 7.240000000000001e-29 | NR | HET8793525.1 | 2169593 | g82557 | i0 | 94.5 | 11.9277108433735 | 55 | 3 | 99.4 | 0 | 166 | 2 | 461 | 515 | HET8793525.1 ABC transporter substrate-binding protein [Nitrososphaeraceae archaeon] | diamond | 1980 | 117 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 33020184 | 33020184 | PRJNA399711_S_NODE_44428_length_208_cov_1.777778_g44286_i0 | PRJNA399711 | 44428 | 208 | 1.777778 | 3.69777824 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 123 | 1.9099999999999998e-31 | NR | MDW0258915.1 | 2169593 | g44286 | i0 | 100 | 0.995192307692308 | 69 | 0 | 99.5 | 0 | 207 | 1 | 256 | 324 | MDW0258915.1 IS1634 family transposase [Nitrososphaeraceae archaeon] | diamond | 207 | 123 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 33037457 | 33037457 | PRJNA399711_S_NODE_73372_length_173_cov_3.514706_g73230_i0 | PRJNA399711 | 73372 | 173 | 3.514706 | 6.08044138 | Methanobacterium sp. | 2164 | Archaea | Archaea | 45.1 | 0.00222 | NR | MCC7564369.1 | 2164 | g73230 | i0 | 100 | 0.416184971098266 | 24 | 0 | 41.6 | 0 | 100 | 171 | 1 | 24 | MCC7564369.1 hypothetical protein [Methanobacterium sp.] | diamond | 72 | 45.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 33054534 | 33054534 | PRJNA399711_S_NODE_81637_length_167_cov_1.161538_g81495_i0 | PRJNA399711 | 81637 | 167 | 1.161538 | 1.93976846 | Nitrosopumilaceae archaeon | 2202732 | Archaea | Archaea | 67.4 | 1.5e-11 | NR | NIU02294.1 | 2202732 | g81495 | i0 | 58.5 | 0.952095808383233 | 53 | 22 | 95.2 | 0 | 165 | 7 | 75 | 127 | NIU02294.1 hypothetical protein [Nitrosopumilaceae archaeon] | diamond | 159 | 67.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 33060674 | 33060674 | PRJNA399711_S_NODE_50397_length_198_cov_6.931677_g50255_i0 | PRJNA399711 | 50397 | 198 | 6.931677 | 13.72472046 | Archaea | 2157 | Archaea | Archaea | 43.1 | 0.0157 | NR | HIO94141.1 | 2163009 | g50255 | i0 | 41.1 | 2.57575757575758 | 56 | 33 | 84.8 | 0 | 4 | 171 | 193 | 248 | HIO94141.1 aconitate hydratase AcnA [Candidatus Poseidoniales archaeon] | diamond | 510 | 43.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 33088182 | 33088182 | PRJNA399711_S_NODE_107014_length_151_cov_3.175439_g106872_i0 | PRJNA399711 | 107014 | 151 | 3.175439 | 4.79491289 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 83.6 | 2.28e-17 | NR | MBI4738261.1 | 2026803 | g106872 | i0 | 80 | 0.993377483443709 | 50 | 10 | 99.3 | 0 | 150 | 1 | 215 | 264 | MBI4738261.1 hypothetical protein [Candidatus Woesearchaeota archaeon] | diamond | 150 | 83.6 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 33088812 | 33088812 | PRJNA399711_S_NODE_96982_length_157_cov_0.941667_g96840_i0 | PRJNA399711 | 96982 | 157 | 0.941667 | 1.47841719 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 87.4 | 6.4e-19 | NR | HEX6671336.1 | 2169593 | g96840 | i0 | 76.5 | 0.974522292993631 | 51 | 12 | 97.5 | 0 | 155 | 3 | 159 | 209 | HEX6671336.1 site-specific integrase [Nitrososphaeraceae archaeon] | diamond | 153 | 87.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 33111895 | 33111895 | PRJNA399711_S_NODE_84534_length_164_cov_14.062992_g84392_i0 | PRJNA399711 | 84534 | 164 | 14.062992 | 23.06330688 | Thermoproteati | 1783275 | Archaea | Archaea | 111 | 7.77e-28 | NR | MDP9305080.1 | 2056631 | g84392 | i0 | 100 | 3.95121951219512 | 54 | 0 | 98.8 | 0 | 1 | 162 | 68 | 121 | MDP9305080.1 isocitrate/isopropylmalate dehydrogenase family protein [Thermoproteota archaeon] | diamond | 648 | 111 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 33173664 | 33173664 | PRJNA399711_S_NODE_18888_length_281_cov_3.938525_g18746_i0 | PRJNA399711 | 18888 | 281 | 3.938525 | 11.06725525 | archaeon | 1906665 | Archaea | Archaea | 88.2 | 5.4e-19 | NR | MDP2438326.1 | 1906665 | g18746 | i0 | 55.6 | 0.864768683274021 | 81 | 33 | 84.3 | 2 | 269 | 33 | 157 | 236 | MDP2438326.1 proteasome subunit beta [archaeon] | diamond | 243 | 88.2 | 1 | Archaea | archaeon | ||||||||
| 33173811 | 33173811 | PRJNA399711_S_NODE_39096_length_217_cov_12.505556_g38954_i0 | PRJNA399711 | 39096 | 217 | 12.505556 | 27.13705652 | Methanomethylophilus alvi | 1291540 | Archaea | Archaea | 41.6 | 0.0344 | NR | WP_400256085.1 | 1291540 | g38954 | i0 | 38.2 | 0.76036866359447 | 55 | 25 | 63.6 | 2 | 60 | 197 | 79 | 133 | WP_400256085.1 hypothetical protein [Methanomethylophilus alvi] | diamond | 165 | 41.6 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomethylophilaceae | Methanomethylophilus | Methanomethylophilus alvi |
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);;