contig_metadata
12 rows where bioproject = "PRJNA1028258" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7816043 | 7816043 | PRJNA1028258_P_NODE_130987_length_235_cov_1.698795_g130424_i0 | PRJNA1028258 | 130987 | 235 | 1.698795 | 3.99216825 | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14 | 2013741 | Bacteria | Bacteria | 111 | 2.56e-26 | NR | PKN56670.1 | 2013741 | g130424 | i0 | 68.5 | 0.931914893617021 | 73 | 23 | 93.2 | 0 | 15 | 233 | 924 | 996 | PKN56670.1 MAG: hypothetical protein CVU56_14940 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14] | diamond | 219 | 111 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14 | ||||||
| 12917322 | 12917322 | PRJNA1028258_P_NODE_139871_length_233_cov_1.609756_g139308_i0 | PRJNA1028258 | 139871 | 233 | 1.609756 | 3.75073148 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 91.6 | 4.42e-14 | NTclustered | gi|2874253999|emb|OY970324.1| | 34034 | g139308 | i0 | 86.585 | 1.43347639484979 | 82 | 11 | 35 | 0 | 140 | 221 | 4182588 | 4182507 | MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1 | blastn | 334 | 91.6 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 18015071 | 18015071 | PRJNA1028258_P_NODE_118155_length_246_cov_1.152542_g117592_i0 | PRJNA1028258 | 118155 | 246 | 1.152542 | 2.83525332 | Persicimonas caeni | 2292766 | Bacteria | Bacteria | 65.8 | 2.85e-6 | NTclustered | gi|1695542189|gb|CP041186.1| | 2292766 | g117592 | i0 | 100 | 3.61382113821138 | 35 | 0 | 14 | 0 | 60 | 94 | 6198702 | 6198668 | Persicimonas caeni strain YN101 chromosome | blastn | 889 | 65.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Persicimonas | Persicimonas caeni | |||
| 26869150 | 26869150 | PRJNA1028258_P_NODE_7081_length_923_cov_2.161593_g6718_i0 | PRJNA1028258 | 7081 | 923 | 2.161593 | 19.95150339 | Bacteria | 2 | Bacteria | Bacteria | 57.8 | 3.24e-5 | NR | OGQ44868.1 | 1797879 | g6718 | i0 | 48.2 | 1.0433369447454 | 56 | 29 | 18.2 | 0 | 8 | 175 | 527 | 582 | OGQ44868.1 MAG: hypothetical protein A3H42_02605 [Deltaproteobacteria bacterium RIFCSPLOWO2_02_FULL_46_8] | diamond | 963 | 57.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFCSPLOWO2_02_FULL_46_8 | ||||||
| 27414543 | 27414543 | PRJNA1028258_P_NODE_129023_length_237_cov_1.267857_g128460_i0 | PRJNA1028258 | 129023 | 237 | 1.267857 | 3.00482109 | Lujinxingia vulgaris | 2600176 | Bacteria | Bacteria | 43.5 | 0.0129 | NR | WP_146972156.1 | 2600176 | g128460 | i0 | 35.6 | 0.746835443037975 | 59 | 35 | 74.7 | 1 | 42 | 218 | 64 | 119 | WP_146972156.1 hypothetical protein [Lujinxingia vulgaris] | diamond | 177 | 43.5 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Lujinxingiaceae | Lujinxingia | Lujinxingia vulgaris | |||
| 27880009 | 27880009 | PRJNA1028258_P_NODE_122265_length_242_cov_1.751445_g121702_i0 | PRJNA1028258 | 122265 | 242 | 1.751445 | 4.2384969 | Bacteria | 2 | Bacteria | Bacteria | 113 | 7.44e-28 | NR | OGQ20604.1 | 1797848 | g121702 | i0 | 71.3 | 1.98347107438017 | 80 | 23 | 99.2 | 0 | 3 | 242 | 132 | 211 | OGQ20604.1 MAG: hypothetical protein A2138_12550 [Deltaproteobacteria bacterium RBG_16_71_12] | diamond | 480 | 113 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RBG_16_71_12 | ||||||
| 28709007 | 28709007 | PRJNA1028258_P_NODE_145387_length_232_cov_0.871166_g144824_i0 | PRJNA1028258 | 145387 | 232 | 0.871166 | 2.02110512 | SAR324 cluster bacterium | 2024889 | Bacteria | Bacteria | 57.8 | 1.54e-7 | NR | MBF0286954.1 | 2024889 | g144824 | i0 | 39.1 | 1.73275862068966 | 64 | 39 | 82.8 | 0 | 15 | 206 | 21 | 84 | MBF0286954.1 ABC transporter permease [SAR324 cluster bacterium] | diamond | 402 | 57.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 29426934 | 29426934 | PRJNA1028258_P_NODE_177749_length_225_cov_0.910256_g177186_i0 | PRJNA1028258 | 177749 | 225 | 0.910256 | 2.048076 | Deltaproteobacteria | 28221 | Bacteria | Bacteria | 82 | 3.18e-16 | NR | WP_111332980.1 | 1548548 | g177186 | i0 | 54.1 | 4.93333333333333 | 74 | 34 | 98.7 | 0 | 3 | 224 | 192 | 265 | WP_111332980.1 pyridoxal-phosphate-dependent aminotransferase family protein [Bradymonas sediminis] | diamond | 1110 | 82.8 | 0.990338164251208 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Bradymonas | Bradymonas sediminis | |||
| 29498164 | 29498164 | PRJNA1028258_P_NODE_174590_length_225_cov_1.365385_g174027_i0 | PRJNA1028258 | 174590 | 225 | 1.365385 | 3.07211625 | Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_ | 2026735 | Bacteria | Bacteria | 60.1 | 2.26e-8 | NR | PIR26036.1 | 1973973 | g174027 | i0 | 38.4 | 0.973333333333333 | 73 | 45 | 97.3 | 0 | 223 | 5 | 830 | 902 | PIR26036.1 MAG: isoleucine--tRNA ligase [Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_42_23] | diamond | 219 | 60.1 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_42_23 | ||||||
| 30508980 | 30508980 | PRJNA1028258_P_NODE_138613_length_234_cov_0.860606_g138050_i0 | PRJNA1028258 | 138613 | 234 | 0.860606 | 2.01381804 | Deltaproteobacteria bacterium PRO3 | 2575691 | Bacteria | Bacteria | 47.4 | 8.05e-4 | NR | MDL1872576.1 | 2575691 | g138050 | i0 | 82.6 | 1.52564102564103 | 23 | 4 | 29.5 | 0 | 234 | 166 | 612 | 634 | MDL1872576.1 aconitate hydratase AcnA [Deltaproteobacteria bacterium PRO3] | diamond | 357 | 47.4 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium PRO3 | ||||||
| 31986823 | 31986823 | PRJNA1028258_P_NODE_146638_length_232_cov_0.871166_g146075_i0 | PRJNA1028258 | 146638 | 232 | 0.871166 | 2.02110512 | Bradymonadaceae | 1779135 | Bacteria | Bacteria | 76.6 | 8.02e-15 | NR | WP_204355067.1 | 1548548 | g146075 | i0 | 57.8 | 2.56034482758621 | 64 | 26 | 82.8 | 1 | 41 | 232 | 30 | 92 | WP_204355067.1 CDP-alcohol phosphatidyltransferase family protein [Bradymonas sediminis] | diamond | 594 | 77 | 0.994805194805195 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Bradymonas | Bradymonas sediminis | |||
| 32658565 | 32658565 | PRJNA1028258_P_NODE_32820_length_443_cov_1.139037_g32258_i0 | PRJNA1028258 | 32820 | 443 | 1.139037 | 5.04593391 | Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_63_12 | 1973967 | Bacteria | Bacteria | 68.9 | 2.39e-10 | NR | PJB48295.1 | 1973967 | g32258 | i0 | 30.5 | 1.81489841986456 | 154 | 57 | 77.2 | 7 | 413 | 72 | 528 | 671 | PJB48295.1 MAG: hypothetical protein CO108_02605 [Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_63_12] | diamond | 804 | 68.9 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_63_12 |
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);;