contig_metadata
23 rows where bioproject = "PRJNA505329" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4938526 | 4938526 | PRJNA505329_P_NODE_25044_length_194_cov_3.082759_g24573_i0 | PRJNA505329 | 25044 | 194 | 3.082759 | 5.98055246 | Natrialbaceae | 1644061 | Archaea | Archaea | 202 | 1.5699999999999998e-47 | NTclustered | gi|1621086513|gb|CP031303.1| | 121872 | g24573 | i0 | 85.784 | 58.1134020618557 | 204 | 14 | 97 | 1 | 4 | 192 | 751860 | 751657 | Natrinema thermotolerans strain A29 chromosome, complete genome | blastn | 11274 | 202 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema thermotolerans | |
| 5587299 | 5587299 | PRJNA505329_P_NODE_47165_length_164_cov_2.452174_g46694_i0 | PRJNA505329 | 47165 | 164 | 2.452174 | 4.02156536 | Halanaeroarchaeum sulfurireducens | 1604004 | Archaea | Archaea | 257 | 2.7e-64 | NTclustered | gi|822662803|gb|CP008875.1| | 1604004 | g46694 | i0 | 95.092 | 6.97560975609756 | 163 | 8 | 99 | 0 | 2 | 164 | 108518 | 108356 | Halanaeroarchaeum sulfurireducens strain HSR2 plasmid pHSR2-01, complete sequence | blastn | 1144 | 257 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sulfurireducens | |
| 16412874 | 16412874 | PRJNA505329_P_NODE_12073_length_233_cov_3.266304_g11602_i0 | PRJNA505329 | 12073 | 233 | 3.266304 | 7.61048832 | Methanosarcina | 2207 | Archaea | Archaea | 187 | 5.48e-43 | NTclustered | gi|470477259|ref|NR_076372.1| | 2208 | g11602 | i0 | 100 | 178.896995708155 | 101 | 0 | 85 | 0 | 133 | 233 | 2254 | 2354 | Methanosarcina barkeri strain Fusaro 23S ribosomal RNA gene, complete sequence | blastn | 41683 | 187 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 18335027 | 18335027 | PRJNA505329_P_NODE_30675_length_186_cov_2.233577_g30204_i0 | PRJNA505329 | 30675 | 186 | 2.233577 | 4.15445322 | Halobacterium sp. BOL4-2 | 2810537 | Archaea | Archaea | 261 | 2.43e-65 | NTclustered | gi|1992393335|gb|CP070334.1| | 2810537 | g30204 | i0 | 94.152 | 10.0591397849462 | 171 | 10 | 92 | 0 | 11 | 181 | 71573 | 71743 | Halobacterium sp. BOL4-2 plasmid pBOL4-2_105.9, complete sequence | blastn | 1871 | 261 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium sp. BOL4-2 | |
| 18335192 | 18335192 | PRJNA505329_P_NODE_43015_length_168_cov_1.722689_g42544_i0 | PRJNA505329 | 43015 | 168 | 1.722689 | 2.89411752 | Methanomassiliicoccaceae archaeon DOK | 1535962 | Archaea | Archaea | 278 | 2.14e-70 | NTclustered | gi|1799215713|gb|CP047880.1| | 1535962 | g42544 | i0 | 96.97 | 18.1547619047619 | 165 | 5 | 98 | 0 | 4 | 168 | 1504145 | 1503981 | Methanomassiliicoccaceae archaeon DOK chromosome, complete genome | blastn | 3050 | 278 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccaceae | Methanomassiliicoccaceae archaeon DOK | |||
| 22787417 | 22787417 | PRJNA505329_P_NODE_40638_length_171_cov_1.680328_g40167_i0 | PRJNA505329 | 40638 | 171 | 1.680328 | 2.87336088 | Pyrobaculum | 2276 | Archaea | Archaea | 311 | 2.14e-80 | NTclustered | gi|294441|gb|L07511.1|PYBRGDY | 2277 | g40167 | i0 | 100 | 98.2456140350877 | 168 | 0 | 98 | 0 | 4 | 171 | 894 | 1061 | Pyrobaculum islandicum 16S ribosomal RNA gene | blastn | 16800 | 311 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum islandicum | ||
| 22787426 | 22787426 | PRJNA505329_P_NODE_42138_length_169_cov_0.866667_g41667_i0 | PRJNA505329 | 42138 | 169 | 0.866667 | 1.46466723 | Methanobrevibacter | 2172 | Archaea | Archaea | 226 | 7.859999999999997e-55 | NTclustered | gi|2791693311|gb|CP144200.1| | 2173 | g41667 | i0 | 93.464 | 110.171597633136 | 153 | 9 | 91 | 1 | 1 | 153 | 1284970 | 1284819 | Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome | blastn | 18619 | 226 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 23435724 | 23435724 | PRJNA505329_P_NODE_23859_length_197_cov_3.925676_g23388_i0 | PRJNA505329 | 23859 | 197 | 3.925676 | 7.73358172 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 180 | 7.499999999999998e-41 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g23388 | i0 | 99 | 14.2842639593909 | 100 | 1 | 98 | 0 | 97 | 196 | 849303 | 849402 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 2814 | 180 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 24709486 | 24709486 | PRJNA505329_P_NODE_44460_length_167_cov_0.881356_g43989_i0 | PRJNA505329 | 44460 | 167 | 0.881356 | 1.47186452 | Candidatus Nitrosotenuis cloacae | 1603555 | Archaea | Archaea | 270 | 3.5499999999999993e-68 | NTclustered | gi|808354332|gb|CP011097.2| | 1603555 | g43989 | i0 | 96.341 | 0.982035928143713 | 164 | 6 | 98 | 0 | 1 | 164 | 1356880 | 1357043 | Candidatus Nitrosotenuis cloacae strain SAT1, complete genome | blastn | 164 | 270 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis cloacae | |||||
| 26697141 | 26697141 | PRJNA505329_P_NODE_35001_length_179_cov_3.784615_g34530_i0 | PRJNA505329 | 35001 | 179 | 3.784615 | 6.77446085 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 80.5 | 7.49e-16 | NR | MBI2667934.1 | 2026803 | g34530 | i0 | 63.8 | 4.8268156424581 | 58 | 21 | 97.2 | 0 | 175 | 2 | 71 | 128 | MBI2667934.1 lysine--tRNA ligase [Candidatus Woesearchaeota archaeon] | diamond | 864 | 80.5 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 27013750 | 27013750 | PRJNA505329_P_NODE_4122_length_401_cov_4.142045_g3657_i0 | PRJNA505329 | 4122 | 401 | 4.142045 | 16.60960045 | Thermoplasmatales archaeon BRNA1 | 1054217 | Archaea | Archaea | 45.8 | 0.0154 | NR | AGI47117.1 | 1054217 | g3657 | i0 | 45.8 | 0.359102244389027 | 48 | 26 | 35.9 | 0 | 6 | 149 | 361 | 408 | AGI47117.1 hypothetical protein TALC_00102 [Thermoplasmatales archaeon BRNA1] | diamond | 144 | 45.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Thermoplasmatales archaeon BRNA1 | ||||
| 28087667 | 28087667 | PRJNA505329_P_NODE_7065_length_276_cov_2.251101_g6594_i0 | PRJNA505329 | 7065 | 276 | 2.251101 | 6.21303876 | Methanobacterium sp. | 2164 | Archaea | Archaea | 116 | 5.569999999999999e-28 | NR | MEN6293712.1 | 2164 | g6594 | i0 | 65.1 | 1.83695652173913 | 86 | 25 | 88 | 2 | 4 | 246 | 123 | 208 | MEN6293712.1 portal protein [Methanobacterium sp.] | diamond | 507 | 116 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 28245416 | 28245416 | PRJNA505329_P_NODE_11246_length_233_cov_3.565217_g10775_i0 | PRJNA505329 | 11246 | 233 | 3.565217 | 8.30695561 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 47 | 5.54e-5 | NR | MBI4451841.1 | 2026803 | g10775 | i0 | 90.5 | 0.270386266094421 | 21 | 2 | 27 | 0 | 232 | 170 | 25 | 45 | MBI4451841.1 hypothetical protein [Candidatus Woesearchaeota archaeon] | diamond | 63 | 47 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 29413799 | 29413799 | PRJNA505329_P_NODE_33249_length_182_cov_2.330827_g32778_i0 | PRJNA505329 | 33249 | 182 | 2.330827 | 4.24210514 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 122 | 1.4899999999999998e-30 | NR | MEK6887837.1 | 3121606 | g32778 | i0 | 94.9 | 1.94505494505495 | 59 | 3 | 97.3 | 0 | 180 | 4 | 1422 | 1480 | MEK6887837.1 DNA polymerase domain-containing protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 354 | 122 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 29445271 | 29445271 | PRJNA505329_P_NODE_26490_length_192_cov_2.146853_g26019_i0 | PRJNA505329 | 26490 | 192 | 2.146853 | 4.12195776 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 46.2 | 1.9e-4 | NR | WP_181692398.1 | 2750669 | g26019 | i0 | 100 | 0.375 | 24 | 0 | 37.5 | 0 | 74 | 3 | 1 | 24 | WP_181692398.1 DUF357 domain-containing protein [Natronomonas sp. LN261] | diamond | 72 | 46.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 30772347 | 30772347 | PRJNA505329_P_NODE_51814_length_155_cov_3.698113_g51343_i0 | PRJNA505329 | 51814 | 155 | 3.698113 | 5.73207515 | archaeon | 1906665 | Archaea | Archaea | 97.1 | 8.34e-22 | NR | HUX65752.1 | 1906665 | g51343 | i0 | 100 | 1.89677419354839 | 49 | 0 | 94.8 | 0 | 151 | 5 | 488 | 536 | HUX65752.1 hypothetical protein [archaeon] | diamond | 294 | 97.1 | 1 | Archaea | archaeon | ||||||||
| 30850789 | 30850789 | PRJNA505329_P_NODE_19554_length_201_cov_5.046053_g19083_i0 | PRJNA505329 | 19554 | 201 | 5.046053 | 10.14256653 | root | 1 | Root_unresolved | Root_unresolved | 53.5 | 2.25e-6 | NR | MEK6882420.1 | 2026764 | g19083 | i0 | 51.1 | 1.13432835820896 | 45 | 18 | 61.2 | 1 | 134 | 12 | 15 | 59 | MEK6882420.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 228 | 53.9 | 0.992578849721707 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 31056891 | 31056891 | PRJNA505329_P_NODE_48275_length_163_cov_2.333333_g47804_i0 | PRJNA505329 | 48275 | 163 | 2.333333 | 3.80333279 | Methanocaldococcus jannaschii | 2190 | Archaea | Archaea | 97.8 | 1.18e-24 | NR | 2J9D_E | 2190 | g47804 | i0 | 94.1 | 0.938650306748466 | 51 | 3 | 93.9 | 0 | 10 | 162 | 56 | 106 | 2J9D_E Chain E, HYPOTHETICAL NITROGEN REGULATORY PII-LIKE PROTEIN MJ0059 [Methanocaldococcus jannaschii] | diamond | 153 | 97.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanocaldococcaceae | Methanocaldococcus | Methanocaldococcus jannaschii | |
| 31246139 | 31246139 | PRJNA505329_P_NODE_32535_length_183_cov_3.044776_g32064_i0 | PRJNA505329 | 32535 | 183 | 3.044776 | 5.57194008 | Candidatus Woesearchaeota archaeon CG1 | 2026803 | Archaea | Archaea | 72.4 | 4.93e-13 | NR | PIN74741.1 | 1974463 | g32064 | i0 | 65.5 | 1.77049180327869 | 58 | 20 | 95.1 | 0 | 174 | 1 | 245 | 302 | PIN74741.1 MAG: hypothetical protein COV18_05975 [Candidatus Woesearchaeota archaeon CG10_big_fil_rev_8_21_14_0_10_37_12] | diamond | 324 | 72.4 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon CG10_big_fil_rev_8_21_14_0_10_37_12 | ||||||
| 31261631 | 31261631 | PRJNA505329_P_NODE_37015_length_176_cov_3.220472_g36544_i0 | PRJNA505329 | 37015 | 176 | 3.220472 | 5.66803072 | root | 1 | Root_unresolved | Root_unresolved | 101 | 1.67e-23 | NR | HJW96663.1 | 1906665 | g36544 | i0 | 69 | 5.89772727272727 | 58 | 18 | 98.9 | 0 | 175 | 2 | 88 | 145 | HJW96663.1 adenosylhomocysteinase [archaeon] | diamond | 1038 | 101 | 1 | Archaea | archaeon | ||||||||
| 31435871 | 31435871 | PRJNA505329_P_NODE_39336_length_173_cov_1.653226_g38865_i0 | PRJNA505329 | 39336 | 173 | 1.653226 | 2.86008098 | Nitrosopumilales archaeon | 2026768 | Archaea | Archaea | 111 | 1.13e-30 | NR | MBI3253335.1 | 2026768 | g38865 | i0 | 100 | 0.815028901734104 | 47 | 0 | 81.5 | 0 | 32 | 172 | 1 | 47 | MBI3253335.1 hypothetical protein [Nitrosopumilales archaeon] | diamond | 141 | 111 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilales archaeon | ||||
| 31847022 | 31847022 | PRJNA505329_P_NODE_51957_length_155_cov_2.415094_g51486_i0 | PRJNA505329 | 51957 | 155 | 2.415094 | 3.7433957 | Nitrosopumilales archaeon | 2026768 | Archaea | Archaea | 101 | 1.73e-23 | NR | MBI2006572.1 | 2026768 | g51486 | i0 | 100 | 2.96129032258065 | 51 | 0 | 98.7 | 0 | 154 | 2 | 146 | 196 | MBI2006572.1 hypothetical protein [Nitrosopumilales archaeon] | diamond | 459 | 101 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilales archaeon | ||||
| 32606287 | 32606287 | PRJNA505329_P_NODE_26120_length_193_cov_1.423611_g25649_i0 | PRJNA505329 | 26120 | 193 | 1.423611 | 2.74756923 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 92.8 | 4.7e-22 | NR | MBI4010347.1 | 3121606 | g25649 | i0 | 77.6 | 0.901554404145078 | 58 | 13 | 90.2 | 0 | 15 | 188 | 3 | 60 | MBI4010347.1 50S ribosomal protein L24 [Candidatus Aenigmatarchaeota archaeon] | diamond | 174 | 92.8 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota 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);;