contig_metadata
22 rows where bioproject = "PRJNA674048" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4994274 | 4994274 | PRJNA674048_P_NODE_23644_length_181_cov_1.181818_g23441_i0 | PRJNA674048 | 23644 | 181 | 1.181818 | 2.13909058 | root | 1 | Root_unresolved | Root_unresolved | 335 | 1.36e-87 | NTclustered | gi|253971047|gb|GQ249655.1| | 29281 | g23441 | i0 | 100 | 99.9889502762431 | 181 | 0 | 100 | 0 | 1 | 181 | 317 | 497 | Uncultured crenarchaeote clone D06-arc 16S ribosomal RNA gene, partial sequence | blastn | 18098 | 335 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 6270001 | 6270001 | PRJNA674048_P_NODE_29445_length_166_cov_0.888889_g29242_i0 | PRJNA674048 | 29445 | 166 | 0.888889 | 1.47555574 | Halalkalicoccus | 332246 | Archaea | Archaea | 292 | 7.52e-75 | NTclustered | gi|507148368|ref|NR_103171.1| | 413810 | g29242 | i0 | 98.78 | 178.030120481928 | 164 | 2 | 99 | 0 | 3 | 166 | 1262 | 1099 | Halalkalicoccus jeotgali strain B3 23S ribosomal RNA gene, complete sequence | blastn | 29553 | 292 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 6270036 | 6270036 | PRJNA674048_P_NODE_31645_length_163_cov_0.912281_g31442_i0 | PRJNA674048 | 31645 | 163 | 0.912281 | 1.48701803 | Haloarcula | 2237 | Archaea | Archaea | 132 | 1.7e-26 | NTclustered | gi|343781660|gb|CP002921.1| | 634497 | g31442 | i0 | 84.733 | 5.77914110429448 | 131 | 20 | 80 | 0 | 30 | 160 | 2336111 | 2336241 | Haloarcula hispanica ATCC 33960 chromosome I, complete sequence | blastn | 942 | 132 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula hispanica | |
| 19017566 | 19017566 | PRJNA674048_P_NODE_14895_length_232_cov_2.841530_g14692_i0 | PRJNA674048 | 14895 | 232 | 2.84153 | 6.5923496 | root | 1 | Root_unresolved | Root_unresolved | 429 | 8.2e-116 | NTclustered | gi|3108087|gb|AF058730.1| | 75624 | g14692 | i0 | 100 | 100 | 232 | 0 | 100 | 0 | 1 | 232 | 481 | 712 | Uncultured crenarchaeote KBSNat20 16S ribosomal RNA gene, partial sequence | blastn | 23200 | 429 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote KBSNat20 | ||||||
| 21045703 | 21045703 | PRJNA674048_P_NODE_30577_length_164_cov_1.808696_g30374_i0 | PRJNA674048 | 30577 | 164 | 1.808696 | 2.96626144 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 303 | 3.42e-78 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g30374 | i0 | 100 | 19.4024390243902 | 164 | 0 | 100 | 0 | 1 | 164 | 848071 | 848234 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 3182 | 303 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 21568154 | 21568154 | PRJNA674048_P_NODE_27277_length_169_cov_0.866667_g27074_i0 | PRJNA674048 | 27277 | 169 | 0.866667 | 1.46466723 | Candidatus Nitrosocosmicus | 1826864 | Archaea | Archaea | 313 | 5.859999999999999e-81 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g27074 | i0 | 100 | 85.3846153846154 | 169 | 0 | 100 | 0 | 1 | 169 | 847994 | 847826 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 14430 | 313 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 22843268 | 22843268 | PRJNA674048_P_NODE_10418_length_291_cov_0.979339_g10215_i0 | PRJNA674048 | 10418 | 291 | 0.979339 | 2.84987649 | Halalkalicoccus | 332246 | Archaea | Archaea | 483 | 8.069999999999998e-132 | NTclustered | gi|507148368|ref|NR_103171.1| | 413810 | g10215 | i0 | 96.564 | 77.7938144329897 | 291 | 10 | 100 | 0 | 1 | 291 | 383 | 93 | Halalkalicoccus jeotgali strain B3 23S ribosomal RNA gene, complete sequence | blastn | 22638 | 483 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 25392378 | 25392378 | PRJNA674048_P_NODE_18820_length_204_cov_1.270968_g18617_i0 | PRJNA674048 | 18820 | 204 | 1.270968 | 2.59277472 | Archaea | 2157 | Archaea | Archaea | 377 | 2.59e-100 | NTclustered | gi|315585451|gb|HQ647201.1| | 29281 | g18617 | i0 | 100 | 102 | 204 | 0 | 100 | 0 | 1 | 204 | 62 | 265 | Uncultured crenarchaeote clone Hm5_rock_SK477 16S ribosomal RNA gene, partial sequence | blastn | 20808 | 377 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 27207969 | 27207969 | PRJNA674048_P_NODE_24822_length_176_cov_1.834646_g24619_i0 | PRJNA674048 | 24822 | 176 | 1.834646 | 3.22897696 | archaeon | 1906665 | Archaea | Archaea | 99 | 2.1099999999999998e-23 | NR | RYG64625.1 | 1906665 | g24619 | i0 | 77.6 | 0.988636363636364 | 58 | 13 | 98.9 | 0 | 175 | 2 | 170 | 227 | RYG64625.1 MAG: 50S ribosomal protein L3, partial [archaeon] | diamond | 174 | 99 | 1 | Archaea | archaeon | ||||||||
| 27883289 | 27883289 | PRJNA674048_P_NODE_29805_length_165_cov_1.793103_g29602_i0 | PRJNA674048 | 29805 | 165 | 1.793103 | 2.95861995 | root | 1 | Root_unresolved | Root_unresolved | 50.4 | 2.91e-6 | NR | WP_048102805.1 | 2208 | g29602 | i0 | 52.2 | 2.32727272727273 | 46 | 22 | 83.6 | 0 | 27 | 164 | 3 | 48 | WP_048102805.1 hypothetical protein [Methanosarcina barkeri] | diamond | 384 | 50.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 27934655 | 27934655 | PRJNA674048_P_NODE_27105_length_169_cov_0.866667_g26902_i0 | PRJNA674048 | 27105 | 169 | 0.866667 | 1.46466723 | archaeon | 1906665 | Archaea | Archaea | 60.8 | 2.68e-9 | NR | RYG66559.1 | 1906665 | g26902 | i0 | 82.4 | 1.57988165680473 | 34 | 6 | 60.4 | 0 | 102 | 1 | 132 | 165 | RYG66559.1 MAG: elongation factor 1-beta/delta [archaeon] | diamond | 267 | 60.8 | 1 | Archaea | archaeon | ||||||||
| 27997892 | 27997892 | PRJNA674048_P_NODE_31065_length_164_cov_0.904348_g30862_i0 | PRJNA674048 | 31065 | 164 | 0.904348 | 1.48313072 | archaeon | 1906665 | Archaea | Archaea | 54.7 | 7.77e-7 | NR | RYG69087.1 | 1906665 | g30862 | i0 | 61.5 | 0.713414634146341 | 39 | 15 | 71.3 | 0 | 39 | 155 | 464 | 502 | RYG69087.1 MAG: hypothetical protein EON64_03605, partial [archaeon] | diamond | 117 | 54.7 | 1 | Archaea | archaeon | ||||||||
| 29229343 | 29229343 | PRJNA674048_P_NODE_22549_length_185_cov_1.529412_g22346_i0 | PRJNA674048 | 22549 | 185 | 1.529412 | 2.8294122 | Candidatus Caldarchaeum sp. | 2972665 | Archaea | Archaea | 78.2 | 5.51e-15 | NR | MEM0462111.1 | 2972665 | g22346 | i0 | 63.9 | 0.989189189189189 | 61 | 21 | 98.9 | 1 | 183 | 1 | 450 | 509 | MEM0462111.1 hypothetical protein [Candidatus Caldarchaeum sp.] | diamond | 183 | 78.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Caldarchaeales | Candidatus Caldarchaeaceae | Candidatus Caldarchaeum | Candidatus Caldarchaeum sp. | |||
| 29923904 | 29923904 | PRJNA674048_P_NODE_30371_length_165_cov_0.896552_g30168_i0 | PRJNA674048 | 30371 | 165 | 0.896552 | 1.4793108 | archaeon | 1906665 | Archaea | Archaea | 59.7 | 1.33e-8 | NR | RYH18422.1 | 1906665 | g30168 | i0 | 54 | 0.909090909090909 | 50 | 23 | 90.9 | 0 | 14 | 163 | 956 | 1005 | RYH18422.1 MAG: hypothetical protein EON65_27240 [archaeon] | diamond | 150 | 59.7 | 1 | Archaea | archaeon | ||||||||
| 30713611 | 30713611 | PRJNA674048_P_NODE_28554_length_167_cov_0.881356_g28351_i0 | PRJNA674048 | 28554 | 167 | 0.881356 | 1.47186452 | archaeon | 1906665 | Archaea | Archaea | 103 | 6.77e-24 | NR | RYH27824.1 | 1906665 | g28351 | i0 | 87.3 | 1.97604790419162 | 55 | 7 | 98.8 | 0 | 1 | 165 | 469 | 523 | RYH27824.1 MAG: acyl-CoA dehydrogenase [archaeon] | diamond | 330 | 103 | 1 | Archaea | archaeon | ||||||||
| 30745271 | 30745271 | PRJNA674048_P_NODE_31614_length_163_cov_0.912281_g31411_i0 | PRJNA674048 | 31614 | 163 | 0.912281 | 1.48701803 | archaeon | 1906665 | Archaea | Archaea | 71.2 | 3.45e-13 | NR | HLD78554.1 | 1906665 | g31411 | i0 | 67.3 | 0.901840490797546 | 49 | 16 | 90.2 | 0 | 162 | 16 | 133 | 181 | HLD78554.1 hypothetical protein [archaeon] | diamond | 147 | 71.2 | 1 | Archaea | archaeon | ||||||||
| 30871594 | 30871594 | PRJNA674048_P_NODE_19494_length_200_cov_1.377483_g19291_i0 | PRJNA674048 | 19494 | 200 | 1.377483 | 2.754966 | archaeon | 1906665 | Archaea | Archaea | 82.4 | 2.09e-17 | NR | RYG65124.1 | 1906665 | g19291 | i0 | 84.1 | 0.66 | 44 | 7 | 66 | 0 | 200 | 69 | 172 | 215 | RYG65124.1 MAG: 30S ribosomal protein S5 [archaeon] | diamond | 132 | 82.4 | 1 | Archaea | archaeon | ||||||||
| 31661840 | 31661840 | PRJNA674048_P_NODE_32137_length_163_cov_0.912281_g31934_i0 | PRJNA674048 | 32137 | 163 | 0.912281 | 1.48701803 | archaeon | 1906665 | Archaea | Archaea | 44.3 | 0.00362 | NR | MDP2436889.1 | 1906665 | g31934 | i0 | 44.4 | 0.828220858895706 | 45 | 25 | 82.8 | 0 | 11 | 145 | 293 | 337 | MDP2436889.1 hypothetical protein [archaeon] | diamond | 135 | 44.3 | 1 | Archaea | archaeon | ||||||||
| 31946531 | 31946531 | PRJNA674048_P_NODE_29497_length_166_cov_0.888889_g29294_i0 | PRJNA674048 | 29497 | 166 | 0.888889 | 1.47555574 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 94 | 3.0300000000000003e-21 | NR | MEK9694268.1 | 2163009 | g29294 | i0 | 77.8 | 0.975903614457831 | 54 | 12 | 97.6 | 0 | 164 | 3 | 277 | 330 | MEK9694268.1 hypothetical protein [Candidatus Poseidoniales archaeon] | diamond | 162 | 94 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 31978279 | 31978279 | PRJNA674048_P_NODE_19418_length_200_cov_2.721854_g19215_i0 | PRJNA674048 | 19418 | 200 | 2.721854 | 5.443708 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 44.7 | 0.00452 | NR | MAQ04991.1 | 2026739 | g19215 | i0 | 39.6 | 0.795 | 53 | 30 | 79.5 | 1 | 186 | 28 | 530 | 580 | MAQ04991.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 159 | 44.7 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 32041677 | 32041677 | PRJNA674048_P_NODE_32838_length_162_cov_0.920354_g32635_i0 | PRJNA674048 | 32838 | 162 | 0.920354 | 1.49097348 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 100 | 1.29e-23 | NR | MCH7660952.1 | 2026739 | g32635 | i0 | 94.2 | 0.962962962962963 | 52 | 3 | 96.3 | 0 | 160 | 5 | 190 | 241 | MCH7660952.1 type II glyceraldehyde-3-phosphate dehydrogenase [Methanobacteriota archaeon] | diamond | 156 | 100 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 32484772 | 32484772 | PRJNA674048_P_NODE_31919_length_163_cov_0.912281_g31716_i0 | PRJNA674048 | 31919 | 163 | 0.912281 | 1.48701803 | archaeon | 1906665 | Archaea | Archaea | 48.1 | 1.53e-4 | NR | MDP2439624.1 | 1906665 | g31716 | i0 | 39.6 | 0.975460122699387 | 53 | 32 | 97.5 | 0 | 161 | 3 | 115 | 167 | MDP2439624.1 hypothetical protein [archaeon] | diamond | 159 | 48.1 | 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);;