contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1174207" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4142779 | 4142779 | PRJNA1174207_P_NODE_3924_length_896_cov_2.331713_g3475_i0 | PRJNA1174207 | 3924 | 896 | 2.331713 | 20.89214848 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 412 | 3.6e-110 | NTclustered | gi|2874253768|emb|OY969715.1| | 412056 | g3475 | i0 | 82.626 | 58.6082589285714 | 495 | 58 | 78 | 15 | 422 | 893 | 914538 | 915027 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1 | blastn | 52513 | 412 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 6693741 | 6693741 | PRJNA1174207_P_NODE_3866_length_905_cov_3.895433_g3418_i0 | PRJNA1174207 | 3866 | 905 | 3.895433 | 35.25366865 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 691 | 0 | NTclustered | gi|2813917447|gb|CP170506.1| | 2811408 | g3418 | i0 | 80.773 | 246.667403314917 | 931 | 139 | 99 | 31 | 8 | 905 | 3049055 | 3048132 | MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome | blastn | 223234 | 691 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 7968673 | 7968673 | PRJNA1174207_P_NODE_15287_length_369_cov_2.391892_g14758_i0 | PRJNA1174207 | 15287 | 369 | 2.391892 | 8.82608148 | Pedosphaera parvula | 1032527 | Bacteria | Bacteria | 549 | 1.0199999999999994e-151 | NTclustered | gi|183579829|emb|AM905426.1| | 320771 | g14758 | i0 | 94.183 | 135.634146341463 | 361 | 19 | 98 | 1 | 9 | 369 | 2251 | 1893 | Bacterium Ellin514 23S rRNA gene, isolate Ellin514 | blastn | 50049 | 549 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera parvula | |
| 9243793 | 9243793 | PRJNA1174207_P_NODE_40328_length_242_cov_1.822485_g39799_i0 | PRJNA1174207 | 40328 | 242 | 1.822485 | 4.4104137 | uncultured Verrucomicrobiota bacterium | 156588 | Bacteria | Bacteria | 370 | 5.3e-98 | NTclustered | gi|511202471|gb|KC994702.1| | 156588 | g39799 | i0 | 94.239 | 95.7231404958678 | 243 | 12 | 100 | 2 | 1 | 242 | 16 | 257 | Uncultured Verrucomicrobia bacterium clone BF 022 16S ribosomal RNA gene, partial sequence | blastn | 23165 | 370 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | uncultured Verrucomicrobiota bacterium | |||||
| 10519119 | 10519119 | PRJNA1174207_P_NODE_20289_length_314_cov_3.647303_g19760_i0 | PRJNA1174207 | 20289 | 314 | 3.647303 | 11.45253142 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 392 | 1.52e-104 | NTclustered | gi|2874253779|emb|OY969763.1| | 412056 | g19760 | i0 | 89.164 | 88.0350318471338 | 323 | 23 | 99 | 7 | 1 | 312 | 3832284 | 3832605 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 | blastn | 27643 | 392 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 14344571 | 14344571 | PRJNA1174207_P_NODE_25772_length_282_cov_2.181818_g25243_i0 | PRJNA1174207 | 25772 | 282 | 2.181818 | 6.15272676 | Opitutales bacterium | 2026772 | Bacteria | Bacteria | 255 | 1.85e-63 | NTclustered | gi|2891482117|emb|OZ219851.1| | 2026772 | g25243 | i0 | 83.333 | 55.2836879432624 | 288 | 37 | 100 | 11 | 1 | 282 | 1410404 | 1410122 | MAG: Opitutales bacterium isolate e4292735-b3b5-42df-bce3-ad3ef7a88f44 genome assembly, chromosome: 10 | blastn | 15590 | 255 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutales bacterium | |||
| 19441951 | 19441951 | PRJNA1174207_P_NODE_42956_length_229_cov_2.416667_g42427_i0 | PRJNA1174207 | 42956 | 229 | 2.416667 | 5.53416743 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 353 | 5e-93 | NTclustered | gi|2874253690|emb|OY969416.1| | 412056 | g42427 | i0 | 94.737 | 40.4148471615721 | 228 | 11 | 99 | 1 | 2 | 229 | 1315574 | 1315800 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 | blastn | 9255 | 353 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 24541783 | 24541783 | PRJNA1174207_P_NODE_37000_length_247_cov_0.879310_g36471_i0 | PRJNA1174207 | 37000 | 247 | 0.87931 | 2.1718957 | Opitutus sp. GAS368 | 1882749 | Bacteria | Bacteria | 429 | 8.83e-116 | NTclustered | gi|1085764882|emb|LT629735.1| | 1882749 | g36471 | i0 | 97.976 | 124.279352226721 | 247 | 5 | 100 | 0 | 1 | 247 | 2834000 | 2833754 | Opitutus sp. GAS368 genome assembly, chromosome: I | blastn | 30697 | 429 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. GAS368 |
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);;