contig_metadata
9 rows where bioproject = "PRJNA1036688" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 169654 | 169654 | PRJNA1036688_P_NODE_5601_length_252_cov_1.762791_g5309_i0 | PRJNA1036688 | 5601 | 252 | 1.762791 | 4.44223332 | Methanoculleus chikugoensis | 118126 | Archaea | Archaea | 283 | 7.44e-72 | NTclustered | gi|2047647073|dbj|AP019781.1| | 118126 | g5309 | i0 | 86.957 | 75.7063492063492 | 253 | 32 | 100 | 1 | 1 | 252 | 2159490 | 2159238 | Methanoculleus chikugoensis MG62 DNA, complete genome | blastn | 19078 | 283 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus chikugoensis | |
| 1008085 | 1008085 | PRJNA1036688_P_NODE_2281_length_459_cov_2.272512_g1992_i0 | PRJNA1036688 | 2281 | 459 | 2.272512 | 10.43083008 | Methanothrix | 2222 | Archaea | Archaea | 523 | 7.849999999999998e-144 | NTclustered | gi|507148322|ref|NR_103125.1| | 2223 | g1992 | i0 | 98.644 | 165.294117647059 | 295 | 4 | 64 | 0 | 1 | 295 | 1819 | 2113 | Methanosaeta concilii strain GP6 23S ribosomal RNA gene, complete sequence | blastn | 75870 | 523 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 3996125 | 3996125 | PRJNA1036688_P_NODE_11204_length_158_cov_2.710744_g10912_i0 | PRJNA1036688 | 11204 | 158 | 2.710744 | 4.28297552 | uncultured Methanomicrobiales archaeon | 183760 | Archaea | Archaea | 246 | 5.58e-61 | NTclustered | gi|2874253666|emb|OY969100.1| | 183760 | g10912 | i0 | 94.904 | 224.664556962025 | 157 | 8 | 99 | 0 | 2 | 158 | 1372482 | 1372638 | MAG: uncultured Methanomicrobiales archaeon isolate MFD10007.bin.c.6 genome assembly, chromosome: 1 | blastn | 35497 | 246 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | uncultured Methanomicrobiales archaeon | |||
| 8661253 | 8661253 | PRJNA1036688_P_NODE_3187_length_368_cov_2.283988_g2897_i0 | PRJNA1036688 | 3187 | 368 | 2.283988 | 8.40507584 | Methanosphaerula | 475087 | Archaea | Archaea | 446 | 1.3699999999999999e-120 | NTclustered | gi|470483922|ref|NR_076620.1| | 475088 | g2897 | i0 | 88.649 | 146.75 | 370 | 37 | 100 | 4 | 1 | 368 | 1830 | 1464 | Methanosphaerula palustris strain E1-9c 23S ribosomal RNA gene, complete sequence | blastn | 54004 | 446 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanosphaerula | Methanosphaerula palustris | |
| 15035767 | 15035767 | PRJNA1036688_P_NODE_432_length_1100_cov_3.863594_g277_i0 | PRJNA1036688 | 432 | 1100 | 3.863594 | 42.499534 | Methanothrix | 2222 | Archaea | Archaea | 2026 | 0 | NTclustered | gi|507148322|ref|NR_103125.1| | 2223 | g277 | i0 | 99.909 | 226.567272727273 | 1100 | 1 | 100 | 0 | 1 | 1100 | 1825 | 726 | Methanosaeta concilii strain GP6 23S ribosomal RNA gene, complete sequence | blastn | 249224 | 2026 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 20570862 | 20570862 | PRJNA1036688_P_NODE_877_length_758_cov_2.436893_g655_i0 | PRJNA1036688 | 877 | 758 | 2.436893 | 18.47164894 | Methanothrix soehngenii | 2223 | Archaea | Archaea | 918 | 0 | NTclustered | gi|328927127|gb|CP002565.1| | 990316 | g655 | i0 | 99.8 | 73.5263852242744 | 500 | 1 | 100 | 0 | 1 | 500 | 293663 | 293164 | Methanosaeta concilii GP-6, complete genome | blastn | 55733 | 918 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 21410120 | 21410120 | PRJNA1036688_P_NODE_1637_length_550_cov_2.775828_g1357_i0 | PRJNA1036688 | 1637 | 550 | 2.775828 | 15.267054 | root | 1 | Root_unresolved | Root_unresolved | 924 | 0 | NTclustered | gi|44504|emb|X16932.1| | 2223 | g1357 | i0 | 97.761 | 99.72 | 536 | 12 | 97 | 0 | 1 | 536 | 1467 | 932 | Methanothrix soehngenii gene for 16S ribosomal RNA | blastn | 54846 | 924 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 22684960 | 22684960 | PRJNA1036688_P_NODE_9058_length_180_cov_3.244755_g8766_i0 | PRJNA1036688 | 9058 | 180 | 3.244755 | 5.840559 | Methanothrix | 2222 | Archaea | Archaea | 333 | 4.87e-87 | NTclustered | gi|507148322|ref|NR_103125.1| | 2223 | g8766 | i0 | 100 | 11.9 | 180 | 0 | 100 | 0 | 1 | 180 | 572 | 751 | Methanosaeta concilii strain GP6 23S ribosomal RNA gene, complete sequence | blastn | 2142 | 333 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 22684963 | 22684963 | PRJNA1036688_P_NODE_9498_length_175_cov_2.521739_g9206_i0 | PRJNA1036688 | 9498 | 175 | 2.521739 | 4.41304325 | Methanothrix | 2222 | Archaea | Archaea | 324 | 2.83e-84 | NTclustered | gi|507148322|ref|NR_103125.1| | 2223 | g9206 | i0 | 100 | 66.1885714285714 | 175 | 0 | 100 | 0 | 1 | 175 | 2227 | 2401 | Methanosaeta concilii strain GP6 23S ribosomal RNA gene, complete sequence | blastn | 11583 | 324 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii |
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);;