contig_metadata
7 rows where bioproject = "PRJNA879067", tax_clade = "delta/epsilon subdivisions" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2514665 | 2514665 | PRJNA879067_P_NODE_61222_length_441_cov_4.437500_g57737_i0 | PRJNA879067 | 61222 | 441 | 4.4375 | 19.569375 | Pseudomonadota | 1224 | Bacteria | Bacteria | 237 | 1.1e-57 | NTclustered | gi|2874253999|emb|OY970324.1| | 34034 | g57737 | i0 | 81.132 | 259.18820861678 | 318 | 40 | 69 | 20 | 107 | 412 | 83628 | 83937 | MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1 | blastn | 114302 | 237 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 3791304 | 3791304 | PRJNA879067_P_NODE_96403_length_275_cov_1.925743_g92917_i0 | PRJNA879067 | 96403 | 275 | 1.925743 | 5.29579325 | Bacteria | 2 | Bacteria | Bacteria | 385 | 2.19e-102 | NTclustered | gi|339646543|gb|JN038932.1| | 34034 | g92917 | i0 | 95.082 | 96.8727272727273 | 244 | 12 | 89 | 0 | 32 | 275 | 1 | 244 | Uncultured delta proteobacterium clone M-B211 16S ribosomal RNA gene, partial sequence | blastn | 26640 | 385 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 7233743 | 7233743 | PRJNA879067_P_NODE_57966_length_463_cov_6.420513_g54481_i0 | PRJNA879067 | 57966 | 463 | 6.420513 | 29.72697519 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 261 | 6.860000000000001e-65 | NTclustered | gi|2874253999|emb|OY970324.1| | 34034 | g54481 | i0 | 82.468 | 170.82505399568 | 308 | 45 | 65 | 6 | 135 | 434 | 83631 | 83937 | MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1 | blastn | 79092 | 261 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 21256844 | 21256844 | PRJNA879067_P_NODE_33697_length_705_cov_3.330696_g30326_i0 | PRJNA879067 | 33697 | 705 | 3.330696 | 23.4814068 | uncultured delta proteobacterium DeepAnt-1F12 | 357894 | Bacteria | Bacteria | 399 | 2.1799999999999995e-106 | NTclustered | gi|82617822|gb|DQ267495.1| | 357894 | g30326 | i0 | 77.794 | 154.524822695035 | 698 | 121 | 95 | 22 | 30 | 701 | 4109 | 4798 | Uncultured delta proteobacterium DeepAnt-1F12 fosmid, complete sequence | blastn | 108940 | 399 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium DeepAnt-1F12 | ||||||
| 22530906 | 22530906 | PRJNA879067_P_NODE_17178_length_1119_cov_6.133843_g14416_i0 | PRJNA879067 | 17178 | 1119 | 6.133843 | 68.63770317 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 656 | 0 | NTclustered | gi|374854163|dbj|AP011765.1| | 34034 | g14416 | i0 | 85.294 | 102.974084003575 | 646 | 83 | 99 | 12 | 480 | 1119 | 13025 | 12386 | Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12 | blastn | 115228 | 656 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 22532870 | 22532870 | PRJNA879067_P_NODE_80538_length_337_cov_0.992424_g77052_i0 | PRJNA879067 | 80538 | 337 | 0.992424 | 3.34446888 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 540 | 5.569999999999999e-149 | NTclustered | gi|1597772012|gb|MK682782.1| | 34034 | g77052 | i0 | 97.468 | 91.5044510385757 | 316 | 8 | 94 | 0 | 22 | 337 | 67 | 382 | Uncultured delta proteobacterium clone 13 16S ribosomal RNA gene, partial sequence | blastn | 30837 | 540 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 25081824 | 25081824 | PRJNA879067_P_NODE_67240_length_403_cov_3.715152_g63755_i0 | PRJNA879067 | 67240 | 403 | 3.715152 | 14.97206256 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 355 | 2.63e-93 | NTclustered | gi|2874253999|emb|OY970324.1| | 34034 | g63755 | i0 | 84 | 106.858560794045 | 375 | 54 | 93 | 6 | 31 | 403 | 83134 | 82764 | MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1 | blastn | 43064 | 355 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium |
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);;