contig_metadata
7 rows where bioproject = "PRJNA795663", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3330622 | 3330622 | PRJNA795663_S_NODE_6163_length_237_cov_2.540000_g6058_i0 | PRJNA795663 | 6163 | 237 | 2.54 | 6.0198 | Prosthecobacter dejongeii | 48465 | Bacteria | Bacteria | 305 | 1.48e-78 | NTclustered | gi|183579826|emb|AM905423.1| | 48465 | g6058 | i0 | 94.472 | 230.324894514768 | 199 | 9 | 84 | 2 | 39 | 237 | 1484 | 1680 | Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251 | blastn | 54587 | 305 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter dejongeii | |
| 5044555 | 5044555 | PRJNA795663_S_NODE_344_length_821_cov_5.272959_g278_i0 | PRJNA795663 | 344 | 821 | 5.272959 | 43.29099339 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 928 | 0 | NTclustered | gi|2874253768|emb|OY969715.1| | 412056 | g278 | i0 | 87.093 | 200.237515225335 | 829 | 95 | 100 | 11 | 1 | 821 | 915447 | 914623 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1 | blastn | 164395 | 928 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 5882825 | 5882825 | PRJNA795663_S_NODE_12405_length_177_cov_1.828571_g12300_i0 | PRJNA795663 | 12405 | 177 | 1.828571 | 3.23657067 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 292 | 8.09e-75 | NTclustered | gi|2874254065|emb|OY970130.1| | 412056 | g12300 | i0 | 96.61 | 18.0790960451977 | 177 | 4 | 100 | 2 | 1 | 177 | 5153596 | 5153422 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1 | blastn | 3200 | 292 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 9707560 | 9707560 | PRJNA795663_S_NODE_14668_length_165_cov_2.101562_g14563_i0 | PRJNA795663 | 14668 | 165 | 2.101562 | 3.4675773 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 217 | 4.619999999999999e-52 | NTclustered | gi|2874253952|emb|OY970277.1| | 412056 | g14563 | i0 | 90.303 | 202.2 | 165 | 16 | 100 | 0 | 1 | 165 | 2751010 | 2750846 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1 | blastn | 33363 | 217 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 14808015 | 14808015 | PRJNA795663_S_NODE_3372_length_313_cov_1.163043_g3267_i0 | PRJNA795663 | 3372 | 313 | 1.163043 | 3.64032459 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 435 | 2.49e-117 | NTclustered | gi|2874254065|emb|OY970130.1| | 412056 | g3267 | i0 | 91.693 | 22.9968051118211 | 313 | 26 | 100 | 0 | 1 | 313 | 5153948 | 5153636 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1 | blastn | 7198 | 435 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 18630945 | 18630945 | PRJNA795663_S_NODE_2255_length_377_cov_2.141176_g2150_i0 | PRJNA795663 | 2255 | 377 | 2.141176 | 8.07223352 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 401 | 3.089999999999999e-107 | NTclustered | gi|2874253690|emb|OY969416.1| | 412056 | g2150 | i0 | 89.623 | 16.6472148541114 | 318 | 30 | 84 | 3 | 39 | 353 | 1316471 | 1316154 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 | blastn | 6276 | 401 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 32203536 | 32203536 | PRJNA795663_S_NODE_13118_length_173_cov_1.705882_g13013_i0 | PRJNA795663 | 13118 | 173 | 1.705882 | 2.95117586 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 63.9 | 4.81e-10 | NR | HUJ09072.1 | 2499141 | g13013 | i0 | 62.5 | 2.13294797687861 | 48 | 15 | 79.8 | 2 | 32 | 169 | 3 | 49 | HUJ09072.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 369 | 63.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium |
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);;