contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax_phylum = "Candidatus Eiseniibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 128887 | 128887 | PRJEB64798_P_NODE_43721_length_298_cov_3.100402_g41956_i0 | PRJEB64798 | 43721 | 298 | 3.100402 | 9.23919796 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 331 | 3.18e-86 | NTclustered | gi|2874254017|emb|OY970342.1| | 2212470 | g41956 | i0 | 90.157 | 427.536912751678 | 254 | 25 | 85 | 0 | 17 | 270 | 4155723 | 4155976 | MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1 | blastn | 127406 | 331 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 5229591 | 5229591 | PRJEB64798_P_NODE_141985_length_192_cov_6.923077_g140219_i0 | PRJEB64798 | 141985 | 192 | 6.923077 | 13.29230784 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 122 | 1.2399999999999999e-23 | NTclustered | gi|2874254017|emb|OY970342.1| | 2212470 | g140219 | i0 | 79.188 | 1.02604166666667 | 197 | 26 | 97 | 14 | 3 | 188 | 4157991 | 4158183 | MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1 | blastn | 197 | 122 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 7782037 | 7782037 | PRJEB64798_P_NODE_79947_length_215_cov_4.096386_g78181_i0 | PRJEB64798 | 79947 | 215 | 4.096386 | 8.8072299 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 342 | 9.999999999999999e-90 | NTclustered | gi|2874254017|emb|OY970342.1| | 2212470 | g78181 | i0 | 95.349 | 176.455813953488 | 215 | 10 | 100 | 0 | 1 | 215 | 4159066 | 4158852 | MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1 | blastn | 37938 | 342 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 11605435 | 11605435 | PRJEB64798_P_NODE_140130_length_193_cov_6.034722_g138364_i0 | PRJEB64798 | 140130 | 193 | 6.034722 | 11.64701346 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 283 | 5.42e-72 | NTclustered | gi|2874254095|emb|OY970178.1| | 2212470 | g138364 | i0 | 93.651 | 3.46632124352332 | 189 | 12 | 98 | 0 | 5 | 193 | 1426046 | 1425858 | MAG: Candidatus Eisenbacteria bacterium isolate MFD05942.bin.c.1 genome assembly, chromosome: 1 | blastn | 669 | 283 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 12881328 | 12881328 | PRJEB64798_P_NODE_188371_length_171_cov_2.336066_g186605_i0 | PRJEB64798 | 188371 | 171 | 2.336066 | 3.99467286 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 220 | 3.71e-53 | NTclustered | gi|2874254017|emb|OY970342.1| | 2212470 | g186605 | i0 | 90.854 | 2.30994152046784 | 164 | 15 | 96 | 0 | 3 | 166 | 4158302 | 4158465 | MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1 | blastn | 395 | 220 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 15429083 | 15429083 | PRJEB64798_P_NODE_122853_length_204_cov_5.516129_g121087_i0 | PRJEB64798 | 122853 | 204 | 5.516129 | 11.25290316 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 276 | 9.7e-70 | NTclustered | gi|2874254095|emb|OY970178.1| | 2212470 | g121087 | i0 | 91.919 | 119.21568627451 | 198 | 14 | 97 | 2 | 8 | 204 | 1426911 | 1426715 | MAG: Candidatus Eisenbacteria bacterium isolate MFD05942.bin.c.1 genome assembly, chromosome: 1 | blastn | 24320 | 276 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 15430457 | 15430457 | PRJEB64798_P_NODE_214473_length_163_cov_10.078947_g212707_i0 | PRJEB64798 | 214473 | 163 | 10.078947 | 16.42868361 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 104 | 3.7e-18 | NTclustered | gi|2874254017|emb|OY970342.1| | 2212470 | g212707 | i0 | 82.927 | 184.552147239264 | 123 | 13 | 71 | 7 | 5 | 120 | 4158943 | 4159064 | MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1 | blastn | 30082 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 20530301 | 20530301 | PRJEB64798_P_NODE_65037_length_241_cov_2.796875_g63272_i0 | PRJEB64798 | 65037 | 241 | 2.796875 | 6.74046875 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 141 | 4.5e-29 | NTclustered | gi|2874254095|emb|OY970178.1| | 2212470 | g63272 | i0 | 92.857 | 78.9045643153527 | 98 | 6 | 40 | 1 | 14 | 110 | 1426514 | 1426611 | MAG: Candidatus Eisenbacteria bacterium isolate MFD05942.bin.c.1 genome assembly, chromosome: 1 | blastn | 19016 | 141 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota 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);;