contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1240804" and tax_clade = "Methanomada 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1049863 | 1049863 | PRJNA1240804_P_NODE_119161_length_167_cov_0.881356_g118795_i0 | PRJNA1240804 | 119161 | 167 | 0.881356 | 1.47186452 | Methanobacterium | 2160 | Archaea | Archaea | 255 | 9.950000000000001e-64 | NTclustered | gi|1297867845|gb|CP017766.1| | 59277 | g118795 | i0 | 96.732 | 9.32335329341317 | 153 | 5 | 92 | 0 | 1 | 153 | 2398264 | 2398416 | Methanobacterium subterraneum strain MO-MB1 chromosome, complete genome | blastn | 1557 | 255 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium subterraneum | |
| 9276762 | 9276762 | PRJNA1240804_P_NODE_55028_length_212_cov_0.938650_g54662_i0 | PRJNA1240804 | 55028 | 212 | 0.93865 | 1.989938 | uncultured Methanobacterium sp. | 176306 | Archaea | Archaea | 259 | 1.02e-64 | NTclustered | gi|2621703503|emb|OY762552.1| | 176306 | g54662 | i0 | 90.355 | 4.56132075471698 | 197 | 19 | 93 | 0 | 2 | 198 | 1161598 | 1161794 | MAG: uncultured Methanobacterium sp. isolate 3f2017ab-9e69-417f-80a5-32741c1572f8 genome assembly, chromosome: 1 | blastn | 967 | 259 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | uncultured Methanobacterium sp. | |
| 11253675 | 11253675 | PRJNA1240804_P_NODE_77349_length_188_cov_1.568345_g76983_i0 | PRJNA1240804 | 77349 | 188 | 1.568345 | 2.9484886 | Methanobrevibacter | 2172 | Archaea | Archaea | 289 | 1.13e-73 | NTclustered | gi|2791693311|gb|CP144200.1| | 2173 | g76983 | i0 | 96.552 | 107.037234042553 | 174 | 6 | 93 | 0 | 15 | 188 | 1285789 | 1285962 | Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome | blastn | 20123 | 289 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 16352603 | 16352603 | PRJNA1240804_P_NODE_37713_length_243_cov_1.515464_g37347_i0 | PRJNA1240804 | 37713 | 243 | 1.515464 | 3.68257752 | root | 1 | Root_unresolved | Root_unresolved | 387 | 5.29e-103 | NTclustered | gi|110180137|gb|DQ649323.1| | 2162 | g37347 | i0 | 96.97 | 98.6666666666667 | 231 | 5 | 94 | 2 | 15 | 243 | 67 | 297 | Methanobacterium formicicum strain 14 16S ribosomal RNA gene, partial sequence | blastn | 23976 | 387 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium formicicum | |
| 16926537 | 16926537 | PRJNA1240804_P_NODE_94774_length_177_cov_0.828125_g94408_i0 | PRJNA1240804 | 94774 | 177 | 0.828125 | 1.46578125 | Methanobacterium sp. ERen5 | 2977359 | Archaea | Archaea | 154 | 3.98e-33 | NTclustered | gi|2264313079|gb|CP099988.1| | 2977359 | g94408 | i0 | 88.281 | 2.75706214689266 | 128 | 15 | 72 | 0 | 1 | 128 | 1456930 | 1456803 | MAG: Methanobacterium sp. ERen5 chromosome, complete genome | blastn | 488 | 154 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. ERen5 | |
| 20176033 | 20176033 | PRJNA1240804_P_NODE_104516_length_170_cov_1.743802_g104150_i0 | PRJNA1240804 | 104516 | 170 | 1.743802 | 2.9644634 | Methanobacterium | 2160 | Archaea | Archaea | 265 | 1.68e-66 | NTclustered | gi|1297867845|gb|CP017766.1| | 59277 | g104150 | i0 | 98.039 | 47.5058823529412 | 153 | 2 | 89 | 1 | 14 | 165 | 1149394 | 1149546 | Methanobacterium subterraneum strain MO-MB1 chromosome, complete genome | blastn | 8076 | 265 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium subterraneum | |
| 20176292 | 20176292 | PRJNA1240804_P_NODE_24476_length_288_cov_1.907950_g24110_i0 | PRJNA1240804 | 24476 | 288 | 1.90795 | 5.494896 | root | 1 | Root_unresolved | Root_unresolved | 56.5 | 0.002 | NTclustered | gi|1294447101|gb|CP017803.1| | 2173 | g24110 | i0 | 97.059 | 12.5277777777778 | 34 | 0 | 12 | 1 | 134 | 167 | 265516 | 265484 | Methanobrevibacter smithii strain KB11 chromosome, complete genome | blastn | 3608 | 56.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 23299890 | 23299890 | PRJNA1240804_P_NODE_143179_length_163_cov_0.912281_g142813_i0 | PRJNA1240804 | 143179 | 163 | 0.912281 | 1.48701803 | Methanosphaera sp. ISO3-F5 | 1452353 | Archaea | Archaea | 69.4 | 1.35e-7 | NTclustered | gi|2695672494|gb|CP118753.2| | 1452353 | g142813 | i0 | 77.966 | 1.4601226993865 | 118 | 21 | 69 | 3 | 17 | 129 | 1474151 | 1474268 | Methanosphaera sp. ISO3-F5 chromosome, complete genome | blastn | 238 | 69.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera sp. ISO3-F5 | |
| 24001988 | 24001988 | PRJNA1240804_P_NODE_132879_length_165_cov_0.896552_g132513_i0 | PRJNA1240804 | 132879 | 165 | 0.896552 | 1.4793108 | Methanobacterium | 2160 | Archaea | Archaea | 250 | 4.5599999999999996e-62 | NTclustered | gi|1297867845|gb|CP017766.1| | 59277 | g132513 | i0 | 96.104 | 17.1454545454545 | 154 | 4 | 92 | 2 | 12 | 163 | 1409873 | 1410026 | Methanobacterium subterraneum strain MO-MB1 chromosome, complete genome | blastn | 2829 | 250 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium subterraneum |
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);;