contig_metadata
13 rows where bioproject = "PRJNA438687" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3642225 | 3642225 | PRJNA438687_S_NODE_7923_length_153_cov_4.652542_g7833_i0 | PRJNA438687 | 7923 | 153 | 4.652542 | 7.11838926 | root | 1 | Root_unresolved | Root_unresolved | 278 | 1.9e-70 | NTclustered | gi|507148322|ref|NR_103125.1| | 2223 | g7833 | i0 | 99.346 | 12.4509803921569 | 153 | 1 | 100 | 0 | 1 | 153 | 663 | 511 | Methanosaeta concilii strain GP6 23S ribosomal RNA gene, complete sequence | blastn | 1905 | 278 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 6194203 | 6194203 | PRJNA438687_S_NODE_2845_length_265_cov_3.926087_g2755_i0 | PRJNA438687 | 2845 | 265 | 3.926087 | 10.40413055 | Methanothrix | 2222 | Archaea | Archaea | 473 | 4.3599999999999987e-129 | NTclustered | gi|507148322|ref|NR_103125.1| | 2223 | g2755 | i0 | 98.868 | 174.988679245283 | 265 | 3 | 100 | 0 | 1 | 265 | 2615 | 2351 | Methanosaeta concilii strain GP6 23S ribosomal RNA gene, complete sequence | blastn | 46372 | 473 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 8088498 | 8088498 | PRJNA438687_S_NODE_3167_length_251_cov_3.314815_g3077_i0 | PRJNA438687 | 3167 | 251 | 3.314815 | 8.32018565 | uncultured Methanocorpusculum sp. | 176309 | Archaea | Archaea | 455 | 1.48e-123 | NTclustered | gi|2621784620|emb|OY781078.1| | 176309 | g3077 | i0 | 100 | 139.549800796813 | 246 | 0 | 98 | 0 | 6 | 251 | 399198 | 399443 | MAG: uncultured Methanocorpusculum sp. isolate da2e5db0-0b8c-42b4-9ad7-c040378b94a4 genome assembly, chromosome: 1 | blastn | 35027 | 455 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocorpusculaceae | Methanocorpusculum | uncultured Methanocorpusculum sp. | |
| 8088598 | 8088598 | PRJNA438687_S_NODE_8227_length_150_cov_1.913043_g8137_i0 | PRJNA438687 | 8227 | 150 | 1.913043 | 2.8695645 | Methanomassiliicoccaceae archaeon | 2052168 | Archaea | Archaea | 58.4 | 2.63e-4 | NTclustered | gi|2621703346|emb|OY760646.1| | 2052168 | g8137 | i0 | 100 | 0.206666666666667 | 31 | 0 | 21 | 0 | 1 | 31 | 162562 | 162532 | MAG: Methanomassiliicoccaceae archaeon isolate 2dded12f-1c8b-4e4a-b374-f87b1937d54c genome assembly, chromosome: 1 | blastn | 31 | 58.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccaceae | Methanomassiliicoccaceae archaeon | |||
| 12569979 | 12569979 | PRJNA438687_S_NODE_1490_length_334_cov_4.090301_g1400_i0 | PRJNA438687 | 1490 | 334 | 4.090301 | 13.66160534 | Methanothrix | 2222 | Archaea | Archaea | 571 | 1.95e-158 | NTclustered | gi|507148322|ref|NR_103125.1| | 2223 | g1400 | i0 | 97.598 | 104.88622754491 | 333 | 8 | 99 | 0 | 2 | 334 | 369 | 37 | Methanosaeta concilii strain GP6 23S ribosomal RNA gene, complete sequence | blastn | 35032 | 571 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 12569989 | 12569989 | PRJNA438687_S_NODE_2230_length_295_cov_2.888462_g2140_i0 | PRJNA438687 | 2230 | 295 | 2.888462 | 8.5209629 | Methanothrix | 2222 | Archaea | Archaea | 518 | 2.25e-142 | NTclustered | gi|507148322|ref|NR_103125.1| | 2223 | g2140 | i0 | 98.305 | 41.6372881355932 | 295 | 5 | 100 | 0 | 1 | 295 | 1812 | 1518 | Methanosaeta concilii strain GP6 23S ribosomal RNA gene, complete sequence | blastn | 12283 | 518 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 12570077 | 12570077 | PRJNA438687_S_NODE_6130_length_177_cov_2.838028_g6040_i0 | PRJNA438687 | 6130 | 177 | 2.838028 | 5.02330956 | root | 1 | Root_unresolved | Root_unresolved | 311 | 2.23e-80 | NTclustered | gi|636559125|ref|NR_115182.1| | 2193 | g6040 | i0 | 98.305 | 105.994350282486 | 177 | 3 | 100 | 0 | 1 | 177 | 1336 | 1160 | Methanocorpusculum parvum strain DSM 3823 16S ribosomal RNA, partial sequence | blastn | 18761 | 311 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocorpusculaceae | Methanocorpusculum | Methanocorpusculum parvum | |
| 13844726 | 13844726 | PRJNA438687_S_NODE_3651_length_233_cov_1.661616_g3561_i0 | PRJNA438687 | 3651 | 233 | 1.661616 | 3.87156528 | root | 1 | Root_unresolved | Root_unresolved | 425 | 1.07e-114 | NTclustered | gi|636559125|ref|NR_115182.1| | 2193 | g3561 | i0 | 99.571 | 99.9742489270386 | 233 | 1 | 100 | 0 | 1 | 233 | 468 | 700 | Methanocorpusculum parvum strain DSM 3823 16S ribosomal RNA, partial sequence | blastn | 23294 | 425 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocorpusculaceae | Methanocorpusculum | Methanocorpusculum parvum | |
| 13844740 | 13844740 | PRJNA438687_S_NODE_4391_length_212_cov_3.338983_g4301_i0 | PRJNA438687 | 4391 | 212 | 3.338983 | 7.07864396 | Methanocorpusculum | 2192 | Archaea | Archaea | 359 | 9.81e-95 | NTclustered | gi|470481509|ref|NR_076479.1| | 83984 | g4301 | i0 | 97.608 | 112.075471698113 | 209 | 5 | 99 | 0 | 3 | 211 | 1017 | 1225 | Methanocorpusculum labreanum strain Z 23S ribosomal RNA gene, complete sequence | blastn | 23760 | 359 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocorpusculaceae | Methanocorpusculum | Methanocorpusculum labreanum | |
| 18287028 | 18287028 | PRJNA438687_S_NODE_7435_length_159_cov_1.467742_g7345_i0 | PRJNA438687 | 7435 | 159 | 1.467742 | 2.33370978 | Candidatus Methanosuratincola petrocarbonis (ex Vanwonterghem et al. 2016) | 1867261 | Archaea | Archaea | 54.7 | 0.004 | NTclustered | gi|2551788334|gb|CP130488.1| | 1867261 | g7345 | i0 | 94.286 | 0.220125786163522 | 35 | 2 | 22 | 0 | 77 | 111 | 1407952 | 1407918 | MAG: Candidatus Methanosuratincola petrocarbonis isolate LWZ-6 chromosome, complete genome | blastn | 35 | 54.7 | 1 | Archaea | Thermoproteati | Thermoproteota | Methanosuratincolia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanosuratincola (ex Vanwonterghem et al. 2016) | Candidatus Methanosuratincola petrocarbonis (ex Vanwonterghem et al. 2016) | ||
| 24043112 | 24043112 | PRJNA438687_S_NODE_7519_length_158_cov_1.243902_g7429_i0 | PRJNA438687 | 7519 | 158 | 1.243902 | 1.96536516 | root | 1 | Root_unresolved | Root_unresolved | 287 | 3.29e-73 | NTclustered | gi|745147048|gb|KP258755.1| | 176232 | g7429 | i0 | 99.367 | 100 | 158 | 1 | 100 | 0 | 1 | 158 | 579 | 422 | Uncultured Methanosaetaceae archaeon clone A151_1 16S ribosomal RNA gene, partial sequence | blastn | 15800 | 287 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | uncultured Methanotrichaceae archaeon | ||
| 24661625 | 24661625 | PRJNA438687_S_NODE_7840_length_154_cov_2.588235_g7750_i0 | PRJNA438687 | 7840 | 154 | 2.588235 | 3.9858819 | Methanothrix sp. | 90426 | Archaea | Archaea | 252 | 1.16e-62 | NTclustered | gi|2626216449|emb|OY821645.1| | 90426 | g7750 | i0 | 96.104 | 14.9480519480519 | 154 | 6 | 100 | 0 | 1 | 154 | 826747 | 826900 | MAG: Methanothrix sp. isolate d1628e35-7b52-4540-a147-c2ca1342adce genome assembly, chromosome: 1 | blastn | 2302 | 252 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 25317356 | 25317356 | PRJNA438687_S_NODE_2480_length_281_cov_3.093496_g2390_i0 | PRJNA438687 | 2480 | 281 | 3.093496 | 8.69272376 | root | 1 | Root_unresolved | Root_unresolved | 429 | 1.02e-115 | NTclustered | gi|636559125|ref|NR_115182.1| | 2193 | g2390 | i0 | 94.326 | 101.950177935943 | 282 | 12 | 99 | 4 | 1 | 280 | 895 | 1174 | Methanocorpusculum parvum strain DSM 3823 16S ribosomal RNA, partial sequence | blastn | 28648 | 429 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocorpusculaceae | Methanocorpusculum | Methanocorpusculum parvum |
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);;