contig_metadata
24 rows where bioproject = "PRJNA812715", tax_clade = "FCB group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 811685 | 811685 | PRJNA812715_P_NODE_101141_length_251_cov_2.230337_g99340_i0 | PRJNA812715 | 101141 | 251 | 2.230337 | 5.59814587 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 250 | 7.52e-62 | NTclustered | gi|2874253789|emb|OY969773.1| | 412054 | g99340 | i0 | 84.921 | 2.8605577689243 | 252 | 32 | 100 | 5 | 4 | 251 | 422327 | 422078 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 | blastn | 718 | 250 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 1225247 | 1225247 | PRJNA812715_P_NODE_85961_length_275_cov_1.262376_g84160_i0 | PRJNA812715 | 85961 | 275 | 1.262376 | 3.471534 | Bacteria | 2 | Bacteria | Bacteria | 82.8 | 4.34e-16 | NR | HTJ21287.1 | 2026741 | g84160 | i0 | 53.4 | 4.86545454545455 | 88 | 41 | 96 | 0 | 3 | 266 | 440 | 527 | HTJ21287.1 murein biosynthesis integral membrane protein MurJ [Gemmatimonadaceae bacterium] | diamond | 1338 | 82.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 2087536 | 2087536 | PRJNA812715_P_NODE_106962_length_248_cov_1.760000_g105161_i0 | PRJNA812715 | 106962 | 248 | 1.76 | 4.3648 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 320 | 5.57e-83 | NTclustered | gi|2874253789|emb|OY969773.1| | 412054 | g105161 | i0 | 89.96 | 122.665322580645 | 249 | 24 | 100 | 1 | 1 | 248 | 423710 | 423462 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 | blastn | 30421 | 320 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 2090193 | 2090193 | PRJNA812715_P_NODE_80942_length_283_cov_1.119048_g79142_i0 | PRJNA812715 | 80942 | 283 | 1.119048 | 3.16690584 | Gemmatirosa sp. | 2510638 | Bacteria | Bacteria | 114 | 2.9800000000000003e-27 | NR | HZF68918.1 | 2510638 | g79142 | i0 | 68.8 | 3.68904593639576 | 93 | 29 | 98.6 | 0 | 3 | 281 | 586 | 678 | HZF68918.1 PAS domain S-box protein [Gemmatirosa sp.] | diamond | 1044 | 114 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa sp. | |
| 3364754 | 3364754 | PRJNA812715_P_NODE_59843_length_339_cov_1.932331_g58044_i0 | PRJNA812715 | 59843 | 339 | 1.932331 | 6.55060209 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 346 | 1.31e-90 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g58044 | i0 | 84.123 | 87.3215339233038 | 359 | 35 | 100 | 6 | 1 | 339 | 1903256 | 1902900 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 29602 | 346 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 7191979 | 7191979 | PRJNA812715_P_NODE_56066_length_354_cov_1.295374_g54267_i0 | PRJNA812715 | 56066 | 354 | 1.295374 | 4.58562396 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 484 | 2.7899999999999993e-132 | NTclustered | gi|2874253728|emb|OY969570.1| | 412054 | g54267 | i0 | 91.714 | 240.375706214689 | 350 | 27 | 99 | 2 | 3 | 351 | 172106 | 172454 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 | blastn | 85093 | 484 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 12290924 | 12290924 | PRJNA812715_P_NODE_100730_length_252_cov_1.670391_g98929_i0 | PRJNA812715 | 100730 | 252 | 1.670391 | 4.20938532 | uncultured Gemmatimonadaceae bacterium | 246130 | Bacteria | Bacteria | 172 | 1.68e-38 | NTclustered | gi|2874253995|emb|OY970320.1| | 246130 | g98929 | i0 | 80.508 | 1.73412698412698 | 236 | 36 | 92 | 9 | 14 | 244 | 321891 | 322121 | MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1 | blastn | 437 | 172 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | uncultured Gemmatimonadaceae bacterium | ||
| 12291414 | 12291414 | PRJNA812715_P_NODE_119890_length_242_cov_0.911243_g118089_i0 | PRJNA812715 | 119890 | 242 | 0.911243 | 2.20520806 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 346 | 8.930000000000001e-91 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g118089 | i0 | 92.531 | 100.140495867769 | 241 | 18 | 99 | 0 | 2 | 242 | 3205531 | 3205771 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 24234 | 346 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 14840033 | 14840033 | PRJNA812715_P_NODE_109572_length_247_cov_0.885057_g107771_i0 | PRJNA812715 | 109572 | 247 | 0.885057 | 2.18609079 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 440 | 4.079999999999999e-119 | NTclustered | gi|2874253789|emb|OY969773.1| | 412054 | g107771 | i0 | 98.785 | 167.947368421053 | 247 | 3 | 100 | 0 | 1 | 247 | 421683 | 421929 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 | blastn | 41483 | 440 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 18665549 | 18665549 | PRJNA812715_P_NODE_66755_length_315_cov_1.909091_g64955_i0 | PRJNA812715 | 66755 | 315 | 1.909091 | 6.01363665 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 333 | 9.4e-87 | NTclustered | gi|2874253755|emb|OY969695.1| | 412054 | g64955 | i0 | 85.802 | 95.4380952380952 | 324 | 34 | 100 | 12 | 1 | 315 | 318827 | 318507 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1 | blastn | 30063 | 333 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 20351316 | 20351316 | PRJNA812715_P_NODE_42896_length_425_cov_1.985795_g41101_i0 | PRJNA812715 | 42896 | 425 | 1.985795 | 8.43962875 | Gemmatirosa | 1706036 | Bacteria | Bacteria | 497 | 4.3799999999999996e-136 | NTclustered | gi|2874253789|emb|OY969773.1| | 412054 | g41101 | i0 | 87.907 | 104.270588235294 | 430 | 43 | 100 | 9 | 1 | 425 | 420938 | 421363 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 | blastn | 44315 | 501 | 0.992015968063872 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 23765883 | 23765883 | PRJNA812715_P_NODE_44519_length_414_cov_1.865103_g42723_i0 | PRJNA812715 | 44519 | 414 | 1.865103 | 7.72152642 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 542 | 1.94e-149 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g42723 | i0 | 90.557 | 226.239130434783 | 413 | 33 | 99 | 6 | 1 | 412 | 1903249 | 1903656 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 93663 | 542 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 26864806 | 26864806 | PRJNA812715_P_NODE_98061_length_256_cov_1.683060_g96260_i0 | PRJNA812715 | 98061 | 256 | 1.68306 | 4.3086336 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 40.4 | 0.036 | NR | MBU10968.1 | 2026742 | g96260 | i0 | 34.6 | 0.609375 | 52 | 33 | 60.9 | 1 | 27 | 182 | 11 | 61 | MBU10968.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 156 | 40.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 26968080 | 26968080 | PRJNA812715_P_NODE_114802_length_244_cov_1.631579_g113001_i0 | PRJNA812715 | 114802 | 244 | 1.631579 | 3.98105276 | Longimicrobium | 1804994 | Bacteria | Bacteria | 63.2 | 2.38e-9 | NR | HEX9936034.1 | 2029185 | g113001 | i0 | 71.1 | 2.91393442622951 | 45 | 13 | 55.3 | 0 | 110 | 244 | 4 | 48 | HEX9936034.1 MFS transporter [Longimicrobium sp.] | diamond | 711 | 63.5 | 0.995275590551181 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 28570143 | 28570143 | PRJNA812715_P_NODE_116287_length_243_cov_2.888235_g114486_i0 | PRJNA812715 | 116287 | 243 | 2.888235 | 7.01841105 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 63.9 | 1.16e-9 | NR | HSJ25270.1 | 2910168 | g114486 | i0 | 75 | 0.888888888888889 | 36 | 9 | 44.4 | 0 | 134 | 241 | 1 | 36 | HSJ25270.1 glycosyltransferase [Longimicrobiales bacterium] | diamond | 216 | 63.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 28854192 | 28854192 | PRJNA812715_P_NODE_103768_length_250_cov_0.870056_g101967_i0 | PRJNA812715 | 103768 | 250 | 0.870056 | 2.17514 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 80.1 | 2.87e-15 | NR | MDP9349913.1 | 2026742 | g101967 | i0 | 47.6 | 1.968 | 82 | 35 | 98.4 | 1 | 250 | 5 | 229 | 302 | MDP9349913.1 prolyl oligopeptidase family serine peptidase [Gemmatimonadota bacterium] | diamond | 492 | 80.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29043974 | 29043974 | PRJNA812715_P_NODE_105328_length_249_cov_1.312500_g103527_i0 | PRJNA812715 | 105328 | 249 | 1.3125 | 3.268125 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 76.3 | 6.07e-14 | NR | MBK8005775.1 | 2026742 | g103527 | i0 | 57.4 | 3.27710843373494 | 68 | 29 | 81.9 | 0 | 234 | 31 | 193 | 260 | MBK8005775.1 S8 family peptidase [Gemmatimonadota bacterium] | diamond | 816 | 76.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29201847 | 29201847 | PRJNA812715_P_NODE_79729_length_285_cov_1.113208_g77929_i0 | PRJNA812715 | 79729 | 285 | 1.113208 | 3.1726428 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 45.4 | 0.00657 | NR | HKG95476.1 | 2026741 | g77929 | i0 | 44.4 | 0.473684210526316 | 45 | 25 | 47.4 | 0 | 283 | 149 | 267 | 311 | HKG95476.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 135 | 45.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 29864758 | 29864758 | PRJNA812715_P_NODE_69011_length_309_cov_3.211864_g67211_i0 | PRJNA812715 | 69011 | 309 | 3.211864 | 9.92465976 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 96.3 | 3.129999999999999e-23 | NR | MCC6769715.1 | 2026741 | g67211 | i0 | 46.9 | 1.85436893203884 | 98 | 52 | 95.1 | 0 | 2 | 295 | 20 | 117 | MCC6769715.1 helix-turn-helix domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 573 | 96.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30022933 | 30022933 | PRJNA812715_P_NODE_86631_length_274_cov_1.184080_g84830_i0 | PRJNA812715 | 86631 | 274 | 1.18408 | 3.2443792 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 74.7 | 2.11e-14 | NR | MBV6522904.1 | 2026741 | g84830 | i0 | 58.3 | 0.656934306569343 | 60 | 25 | 65.7 | 0 | 2 | 181 | 97 | 156 | MBV6522904.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 180 | 74.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30654490 | 30654490 | PRJNA812715_P_NODE_101513_length_251_cov_1.337079_g99712_i0 | PRJNA812715 | 101513 | 251 | 1.337079 | 3.35606829 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 57 | 3.46e-7 | NR | HEU4558844.1 | 2029185 | g99712 | i0 | 100 | 0.645418326693227 | 27 | 0 | 32.3 | 0 | 249 | 169 | 298 | 324 | HEU4558844.1 M48 family metallopeptidase [Longimicrobium sp.] | diamond | 162 | 57 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 30844333 | 30844333 | PRJNA812715_P_NODE_92634_length_264_cov_1.952880_g90833_i0 | PRJNA812715 | 92634 | 264 | 1.95288 | 5.1556032 | Roseisolibacter sp. H3M3-2 | 3031323 | Bacteria | Bacteria | 135 | 2e-38 | NR | MDF1505490.1 | 3031323 | g90833 | i0 | 69.3 | 1 | 88 | 27 | 100 | 0 | 264 | 1 | 24 | 111 | MDF1505490.1 hypothetical protein [Roseisolibacter sp. H3M3-2] | diamond | 264 | 135 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Roseisolibacter | Roseisolibacter sp. H3M3-2 | |
| 32646206 | 32646206 | PRJNA812715_P_NODE_110500_length_247_cov_0.885057_g108699_i0 | PRJNA812715 | 110500 | 247 | 0.885057 | 2.18609079 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 103 | 5.9899999999999996e-24 | NR | HKP49127.1 | 2448054 | g108699 | i0 | 88.5 | 1.26315789473684 | 52 | 6 | 63.2 | 0 | 157 | 2 | 186 | 237 | HKP49127.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 312 | 103 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 32835437 | 32835437 | PRJNA812715_P_NODE_93460_length_263_cov_1.552632_g91659_i0 | PRJNA812715 | 93460 | 263 | 1.552632 | 4.08342216 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 99.8 | 4.64e-23 | NR | MBX6331758.1 | 2026741 | g91659 | i0 | 53.2 | 0.901140684410646 | 79 | 34 | 86.7 | 1 | 32 | 259 | 1 | 79 | MBX6331758.1 tyrosinase family protein [Gemmatimonadaceae bacterium] | diamond | 237 | 99.8 | 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);;