contig_metadata
6 rows where bioproject = "PRJNA645397" and tax_phylum = "Uroviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 619603 | 619603 | PRJNA645397_P_NODE_9201_length_169_cov_0.866667_g9128_i0 | PRJNA645397 | 9201 | 169 | 0.866667 | 1.46466723 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 248 | 1.68e-61 | NTclustered | gi|2914991147|gb|OR222188.1| | 2832643 | g9128 | i0 | 99.27 | 2.67455621301775 | 137 | 1 | 81 | 0 | 33 | 169 | 34766 | 34630 | MAG: Caudoviricetes sp. isolate MSP0788 genomic sequence | blastn | 452 | 248 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 3170402 | 3170402 | PRJNA645397_P_NODE_8043_length_182_cov_0.962406_g7970_i0 | PRJNA645397 | 8043 | 182 | 0.962406 | 1.75157892 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 200 | 5.219999999999998e-47 | NTclustered | gi|2915025644|gb|OR222608.1| | 2832643 | g7970 | i0 | 88.485 | 0.906593406593407 | 165 | 19 | 91 | 0 | 16 | 180 | 51161 | 50997 | MAG: Caudoviricetes sp. isolate MSP0326 genomic sequence | blastn | 165 | 200 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15922465 | 15922465 | PRJNA645397_P_NODE_9713_length_167_cov_0.881356_g9640_i0 | PRJNA645397 | 9713 | 167 | 0.881356 | 1.47186452 | Pahexavirus PHL152M00 | 1982295 | Viruses | Viruses | 189 | 1.0199999999999999e-43 | NTclustered | gi|849255497|ref|NC_027386.1| | 1500825 | g9640 | i0 | 89.796 | 32.2155688622754 | 147 | 15 | 88 | 0 | 21 | 167 | 10493 | 10639 | Propionibacterium phage PHL152M00, complete genome | blastn | 5380 | 189 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PHL152M00 | ||||
| 18471879 | 18471879 | PRJNA645397_P_NODE_10455_length_164_cov_0.904348_g10382_i0 | PRJNA645397 | 10455 | 164 | 0.904348 | 1.48313072 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 182 | 1.67e-41 | NTclustered | gi|2914939593|gb|OR221722.1| | 2832643 | g10382 | i0 | 90 | 9.37195121951219 | 140 | 14 | 85 | 0 | 25 | 164 | 25624 | 25763 | MAG: Caudoviricetes sp. isolate MSP1316 genomic sequence | blastn | 1537 | 182 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23572333 | 23572333 | PRJNA645397_P_NODE_6939_length_196_cov_1.115646_g6866_i0 | PRJNA645397 | 6939 | 196 | 1.115646 | 2.18666616 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 252 | 1.56e-62 | NTclustered | gi|2914860015|gb|OR222086.1| | 2832643 | g6866 | i0 | 93.491 | 2.87244897959184 | 169 | 11 | 86 | 0 | 28 | 196 | 87309 | 87141 | MAG: Caudoviricetes sp. isolate MSP0029 genomic sequence | blastn | 563 | 252 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24845928 | 24845928 | PRJNA645397_P_NODE_4740_length_243_cov_1.072165_g4667_i0 | PRJNA645397 | 4740 | 243 | 1.072165 | 2.60536095 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 337 | 5.399999999999998e-88 | NTclustered | gi|2915025644|gb|OR222608.1| | 2832643 | g4667 | i0 | 92.05 | 5.4156378600823 | 239 | 19 | 98 | 0 | 5 | 243 | 54563 | 54801 | MAG: Caudoviricetes sp. isolate MSP0326 genomic sequence | blastn | 1316 | 337 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. |
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);;