contig_metadata
10 rows where bioproject = "PRJNA1022392" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3988988 | 3988988 | PRJNA1022392_P_NODE_63864_length_172_cov_2.328000_g63195_i0 | PRJNA1022392 | 63864 | 172 | 2.328 | 4.00416 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 111 | 2.35e-20 | NTclustered | gi|2874253938|emb|OY970263.1| | 412054 | g63195 | i0 | 86.869 | 5.7906976744186 | 99 | 13 | 58 | 0 | 73 | 171 | 1606806 | 1606708 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1 | blastn | 996 | 111 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 7814703 | 7814703 | PRJNA1022392_P_NODE_39447_length_199_cov_1.881579_g38778_i0 | PRJNA1022392 | 39447 | 199 | 1.881579 | 3.74434221 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 174 | 3.53e-39 | NTclustered | gi|2874253755|emb|OY969695.1| | 412054 | g38778 | i0 | 85.38 | 60.6934673366834 | 171 | 21 | 85 | 4 | 1 | 169 | 120327 | 120495 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1 | blastn | 12078 | 174 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 28645779 | 28645779 | PRJNA1022392_P_NODE_75107_length_161_cov_1.385965_g74438_i0 | PRJNA1022392 | 75107 | 161 | 1.385965 | 2.23140365 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 83.2 | 6.76e-17 | NR | MBI2797314.1 | 2026742 | g74438 | i0 | 98 | 0.93167701863354 | 50 | 1 | 93.2 | 0 | 11 | 160 | 1 | 50 | MBI2797314.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 150 | 83.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29214208 | 29214208 | PRJNA1022392_P_NODE_42989_length_195_cov_3.222973_g42320_i0 | PRJNA1022392 | 42989 | 195 | 3.222973 | 6.28479735 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 69.3 | 1.17e-12 | NR | HEU4994265.1 | 2026741 | g42320 | i0 | 59.6 | 5.13846153846154 | 52 | 21 | 80 | 0 | 1 | 156 | 11 | 62 | HEU4994265.1 DUF488 domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 1002 | 69.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 29940391 | 29940391 | PRJNA1022392_P_NODE_61911_length_175_cov_1.226562_g61242_i0 | PRJNA1022392 | 61911 | 175 | 1.226562 | 2.1464835 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 74.7 | 8.01e-14 | NR | HEY0241622.1 | 2026741 | g61242 | i0 | 61.4 | 0.977142857142857 | 57 | 22 | 97.7 | 0 | 171 | 1 | 186 | 242 | HEY0241622.1 TonB-dependent receptor [Gemmatimonadaceae bacterium] | diamond | 171 | 74.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30603604 | 30603604 | PRJNA1022392_P_NODE_34153_length_206_cov_2.597484_g33484_i0 | PRJNA1022392 | 34153 | 206 | 2.597484 | 5.35081704 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 59.3 | 3.23e-8 | NR | MDQ2669042.1 | 2026742 | g33484 | i0 | 84.4 | 1.26699029126214 | 32 | 5 | 46.6 | 0 | 205 | 110 | 433 | 464 | MDQ2669042.1 NAD(P)/FAD-dependent oxidoreductase [Gemmatimonadota bacterium] | diamond | 261 | 59.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30951472 | 30951472 | PRJNA1022392_P_NODE_61734_length_175_cov_1.671875_g61065_i0 | PRJNA1022392 | 61734 | 175 | 1.671875 | 2.92578125 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 59.7 | 1.56e-8 | NR | HSL69443.1 | 2910168 | g61065 | i0 | 52.6 | 0.977142857142857 | 57 | 27 | 97.7 | 0 | 172 | 2 | 208 | 264 | HSL69443.1 polysaccharide biosynthesis C-terminal domain-containing protein [Longimicrobiales bacterium] | diamond | 171 | 59.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 31330491 | 31330491 | PRJNA1022392_P_NODE_80536_length_157_cov_1.318182_g79867_i0 | PRJNA1022392 | 80536 | 157 | 1.318182 | 2.06954574 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 41.6 | 0.0298 | NR | HZG44202.1 | 2029185 | g79867 | i0 | 51.4 | 0.668789808917197 | 35 | 10 | 66.9 | 1 | 150 | 46 | 199 | 226 | HZG44202.1 hypothetical protein [Longimicrobium sp.] | diamond | 105 | 41.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 31386074 | 31386074 | PRJNA1022392_P_NODE_43436_length_195_cov_2.993243_g42767_i0 | PRJNA1022392 | 43436 | 195 | 2.993243 | 5.83682385 | Gemmatimonas | 173479 | Bacteria | Bacteria | 64.3 | 4.85e-10 | NR | MEO7520221.1 | 1962908 | g42767 | i0 | 48.9 | 8.66153846153846 | 94 | 19 | 100 | 2 | 195 | 1 | 135 | 228 | MEO7520221.1 GAF domain-containing protein [Gemmatimonas sp.] | diamond | 1689 | 64.7 | 0.993817619783617 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas sp. | |
| 32216401 | 32216401 | PRJNA1022392_P_NODE_74138_length_162_cov_0.886957_g73469_i0 | PRJNA1022392 | 74138 | 162 | 0.886957 | 1.43687034 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 86.3 | 1.51e-19 | NR | HEX6574521.1 | 2026741 | g73469 | i0 | 77.8 | 1.98148148148148 | 54 | 12 | 100 | 0 | 162 | 1 | 103 | 156 | HEX6574521.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 321 | 86.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium |
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);;