contig_metadata
12 rows where bioproject = "PRJNA533623", tax_clade = "Stenosarchaea group" and tax_phylum = "Methanobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4333204 | 4333204 | PRJNA533623_P_NODE_29744_length_416_cov_9.859155_g27974_i0 | PRJNA533623 | 29744 | 416 | 9.859155 | 41.0140848 | Halococcus qingdaonensis | 224402 | Archaea | Archaea | 691 | 0 | NTclustered | gi|2281256326|gb|CP101943.1| | 224402 | g27974 | i0 | 98.966 | 1.90384615384615 | 387 | 2 | 93 | 2 | 8 | 394 | 2477290 | 2477674 | Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome | blastn | 792 | 691 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus qingdaonensis | |
| 5609693 | 5609693 | PRJNA533623_P_NODE_15605_length_597_cov_9.809701_g13894_i0 | PRJNA533623 | 15605 | 597 | 9.809701 | 58.56391497 | Salinirubellus litoreus | 3131999 | Archaea | Archaea | 54.7 | 0.016 | NTclustered | gi|2700494409|gb|CP147841.1| | 3131999 | g13894 | i0 | 100 | 0.0485762144053601 | 29 | 0 | 5 | 0 | 483 | 511 | 2445208 | 2445236 | Salinirubellus litoreus strain SYNS196 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Salinirubellus | Salinirubellus litoreus | |
| 7496058 | 7496058 | PRJNA533623_P_NODE_45586_length_315_cov_3.913386_g43810_i0 | PRJNA533623 | 45586 | 315 | 3.913386 | 12.3271659 | Methanothrix | 2222 | Archaea | Archaea | 505 | 1.8799999999999995e-138 | NTclustered | gi|2133328945|gb|CP086219.1| | 90426 | g43810 | i0 | 99.283 | 1.77142857142857 | 279 | 2 | 89 | 0 | 14 | 292 | 1633763 | 1633485 | MAG: Methanothrix sp. isolate MAG 281 chromosome | blastn | 558 | 505 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 8158758 | 8158758 | PRJNA533623_P_NODE_15707_length_595_cov_8.595506_g13996_i0 | PRJNA533623 | 15707 | 595 | 8.595506 | 51.1432607 | Haloferax sp. S1W | 3377110 | Archaea | Archaea | 84.2 | 2.09e-11 | NTclustered | gi|2845109985|gb|CP172595.1| | 3377110 | g13996 | i0 | 90.476 | 0.105882352941176 | 63 | 6 | 11 | 0 | 481 | 543 | 648036 | 648098 | Haloferax sp. S1W chromosome, complete genome | blastn | 63 | 84.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax sp. S1W | |
| 20908970 | 20908970 | PRJNA533623_P_NODE_60997_length_250_cov_4.238095_g59217_i0 | PRJNA533623 | 60997 | 250 | 4.238095 | 10.5952375 | Halobaculum halobium | 3032281 | Archaea | Archaea | 176 | 1.2899999999999999e-39 | NTclustered | gi|2511738011|gb|CP126159.1| | 3032281 | g59217 | i0 | 83 | 11.928 | 200 | 28 | 79 | 4 | 13 | 209 | 286422 | 286618 | Halobaculum halobium strain SYNS20 plasmid unnamed1, complete sequence | blastn | 2982 | 176 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum halobium | |
| 27520112 | 27520112 | PRJNA533623_P_NODE_15183_length_605_cov_4.143382_g13480_i0 | PRJNA533623 | 15183 | 605 | 4.143382 | 25.0674611 | Methanosarcina sp. | 2213 | Archaea | Archaea | 90.9 | 8.09e-20 | NR | HET8689612.1 | 2213 | g13480 | i0 | 43.7 | 0.510743801652893 | 103 | 55 | 51.1 | 1 | 360 | 52 | 9 | 108 | HET8689612.1 hypothetical protein [Methanosarcina sp.] | diamond | 309 | 90.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 28814377 | 28814377 | PRJNA533623_P_NODE_21268_length_504_cov_18.040632_g19520_i0 | PRJNA533623 | 21268 | 504 | 18.040632 | 90.92478528 | Natrinema amylolyticum | 2878679 | Archaea | Archaea | 171 | 1.16e-50 | NR | WP_226482782.1 | 2878679 | g19520 | i0 | 81.1 | 1.32142857142857 | 111 | 21 | 66.1 | 0 | 165 | 497 | 1 | 111 | WP_226482782.1 bifunctional 4-hydroxy-2-oxoglutarate aldolase/2-dehydro-3-deoxy-phosphogluconate aldolase [Natrinema amylolyticum] | diamond | 666 | 171 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema amylolyticum | |
| 29951435 | 29951435 | PRJNA533623_P_NODE_72411_length_212_cov_10.933775_g70630_i0 | PRJNA533623 | 72411 | 212 | 10.933775 | 23.179603 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 43.1 | 0.00386 | NR | MCK5216355.1 | 2250255 | g70630 | i0 | 54.1 | 0.523584905660377 | 37 | 17 | 52.4 | 0 | 164 | 54 | 56 | 92 | MCK5216355.1 hypothetical protein [Methanosarcinales archaeon] | diamond | 111 | 43.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 30140546 | 30140546 | PRJNA533623_P_NODE_22912_length_484_cov_7.938534_g21156_i0 | PRJNA533623 | 22912 | 484 | 7.938534 | 38.42250456 | Methanogenium sp. | 2196 | Archaea | Archaea | 91.7 | 2.7e-18 | NR | MFA5396188.1 | 2196 | g21156 | i0 | 47.5 | 1.86570247933884 | 101 | 52 | 62 | 1 | 431 | 132 | 267 | 367 | MFA5396188.1 RNA ligase family protein [Methanogenium sp.] | diamond | 903 | 91.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanogenium | Methanogenium sp. | |
| 32037666 | 32037666 | PRJNA533623_P_NODE_3418_length_1184_cov_59.008014_g2421_i0 | PRJNA533623 | 3418 | 1184 | 59.008014 | 698.65488576 | Methanolobus sp. | 1874737 | Archaea | Archaea | 159 | 1.0699999999999998e-41 | NR | WP_305310995.1 | 1874737 | g2421 | i0 | 73.5 | 0.248310810810811 | 98 | 24 | 24.8 | 1 | 558 | 851 | 199 | 294 | WP_305310995.1 NUMOD3 domain-containing DNA-binding protein [Methanolobus sp.] | diamond | 294 | 159 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus sp. | |
| 32354340 | 32354340 | PRJNA533623_P_NODE_35019_length_375_cov_16.796178_g33247_i0 | PRJNA533623 | 35019 | 375 | 16.796178 | 62.9856675 | Methanosarcina sp. | 2213 | Archaea | Archaea | 169 | 1.16e-50 | NR | HET8686855.1 | 2213 | g33247 | i0 | 71.9 | 0.968 | 121 | 33 | 96 | 1 | 372 | 13 | 88 | 208 | HET8686855.1 SDR family oxidoreductase [Methanosarcina sp.] | diamond | 363 | 169 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 32890225 | 32890225 | PRJNA533623_P_NODE_5860_length_947_cov_10.857788_g4583_i0 | PRJNA533623 | 5860 | 947 | 10.857788 | 102.82325236 | Methanomicrobiales archaeon | 2184052 | Archaea | Archaea | 47 | 0.0336 | NR | NLL09360.1 | 2184052 | g4583 | i0 | 28.1 | 0.28194297782471 | 89 | 59 | 26.9 | 2 | 429 | 683 | 87 | 174 | NLL09360.1 hypothetical protein [Methanomicrobiales archaeon] | diamond | 267 | 47 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiales 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);;