contig_metadata
23 rows where bioproject = "PRJNA533114" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25343964 | 25343964 | PRJNA533114_P_NODE_83440_length_266_cov_1.253886_g83188_i0 | PRJNA533114 | 83440 | 266 | 1.253886 | 3.33533676 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 52.8 | 0.024 | NTclustered | gi|2893358392|emb|OZ220683.1| | 2026742 | g83188 | i0 | 100 | 0.210526315789474 | 28 | 0 | 11 | 0 | 101 | 128 | 3218968 | 3218995 | MAG: Gemmatimonadota bacterium isolate c4f6f2ca-7934-440c-833b-e1b430e415c5 genome assembly, chromosome: 1 | blastn | 56 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 27235735 | 27235735 | PRJNA533114_P_NODE_61983_length_303_cov_1.213043_g61731_i0 | PRJNA533114 | 61983 | 303 | 1.213043 | 3.67552029 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 47.8 | 0.00123 | NR | MDT8370208.1 | 2910168 | g61731 | i0 | 27.7 | 4.85148514851485 | 101 | 72 | 99 | 1 | 3 | 302 | 42 | 142 | MDT8370208.1 serpin family protein [Longimicrobiales bacterium] | diamond | 1470 | 47.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 27330648 | 27330648 | PRJNA533114_P_NODE_37263_length_378_cov_1.465574_g37011_i0 | PRJNA533114 | 37263 | 378 | 1.465574 | 5.53986972 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 157 | 6.699999999999998e-44 | NR | MBL8960531.1 | 2026742 | g37011 | i0 | 70.1 | 4.03174603174603 | 127 | 37 | 100 | 1 | 378 | 1 | 246 | 372 | MBL8960531.1 S8 family peptidase [Gemmatimonadota bacterium] | diamond | 1524 | 157 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 27393822 | 27393822 | PRJNA533114_P_NODE_104203_length_247_cov_0.885057_g103951_i0 | PRJNA533114 | 104203 | 247 | 0.885057 | 2.18609079 | Gemmatimonas sp. | 1962908 | Bacteria | Bacteria | 70.9 | 4.25e-12 | NR | WP_409926533.1 | 1962908 | g103951 | i0 | 57.1 | 4.62753036437247 | 63 | 27 | 76.5 | 0 | 246 | 58 | 313 | 375 | WP_409926533.1 oxaloacetate-decarboxylating malate dehydrogenase, partial [Gemmatimonas sp.] | diamond | 1143 | 70.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas sp. | |
| 27535076 | 27535076 | PRJNA533114_P_NODE_103563_length_247_cov_1.327586_g103311_i0 | PRJNA533114 | 103563 | 247 | 1.327586 | 3.27913742 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 53.1 | 5.92e-6 | NR | HET7040534.1 | 2448054 | g103311 | i0 | 47.7 | 1.32388663967611 | 65 | 25 | 78.9 | 2 | 235 | 41 | 110 | 165 | HET7040534.1 phosphate ABC transporter substrate-binding protein PstS [Gemmatimonadales bacterium] | diamond | 327 | 53.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 27741378 | 27741378 | PRJNA533114_P_NODE_41844_length_360_cov_0.902439_g41592_i0 | PRJNA533114 | 41844 | 360 | 0.902439 | 3.2487804 | Longimicrobiaceae bacterium | 3047548 | Bacteria | Bacteria | 107 | 2.24e-24 | NR | HET6231204.1 | 3047548 | g41592 | i0 | 46 | 1.05 | 126 | 62 | 100 | 3 | 360 | 1 | 494 | 619 | HET6231204.1 leishmanolysin-related zinc metalloendopeptidase [Longimicrobiaceae bacterium] | diamond | 378 | 107 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobiaceae bacterium | ||
| 28467408 | 28467408 | PRJNA533114_P_NODE_45886_length_346_cov_1.128205_g45634_i0 | PRJNA533114 | 45886 | 346 | 1.128205 | 3.9035893 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 43.9 | 0.042 | NR | HET9066388.1 | 2448054 | g45634 | i0 | 56.7 | 0.260115606936416 | 30 | 13 | 26 | 0 | 46 | 135 | 176 | 205 | HET9066388.1 glycosyltransferase [Gemmatimonadales bacterium] | diamond | 90 | 43.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 28513849 | 28513849 | PRJNA533114_P_NODE_41227_length_362_cov_1.266436_g40975_i0 | PRJNA533114 | 41227 | 362 | 1.266436 | 4.58449832 | Bacteria | 2 | Bacteria | Bacteria | 49.3 | 1.35e-4 | NR | MFH1568199.1 | 2026742 | g40975 | i0 | 46.7 | 1.5 | 45 | 24 | 37.3 | 0 | 228 | 362 | 7 | 51 | MFH1568199.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 543 | 49.7 | 0.991951710261569 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 28530592 | 28530592 | PRJNA533114_P_NODE_58527_length_311_cov_1.214286_g58275_i0 | PRJNA533114 | 58527 | 311 | 1.214286 | 3.77642946 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 127 | 1.1999999999999999e-32 | NR | MBL8960531.1 | 2026742 | g58275 | i0 | 71.1 | 4.67845659163987 | 97 | 28 | 93.6 | 0 | 291 | 1 | 241 | 337 | MBL8960531.1 S8 family peptidase [Gemmatimonadota bacterium] | diamond | 1455 | 127 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 28751418 | 28751418 | PRJNA533114_P_NODE_49027_length_336_cov_1.463878_g48775_i0 | PRJNA533114 | 49027 | 336 | 1.463878 | 4.91863008 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 71.2 | 1.1e-11 | NR | NNE08319.1 | 2026742 | g48775 | i0 | 34.8 | 1 | 112 | 68 | 99.1 | 3 | 333 | 1 | 63 | 170 | NNE08319.1 T9SS type A sorting domain-containing protein [Gemmatimonadota bacterium] | diamond | 336 | 71.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29035719 | 29035719 | PRJNA533114_P_NODE_106848_length_246_cov_0.890173_g106596_i0 | PRJNA533114 | 106848 | 246 | 0.890173 | 2.18982558 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 75.5 | 3.58e-14 | NR | HEX9482959.1 | 2026741 | g106596 | i0 | 50 | 0.926829268292683 | 76 | 38 | 92.7 | 0 | 242 | 15 | 188 | 263 | HEX9482959.1 Hsp20 family protein [Gemmatimonadaceae bacterium] | diamond | 228 | 75.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 29666740 | 29666740 | PRJNA533114_P_NODE_45330_length_348_cov_0.840000_g45078_i0 | PRJNA533114 | 45330 | 348 | 0.84 | 2.9232 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 54.7 | 5.92e-6 | NR | HEU5050793.1 | 2448054 | g45078 | i0 | 40.9 | 0.758620689655172 | 88 | 47 | 73.3 | 3 | 256 | 2 | 13 | 98 | HEU5050793.1 PDZ domain-containing protein [Gemmatimonadales bacterium] | diamond | 264 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29744995 | 29744995 | PRJNA533114_P_NODE_67250_length_291_cov_1.743119_g66998_i0 | PRJNA533114 | 67250 | 291 | 1.743119 | 5.07247629 | Bacteria | 2 | Bacteria | Bacteria | 48.5 | 5.71e-4 | NR | MDH3205933.1 | 2026742 | g66998 | i0 | 64.9 | 1.22680412371134 | 37 | 13 | 38.1 | 0 | 174 | 284 | 6 | 42 | MDH3205933.1 acyl-CoA dehydrogenase [Gemmatimonadota bacterium] | diamond | 357 | 48.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29793172 | 29793172 | PRJNA533114_P_NODE_3051_length_1194_cov_2.180196_g2914_i0 | PRJNA533114 | 3051 | 1194 | 2.180196 | 26.031540240000002 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 52 | 0.00329 | NR | MFO8175481.1 | 2910168 | g2914 | i0 | 32.2 | 0.444723618090452 | 177 | 97 | 44.2 | 5 | 422 | 949 | 159 | 313 | MFO8175481.1 filamin/ABP280 repeat domain-containing protein [Longimicrobiales bacterium] | diamond | 531 | 52 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 30457203 | 30457203 | PRJNA533114_P_NODE_33233_length_398_cov_1.418462_g32981_i0 | PRJNA533114 | 33233 | 398 | 1.418462 | 5.64547876 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 52.4 | 7.99e-5 | NR | MDH5588617.1 | 2026742 | g32981 | i0 | 63.9 | 0.271356783919598 | 36 | 13 | 27.1 | 0 | 397 | 290 | 400 | 435 | MDH5588617.1 TRZ/ATZ family hydrolase [Gemmatimonadota bacterium] | diamond | 108 | 52.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31008963 | 31008963 | PRJNA533114_P_NODE_113234_length_244_cov_0.900585_g112982_i0 | PRJNA533114 | 113234 | 244 | 0.900585 | 2.1974274 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 81.3 | 1.06e-16 | NR | MFN2635600.1 | 2026741 | g112982 | i0 | 53.4 | 4.38934426229508 | 73 | 32 | 87.3 | 1 | 29 | 241 | 6 | 78 | MFN2635600.1 SGNH/GDSL hydrolase family protein [Gemmatimonadaceae bacterium] | diamond | 1071 | 82 | 0.991463414634146 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31103633 | 31103633 | PRJNA533114_P_NODE_8875_length_755_cov_2.083578_g8659_i0 | PRJNA533114 | 8875 | 755 | 2.083578 | 15.7310139 | Bacteria | 2 | Bacteria | Bacteria | 101 | 2.5599999999999998e-23 | NR | MCY4352252.1 | 2026742 | g8659 | i0 | 49.5 | 2.04238410596026 | 93 | 45 | 37 | 1 | 296 | 18 | 4 | 94 | MCY4352252.1 Hsp20/alpha crystallin family protein [Gemmatimonadota bacterium] | diamond | 1542 | 101 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31563379 | 31563379 | PRJNA533114_P_NODE_96596_length_250_cov_0.870056_g96344_i0 | PRJNA533114 | 96596 | 250 | 0.870056 | 2.17514 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 43.5 | 0.022 | NR | HZD86152.1 | 2026741 | g96344 | i0 | 38.1 | 0.756 | 63 | 38 | 75.6 | 1 | 52 | 240 | 561 | 622 | HZD86152.1 RNB domain-containing ribonuclease [Gemmatimonadaceae bacterium] | diamond | 189 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31594930 | 31594930 | PRJNA533114_P_NODE_62476_length_302_cov_1.008734_g62224_i0 | PRJNA533114 | 62476 | 302 | 1.008734 | 3.04637668 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 80.9 | 2.34e-15 | NR | MEO7086311.1 | 2026741 | g62224 | i0 | 55.4 | 0.645695364238411 | 65 | 28 | 64.6 | 1 | 300 | 106 | 340 | 403 | MEO7086311.1 serine hydrolase domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 195 | 80.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32020976 | 32020976 | PRJNA533114_P_NODE_34098_length_394_cov_0.828660_g33846_i0 | PRJNA533114 | 34098 | 394 | 0.82866 | 3.2649204 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 130 | 4.709999999999999e-32 | NR | HVB31985.1 | 2026741 | g33846 | i0 | 49.6 | 2.83248730964467 | 119 | 58 | 89.1 | 2 | 394 | 44 | 173 | 291 | HVB31985.1 prolyl oligopeptidase family serine peptidase [Gemmatimonadaceae bacterium] | diamond | 1116 | 131 | 0.99236641221374 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32480628 | 32480628 | PRJNA533114_P_NODE_112659_length_244_cov_0.900585_g112407_i0 | PRJNA533114 | 112659 | 244 | 0.900585 | 2.1974274 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 45.8 | 0.00289 | NR | HET9133845.1 | 2448054 | g112407 | i0 | 36.6 | 1.63524590163934 | 82 | 45 | 94.7 | 3 | 237 | 7 | 140 | 219 | HET9133845.1 DMT family transporter [Gemmatimonadales bacterium] | diamond | 399 | 45.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 32512451 | 32512451 | PRJNA533114_P_NODE_121679_length_238_cov_2.333333_g121427_i0 | PRJNA533114 | 121679 | 238 | 2.333333 | 5.55333254 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 74.7 | 1.62e-13 | NR | MBW7934491.1 | 2026741 | g121427 | i0 | 50.7 | 0.894957983193277 | 71 | 32 | 89.5 | 1 | 235 | 23 | 148 | 215 | MBW7934491.1 thiamine pyrophosphate-binding protein [Gemmatimonadaceae bacterium] | diamond | 213 | 74.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32638069 | 32638069 | PRJNA533114_P_NODE_44100_length_352_cov_1.078853_g43848_i0 | PRJNA533114 | 44100 | 352 | 1.078853 | 3.79756256 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 47.8 | 9.4e-4 | NR | HEY7566466.1 | 2026741 | g43848 | i0 | 30.1 | 0.707386363636364 | 83 | 57 | 70.7 | 1 | 254 | 6 | 31 | 112 | HEY7566466.1 CHRD domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 249 | 47.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);;