contig_metadata
24 rows where bioproject = "PRJNA488043" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1098051 | 1098051 | PRJNA488043_P_NODE_9281_length_364_cov_1.973134_g7052_i0 | PRJNA488043 | 9281 | 364 | 1.973134 | 7.18220776 | root | 1 | Root_unresolved | Root_unresolved | 76.8 | 2.05e-9 | NTclustered | gi|268322253|emb|FM868132.1| | 115547 | g7052 | i0 | 92.593 | 14.5824175824176 | 54 | 3 | 15 | 1 | 262 | 315 | 347 | 399 | Uncultured archaeon partial 16S rRNA gene, clone HA7-ARCH-C77 | blastn | 5308 | 76.8 | 1 | Archaea | uncultured archaeon | ||||||||
| 1724475 | 1724475 | PRJNA488043_P_NODE_11282_length_300_cov_6.996310_g9041_i0 | PRJNA488043 | 11282 | 300 | 6.99631 | 20.98893 | Candidatus Nitrosotenuis cloacae | 1603555 | Archaea | Archaea | 521 | 1.7699999999999996e-143 | NTclustered | gi|808354332|gb|CP011097.2| | 1603555 | g9041 | i0 | 98 | 27.9 | 300 | 6 | 100 | 0 | 1 | 300 | 121161 | 121460 | Candidatus Nitrosotenuis cloacae strain SAT1, complete genome | blastn | 8370 | 521 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis cloacae | |||||
| 8102935 | 8102935 | PRJNA488043_P_NODE_17407_length_198_cov_2.136095_g15165_i0 | PRJNA488043 | 17407 | 198 | 2.136095 | 4.2294681 | Methanosarcina thermophila | 2210 | Archaea | Archaea | 54.7 | 0.005 | NTclustered | gi|805329805|gb|CP009501.1| | 523844 | g15165 | i0 | 94.444 | 0.747474747474748 | 36 | 0 | 17 | 2 | 165 | 198 | 2419746 | 2419781 | Methanosarcina thermophila TM-1, complete genome | blastn | 148 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina thermophila | |
| 11928501 | 11928501 | PRJNA488043_P_NODE_16790_length_205_cov_1.670455_g14548_i0 | PRJNA488043 | 16790 | 205 | 1.670455 | 3.42443275 | Candidatus Nitrosotenuis cloacae | 1603555 | Archaea | Archaea | 351 | 1.58e-92 | NTclustered | gi|808354332|gb|CP011097.2| | 1603555 | g14548 | i0 | 98.02 | 26.3170731707317 | 202 | 4 | 99 | 0 | 4 | 205 | 740101 | 739900 | Candidatus Nitrosotenuis cloacae strain SAT1, complete genome | blastn | 5395 | 351 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis cloacae | |||||
| 14478581 | 14478581 | PRJNA488043_P_NODE_932_length_1950_cov_4.498178_g148_i2 | PRJNA488043 | 932 | 1950 | 4.498178 | 87.714471 | Candidatus Nitrosotenuis aquarius | 1846278 | Archaea | Archaea | 2900 | 0 | NTclustered | gi|1279207014|gb|CP024808.1| | 1846278 | g148 | i2 | 93.327 | 18.9164102564103 | 1963 | 112 | 100 | 8 | 1 | 1950 | 1535573 | 1533617 | Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome | blastn | 36887 | 2900 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis aquarius | |||||
| 22126267 | 22126267 | PRJNA488043_P_NODE_14018_length_243_cov_1.457944_g11776_i0 | PRJNA488043 | 14018 | 243 | 1.457944 | 3.54280392 | Candidatus Nitrosotenuis cloacae | 1603555 | Archaea | Archaea | 150 | 7.55e-32 | NTclustered | gi|808354332|gb|CP011097.2| | 1603555 | g11776 | i0 | 91.667 | 0.893004115226337 | 108 | 9 | 44 | 0 | 135 | 242 | 704266 | 704159 | Candidatus Nitrosotenuis cloacae strain SAT1, complete genome | blastn | 217 | 150 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis cloacae | |||||
| 24675950 | 24675950 | PRJNA488043_P_NODE_460_length_5141_cov_4.026995_g148_i0 | PRJNA488043 | 460 | 5141 | 4.026995 | 207.02781295 | Candidatus Nitrosotenuis aquarius | 1846278 | Archaea | Archaea | 3476 | 0 | NTclustered | gi|1279207014|gb|CP024808.1| | 1846278 | g148 | i0 | 92.402 | 9.03948648122933 | 2435 | 148 | 92 | 11 | 2727 | 5141 | 1533156 | 1535573 | Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome | blastn | 46472 | 3476 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis aquarius | |||||
| 24676006 | 24676006 | PRJNA488043_P_NODE_900_length_1997_cov_4.404472_g148_i1 | PRJNA488043 | 900 | 1997 | 4.404472 | 87.95730584 | Candidatus Nitrosotenuis aquarius | 1846278 | Archaea | Archaea | 2880 | 0 | NTclustered | gi|1279207014|gb|CP024808.1| | 1846278 | g148 | i1 | 92.587 | 18.528292438658 | 2010 | 120 | 100 | 9 | 1 | 1997 | 1533580 | 1535573 | Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome | blastn | 37001 | 2880 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis aquarius | |||||
| 27170970 | 27170970 | PRJNA488043_P_NODE_20482_length_167_cov_1.963768_g18240_i0 | PRJNA488043 | 20482 | 167 | 1.963768 | 3.27949256 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 70.5 | 2.17e-12 | NR | RLI37484.1 | 2026714 | g18240 | i0 | 66 | 1.86826347305389 | 53 | 18 | 95.2 | 0 | 161 | 3 | 170 | 222 | RLI37484.1 MAG: hypothetical protein DRO66_03775 [Candidatus Bathyarchaeota archaeon] | diamond | 312 | 70.5 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 27250395 | 27250395 | PRJNA488043_P_NODE_15243_length_224_cov_2.312821_g13001_i0 | PRJNA488043 | 15243 | 224 | 2.312821 | 5.18071904 | root | 1 | Root_unresolved | Root_unresolved | 71.6 | 6.62e-14 | NR | MDX1532587.1 | 2202732 | g13001 | i0 | 51.4 | 1.94196428571429 | 72 | 35 | 96.4 | 0 | 224 | 9 | 23 | 94 | MDX1532587.1 hypothetical protein [Nitrosopumilaceae archaeon] | diamond | 435 | 71.6 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 27629645 | 27629645 | PRJNA488043_P_NODE_15244_length_224_cov_2.282051_g13002_i0 | PRJNA488043 | 15244 | 224 | 2.282051 | 5.11179424 | root | 1 | Root_unresolved | Root_unresolved | 57 | 1.96e-7 | NR | WP_292787978.1 | 66852 | g13002 | i0 | 48 | 2.14285714285714 | 50 | 26 | 67 | 0 | 5 | 154 | 88 | 137 | WP_292787978.1 DNA-methyltransferase [Methanobrevibacter sp.] | diamond | 480 | 57.4 | 0.993031358885017 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 27803026 | 27803026 | PRJNA488043_P_NODE_22324_length_152_cov_1.691057_g20082_i0 | PRJNA488043 | 22324 | 152 | 1.691057 | 2.57040664 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 42 | 0.0203 | NR | MCK9570055.1 | 2026773 | g20082 | i0 | 48.6 | 0.690789473684211 | 35 | 18 | 69.1 | 0 | 112 | 8 | 305 | 339 | MCK9570055.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 105 | 42 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 28497649 | 28497649 | PRJNA488043_P_NODE_3427_length_783_cov_2.578249_g1558_i1 | PRJNA488043 | 3427 | 783 | 2.578249 | 20.18768967 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 80.1 | 4.22e-14 | NR | MCA9497338.1 | 2026764 | g1558 | i1 | 45.6 | 0.344827586206897 | 90 | 46 | 33.7 | 2 | 518 | 781 | 10 | 98 | MCA9497338.1 HK97 family phage prohead protease [Nanoarchaeota archaeon] | diamond | 270 | 80.1 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 29286725 | 29286725 | PRJNA488043_P_NODE_16909_length_203_cov_2.655172_g14667_i0 | PRJNA488043 | 16909 | 203 | 2.655172 | 5.38999916 | Methanosarcina sp. | 2213 | Archaea | Archaea | 51.6 | 1.53e-6 | NR | HET8686851.1 | 2213 | g14667 | i0 | 69 | 0.428571428571429 | 29 | 9 | 42.9 | 0 | 114 | 200 | 1 | 29 | HET8686851.1 hypothetical protein [Methanosarcina sp.] | diamond | 87 | 51.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 29728627 | 29728627 | PRJNA488043_P_NODE_3450_length_779_cov_2.849333_g1558_i2 | PRJNA488043 | 3450 | 779 | 2.849333 | 22.19630407 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 80.1 | 4.14e-14 | NR | MCA9497338.1 | 2026764 | g1558 | i2 | 45.6 | 0.346598202824134 | 90 | 46 | 33.9 | 2 | 266 | 3 | 10 | 98 | MCA9497338.1 HK97 family phage prohead protease [Nanoarchaeota archaeon] | diamond | 270 | 80.1 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 29855262 | 29855262 | PRJNA488043_P_NODE_16011_length_214_cov_1.610811_g13769_i0 | PRJNA488043 | 16011 | 214 | 1.610811 | 3.44713554 | Methanosarcina sp. | 2213 | Archaea | Archaea | 67.8 | 1.3e-12 | NR | HET8689073.1 | 2213 | g13769 | i0 | 47.9 | 0.995327102803738 | 71 | 37 | 99.5 | 0 | 1 | 213 | 12 | 82 | HET8689073.1 hypothetical protein [Methanosarcina sp.] | diamond | 213 | 67.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 30013266 | 30013266 | PRJNA488043_P_NODE_3011_length_853_cov_2.406553_g1558_i0 | PRJNA488043 | 3011 | 853 | 2.406553 | 20.52789709 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 80.1 | 6.27e-14 | NR | MCA9497338.1 | 2026764 | g1558 | i0 | 45.6 | 0.316529894490035 | 90 | 46 | 30.9 | 2 | 588 | 851 | 10 | 98 | MCA9497338.1 HK97 family phage prohead protease [Nanoarchaeota archaeon] | diamond | 270 | 80.1 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 30076222 | 30076222 | PRJNA488043_P_NODE_2112_length_1066_cov_3.185149_g621_i2 | PRJNA488043 | 2112 | 1066 | 3.185149 | 33.95368834 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 52.4 | 4.83e-5 | NR | MEM2002118.1 | 3058293 | g621 | i2 | 42.2 | 0.180112570356473 | 64 | 35 | 18 | 2 | 882 | 691 | 1 | 62 | MEM2002118.1 hypothetical protein [Candidatus Methanomethylicaceae archaeon] | diamond | 192 | 52.4 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 30455860 | 30455860 | PRJNA488043_P_NODE_9393_length_360_cov_2.175227_g7163_i0 | PRJNA488043 | 9393 | 360 | 2.175227 | 7.8308172 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 79 | 1.64e-16 | NR | MCK5607752.1 | 2026773 | g7163 | i0 | 51.2 | 0.716666666666667 | 86 | 35 | 70 | 2 | 269 | 18 | 1 | 81 | MCK5607752.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 258 | 79 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 30613335 | 30613335 | PRJNA488043_P_NODE_20613_length_166_cov_1.518248_g18371_i0 | PRJNA488043 | 20613 | 166 | 1.518248 | 2.52029168 | Nitrosarchaeum koreense | 1088740 | Archaea | Archaea | 52 | 7.25e-6 | NR | WP_007550483.1 | 1088740 | g18371 | i0 | 56.4 | 2.02409638554217 | 55 | 20 | 94 | 3 | 8 | 163 | 516 | 569 | WP_007550483.1 hypothetical protein [Nitrosarchaeum koreense] | diamond | 336 | 52 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum koreense | ||
| 31024251 | 31024251 | PRJNA488043_P_NODE_2055_length_1087_cov_3.140832_g621_i1 | PRJNA488043 | 2055 | 1087 | 3.140832 | 34.14084384 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 52.4 | 4.94e-5 | NR | MEM2002118.1 | 3058293 | g621 | i1 | 42.2 | 0.176632934682613 | 64 | 35 | 17.7 | 2 | 903 | 712 | 1 | 62 | MEM2002118.1 hypothetical protein [Candidatus Methanomethylicaceae archaeon] | diamond | 192 | 52.4 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 31609454 | 31609454 | PRJNA488043_P_NODE_10676_length_318_cov_2.356401_g8435_i0 | PRJNA488043 | 10676 | 318 | 2.356401 | 7.49335518 | root | 1 | Root_unresolved | Root_unresolved | 90.9 | 4.3e-19 | NR | HET8686349.1 | 2213 | g8435 | i0 | 83.6 | 2.07547169811321 | 55 | 9 | 51.9 | 0 | 1 | 165 | 286 | 340 | HET8686349.1 DNA methyltransferase [Methanosarcina sp.] | diamond | 660 | 90.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 31719839 | 31719839 | PRJNA488043_P_NODE_2157_length_1053_cov_3.283203_g621_i3 | PRJNA488043 | 2157 | 1053 | 3.283203 | 34.57212759 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 52.4 | 4.77e-5 | NR | MEM2002118.1 | 3058293 | g621 | i3 | 42.2 | 0.182336182336182 | 64 | 35 | 18.2 | 2 | 864 | 673 | 1 | 62 | MEM2002118.1 hypothetical protein [Candidatus Methanomethylicaceae archaeon] | diamond | 192 | 52.4 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 32004599 | 32004599 | PRJNA488043_P_NODE_21678_length_157_cov_1.640625_g19436_i0 | PRJNA488043 | 21678 | 157 | 1.640625 | 2.57578125 | Methanosarcina sp. | 2213 | Archaea | Archaea | 62 | 6.73e-11 | NR | HET8689436.1 | 2213 | g19436 | i0 | 51 | 0.974522292993631 | 51 | 25 | 97.5 | 0 | 5 | 157 | 34 | 84 | HET8689436.1 hypothetical protein [Methanosarcina sp.] | diamond | 153 | 62 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. |
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);;