contig_metadata
9 rows where bioproject = "PRJNA983848", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9896601 | 9896601 | PRJNA983848_P_NODE_167088_length_211_cov_4.376812_g161205_i0 | PRJNA983848 | 167088 | 211 | 4.376812 | 9.23507332 | uncultured delta proteobacterium HF0010_01J10 | 710820 | Bacteria | Bacteria | 279 | 7.81e-71 | NTclustered | gi|297180392|gb|GU474842.1| | 710820 | g161205 | i0 | 90.865 | 60.9668246445498 | 208 | 19 | 99 | 0 | 1 | 208 | 14053 | 13846 | Uncultured delta proteobacterium HF0010_01J10 genomic sequence | blastn | 12864 | 279 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0010_01J10 | ||||||
| 14995510 | 14995510 | PRJNA983848_P_NODE_140712_length_251_cov_2.297753_g134829_i0 | PRJNA983848 | 140712 | 251 | 2.297753 | 5.76736003 | uncultured delta proteobacterium DeepAnt-32C6 | 357895 | Bacteria | Bacteria | 374 | 4.27e-99 | NTclustered | gi|82617838|gb|DQ267496.1| | 357895 | g134829 | i0 | 93.6 | 384.294820717131 | 250 | 16 | 99 | 0 | 1 | 250 | 3620 | 3869 | Uncultured delta proteobacterium DeepAnt-32C6 fosmid, complete sequence | blastn | 96458 | 374 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium DeepAnt-32C6 | ||||||
| 20094183 | 20094183 | PRJNA983848_P_NODE_146656_length_248_cov_1.845714_g140773_i0 | PRJNA983848 | 146656 | 248 | 1.845714 | 4.57737072 | uncultured delta proteobacterium DeepAnt-1F12 | 357894 | Bacteria | Bacteria | 331 | 2.57e-86 | NTclustered | gi|82617822|gb|DQ267495.1| | 357894 | g140773 | i0 | 94.444 | 176.383064516129 | 216 | 10 | 87 | 2 | 34 | 248 | 4469 | 4255 | Uncultured delta proteobacterium DeepAnt-1F12 fosmid, complete sequence | blastn | 43743 | 331 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium DeepAnt-1F12 | ||||||
| 20094765 | 20094765 | PRJNA983848_P_NODE_163956_length_232_cov_3.748428_g158073_i0 | PRJNA983848 | 163956 | 232 | 3.748428 | 8.69635296 | uncultured delta proteobacterium HF0010_01J10 | 710820 | Bacteria | Bacteria | 268 | 1.89e-67 | NTclustered | gi|297180392|gb|GU474842.1| | 710820 | g158073 | i0 | 88.94 | 69.2672413793103 | 217 | 24 | 94 | 0 | 4 | 220 | 13696 | 13480 | Uncultured delta proteobacterium HF0010_01J10 genomic sequence | blastn | 16070 | 268 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0010_01J10 | ||||||
| 21370497 | 21370497 | PRJNA983848_P_NODE_163377_length_234_cov_2.695652_g157494_i0 | PRJNA983848 | 163377 | 234 | 2.695652 | 6.30782568 | Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_ | 2026735 | Bacteria | Bacteria | 129 | 2.63e-33 | NR | PIR26441.1 | 1973973 | g157494 | i0 | 77.3 | 10.7307692307692 | 75 | 17 | 96.2 | 0 | 9 | 233 | 320 | 394 | PIR26441.1 MAG: glutamine-hydrolyzing GMP synthase [Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_42_23] | diamond | 2511 | 129 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_42_23 | ||||||
| 21370558 | 21370558 | PRJNA983848_P_NODE_164977_length_229_cov_6.012821_g159094_i0 | PRJNA983848 | 164977 | 229 | 6.012821 | 13.76936009 | uncultured delta proteobacterium HF0010_01J10 | 710820 | Bacteria | Bacteria | 291 | 3.98e-74 | NTclustered | gi|297180392|gb|GU474842.1| | 710820 | g159094 | i0 | 90.783 | 31.8951965065502 | 217 | 20 | 95 | 0 | 1 | 217 | 13696 | 13480 | Uncultured delta proteobacterium HF0010_01J10 genomic sequence | blastn | 7304 | 291 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0010_01J10 | ||||||
| 21372653 | 21372653 | PRJNA983848_P_NODE_73497_length_365_cov_7.332192_g67614_i0 | PRJNA983848 | 73497 | 365 | 7.332192 | 26.7625008 | uncultured delta proteobacterium HF0070_10I02 | 710824 | Bacteria | Bacteria | 438 | 2.2799999999999995e-118 | NTclustered | gi|297181000|gb|GU474857.1| | 710824 | g67614 | i0 | 88.462 | 140.627397260274 | 364 | 40 | 99 | 1 | 2 | 363 | 6743 | 7106 | Uncultured delta proteobacterium HF0070_10I02 genomic sequence | blastn | 51329 | 438 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0070_10I02 | ||||||
| 22647227 | 22647227 | PRJNA983848_P_NODE_63358_length_405_cov_2.367470_g57476_i0 | PRJNA983848 | 63358 | 405 | 2.36747 | 9.5882535 | uncultured delta proteobacterium HF0010_01J10 | 710820 | Bacteria | Bacteria | 547 | 4.0599999999999985e-151 | NTclustered | gi|297180392|gb|GU474842.1| | 710820 | g57476 | i0 | 92.838 | 195.266666666667 | 377 | 27 | 93 | 0 | 1 | 377 | 13742 | 14118 | Uncultured delta proteobacterium HF0010_01J10 genomic sequence | blastn | 79083 | 547 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0010_01J10 | ||||||
| 25193816 | 25193816 | PRJNA983848_P_NODE_142600_length_250_cov_2.542373_g136717_i0 | PRJNA983848 | 142600 | 250 | 2.542373 | 6.3559325 | uncultured delta proteobacterium HF0010_01J10 | 710820 | Bacteria | Bacteria | 363 | 9.209999999999997e-96 | NTclustered | gi|297180392|gb|GU474842.1| | 710820 | g136717 | i0 | 92.829 | 156.388 | 251 | 16 | 100 | 2 | 1 | 250 | 13719 | 13968 | Uncultured delta proteobacterium HF0010_01J10 genomic sequence | blastn | 39097 | 363 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0010_01J10 |
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);;