contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA533623" and tax_clade = "Stenosarchaea group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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);;