contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA781427" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3313213 | 3313213 | PRJNA781427_P_NODE_92183_length_243_cov_0.905882_g91299_i0 | PRJNA781427 | 92183 | 243 | 0.905882 | 2.20129326 | Methanomethylovorans sp. | 2758717 | Archaea | Archaea | 160 | 8.129999999999998e-48 | NR | HML27079.1 | 2758717 | g91299 | i0 | 98.8 | 0.987654320987654 | 80 | 1 | 98.8 | 0 | 2 | 241 | 29 | 108 | HML27079.1 response regulator [Methanomethylovorans sp.] | diamond | 240 | 160 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanomethylovorans | Methanomethylovorans sp. | |
| 17339907 | 17339907 | PRJNA781427_P_NODE_82054_length_248_cov_0.880000_g81170_i0 | PRJNA781427 | 82054 | 248 | 0.88 | 2.1824 | Candidatus Methanophagales archaeon | 2056316 | Archaea | Archaea | 157 | 5.04e-45 | NR | MCW3135140.1 | 2056316 | g81170 | i0 | 93.8 | 4.8991935483871 | 81 | 5 | 98 | 0 | 6 | 248 | 74 | 154 | MCW3135140.1 phosphoribosylformylglycinamidine cyclo-ligase [Candidatus Methanophagales archaeon] | diamond | 1215 | 157 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Candidatus Methanophagales | Candidatus Methanophagales archaeon | |||
| 27022012 | 27022012 | PRJNA781427_P_NODE_83102_length_247_cov_0.885057_g82218_i0 | PRJNA781427 | 83102 | 247 | 0.885057 | 2.18609079 | Candidatus Methanophagaceaer archaeon GoMg4 | 2081357 | Archaea | Archaea | 111 | 2.29e-26 | NR | NMX22070.1 | 2081357 | g82218 | i0 | 85 | 0.728744939271255 | 60 | 9 | 72.9 | 0 | 246 | 67 | 914 | 973 | NMX22070.1 hypothetical protein [Candidatus Methanophagaceaer archaeon GoMg4] | diamond | 180 | 111 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Candidatus Methanophagales | Candidatus Methanophagaceae | Candidatus Methanophagaceaer archaeon GoMg4 | ||
| 28790388 | 28790388 | PRJNA781427_P_NODE_77967_length_250_cov_0.870056_g77083_i0 | PRJNA781427 | 77967 | 250 | 0.870056 | 2.17514 | Methanosarcinaceae archaeon | 1945595 | Archaea | Archaea | 114 | 1.96e-29 | NR | HJH30374.1 | 1945595 | g77083 | i0 | 96.3 | 0.648 | 54 | 2 | 64.8 | 0 | 164 | 3 | 1 | 54 | HJH30374.1 tetrahydromethanopterin S-methyltransferase subunit A [Methanosarcinaceae archaeon] | diamond | 162 | 114 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcinaceae archaeon | ||
| 29011871 | 29011871 | PRJNA781427_P_NODE_92708_length_243_cov_0.905882_g91824_i0 | PRJNA781427 | 92708 | 243 | 0.905882 | 2.20129326 | Candidatus Methanophaga sp. ANME-1 ERB7 | 2759913 | Archaea | Archaea | 152 | 5.39e-41 | NR | AAU83961.1 | 2759913 | g91824 | i0 | 91 | 0.962962962962963 | 78 | 7 | 96.3 | 0 | 236 | 3 | 409 | 486 | AAU83961.1 conserved hypothetical protein [Candidatus Methanophaga sp. ANME-1 ERB7] | diamond | 234 | 152 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Candidatus Methanophagales | Candidatus Methanophagaceae | Candidatus Methanophaga | Candidatus Methanophaga sp. ANME-1 ERB7 | |
| 29178869 | 29178869 | PRJNA781427_P_NODE_69529_length_262_cov_1.629630_g68645_i0 | PRJNA781427 | 69529 | 262 | 1.62963 | 4.2696306 | Methanolobus | 2220 | Archaea | Archaea | 55.1 | 2.08e-6 | NR | WP_246276026.1 | 536044 | g68645 | i0 | 74.2 | 0.709923664122137 | 31 | 8 | 35.5 | 0 | 260 | 168 | 726 | 756 | WP_246276026.1 anaerobic ribonucleoside-triphosphate reductase [Methanolobus zinderi] | diamond | 186 | 55.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus zinderi | |
| 29232685 | 29232685 | PRJNA781427_P_NODE_77809_length_250_cov_0.870056_g76925_i0 | PRJNA781427 | 77809 | 250 | 0.870056 | 2.17514 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 62 | 3.03e-9 | NR | MCD4797922.1 | 2250255 | g76925 | i0 | 100 | 0.348 | 29 | 0 | 34.8 | 0 | 162 | 248 | 2 | 30 | MCD4797922.1 phosphoribosylformimino-5-aminoimidazole carboxamide ribotide isomerase [Methanosarcinales archaeon] | diamond | 87 | 62 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 30116673 | 30116673 | PRJNA781427_P_NODE_88072_length_245_cov_0.895349_g87188_i0 | PRJNA781427 | 88072 | 245 | 0.895349 | 2.19360505 | Methanosarcinaceae archaeon | 1945595 | Archaea | Archaea | 121 | 1.5599999999999998e-31 | NR | MBN2489050.1 | 1945595 | g87188 | i0 | 75 | 2.79183673469388 | 76 | 19 | 93.1 | 0 | 17 | 244 | 207 | 282 | MBN2489050.1 energy-coupling factor transporter transmembrane protein EcfT [Methanosarcinaceae archaeon] | diamond | 684 | 121 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcinaceae archaeon | ||
| 30284511 | 30284511 | PRJNA781427_P_NODE_89552_length_244_cov_0.900585_g88668_i0 | PRJNA781427 | 89552 | 244 | 0.900585 | 2.1974274 | Methanomethylovorans | 101191 | Archaea | Archaea | 163 | 8.289999999999999e-45 | NR | WP_015324480.1 | 101192 | g88668 | i0 | 95 | 1.9672131147541 | 80 | 4 | 98.4 | 0 | 242 | 3 | 162 | 241 | WP_015324480.1 CoB-CoM heterodisulfide reductase HdrA2 [Methanomethylovorans hollandica] | diamond | 480 | 164 | 0.99390243902439 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanomethylovorans | Methanomethylovorans hollandica | |
| 30906861 | 30906861 | PRJNA781427_P_NODE_76614_length_250_cov_0.870056_g75730_i0 | PRJNA781427 | 76614 | 250 | 0.870056 | 2.17514 | Candidatus Methanophaga sp. AG-394-G21 | 2081361 | Archaea | Archaea | 76.6 | 8.53e-15 | NR | NAS88412.1 | 2081361 | g75730 | i0 | 86.7 | 0.54 | 45 | 6 | 54 | 0 | 115 | 249 | 3 | 47 | NAS88412.1 hypothetical protein [Candidatus Methanophaga sp. AG-394-G21] | diamond | 135 | 76.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Candidatus Methanophagales | Candidatus Methanophagaceae | Candidatus Methanophaga | Candidatus Methanophaga sp. AG-394-G21 | |
| 31823475 | 31823475 | PRJNA781427_P_NODE_90337_length_244_cov_0.900585_g89453_i0 | PRJNA781427 | 90337 | 244 | 0.900585 | 2.1974274 | Methanosarcinaceae archaeon | 1945595 | Archaea | Archaea | 156 | 5.2e-44 | NR | HJH28492.1 | 1945595 | g89453 | i0 | 90.1 | 0.995901639344262 | 81 | 8 | 99.6 | 0 | 2 | 244 | 266 | 346 | HJH28492.1 IS21 family transposase [Methanosarcinaceae archaeon] | diamond | 243 | 156 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcinaceae archaeon | ||
| 31855165 | 31855165 | PRJNA781427_P_NODE_88517_length_245_cov_0.895349_g87633_i0 | PRJNA781427 | 88517 | 245 | 0.895349 | 2.19360505 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 165 | 1.07e-50 | NR | MCD4799850.1 | 2250255 | g87633 | i0 | 97.5 | 1.98367346938776 | 81 | 2 | 99.2 | 0 | 2 | 244 | 26 | 106 | MCD4799850.1 hypothetical protein [Methanosarcinales archaeon] | diamond | 486 | 165 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 31981688 | 31981688 | PRJNA781427_P_NODE_90398_length_244_cov_0.900585_g89514_i0 | PRJNA781427 | 90398 | 244 | 0.900585 | 2.1974274 | Candidatus Methanophagales archaeon | 2056316 | Archaea | Archaea | 135 | 3.59e-38 | NR | HID19391.1 | 2056316 | g89514 | i0 | 79 | 0.995901639344262 | 81 | 17 | 99.6 | 0 | 244 | 2 | 42 | 122 | HID19391.1 HAD family hydrolase [Candidatus Methanophagales archaeon] | diamond | 243 | 135 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Candidatus Methanophagales | Candidatus Methanophagales archaeon | |||
| 32244595 | 32244595 | PRJNA781427_P_NODE_74598_length_251_cov_0.865169_g73714_i0 | PRJNA781427 | 74598 | 251 | 0.865169 | 2.17157419 | root | 1 | Root_unresolved | Root_unresolved | 149 | 7.319999999999998e-42 | NR | WP_321419204.1 | 183759 | g73714 | i0 | 88 | 4.9601593625498 | 83 | 10 | 99.2 | 0 | 3 | 251 | 131 | 213 | WP_321419204.1 UDP-N-acetylglucosamine 4,6-dehydratase family protein [uncultured Methanomethylovorans sp.] | diamond | 1245 | 149 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanomethylovorans | uncultured Methanomethylovorans sp. | |
| 32393159 | 32393159 | PRJNA781427_P_NODE_87579_length_245_cov_0.895349_g86695_i0 | PRJNA781427 | 87579 | 245 | 0.895349 | 2.19360505 | Candidatus Methanoperedens nitroreducens | 1392997 | Archaea | Archaea | 65.1 | 2.38e-10 | NR | WP_048091670.1 | 1392998 | g86695 | i0 | 44.6 | 1.76326530612245 | 83 | 44 | 99.2 | 2 | 3 | 245 | 49 | 131 | WP_048091670.1 phage head morphogenesis protein [Candidatus Methanoperedens nitroreducens] | diamond | 432 | 65.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens nitratireducens | |
| 32402572 | 32402572 | PRJNA781427_P_NODE_78499_length_249_cov_0.875000_g77615_i0 | PRJNA781427 | 78499 | 249 | 0.875 | 2.17875 | root | 1 | Root_unresolved | Root_unresolved | 93.6 | 5.18e-20 | NR | WP_006165197.1 | 68911 | g77615 | i0 | 56 | 2.02409638554217 | 84 | 33 | 97.6 | 2 | 5 | 247 | 533 | 615 | WP_006165197.1 hypothetical protein [Natrialba chahannaoensis] | diamond | 504 | 94.4 | 0.991525423728813 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrialba | Natrialba chahannaoensis |
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);;