contig_metadata
20 rows where bioproject = "PRJNA382558" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1679753 | 1679753 | PRJNA382558_S_NODE_42_length_677_cov_23.567187_g40_i0 | PRJNA382558 | 42 | 677 | 23.567187 | 159.54985599 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 477 | 9.4e-130 | NTclustered | gi|2874253755|emb|OY969695.1| | 412054 | g40 | i0 | 81.507 | 155.308714918759 | 584 | 105 | 86 | 3 | 88 | 668 | 254556 | 253973 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1 | blastn | 105144 | 477 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 6782721 | 6782721 | PRJNA382558_S_NODE_8606_length_181_cov_4.138889_g8602_i0 | PRJNA382558 | 8606 | 181 | 4.138889 | 7.49138909 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 130 | 6.9e-26 | NTclustered | gi|2874253728|emb|OY969570.1| | 412054 | g8602 | i0 | 79.781 | 42.7569060773481 | 183 | 33 | 100 | 3 | 1 | 181 | 4682150 | 4681970 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 | blastn | 7739 | 130 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 8058219 | 8058219 | PRJNA382558_S_NODE_4307_length_220_cov_8.524590_g4303_i0 | PRJNA382558 | 4307 | 220 | 8.52459 | 18.754098 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 152 | 1.87e-32 | NTclustered | gi|2874254107|emb|OY970192.1| | 412054 | g4303 | i0 | 83.636 | 26.8454545454545 | 165 | 23 | 74 | 4 | 54 | 216 | 2756251 | 2756089 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1 | blastn | 5906 | 152 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 13158754 | 13158754 | PRJNA382558_S_NODE_891_length_327_cov_5.224138_g887_i0 | PRJNA382558 | 891 | 327 | 5.224138 | 17.08293126 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 86.3 | 2.64e-17 | NR | HEX7918898.1 | 2448054 | g887 | i0 | 77.6 | 0.44954128440367 | 49 | 11 | 45 | 0 | 2 | 148 | 313 | 361 | HEX7918898.1 M13 family metallopeptidase [Gemmatimonadales bacterium] | diamond | 147 | 86.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 16982367 | 16982367 | PRJNA382558_S_NODE_7254_length_190_cov_5.993464_g7250_i0 | PRJNA382558 | 7254 | 190 | 5.993464 | 11.3875816 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 83.6 | 1.29e-17 | NR | HEY4304911.1 | 2026741 | g7250 | i0 | 57.1 | 3.97894736842105 | 63 | 27 | 99.5 | 0 | 189 | 1 | 173 | 235 | HEY4304911.1 DUF4386 domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 756 | 83.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 18256302 | 18256302 | PRJNA382558_S_NODE_11575_length_165_cov_7.601562_g11571_i0 | PRJNA382558 | 11575 | 165 | 7.601562 | 12.5425773 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 70.5 | 2.09e-12 | NR | HXJ29969.1 | 2448054 | g11571 | i0 | 61.8 | 2 | 55 | 19 | 96.4 | 1 | 161 | 3 | 250 | 304 | HXJ29969.1 M13 family metallopeptidase [Gemmatimonadales bacterium] | diamond | 330 | 70.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 18256556 | 18256556 | PRJNA382558_S_NODE_9695_length_174_cov_7.547445_g9691_i0 | PRJNA382558 | 9695 | 174 | 7.547445 | 13.1325543 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 161 | 2.33e-35 | NTclustered | gi|2874253755|emb|OY969695.1| | 412054 | g9691 | i0 | 84.906 | 167.959770114943 | 159 | 24 | 91 | 0 | 13 | 171 | 218525 | 218683 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1 | blastn | 29225 | 161 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 22081435 | 22081435 | PRJNA382558_S_NODE_6338_length_197_cov_9.937500_g6334_i0 | PRJNA382558 | 6338 | 197 | 9.9375 | 19.576875 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 219 | 1.59e-52 | NTclustered | gi|2874253755|emb|OY969695.1| | 412054 | g6334 | i0 | 86.802 | 23.756345177665 | 197 | 24 | 99 | 2 | 1 | 196 | 131461 | 131266 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1 | blastn | 4680 | 219 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 27423034 | 27423034 | PRJNA382558_S_NODE_23_length_871_cov_12.105516_g21_i0 | PRJNA382558 | 23 | 871 | 12.105516 | 105.43904436 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 402 | 5.9e-139 | NR | HXG72350.1 | 2026741 | g21 | i0 | 99.5 | 0.709529276693456 | 206 | 1 | 71 | 0 | 869 | 252 | 45 | 250 | HXG72350.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 618 | 402 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 27707386 | 27707386 | PRJNA382558_S_NODE_1184_length_306_cov_5.620818_g1180_i0 | PRJNA382558 | 1184 | 306 | 5.620818 | 17.19970308 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 105 | 1.64e-27 | NR | HXG72343.1 | 2026741 | g1180 | i0 | 96.4 | 0.549019607843137 | 56 | 2 | 54.9 | 0 | 139 | 306 | 1 | 56 | HXG72343.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 168 | 105 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28622762 | 28622762 | PRJNA382558_S_NODE_13027_length_159_cov_8.721311_g13023_i0 | PRJNA382558 | 13027 | 159 | 8.721311 | 13.86688449 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 112 | 1.95e-30 | NR | HXG72352.1 | 2026741 | g13023 | i0 | 100 | 0.981132075471698 | 52 | 0 | 98.1 | 0 | 157 | 2 | 52 | 103 | HXG72352.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 156 | 112 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28938484 | 28938484 | PRJNA382558_S_NODE_4188_length_222_cov_5.767568_g4184_i0 | PRJNA382558 | 4188 | 222 | 5.767568 | 12.80400096 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 44.7 | 0.00562 | NR | WP_331126392.1 | 2029185 | g4184 | i0 | 62.2 | 0.5 | 37 | 10 | 50 | 1 | 2 | 112 | 271 | 303 | WP_331126392.1 hypothetical protein [Longimicrobium sp.] | diamond | 111 | 44.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 29443294 | 29443294 | PRJNA382558_S_NODE_5510_length_206_cov_4.680473_g5506_i0 | PRJNA382558 | 5510 | 206 | 4.680473 | 9.64177438 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 54.3 | 1.86e-6 | NR | MFL5494705.1 | 2448054 | g5506 | i0 | 58.5 | 0.597087378640777 | 41 | 17 | 59.7 | 0 | 129 | 7 | 41 | 81 | MFL5494705.1 M13 family peptidase [Gemmatimonadales bacterium] | diamond | 123 | 54.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 30137964 | 30137964 | PRJNA382558_S_NODE_10192_length_172_cov_5.207407_g10188_i0 | PRJNA382558 | 10192 | 172 | 5.207407 | 8.95674004 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 95.9 | 2.19e-22 | NR | HEU4561388.1 | 2029185 | g10188 | i0 | 76.4 | 0.959302325581395 | 55 | 13 | 95.9 | 0 | 2 | 166 | 145 | 199 | HEU4561388.1 class I SAM-dependent methyltransferase [Longimicrobium sp.] | diamond | 165 | 95.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 30233114 | 30233114 | PRJNA382558_S_NODE_4892_length_212_cov_10.748571_g4888_i0 | PRJNA382558 | 4892 | 212 | 10.748571 | 22.78697052 | Gemmatimonadetes bacterium 13_2_2 | 1805206 | Bacteria | Bacteria | 48.9 | 1.58e-4 | NR | OLB17304.1 | 1805206 | g4888 | i0 | 64.7 | 1.34433962264151 | 34 | 12 | 48.1 | 0 | 109 | 210 | 11 | 44 | OLB17304.1 MAG: MarR family transcriptional regulator [Gemmatimonadetes bacterium 13_2_20CM_69_8] | diamond | 285 | 48.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadetes bacterium 13_2_20CM_69_8 | |||||
| 30738564 | 30738564 | PRJNA382558_S_NODE_1994_length_269_cov_11.737069_g1990_i0 | PRJNA382558 | 1994 | 269 | 11.737069 | 31.57271561 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 115 | 1.65e-29 | NR | HXG72350.1 | 2026741 | g1990 | i0 | 100 | 0.591078066914498 | 53 | 0 | 59.1 | 0 | 161 | 3 | 1 | 53 | HXG72350.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 159 | 115 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31244157 | 31244157 | PRJNA382558_S_NODE_10235_length_171_cov_12.029851_g10231_i0 | PRJNA382558 | 10235 | 171 | 12.029851 | 20.57104521 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 110 | 1.19e-29 | NR | HXG72351.1 | 2026741 | g10231 | i0 | 100 | 0.982456140350877 | 56 | 0 | 98.2 | 0 | 2 | 169 | 36 | 91 | HXG72351.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 168 | 110 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32224950 | 32224950 | PRJNA382558_S_NODE_1178_length_306_cov_6.308550_g1174_i0 | PRJNA382558 | 1178 | 306 | 6.30855 | 19.304163 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 108 | 2.78e-28 | NR | HXG72349.1 | 2026741 | g1174 | i0 | 70.3 | 0.627450980392157 | 64 | 19 | 62.7 | 0 | 305 | 114 | 40 | 103 | HXG72349.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 192 | 108 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32288504 | 32288504 | PRJNA382558_S_NODE_939_length_323_cov_5.937063_g935_i0 | PRJNA382558 | 939 | 323 | 5.937063 | 19.17671349 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 129 | 1.1e-34 | NR | MEW5918430.1 | 2026742 | g935 | i0 | 61.7 | 1.98761609907121 | 107 | 41 | 99.4 | 0 | 323 | 3 | 10 | 116 | MEW5918430.1 DUF4386 domain-containing protein [Gemmatimonadota bacterium] | diamond | 642 | 129 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 32761803 | 32761803 | PRJNA382558_S_NODE_9280_length_176_cov_13.007194_g9276_i0 | PRJNA382558 | 9280 | 176 | 13.007194 | 22.89266144 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 75.9 | 5.01e-16 | NR | HXG72352.1 | 2026741 | g9276 | i0 | 100 | 0.579545454545455 | 34 | 0 | 58 | 0 | 103 | 2 | 1 | 34 | HXG72352.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 102 | 75.9 | 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);;