contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Uhriibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4117484 | 4117484 | PRJNA1148190_P_NODE_109964_length_506_cov_2.020785_g98803_i0 | PRJNA1148190 | 109964 | 506 | 2.020785 | 10.2251721 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 538 | 3.119999999999999e-148 | NTclustered | gi|1958012472|gb|CP064964.1| | 2053634 | g98803 | i0 | 85.882 | 79.9624505928854 | 510 | 66 | 100 | 5 | 1 | 506 | 766609 | 766102 | MAG: Candidatus Uhrbacteria bacterium isolate Bjer_18-Q3-R1-45_BAT3C.201_fly chromosome, complete genome | blastn | 40461 | 538 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 4119027 | 4119027 | PRJNA1148190_P_NODE_19764_length_1858_cov_1.833053_g11770_i0 | PRJNA1148190 | 19764 | 1858 | 1.833053 | 34.05812474 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 119 | 1.86e-21 | NTclustered | gi|1958012472|gb|CP064964.1| | 2053634 | g11770 | i0 | 91.954 | 0.916576964477933 | 87 | 4 | 5 | 3 | 65 | 150 | 187449 | 187365 | MAG: Candidatus Uhrbacteria bacterium isolate Bjer_18-Q3-R1-45_BAT3C.201_fly chromosome, complete genome | blastn | 1703 | 119 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 4121347 | 4121347 | PRJNA1148190_P_NODE_348204_length_301_cov_1.350877_g337031_i0 | PRJNA1148190 | 348204 | 301 | 1.350877 | 4.06613977 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 217 | 9.39e-52 | NTclustered | gi|2874254032|emb|OY970357.1| | 2053634 | g337031 | i0 | 81.579 | 6.27242524916944 | 266 | 45 | 88 | 3 | 3 | 266 | 907237 | 907500 | MAG: Candidatus Uhrbacteria bacterium isolate MFD02416.bin.c.4 genome assembly, chromosome: 1 | blastn | 1888 | 217 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 5395205 | 5395205 | PRJNA1148190_P_NODE_19505_length_1879_cov_2.181617_g11586_i0 | PRJNA1148190 | 19505 | 1879 | 2.181617 | 40.99258343 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 621 | 1.1799999999999997e-172 | NTclustered | gi|1958012472|gb|CP064964.1| | 2053634 | g11586 | i0 | 80.364 | 12.6146886641831 | 825 | 156 | 44 | 6 | 899 | 1720 | 54633 | 53812 | MAG: Candidatus Uhrbacteria bacterium isolate Bjer_18-Q3-R1-45_BAT3C.201_fly chromosome, complete genome | blastn | 23703 | 621 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 5401527 | 5401527 | PRJNA1148190_P_NODE_643585_length_248_cov_0.880000_g632412_i0 | PRJNA1148190 | 643585 | 248 | 0.88 | 2.1824 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2874254032|emb|OY970357.1| | 2053634 | g632412 | i0 | 100 | 0.120967741935484 | 30 | 0 | 12 | 0 | 108 | 137 | 415176 | 415205 | MAG: Candidatus Uhrbacteria bacterium isolate MFD02416.bin.c.4 genome assembly, chromosome: 1 | blastn | 30 | 56.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 6673630 | 6673630 | PRJNA1148190_P_NODE_444826_length_277_cov_1.750000_g433653_i0 | PRJNA1148190 | 444826 | 277 | 1.75 | 4.8475 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 78.7 | 4.2e-10 | NTclustered | gi|2874254032|emb|OY970357.1| | 2053634 | g433653 | i0 | 94.231 | 0.696750902527076 | 52 | 2 | 19 | 1 | 115 | 166 | 478840 | 478790 | MAG: Candidatus Uhrbacteria bacterium isolate MFD02416.bin.c.4 genome assembly, chromosome: 1 | blastn | 193 | 78.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 9226912 | 9226912 | PRJNA1148190_P_NODE_682028_length_246_cov_0.890173_g670855_i0 | PRJNA1148190 | 682028 | 246 | 0.890173 | 2.18982558 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 91.6 | 4.71e-14 | NTclustered | gi|1958012472|gb|CP064964.1| | 2053634 | g670855 | i0 | 92.188 | 1.1869918699187 | 64 | 5 | 26 | 0 | 66 | 129 | 7965 | 7902 | MAG: Candidatus Uhrbacteria bacterium isolate Bjer_18-Q3-R1-45_BAT3C.201_fly chromosome, complete genome | blastn | 292 | 91.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 11772254 | 11772254 | PRJNA1148190_P_NODE_29370_length_1313_cov_2.266129_g19817_i0 | PRJNA1148190 | 29370 | 1313 | 2.266129 | 29.75427377 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 117 | 4.7e-21 | NTclustered | gi|1958012472|gb|CP064964.1| | 2053634 | g19817 | i0 | 92.683 | 0.121858339680122 | 82 | 5 | 6 | 1 | 25 | 105 | 806298 | 806217 | MAG: Candidatus Uhrbacteria bacterium isolate Bjer_18-Q3-R1-45_BAT3C.201_fly chromosome, complete genome | blastn | 160 | 117 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 14329354 | 14329354 | PRJNA1148190_P_NODE_797932_length_234_cov_2.844720_g786759_i0 | PRJNA1148190 | 797932 | 234 | 2.84472 | 6.6566448 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 124 | 4.38e-24 | NTclustered | gi|1958012472|gb|CP064964.1| | 2053634 | g786759 | i0 | 90.426 | 0.401709401709402 | 94 | 9 | 40 | 0 | 104 | 197 | 374069 | 373976 | MAG: Candidatus Uhrbacteria bacterium isolate Bjer_18-Q3-R1-45_BAT3C.201_fly chromosome, complete genome | blastn | 94 | 124 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 15596011 | 15596011 | PRJNA1148190_P_NODE_26633_length_1433_cov_2.332353_g17442_i0 | PRJNA1148190 | 26633 | 1433 | 2.332353 | 33.42261849 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 673 | 0 | NTclustered | gi|1958012472|gb|CP064964.1| | 2053634 | g17442 | i0 | 82.946 | 92.1053733426378 | 774 | 104 | 53 | 22 | 4 | 765 | 765907 | 765150 | MAG: Candidatus Uhrbacteria bacterium isolate Bjer_18-Q3-R1-45_BAT3C.201_fly chromosome, complete genome | blastn | 131987 | 673 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 19416940 | 19416940 | PRJNA1148190_P_NODE_129356_length_463_cov_1.689744_g118193_i0 | PRJNA1148190 | 129356 | 463 | 1.689744 | 7.82351472 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 158 | 9.26e-34 | NTclustered | gi|1958012472|gb|CP064964.1| | 2053634 | g118193 | i0 | 91.525 | 18.9416846652268 | 118 | 4 | 25 | 6 | 247 | 362 | 705205 | 705318 | MAG: Candidatus Uhrbacteria bacterium isolate Bjer_18-Q3-R1-45_BAT3C.201_fly chromosome, complete genome | blastn | 8770 | 158 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 19418093 | 19418093 | PRJNA1148190_P_NODE_192956_length_382_cov_1.563107_g181786_i0 | PRJNA1148190 | 192956 | 382 | 1.563107 | 5.97106874 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 158 | 7.5e-34 | NTclustered | gi|1958012472|gb|CP064964.1| | 2053634 | g181786 | i0 | 100 | 0.884816753926702 | 85 | 0 | 22 | 0 | 95 | 179 | 303021 | 303105 | MAG: Candidatus Uhrbacteria bacterium isolate Bjer_18-Q3-R1-45_BAT3C.201_fly chromosome, complete genome | blastn | 338 | 158 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 19419249 | 19419249 | PRJNA1148190_P_NODE_264716_length_336_cov_1.171103_g253545_i0 | PRJNA1148190 | 264716 | 336 | 1.171103 | 3.93490608 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 82.4 | 4.04e-11 | NTclustered | gi|1958012472|gb|CP064964.1| | 2053634 | g253545 | i0 | 85.185 | 1.5625 | 81 | 11 | 24 | 1 | 157 | 236 | 827303 | 827223 | MAG: Candidatus Uhrbacteria bacterium isolate Bjer_18-Q3-R1-45_BAT3C.201_fly chromosome, complete genome | blastn | 525 | 82.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 20695105 | 20695105 | PRJNA1148190_P_NODE_295937_length_321_cov_2.290323_g284764_i0 | PRJNA1148190 | 295937 | 321 | 2.290323 | 7.35193683 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 115 | 3.790000000000001e-21 | NTclustered | gi|2874254032|emb|OY970357.1| | 2053634 | g284764 | i0 | 86.667 | 29.8629283489097 | 105 | 13 | 33 | 1 | 123 | 227 | 956271 | 956168 | MAG: Candidatus Uhrbacteria bacterium isolate MFD02416.bin.c.4 genome assembly, chromosome: 1 | blastn | 9586 | 115 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 21968901 | 21968901 | PRJNA1148190_P_NODE_197398_length_378_cov_2.439344_g186228_i0 | PRJNA1148190 | 197398 | 378 | 2.439344 | 9.22072032 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 294 | 5.42e-75 | NTclustered | gi|1958012472|gb|CP064964.1| | 2053634 | g186228 | i0 | 82.267 | 22.1746031746032 | 344 | 57 | 90 | 3 | 32 | 373 | 3053 | 3394 | MAG: Candidatus Uhrbacteria bacterium isolate Bjer_18-Q3-R1-45_BAT3C.201_fly chromosome, complete genome | blastn | 8382 | 294 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 21972579 | 21972579 | PRJNA1148190_P_NODE_447098_length_277_cov_1.254902_g435925_i0 | PRJNA1148190 | 447098 | 277 | 1.254902 | 3.47607854 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 119 | 2.48e-22 | NTclustered | gi|2874254032|emb|OY970357.1| | 2053634 | g435925 | i0 | 93.75 | 6.14801444043321 | 80 | 4 | 29 | 1 | 92 | 171 | 622107 | 622185 | MAG: Candidatus Uhrbacteria bacterium isolate MFD02416.bin.c.4 genome assembly, chromosome: 1 | blastn | 1703 | 119 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 24521881 | 24521881 | PRJNA1148190_P_NODE_45620_length_912_cov_2.351609_g34970_i0 | PRJNA1148190 | 45620 | 912 | 2.351609 | 21.44667408 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 259 | 5.06e-64 | NTclustered | gi|1958012472|gb|CP064964.1| | 2053634 | g34970 | i0 | 74.724 | 0.982456140350877 | 633 | 135 | 67 | 23 | 301 | 912 | 899409 | 898781 | MAG: Candidatus Uhrbacteria bacterium isolate Bjer_18-Q3-R1-45_BAT3C.201_fly chromosome, complete genome | blastn | 896 | 259 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria 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);;