contig_metadata
19 rows where bioproject = "PRJEB81327" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2690022 | 2690022 | PRJEB81327_P_NODE_46043_length_251_cov_1.556180_g45435_i0 | PRJEB81327 | 46043 | 251 | 1.55618 | 3.9060118 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 281 | 2.66e-71 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g45435 | i0 | 86.853 | 1 | 251 | 33 | 100 | 0 | 1 | 251 | 3210109 | 3210359 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 251 | 281 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 7792040 | 7792040 | PRJEB81327_P_NODE_32007_length_275_cov_1.217822_g31399_i0 | PRJEB81327 | 32007 | 275 | 1.217822 | 3.3490105 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 298 | 2.94e-76 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g31399 | i0 | 86.232 | 106.301818181818 | 276 | 36 | 100 | 2 | 1 | 275 | 37290 | 37016 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 29233 | 298 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 11200547 | 11200547 | PRJEB81327_P_NODE_67409_length_232_cov_2.572327_g66801_i0 | PRJEB81327 | 67409 | 232 | 2.572327 | 5.96779864 | Gemmatimonadetes bacterium T265 | 2839016 | Bacteria | Bacteria | 141 | 4.11e-37 | NR | GJG85456.1 | 2839016 | g66801 | i0 | 85.7 | 2.98706896551724 | 77 | 11 | 99.6 | 0 | 232 | 2 | 76 | 152 | GJG85456.1 glucosamine-6-phosphate deaminase [Gemmatimonadetes bacterium T265] | diamond | 693 | 141 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadetes bacterium T265 | |||||
| 15442447 | 15442447 | PRJEB81327_P_NODE_43793_length_255_cov_1.082418_g43185_i0 | PRJEB81327 | 43793 | 255 | 1.082418 | 2.7601659 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 311 | 3.46e-80 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g43185 | i0 | 88.627 | 94.9176470588235 | 255 | 29 | 100 | 0 | 1 | 255 | 4457727 | 4457981 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 24204 | 311 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 16299567 | 16299567 | PRJEB81327_P_NODE_24593_length_288_cov_1.432558_g23985_i0 | PRJEB81327 | 24593 | 288 | 1.432558 | 4.12576704 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 101 | 5.22e-24 | NR | HEX8673236.1 | 2029185 | g23985 | i0 | 90.9 | 2.29166666666667 | 55 | 5 | 57.3 | 0 | 1 | 165 | 197 | 251 | HEX8673236.1 HrcA family transcriptional regulator [Longimicrobium sp.] | diamond | 660 | 101 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 17991351 | 17991351 | PRJEB81327_P_NODE_33415_length_272_cov_1.547739_g32807_i0 | PRJEB81327 | 33415 | 272 | 1.547739 | 4.20985008 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 193 | 1.41e-44 | NTclustered | gi|575461033|gb|CP007129.1| | 861299 | g32807 | i0 | 82.096 | 0.841911764705882 | 229 | 38 | 84 | 3 | 1 | 228 | 598802 | 599028 | Gemmatirosa kalamazoonesis strain KBS708 plasmid 1, complete sequence | blastn | 229 | 193 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 17991729 | 17991729 | PRJEB81327_P_NODE_63835_length_241_cov_4.809524_g63227_i0 | PRJEB81327 | 63835 | 241 | 4.809524 | 11.59095284 | Gemmatirosa sp. | 2510638 | Bacteria | Bacteria | 116 | 1.47e-30 | NR | HEY0780523.1 | 2510638 | g63227 | i0 | 82.1 | 1.95435684647303 | 78 | 14 | 97.1 | 0 | 2 | 235 | 35 | 112 | HEY0780523.1 DUF979 family protein [Gemmatirosa sp.] | diamond | 471 | 116 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa sp. | |
| 21816684 | 21816684 | PRJEB81327_P_NODE_44738_length_253_cov_1.711111_g44130_i0 | PRJEB81327 | 44738 | 253 | 1.711111 | 4.32911083 | uncultured Gemmatimonadaceae bacterium | 246130 | Bacteria | Bacteria | 150 | 7.91e-32 | NTclustered | gi|2874253995|emb|OY970320.1| | 246130 | g44130 | i0 | 84.768 | 28.5928853754941 | 151 | 21 | 59 | 2 | 2 | 151 | 1272128 | 1271979 | MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1 | blastn | 7234 | 150 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | uncultured Gemmatimonadaceae bacterium | ||
| 28739678 | 28739678 | PRJEB81327_P_NODE_60067_length_244_cov_0.900585_g59459_i0 | PRJEB81327 | 60067 | 244 | 0.900585 | 2.1974274 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 42.4 | 0.0453 | NR | MEX2526726.1 | 2026742 | g59459 | i0 | 35 | 0.983606557377049 | 80 | 51 | 97.1 | 1 | 6 | 242 | 142 | 221 | MEX2526726.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 240 | 42.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29813067 | 29813067 | PRJEB81327_P_NODE_64991_length_241_cov_0.916667_g64383_i0 | PRJEB81327 | 64991 | 241 | 0.916667 | 2.20916747 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 50.8 | 5.15e-5 | NR | HWJ14826.1 | 2026741 | g64383 | i0 | 62.8 | 1.13278008298755 | 43 | 14 | 51 | 1 | 106 | 228 | 4 | 46 | HWJ14826.1 alpha-glucuronidase family glycosyl hydrolase [Gemmatimonadaceae bacterium] | diamond | 273 | 50.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 29869056 | 29869056 | PRJEB81327_P_NODE_45491_length_252_cov_1.363128_g44883_i0 | PRJEB81327 | 45491 | 252 | 1.363128 | 3.43508256 | Gemmatimonas | 173479 | Bacteria | Bacteria | 42.7 | 0.0405 | NR | WP_337171994.1 | 173480 | g44883 | i0 | 40.3 | 1.21428571428571 | 62 | 34 | 73.8 | 1 | 24 | 209 | 327 | 385 | WP_337171994.1 cytochrome b N-terminal domain-containing protein [Gemmatimonas aurantiaca] | diamond | 306 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas aurantiaca | |
| 30508222 | 30508222 | PRJEB81327_P_NODE_51833_length_248_cov_0.880000_g51225_i0 | PRJEB81327 | 51833 | 248 | 0.88 | 2.1824 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 50.8 | 3.75e-5 | NR | MBT5145793.1 | 2026742 | g51225 | i0 | 47.9 | 1.16129032258065 | 48 | 25 | 58.1 | 0 | 4 | 147 | 88 | 135 | MBT5145793.1 pentapeptide repeat-containing protein [Gemmatimonadota bacterium] | diamond | 288 | 50.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30974966 | 30974966 | PRJEB81327_P_NODE_62294_length_242_cov_1.822485_g61686_i0 | PRJEB81327 | 62294 | 242 | 1.822485 | 4.4104137 | Gemmatimonas | 173479 | Bacteria | Bacteria | 150 | 3.629999999999999e-42 | NR | WP_396204666.1 | 1962908 | g61686 | i0 | 86.3 | 4.95867768595041 | 80 | 11 | 99.2 | 0 | 241 | 2 | 26 | 105 | WP_396204666.1 NAD-dependent epimerase/dehydratase family protein [Gemmatimonas sp.] | diamond | 1200 | 150 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas sp. | |
| 31045675 | 31045675 | PRJEB81327_P_NODE_54155_length_247_cov_0.885057_g53547_i0 | PRJEB81327 | 54155 | 247 | 0.885057 | 2.18609079 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 138 | 3.64e-39 | NR | HWO88676.1 | 2448054 | g53547 | i0 | 88.8 | 0.97165991902834 | 80 | 9 | 97.2 | 0 | 1 | 240 | 125 | 204 | HWO88676.1 response regulator transcription factor [Gemmatimonadales bacterium] | diamond | 240 | 138 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 31361605 | 31361605 | PRJEB81327_P_NODE_52496_length_248_cov_0.880000_g51888_i0 | PRJEB81327 | 52496 | 248 | 0.88 | 2.1824 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 128 | 7.120000000000001e-33 | NR | HEX8430016.1 | 2029185 | g51888 | i0 | 72 | 1.98387096774194 | 82 | 23 | 99.2 | 0 | 2 | 247 | 162 | 243 | HEX8430016.1 hypothetical protein [Longimicrobium sp.] | diamond | 492 | 128 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 31361606 | 31361606 | PRJEB81327_P_NODE_53796_length_247_cov_0.885057_g53188_i0 | PRJEB81327 | 53796 | 247 | 0.885057 | 2.18609079 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 84 | 1.18e-16 | NR | MBV9774374.1 | 2026742 | g53188 | i0 | 78.2 | 2.07692307692308 | 55 | 12 | 66.8 | 0 | 82 | 246 | 4 | 58 | MBV9774374.1 FAD-dependent oxidoreductase [Gemmatimonadota bacterium] | diamond | 513 | 84 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31899200 | 31899200 | PRJEB81327_P_NODE_63577_length_242_cov_0.911243_g62969_i0 | PRJEB81327 | 63577 | 242 | 0.911243 | 2.20520806 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 126 | 1.47e-32 | NR | WP_329685498.1 | 2029185 | g62969 | i0 | 77.5 | 1.98347107438017 | 80 | 18 | 99.2 | 0 | 3 | 242 | 33 | 112 | WP_329685498.1 low temperature requirement protein A [Longimicrobium sp.] | diamond | 480 | 126 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 31994087 | 31994087 | PRJEB81327_P_NODE_25518_length_286_cov_2.577465_g24910_i0 | PRJEB81327 | 25518 | 286 | 2.577465 | 7.3715499 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 185 | 7.089999999999999e-55 | NR | HSJ10138.1 | 2910168 | g24910 | i0 | 86.3 | 1.99300699300699 | 95 | 13 | 99.7 | 0 | 285 | 1 | 189 | 283 | HSJ10138.1 serine hydrolase [Longimicrobiales bacterium] | diamond | 570 | 185 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 32120802 | 32120802 | PRJEB81327_P_NODE_65478_length_241_cov_0.916667_g64870_i0 | PRJEB81327 | 65478 | 241 | 0.916667 | 2.20916747 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 106 | 1.49e-24 | NR | HXG72790.1 | 2026741 | g64870 | i0 | 57 | 0.983402489626556 | 79 | 34 | 98.3 | 0 | 237 | 1 | 99 | 177 | HXG72790.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 237 | 106 | 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);;