contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA431371" and tax_kingdom = "Heunggongvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4255005 | 4255005 | PRJNA431371_P_NODE_18944_length_294_cov_1.239819_g18871_i0 | PRJNA431371 | 18944 | 294 | 1.239819 | 3.64506786 | Purivirus UFJFPfDIW6 | 3060664 | Viruses | Viruses | 374 | 5.1199999999999995e-99 | NTclustered | gi|2214231935|gb|OM418631.1| | 2927622 | g18871 | i0 | 89.726 | 8.66326530612245 | 292 | 30 | 99 | 0 | 1 | 292 | 16552 | 16261 | Pseudomonas phage UFJF_PfDIW6, complete genome | blastn | 2547 | 374 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Purivirus | Purivirus UFJFPfDIW6 | ||||
| 5532037 | 5532037 | PRJNA431371_P_NODE_30645_length_246_cov_0.890173_g30572_i0 | PRJNA431371 | 30645 | 246 | 0.890173 | 2.18982558 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 327 | 3.3e-85 | NTclustered | gi|2056831317|tpg|BK043942.1| | 2832643 | g30572 | i0 | 90.65 | 13.0162601626016 | 246 | 23 | 100 | 0 | 1 | 246 | 14767 | 15012 | MAG TPA_asm: Caudoviricetes sp. isolate ct6EZ30, partial genome | blastn | 3202 | 327 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8081690 | 8081690 | PRJNA431371_P_NODE_33287_length_244_cov_0.900585_g33214_i0 | PRJNA431371 | 33287 | 244 | 0.900585 | 2.1974274 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 119 | 2.14e-22 | NTclustered | gi|2914927861|gb|OR221512.1| | 2832643 | g33214 | i0 | 92.771 | 1.95491803278689 | 83 | 5 | 53 | 1 | 59 | 141 | 9264 | 9183 | MAG: Caudoviricetes sp. isolate MSP1567 genomic sequence | blastn | 477 | 119 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11907141 | 11907141 | PRJNA431371_P_NODE_32530_length_244_cov_0.900585_g32457_i0 | PRJNA431371 | 32530 | 244 | 0.900585 | 2.1974274 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 446 | 8.639999999999999e-121 | NTclustered | gi|2059816587|tpg|BK039934.1| | 2832643 | g32457 | i0 | 99.59 | 1.73360655737705 | 244 | 1 | 100 | 0 | 1 | 244 | 14630 | 14387 | MAG TPA_asm: Caudoviricetes sp. isolate ctoLq5, partial genome | blastn | 423 | 446 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13181889 | 13181889 | PRJNA431371_P_NODE_22811_length_265_cov_1.526042_g22738_i0 | PRJNA431371 | 22811 | 265 | 1.526042 | 4.0440113 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 377 | 3.5200000000000003e-100 | NTclustered | gi|2056869534|tpg|BK044656.1| | 2832643 | g22738 | i0 | 93.023 | 24.2188679245283 | 258 | 18 | 97 | 0 | 8 | 265 | 32003 | 31746 | MAG TPA_asm: Caudoviricetes sp. isolate ctyHb21, partial genome | blastn | 6418 | 377 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20214333 | 20214333 | PRJNA431371_P_NODE_9616_length_402_cov_1.133739_g9543_i0 | PRJNA431371 | 9616 | 402 | 1.133739 | 4.55763078 | root | 1 | Root_unresolved | Root_unresolved | 710 | 0 | NTclustered | gi|1269168330|gb|MF975720.1| | 2041487 | g9543 | i0 | 98.507 | 72.4054726368159 | 402 | 6 | 100 | 0 | 1 | 402 | 30348 | 29947 | Pseudomonas phage VW-6S, complete genome | blastn | 29107 | 710 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage VW-6S | |||||
| 23380576 | 23380576 | PRJNA431371_P_NODE_34959_length_242_cov_0.911243_g34886_i0 | PRJNA431371 | 34959 | 242 | 0.911243 | 2.20520806 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 372 | 1.47e-98 | NTclustered | gi|2914754352|gb|OR221458.1| | 2832643 | g34886 | i0 | 94.583 | 0.991735537190083 | 240 | 13 | 99 | 0 | 1 | 240 | 17090 | 17329 | MAG: Caudoviricetes sp. isolate MSP1621 genomic sequence | blastn | 240 | 372 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24654670 | 24654670 | PRJNA431371_P_NODE_31520_length_245_cov_0.895349_g31447_i0 | PRJNA431371 | 31520 | 245 | 0.895349 | 2.19360505 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 407 | 4.1e-109 | NTclustered | gi|2914916405|gb|OR221289.1| | 2832643 | g31447 | i0 | 96.721 | 0.995918367346939 | 244 | 8 | 99 | 0 | 1 | 244 | 5736 | 5979 | MAG: Caudoviricetes sp. isolate MSP1816 genomic sequence | blastn | 244 | 407 | 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);;