contig_metadata
7 rows where bioproject = "PRJNA743294", tax_clade = "Methanomada 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 722088 | 722088 | PRJNA743294_P_NODE_41461_length_264_cov_9.743455_g41005_i0 | PRJNA743294 | 41461 | 264 | 9.743455 | 25.7227212 | Methanobacterium ferruginis | 710191 | Archaea | Archaea | 370 | 5.86e-98 | NTclustered | gi|2465756734|dbj|AP027738.1| | 710191 | g41005 | i0 | 92.366 | 126.011363636364 | 262 | 16 | 98 | 4 | 1 | 260 | 35426 | 35167 | Methanobacterium ferruginis NBRC 105197 DNA, complete genome | blastn | 33267 | 370 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium ferruginis | |
| 13475753 | 13475753 | PRJNA743294_P_NODE_151_length_2415_cov_10.653715_g109_i0 | PRJNA743294 | 151 | 2415 | 10.653715 | 257.28721725 | Methanobacterium alcaliphilum | 392018 | Archaea | Archaea | 3738 | 0 | NTclustered | gi|584298067|gb|KF882006.1| | 392018 | g109 | i0 | 94.7 | 172.520082815735 | 2415 | 115 | 99 | 12 | 5 | 2407 | 2645 | 232 | Methanobacterium alcaliphilum strain WeN4 23S ribosomal RNA gene, partial sequence | blastn | 416636 | 3738 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium alcaliphilum | |
| 13475827 | 13475827 | PRJNA743294_P_NODE_2431_length_944_cov_8.580941_g2108_i0 | PRJNA743294 | 2431 | 944 | 8.580941 | 81.00408304 | Methanobacterium flexile | 490098 | Archaea | Archaea | 1735 | 0 | NTclustered | gi|1161053746|gb|KY780618.1| | 490098 | g2108 | i0 | 100 | 95.1239406779661 | 939 | 0 | 99 | 0 | 6 | 944 | 1 | 939 | Methanobacterium flexile strain Z-7215 16S ribosomal RNA gene, partial sequence | blastn | 89797 | 1735 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium flexile | |
| 20324798 | 20324798 | PRJNA743294_P_NODE_52996_length_245_cov_2.686047_g52540_i0 | PRJNA743294 | 52996 | 245 | 2.686047 | 6.58081515 | Methanobacterium | 2160 | Archaea | Archaea | 294 | 3.33e-75 | NTclustered | gi|2874253877|emb|OY969932.1| | 176233 | g52540 | i0 | 89.655 | 81.9102040816327 | 232 | 23 | 95 | 1 | 2 | 233 | 29474 | 29704 | MAG: uncultured Methanobacteriaceae archaeon isolate MFD09286.bin.c.5 genome assembly, chromosome: 1 | blastn | 20068 | 296 | 0.993243243243243 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | uncultured Methanobacteriaceae archaeon | ||
| 20324819 | 20324819 | PRJNA743294_P_NODE_9276_length_517_cov_7.722973_g8820_i0 | PRJNA743294 | 9276 | 517 | 7.722973 | 39.92777041 | Methanobacterium | 2160 | Archaea | Archaea | 939 | 0 | NTclustered | gi|76443580|dbj|AB236053.1| | 176233 | g8820 | i0 | 100 | 102.007736943907 | 508 | 0 | 98 | 0 | 1 | 508 | 822 | 1329 | Uncultured Methanobacteriaceae archaeon gene for 16S rRNA, partial sequence, clone:NR-H2-A | blastn | 52738 | 944 | 0.994703389830508 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | uncultured Methanobacteriaceae archaeon | ||
| 28979156 | 28979156 | PRJNA743294_P_NODE_58548_length_232_cov_2.698113_g58092_i0 | PRJNA743294 | 58548 | 232 | 2.698113 | 6.25962216 | Methanopyri archaeon | 2599940 | Archaea | Archaea | 72.4 | 1.15e-12 | NR | NPB02643.1 | 2599940 | g58092 | i0 | 48.1 | 0.995689655172414 | 77 | 40 | 99.6 | 0 | 2 | 232 | 394 | 470 | NPB02643.1 ribosome biogenesis/translation initiation ATPase RLI [Methanopyri archaeon] | diamond | 231 | 72.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanopyri | Methanopyri archaeon | ||||
| 31538154 | 31538154 | PRJNA743294_P_NODE_4676_length_704_cov_2.076070_g4254_i0 | PRJNA743294 | 4676 | 704 | 2.07607 | 14.6155328 | Methanosphaera sp. | 2666342 | Archaea | Archaea | 57 | 2.24e-5 | NR | MEE3325473.1 | 2666342 | g4254 | i0 | 27.2 | 1.51704545454545 | 173 | 100 | 69.5 | 8 | 702 | 214 | 532 | 688 | MEE3325473.1 hypothetical protein [Methanosphaera sp.] | diamond | 1068 | 57 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera sp. |
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);;