contig_metadata
9 rows where bioproject = "PRJNA414036" and tax_clade = "delta/epsilon subdivisions"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3633782 | 3633782 | PRJNA414036_P_NODE_44383_length_231_cov_3.469388_g42644_i0 | PRJNA414036 | 44383 | 231 | 3.469388 | 8.01428628 | Bacteria | 2 | Bacteria | Bacteria | 122 | 1.55e-23 | NTclustered | gi|298231328|emb|FN811199.1| | 34034 | g42644 | i0 | 100 | 29.995670995671 | 66 | 0 | 29 | 0 | 10 | 75 | 28 | 93 | Uncultured delta proteobacterium partial 16S rRNA gene, clone UMAB-cl-15 | blastn | 6929 | 122 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 16996299 | 16996299 | PRJNA414036_P_NODE_85594_length_154_cov_873.411765_g83855_i0 | PRJNA414036 | 85594 | 154 | 873.411765 | 1345.0541181 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 158 | 2.6e-34 | NTclustered | gi|148723952|gb|EF520537.1| | 34034 | g83855 | i0 | 88.462 | 84.9545454545455 | 130 | 15 | 84 | 0 | 22 | 151 | 1130 | 1259 | Uncultured delta proteobacterium clone ADK-BTh02-06 16S ribosomal RNA gene, partial sequence | blastn | 13083 | 158 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 17660494 | 17660494 | PRJNA414036_P_NODE_4194_length_543_cov_3390.921260_g3404_i0 | PRJNA414036 | 4194 | 543 | 3390.92126 | 18412.7024418 | Polyangium | 55 | Bacteria | Bacteria | 710 | 0 | NTclustered | gi|146429340|gb|EF220156.1| | 34034 | g3404 | i0 | 91.363 | 103.252302025783 | 521 | 41 | 96 | 4 | 10 | 528 | 531 | 13 | Uncultured delta proteobacterium clone G06_ELL02 16S ribosomal RNA gene, partial sequence | blastn | 56066 | 713 | 0.995792426367461 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 21484686 | 21484686 | PRJNA414036_P_NODE_57957_length_224_cov_27.783069_g56218_i0 | PRJNA414036 | 57957 | 224 | 27.783069 | 62.23407456 | Bacteria | 2 | Bacteria | Bacteria | 145 | 3.19e-30 | NTclustered | gi|152031374|gb|EF999009.1| | 34034 | g56218 | i0 | 78.539 | 97.8035714285714 | 219 | 47 | 98 | 0 | 6 | 224 | 398 | 180 | Uncultured delta proteobacterium clone M2 16S ribosomal RNA gene, partial sequence | blastn | 21908 | 145 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 26790813 | 26790813 | PRJNA414036_P_NODE_59221_length_219_cov_11.706522_g57482_i0 | PRJNA414036 | 59221 | 219 | 11.706522 | 25.63728318 | uncultured delta proteobacterium HF | 34034 | Bacteria | Bacteria | 49.3 | 3.07e-5 | NR | ADI18196.1 | 710833 | g57482 | i0 | 53.5 | 0.589041095890411 | 43 | 20 | 58.9 | 0 | 197 | 69 | 74 | 116 | ADI18196.1 hypothetical protein [uncultured delta proteobacterium HF0200_39N20] | diamond | 129 | 49.3 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0200_39N20 | ||||||
| 27549390 | 27549390 | PRJNA414036_P_NODE_40004_length_232_cov_108.979695_g38265_i0 | PRJNA414036 | 40004 | 232 | 108.979695 | 252.8328924 | uncultured delta proteobacterium HF | 34034 | Bacteria | Bacteria | 47 | 1.49e-4 | NR | ADI18200.1 | 710833 | g38265 | i0 | 58.1 | 0.556034482758621 | 43 | 18 | 55.6 | 0 | 130 | 2 | 9 | 51 | ADI18200.1 hypothetical protein [uncultured delta proteobacterium HF0200_39N20] | diamond | 129 | 47 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0200_39N20 | ||||||
| 29712776 | 29712776 | PRJNA414036_P_NODE_64330_length_200_cov_3.915152_g62591_i0 | PRJNA414036 | 64330 | 200 | 3.915152 | 7.830304 | Bacteria | 2 | Bacteria | Bacteria | 47.8 | 1.94e-4 | NR | ADI17622.1 | 710828 | g62591 | i0 | 44.9 | 2.07 | 69 | 32 | 94.5 | 1 | 2 | 190 | 90 | 158 | ADI17622.1 hypothetical protein [uncultured delta proteobacterium HF0130_19C20] | diamond | 414 | 47.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0130_19C20 | ||||||
| 31451171 | 31451171 | PRJNA414036_P_NODE_3456_length_566_cov_9.512241_g2796_i0 | PRJNA414036 | 3456 | 566 | 9.512241 | 53.83928406 | Pseudomonadota | 1224 | Bacteria | Bacteria | 46.6 | 0.0119 | NR | ADI17622.1 | 710828 | g2796 | i0 | 66.7 | 1.21378091872792 | 33 | 11 | 17.5 | 0 | 329 | 231 | 90 | 122 | ADI17622.1 hypothetical protein [uncultured delta proteobacterium HF0130_19C20] | diamond | 687 | 46.6 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0130_19C20 | ||||||
| 32352066 | 32352066 | PRJNA414036_P_NODE_2299_length_618_cov_9.205832_g1830_i0 | PRJNA414036 | 2299 | 618 | 9.205832 | 56.89204176 | uncultured delta proteobacterium HF | 34034 | Bacteria | Bacteria | 43.9 | 0.0218 | NR | ADI17207.1 | 710824 | g1830 | i0 | 45.7 | 0.223300970873786 | 46 | 25 | 22.3 | 0 | 568 | 431 | 23 | 68 | ADI17207.1 hypothetical protein [uncultured delta proteobacterium HF0070_10I02] | diamond | 138 | 43.9 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0070_10I02 |
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);;