contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA376117" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 399987 | 399987 | PRJNA376117_P_NODE_34741_length_250_cov_1.305085_g34439_i0 | PRJNA376117 | 34741 | 250 | 1.305085 | 3.2627125 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 359 | 1.19e-94 | NTclustered | gi|2874253690|emb|OY969416.1| | 412056 | g34439 | i0 | 93.75 | 95.064 | 240 | 13 | 95 | 2 | 1 | 238 | 1315557 | 1315318 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 | blastn | 23766 | 359 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 2950632 | 2950632 | PRJNA376117_P_NODE_37343_length_248_cov_0.880000_g37041_i0 | PRJNA376117 | 37343 | 248 | 0.88 | 2.1824 | uncultured verrucomicrobium HF0070_15G23 | 723594 | Bacteria | Bacteria | 93.5 | 1.32e-14 | NTclustered | gi|297170473|gb|GU567957.1| | 723594 | g37041 | i0 | 77.64 | 5.33870967741935 | 161 | 31 | 64 | 4 | 33 | 190 | 16163 | 16005 | Uncultured verrucomicrobium HF0070_15G23 genomic sequence | blastn | 1324 | 93.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | uncultured verrucomicrobium HF0070_15G23 | |||||
| 8052863 | 8052863 | PRJNA376117_P_NODE_10187_length_421_cov_2.436782_g9885_i0 | PRJNA376117 | 10187 | 421 | 2.436782 | 10.25885222 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 617 | 3.19e-172 | NTclustered | gi|2874254065|emb|OY970130.1| | 412056 | g9885 | i0 | 93.128 | 79.5914489311164 | 422 | 27 | 100 | 2 | 1 | 421 | 5152796 | 5152376 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1 | blastn | 33508 | 617 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 19526016 | 19526016 | PRJNA376117_P_NODE_6376_length_532_cov_1.941176_g6076_i0 | PRJNA376117 | 6376 | 532 | 1.941176 | 10.32705632 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 833 | 0 | NTclustered | gi|2874254065|emb|OY970130.1| | 412056 | g6076 | i0 | 94.925 | 178.146616541353 | 532 | 27 | 100 | 0 | 1 | 532 | 5153565 | 5154096 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1 | blastn | 94774 | 833 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 20199752 | 20199752 | PRJNA376117_P_NODE_24736_length_283_cov_2.052381_g24434_i0 | PRJNA376117 | 24736 | 283 | 2.052381 | 5.80823823 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 451 | 2.1999999999999995e-122 | NTclustered | gi|2874254065|emb|OY970130.1| | 412056 | g24434 | i0 | 95.406 | 120.049469964664 | 283 | 13 | 100 | 0 | 1 | 283 | 5154271 | 5154553 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1 | blastn | 33974 | 451 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 20801337 | 20801337 | PRJNA376117_P_NODE_27977_length_272_cov_1.547739_g27675_i0 | PRJNA376117 | 27977 | 272 | 1.547739 | 4.20985008 | Akkermansia muciniphila | 239935 | Bacteria | Bacteria | 54.7 | 0.007 | NTclustered | gi|1805906055|gb|CP027004.1| | 239935 | g27675 | i0 | 100 | 2.23897058823529 | 29 | 0 | 11 | 0 | 221 | 249 | 1454019 | 1453991 | Akkermansia muciniphila strain EB-AMDK-28 chromosome, complete genome | blastn | 609 | 54.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia muciniphila | |
| 22076429 | 22076429 | PRJNA376117_P_NODE_31778_length_258_cov_1.664865_g31476_i0 | PRJNA376117 | 31778 | 258 | 1.664865 | 4.2953517 | Horticoccus luteus | 2862869 | Bacteria | Bacteria | 111 | 3.82e-20 | NTclustered | gi|2077391884|gb|CP080507.1| | 2862869 | g31476 | i0 | 86.869 | 3.46124031007752 | 99 | 13 | 38 | 0 | 159 | 257 | 1507126 | 1507028 | Horticoccus luteus strain KSB-15 chromosome, complete genome | blastn | 893 | 111 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Horticoccus | Horticoccus luteus | |
| 23351661 | 23351661 | PRJNA376117_P_NODE_15499_length_348_cov_2.716364_g15197_i0 | PRJNA376117 | 15499 | 348 | 2.716364 | 9.45294672 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 462 | 1.2799999999999998e-125 | NTclustered | gi|2874253690|emb|OY969416.1| | 412056 | g15197 | i0 | 90.988 | 82.0632183908046 | 344 | 30 | 99 | 1 | 6 | 348 | 1316202 | 1315859 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 | blastn | 28558 | 462 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 23352123 | 23352123 | PRJNA376117_P_NODE_5659_length_570_cov_1.849095_g5361_i0 | PRJNA376117 | 5659 | 570 | 1.849095 | 10.5398415 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 863 | 0 | NTclustered | gi|2874253690|emb|OY969416.1| | 412056 | g5361 | i0 | 93.913 | 211.438596491228 | 575 | 29 | 100 | 6 | 1 | 570 | 1315284 | 1315857 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 | blastn | 120520 | 863 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae 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);;