contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA1086823" and tax_phylum = "Gemmatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6571642 | 6571642 | PRJNA1086823_P_NODE_16946_length_245_cov_0.906977_g16829_i0 | PRJNA1086823 | 16946 | 245 | 0.906977 | 2.22209365 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 75.5 | 1.08e-13 | NR | HXG69990.1 | 2026741 | g16829 | i0 | 51.5 | 0.83265306122449 | 68 | 33 | 83.3 | 0 | 30 | 233 | 1 | 68 | HXG69990.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 204 | 75.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 27699661 | 27699661 | PRJNA1086823_P_NODE_13004_length_252_cov_0.871508_g12887_i0 | PRJNA1086823 | 13004 | 252 | 0.871508 | 2.19620016 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 160 | 1.5599999999999998e-45 | NR | HSE28238.1 | 2448054 | g12887 | i0 | 95.2 | 1 | 84 | 4 | 100 | 0 | 252 | 1 | 16 | 99 | HSE28238.1 UDP-N-acetylglucosamine 1-carboxyvinyltransferase [Gemmatimonadales bacterium] | diamond | 252 | 160 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 27699666 | 27699666 | PRJNA1086823_P_NODE_5604_length_340_cov_1.168539_g5487_i0 | PRJNA1086823 | 5604 | 340 | 1.168539 | 3.9730326 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 75.5 | 4.6e-14 | NR | HXG69993.1 | 2026741 | g5487 | i0 | 55.6 | 0.635294117647059 | 72 | 32 | 63.5 | 0 | 340 | 125 | 132 | 203 | HXG69993.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 216 | 75.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28078129 | 28078129 | PRJNA1086823_P_NODE_16585_length_246_cov_0.901734_g16468_i0 | PRJNA1086823 | 16585 | 246 | 0.901734 | 2.21826564 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 82.8 | 3.16e-16 | NR | HVE79799.1 | 2026741 | g16468 | i0 | 51.1 | 5.30487804878049 | 88 | 33 | 95.1 | 2 | 1 | 234 | 893 | 980 | HVE79799.1 TonB-dependent receptor [Gemmatimonadaceae bacterium] | diamond | 1305 | 82.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28172846 | 28172846 | PRJNA1086823_P_NODE_11626_length_256_cov_1.704918_g11509_i0 | PRJNA1086823 | 11626 | 256 | 1.704918 | 4.36459008 | uncultured Gemmatimonadaceae bacterium | 246130 | Bacteria | Bacteria | 42.7 | 0.045 | NR | CAA9295630.1 | 246130 | g11509 | i0 | 37.5 | 1.125 | 96 | 48 | 98.4 | 2 | 5 | 256 | 56 | 151 | CAA9295630.1 MAG: Excinuclease ABC subunit A, partial [uncultured Gemmatimonadaceae bacterium] | diamond | 288 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | uncultured Gemmatimonadaceae bacterium | ||
| 28330724 | 28330724 | PRJNA1086823_P_NODE_14026_length_250_cov_0.881356_g13909_i0 | PRJNA1086823 | 14026 | 250 | 0.881356 | 2.20339 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 103 | 1.6299999999999994e-23 | NR | NNF13398.1 | 2026742 | g13909 | i0 | 57.8 | 0.996 | 83 | 35 | 99.6 | 0 | 249 | 1 | 375 | 457 | NNF13398.1 AsmA family protein [Gemmatimonadota bacterium] | diamond | 249 | 103 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 28732771 | 28732771 | PRJNA1086823_P_NODE_10147_length_271_cov_1.525253_g10030_i0 | PRJNA1086823 | 10147 | 271 | 1.525253 | 4.13343563 | Gemmatimonadaceae | 219687 | Bacteria | Bacteria | 97.8 | 2.33e-21 | NR | WP_025410860.1 | 861299 | g10030 | i0 | 62.5 | 4.4169741697417 | 80 | 27 | 88.6 | 1 | 270 | 31 | 941 | 1017 | WP_025410860.1 SusC/RagA family TonB-linked outer membrane protein [Gemmatirosa kalamazoonensis] | diamond | 1197 | 98.6 | 0.991886409736308 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 29057125 | 29057125 | PRJNA1086823_P_NODE_13708_length_251_cov_0.876404_g13591_i0 | PRJNA1086823 | 13708 | 251 | 0.876404 | 2.19977404 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 156 | 7.48e-44 | NR | HZE94286.1 | 2448054 | g13591 | i0 | 89.2 | 4.9601593625498 | 83 | 9 | 99.2 | 0 | 251 | 3 | 119 | 201 | HZE94286.1 NAD-binding protein [Gemmatimonadales bacterium] | diamond | 1245 | 156 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29152098 | 29152098 | PRJNA1086823_P_NODE_13769_length_251_cov_0.865169_g13652_i0 | PRJNA1086823 | 13769 | 251 | 0.865169 | 2.17157419 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 94.7 | 7.149999999999999e-23 | NR | HUF50634.1 | 2910168 | g13652 | i0 | 48.1 | 1.60159362549801 | 81 | 41 | 96.8 | 1 | 9 | 251 | 5 | 84 | HUF50634.1 BrnA antitoxin family protein [Longimicrobiales bacterium] | diamond | 402 | 94.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 30289057 | 30289057 | PRJNA1086823_P_NODE_16172_length_247_cov_0.896552_g16055_i0 | PRJNA1086823 | 16172 | 247 | 0.896552 | 2.21448344 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 45.1 | 0.006 | NR | MFN8653765.1 | 2448054 | g16055 | i0 | 45.8 | 1.0080971659919 | 83 | 37 | 91.1 | 4 | 5 | 229 | 220 | 302 | MFN8653765.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 249 | 45.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 31268242 | 31268242 | PRJNA1086823_P_NODE_3575_length_410_cov_2.097923_g3458_i0 | PRJNA1086823 | 3575 | 410 | 2.097923 | 8.6014843 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 47.4 | 0.00264 | NR | WP_331072372.1 | 2029185 | g3458 | i0 | 28 | 0.6 | 82 | 52 | 60 | 1 | 5 | 250 | 94 | 168 | WP_331072372.1 3'-5' exonuclease [Longimicrobium sp.] | diamond | 246 | 47.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium 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);;