contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA946307" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26645293 | 26645293 | PRJNA946307_P_NODE_104321_length_182_cov_2.142857_g103447_i0 | PRJNA946307 | 104321 | 182 | 2.142857 | 3.89999974 | Methanobacterium paludis | 868131 | Archaea | Archaea | 85.5 | 2.17e-19 | NR | WP_013825963.1 | 868131 | g103447 | i0 | 73.2 | 2.76923076923077 | 56 | 15 | 92.3 | 0 | 169 | 2 | 78 | 133 | WP_013825963.1 uL15m family ribosomal protein [Methanobacterium paludis] | diamond | 504 | 85.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium paludis | |
| 27057151 | 27057151 | PRJNA946307_P_NODE_71162_length_199_cov_2.973333_g70288_i0 | PRJNA946307 | 71162 | 199 | 2.973333 | 5.91693267 | Methanobacteriaceae archaeon | 2099680 | Archaea | Archaea | 64.3 | 4.92e-10 | NR | NYB51693.1 | 2099680 | g70288 | i0 | 93.9 | 0.49748743718593 | 33 | 2 | 49.7 | 0 | 100 | 2 | 48 | 80 | NYB51693.1 NAD(P)/FAD-dependent oxidoreductase [Methanobacteriaceae archaeon] | diamond | 99 | 64.3 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacteriaceae archaeon | ||
| 28478194 | 28478194 | PRJNA946307_P_NODE_107846_length_180_cov_4.885496_g106972_i0 | PRJNA946307 | 107846 | 180 | 4.885496 | 8.7938928 | Methanobacterium sp. | 2164 | Archaea | Archaea | 94 | 4.149999999999999e-23 | NR | MDD1775128.1 | 2164 | g106972 | i0 | 87.5 | 3.2 | 48 | 6 | 80 | 0 | 144 | 1 | 1 | 48 | MDD1775128.1 dinitrogenase iron-molybdenum cofactor biosynthesis protein [Methanobacterium sp.] | diamond | 576 | 94 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 29046622 | 29046622 | PRJNA946307_P_NODE_137628_length_168_cov_1.453782_g136754_i0 | PRJNA946307 | 137628 | 168 | 1.453782 | 2.44235376 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 56.6 | 1.73e-7 | NR | MDO5819915.1 | 66852 | g136754 | i0 | 60.9 | 1.64285714285714 | 46 | 14 | 75 | 1 | 165 | 40 | 195 | 240 | MDO5819915.1 RNA ligase family protein [Methanobrevibacter sp.] | diamond | 276 | 56.6 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 29204653 | 29204653 | PRJNA946307_P_NODE_81729_length_192_cov_6.356643_g80855_i0 | PRJNA946307 | 81729 | 192 | 6.356643 | 12.20475456 | Methanobacterium sp. | 2164 | Archaea | Archaea | 84 | 1.08e-19 | NR | MEN6592262.1 | 2164 | g80855 | i0 | 87 | 0.71875 | 46 | 6 | 71.9 | 0 | 20 | 157 | 1 | 46 | MEN6592262.1 hypothetical protein [Methanobacterium sp.] | diamond | 138 | 84 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 29236061 | 29236061 | PRJNA946307_P_NODE_153669_length_164_cov_0.904348_g152795_i0 | PRJNA946307 | 153669 | 164 | 0.904348 | 1.48313072 | Methanobacterium sp. PtaU1.Bin | 2164 | Archaea | Archaea | 102 | 1.66e-24 | NR | OPY20746.1 | 1811675 | g152795 | i0 | 96.2 | 0.951219512195122 | 52 | 2 | 95.1 | 0 | 7 | 162 | 217 | 268 | OPY20746.1 MAG: ferrous iron efflux protein F [Methanobacterium sp. PtaU1.Bin097] | diamond | 156 | 102 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. PtaU1.Bin097 | |
| 29962312 | 29962312 | PRJNA946307_P_NODE_75511_length_197_cov_3.162162_g74637_i0 | PRJNA946307 | 75511 | 197 | 3.162162 | 6.22945914 | Methanobacteriaceae archaeon | 2099680 | Archaea | Archaea | 85.1 | 1.97e-18 | NR | NYB25845.1 | 2099680 | g74637 | i0 | 69.8 | 0.959390862944162 | 63 | 18 | 95.9 | 1 | 7 | 195 | 107 | 168 | NYB25845.1 phosphoribosylanthranilate isomerase [Methanobacteriaceae archaeon] | diamond | 189 | 85.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacteriaceae archaeon | ||
| 30373372 | 30373372 | PRJNA946307_P_NODE_154432_length_164_cov_0.886957_g153558_i0 | PRJNA946307 | 154432 | 164 | 0.886957 | 1.45460948 | Methanobacterium sp. | 2164 | Archaea | Archaea | 85.1 | 8.87e-18 | NR | MDD1775540.1 | 2164 | g153558 | i0 | 79.6 | 0.896341463414634 | 49 | 10 | 89.6 | 0 | 148 | 2 | 316 | 364 | MDD1775540.1 pyridoxal phosphate-dependent aminotransferase [Methanobacterium sp.] | diamond | 147 | 85.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 30380032 | 30380032 | PRJNA946307_P_NODE_148212_length_165_cov_1.672414_g147338_i0 | PRJNA946307 | 148212 | 165 | 1.672414 | 2.7594831 | Methanobacterium | 2160 | Archaea | Archaea | 95.9 | 9.78e-22 | NR | MCE5214113.1 | 2164 | g147338 | i0 | 94.1 | 2.78181818181818 | 51 | 3 | 92.7 | 0 | 13 | 165 | 229 | 279 | MCE5214113.1 AAA family ATPase [Methanobacterium sp.] | diamond | 459 | 95.9 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 31036745 | 31036745 | PRJNA946307_P_NODE_128915_length_171_cov_2.147541_g128041_i0 | PRJNA946307 | 128915 | 171 | 2.147541 | 3.67229511 | Methanobacterium sp. PtaU1.Bin | 2164 | Archaea | Archaea | 70.5 | 1.25e-12 | NR | OPY19818.1 | 1811675 | g128041 | i0 | 86.8 | 1.33333333333333 | 38 | 5 | 66.7 | 0 | 157 | 44 | 233 | 270 | OPY19818.1 MAG: 2-oxoglutarate synthase subunit KorB [Methanobacterium sp. PtaU1.Bin097] | diamond | 228 | 70.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. PtaU1.Bin097 | |
| 31320895 | 31320895 | PRJNA946307_P_NODE_170455_length_155_cov_4.113208_g169581_i0 | PRJNA946307 | 170455 | 155 | 4.113208 | 6.3754724 | Methanobacteriaceae archaeon | 2099680 | Archaea | Archaea | 97.8 | 3.0099999999999995e-23 | NR | NYB27019.1 | 2099680 | g169581 | i0 | 89.1 | 0.890322580645161 | 46 | 5 | 89 | 0 | 140 | 3 | 18 | 63 | NYB27019.1 exodeoxyribonuclease III [Methanobacteriaceae archaeon] | diamond | 138 | 97.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacteriaceae archaeon | ||
| 32838100 | 32838100 | PRJNA946307_P_NODE_139120_length_167_cov_2.508475_g138246_i0 | PRJNA946307 | 139120 | 167 | 2.508475 | 4.18915325 | Methanosphaera sp. | 2666342 | Archaea | Archaea | 92.8 | 2.98e-20 | NR | WP_292537504.1 | 2666342 | g138246 | i0 | 97.8 | 0.808383233532934 | 45 | 1 | 80.8 | 0 | 18 | 152 | 311 | 355 | WP_292537504.1 formylmethanofuran dehydrogenase subunit A [Methanosphaera sp.] | diamond | 135 | 92.8 | 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);;