contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA474426" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26854984 | 26854984 | PRJNA474426_P_NODE_19981_length_224_cov_0.880000_g19776_i0 | PRJNA474426 | 19981 | 224 | 0.88 | 1.9712 | Methanosarcina sp. | 2213 | Archaea | Archaea | 87 | 6.81e-18 | NR | HET8687757.1 | 2213 | g19776 | i0 | 51.4 | 0.964285714285714 | 72 | 34 | 95.1 | 1 | 213 | 1 | 353 | 424 | HET8687757.1 toprim domain-containing protein [Methanosarcina sp.] | diamond | 216 | 87 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 28750034 | 28750034 | PRJNA474426_P_NODE_17707_length_241_cov_2.166667_g17502_i0 | PRJNA474426 | 17707 | 241 | 2.166667 | 5.22166747 | Methanoculleus sp. 7T | 2937282 | Archaea | Archaea | 66.2 | 3.61e-11 | NR | WP_248535981.1 | 2937282 | g17502 | i0 | 47.6 | 1.0207468879668 | 82 | 38 | 95.9 | 1 | 241 | 11 | 43 | 124 | WP_248535981.1 hypothetical protein [Methanoculleus sp. 7T] | diamond | 246 | 66.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus sp. 7T | |
| 28907622 | 28907622 | PRJNA474426_P_NODE_12388_length_300_cov_1.569721_g12183_i0 | PRJNA474426 | 12388 | 300 | 1.569721 | 4.709163 | Methanogenium sp. | 2196 | Archaea | Archaea | 136 | 5.88e-39 | NR | MFA5395027.1 | 2196 | g12183 | i0 | 68.2 | 0.85 | 85 | 27 | 85 | 0 | 293 | 39 | 55 | 139 | MFA5395027.1 hypothetical protein [Methanogenium sp.] | diamond | 255 | 136 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanogenium | Methanogenium sp. | |
| 30424227 | 30424227 | PRJNA474426_P_NODE_8313_length_375_cov_1.469325_g8108_i0 | PRJNA474426 | 8313 | 375 | 1.469325 | 5.50996875 | Methanosarcina sp. | 2213 | Archaea | Archaea | 60.1 | 5.59e-9 | NR | HET8689601.1 | 2213 | g8108 | i0 | 40.2 | 0.696 | 87 | 46 | 64.8 | 2 | 362 | 120 | 6 | 92 | HET8689601.1 hypothetical protein [Methanosarcina sp.] | diamond | 261 | 60.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 30518583 | 30518583 | PRJNA474426_P_NODE_14733_length_270_cov_4.190045_g14528_i0 | PRJNA474426 | 14733 | 270 | 4.190045 | 11.3131215 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 52.4 | 1.97e-5 | NR | HUV84265.1 | 2250255 | g14528 | i0 | 39.7 | 0.755555555555556 | 68 | 39 | 75.6 | 1 | 50 | 253 | 145 | 210 | HUV84265.1 hypothetical protein [Methanosarcinales archaeon] | diamond | 204 | 52.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 31656315 | 31656315 | PRJNA474426_P_NODE_15137_length_266_cov_1.290323_g14932_i0 | PRJNA474426 | 15137 | 266 | 1.290323 | 3.43225918 | Methanosarcina sp. | 2213 | Archaea | Archaea | 103 | 8.779999999999999e-25 | NR | HET8689803.1 | 2213 | g14932 | i0 | 59 | 0.93609022556391 | 83 | 34 | 93.6 | 0 | 1 | 249 | 112 | 194 | HET8689803.1 tRNA(His) guanylyltransferase Thg1 family protein [Methanosarcina sp.] | diamond | 249 | 103 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 31972836 | 31972836 | PRJNA474426_P_NODE_18618_length_233_cov_2.467391_g18413_i0 | PRJNA474426 | 18618 | 233 | 2.467391 | 5.74902103 | Methanosarcina sp. | 2213 | Archaea | Archaea | 114 | 4.9199999999999993e-29 | NR | HET8687130.1 | 2213 | g18413 | i0 | 69.4 | 1.85407725321888 | 72 | 22 | 92.7 | 0 | 231 | 16 | 196 | 267 | HET8687130.1 hypothetical protein [Methanosarcina sp.] | diamond | 432 | 114 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina 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);;