contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJEB66218" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7784469 | 7784469 | PRJEB66218_P_NODE_193667_length_213_cov_1.282895_g191237_i0 | PRJEB66218 | 193667 | 213 | 1.282895 | 2.73256635 | uncultured delta proteobacterium HF0010_01J10 | 710820 | Bacteria | Bacteria | 224 | 3.7499999999999997e-54 | NTclustered | gi|297180392|gb|GU474842.1| | 710820 | g191237 | i0 | 87.565 | 142.431924882629 | 193 | 24 | 91 | 0 | 21 | 213 | 12837 | 12645 | Uncultured delta proteobacterium HF0010_01J10 genomic sequence | blastn | 30338 | 224 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0010_01J10 | ||||||
| 9061621 | 9061621 | PRJEB66218_P_NODE_79668_length_354_cov_1.873720_g77242_i0 | PRJEB66218 | 79668 | 354 | 1.87372 | 6.6329688000000004 | Bradymonas sediminis | 1548548 | Bacteria | Bacteria | 52.8 | 0.033 | NTclustered | gi|1406952946|gb|CP030032.1| | 1548548 | g77242 | i0 | 100 | 0.0790960451977401 | 28 | 0 | 8 | 0 | 301 | 328 | 216114 | 216087 | Bradymonas sediminis strain FA350 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Bradymonas | Bradymonas sediminis | |||
| 11198523 | 11198523 | PRJEB66218_P_NODE_88229_length_332_cov_0.848708_g85802_i0 | PRJEB66218 | 88229 | 332 | 0.848708 | 2.81771056 | Haliangium | 162027 | Bacteria | Bacteria | 69.4 | 3.11e-7 | NTclustered | gi|2874253659|emb|OY969087.1| | 34034 | g85802 | i0 | 90.385 | 0.710843373493976 | 52 | 5 | 16 | 0 | 166 | 217 | 3128904 | 3128853 | MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1 | blastn | 236 | 69.4 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 12884056 | 12884056 | PRJEB66218_P_NODE_107251_length_294_cov_1.107296_g104822_i0 | PRJEB66218 | 107251 | 294 | 1.107296 | 3.25545024 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 259 | 1.5e-64 | NTclustered | gi|2874253999|emb|OY970324.1| | 34034 | g104822 | i0 | 87.611 | 120.833333333333 | 226 | 24 | 76 | 4 | 54 | 277 | 82673 | 82450 | MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1 | blastn | 35525 | 259 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 13747714 | 13747714 | PRJEB66218_P_NODE_153511_length_239_cov_1.325843_g151082_i0 | PRJEB66218 | 153511 | 239 | 1.325843 | 3.16876477 | Thermodesulfobacteriota | 200940 | Bacteria | Bacteria | 425 | 1.1e-114 | NTclustered | gi|38373449|gb|AY455845.1| | 34034 | g151082 | i0 | 98.745 | 99.5020920502092 | 239 | 3 | 100 | 0 | 1 | 239 | 249 | 11 | Uncultured delta proteobacterium clone AL1 16S ribosomal RNA gene, partial sequence | blastn | 23781 | 425 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 14162969 | 14162969 | PRJEB66218_P_NODE_86912_length_335_cov_1.594891_g84485_i0 | PRJEB66218 | 86912 | 335 | 1.594891 | 5.34288485 | uncultured delta proteobacterium DeepAnt-1F12 | 357894 | Bacteria | Bacteria | 448 | 3.4499999999999995e-121 | NTclustered | gi|82617822|gb|DQ267495.1| | 357894 | g84485 | i0 | 91.9 | 207.728358208955 | 321 | 24 | 96 | 2 | 1 | 320 | 3887 | 4206 | Uncultured delta proteobacterium DeepAnt-1F12 fosmid, complete sequence | blastn | 69589 | 448 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium DeepAnt-1F12 | ||||||
| 21396437 | 21396437 | PRJEB66218_P_NODE_156797_length_236_cov_2.851429_g154367_i0 | PRJEB66218 | 156797 | 236 | 2.851429 | 6.72937244 | Bacteria | 2 | Bacteria | Bacteria | 436 | 4.999999999999999e-118 | NTclustered | gi|383932333|gb|JN981954.1| | 34034 | g154367 | i0 | 100 | 95.3262711864407 | 236 | 0 | 100 | 0 | 1 | 236 | 242 | 7 | Uncultured delta proteobacterium clone OTU-20_BFBA 16S ribosomal RNA gene, partial sequence | blastn | 22497 | 436 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 24357718 | 24357718 | PRJEB66218_P_NODE_179200_length_221_cov_2.062500_g176770_i0 | PRJEB66218 | 179200 | 221 | 2.0625 | 4.558125 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 403 | 4.69e-108 | NTclustered | gi|451917560|gb|KC451424.1| | 34034 | g176770 | i0 | 99.548 | 98.9004524886878 | 221 | 1 | 100 | 0 | 1 | 221 | 3 | 223 | Uncultured delta proteobacterium clone RLBp5442 16S ribosomal RNA gene, partial sequence | blastn | 21857 | 403 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 24358078 | 24358078 | PRJEB66218_P_NODE_200920_length_210_cov_1.677852_g198490_i0 | PRJEB66218 | 200920 | 210 | 1.677852 | 3.5234892 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 278 | 2.79e-70 | NTclustered | gi|374854163|dbj|AP011765.1| | 34034 | g198490 | i0 | 90.476 | 136.290476190476 | 210 | 20 | 100 | 0 | 1 | 210 | 13217 | 13008 | Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12 | blastn | 28621 | 278 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 25220412 | 25220412 | PRJEB66218_P_NODE_156160_length_237_cov_1.397727_g153731_i0 | PRJEB66218 | 156160 | 237 | 1.397727 | 3.31261299 | Myxococcota | 2818505 | Bacteria | Bacteria | 377 | 3.09e-100 | NTclustered | gi|60266418|gb|AY921872.1| | 34034 | g153731 | i0 | 95.397 | 100.405063291139 | 239 | 7 | 100 | 4 | 1 | 237 | 783 | 547 | Uncultured delta proteobacterium clone AKYH836 16S ribosomal RNA gene, partial sequence | blastn | 23796 | 377 | 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);;