contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA385064" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1075844 | 1075844 | PRJNA385064_P_NODE_5741_length_178_cov_1.062016_g5616_i0 | PRJNA385064 | 5741 | 178 | 1.062016 | 1.89038848 | Pahexavirus | 1982251 | Viruses | Viruses | 329 | 6.21e-86 | NTclustered | gi|906475808|ref|NC_027622.1| | 1655022 | g5616 | i0 | 100 | 89.1685393258427 | 178 | 0 | 100 | 0 | 1 | 178 | 19930 | 19753 | Propionibacterium phage Stormborn, complete genome | blastn | 15872 | 329 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus stormborn | ||||
| 2956060 | 2956060 | PRJNA385064_P_NODE_6863_length_166_cov_0.871795_g6738_i0 | PRJNA385064 | 6863 | 166 | 0.871795 | 1.4471797 | Geobacillus virus E3 | 1572712 | Viruses | Viruses | 235 | 1.2899999999999998e-57 | NTclustered | gi|985758336|ref|NC_029073.1| | 1572712 | g6738 | i0 | 93.125 | 0.963855421686747 | 160 | 11 | 96 | 0 | 2 | 161 | 49938 | 50097 | Geobacillus virus E3, complete genome | blastn | 160 | 235 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Geobacillus virus E3 | |||||
| 2956067 | 2956067 | PRJNA385064_P_NODE_7363_length_164_cov_0.886957_g7238_i0 | PRJNA385064 | 7363 | 164 | 0.886957 | 1.45460948 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 281 | 1.6000000000000001e-71 | NTclustered | gi|2054649992|tpg|BK052003.1| | 2832643 | g7238 | i0 | 97.561 | 1 | 164 | 4 | 100 | 0 | 1 | 164 | 50489 | 50326 | MAG TPA_asm: Caudoviricetes sp. isolate ctupA9, partial genome | blastn | 164 | 281 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5509080 | 5509080 | PRJNA385064_P_NODE_5285_length_186_cov_1.153285_g5160_i0 | PRJNA385064 | 5285 | 186 | 1.153285 | 2.1451101 | Geobacillus virus E3 | 1572712 | Viruses | Viruses | 315 | 1.84e-81 | NTclustered | gi|985758336|ref|NC_029073.1| | 1572712 | g5160 | i0 | 97.297 | 1.76344086021505 | 185 | 5 | 99 | 0 | 2 | 186 | 62121 | 62305 | Geobacillus virus E3, complete genome | blastn | 328 | 315 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Geobacillus virus E3 | |||||
| 10609164 | 10609164 | PRJNA385064_P_NODE_3309_length_241_cov_1.177083_g3184_i0 | PRJNA385064 | 3309 | 241 | 1.177083 | 2.83677003 | Geobacillus phage vB_GthS_PK5.1 | 2985566 | Viruses | Viruses | 119 | 2.11e-22 | NTclustered | gi|2320141253|gb|OP341628.1| | 2985566 | g3184 | i0 | 84.746 | 0.62655601659751 | 118 | 18 | 49 | 0 | 124 | 241 | 36061 | 35944 | Geobacillus phage vB_GthS_PK5.1, complete genome | blastn | 151 | 119 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Geobacillus phage vB_GthS_PK5.1 | |||||
| 11884051 | 11884051 | PRJNA385064_P_NODE_7030_length_165_cov_0.879310_g6905_i0 | PRJNA385064 | 7030 | 165 | 0.87931 | 1.4508615 | Geobacillus virus E3 | 1572712 | Viruses | Viruses | 159 | 7.9e-35 | NTclustered | gi|985758336|ref|NC_029073.1| | 1572712 | g6905 | i0 | 88.148 | 0.818181818181818 | 135 | 15 | 82 | 1 | 31 | 165 | 114601 | 114734 | Geobacillus virus E3, complete genome | blastn | 135 | 159 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Geobacillus virus E3 | |||||
| 14434101 | 14434101 | PRJNA385064_P_NODE_6892_length_166_cov_0.871795_g6767_i0 | PRJNA385064 | 6892 | 166 | 0.871795 | 1.4471797 | Deep-sea thermophilic phage D6E | 749413 | Viruses | Viruses | 302 | 1.2500000000000001e-77 | NTclustered | gi|423262327|ref|NC_019544.1| | 749413 | g6767 | i0 | 99.398 | 1 | 166 | 1 | 100 | 0 | 1 | 166 | 9597 | 9762 | Deep-sea thermophilic phage D6E, complete genome | blastn | 166 | 302 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Deep-sea thermophilic phage D6E | |||||
| 16982740 | 16982740 | PRJNA385064_P_NODE_3054_length_251_cov_1.262376_g2929_i0 | PRJNA385064 | 3054 | 251 | 1.262376 | 3.16856376 | Geobacillus phage vB_GthS_PK5.1 | 2985566 | Viruses | Viruses | 117 | 7.95e-22 | NTclustered | gi|2320141253|gb|OP341628.1| | 2985566 | g2929 | i0 | 98.485 | 2.51394422310757 | 66 | 1 | 26 | 0 | 1 | 66 | 28570 | 28505 | Geobacillus phage vB_GthS_PK5.1, complete genome | blastn | 631 | 117 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Geobacillus phage vB_GthS_PK5.1 | |||||
| 16982747 | 16982747 | PRJNA385064_P_NODE_5274_length_186_cov_1.540146_g5149_i0 | PRJNA385064 | 5274 | 186 | 1.540146 | 2.86467156 | Geobacillus phage vB_GthS_NIIg9.7 | 2985562 | Viruses | Viruses | 279 | 6.7000000000000014e-71 | NTclustered | gi|2320140953|gb|OP341624.1| | 2985562 | g5149 | i0 | 93.651 | 10.8817204301075 | 189 | 9 | 100 | 1 | 1 | 186 | 3817 | 3629 | Geobacillus phage vB_GthS_NIIg9.7, complete genome | blastn | 2024 | 279 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Geobacillus phage vB_GthS_NIIg9.7 | |||||
| 16982757 | 16982757 | PRJNA385064_P_NODE_7074_length_165_cov_0.879310_g6949_i0 | PRJNA385064 | 7074 | 165 | 0.87931 | 1.4508615 | Inoviridae sp. | 2219103 | Viruses | Viruses | 278 | 2.09e-70 | NTclustered | gi|2056837707|tpg|BK044060.1| | 2219103 | g6949 | i0 | 96.97 | 2.90909090909091 | 165 | 5 | 100 | 0 | 1 | 165 | 1785 | 1949 | MAG TPA_asm: Inoviridae sp. isolate ctXjl4, partial genome | blastn | 480 | 278 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 18256902 | 18256902 | PRJNA385064_P_NODE_7095_length_165_cov_0.879310_g6970_i0 | PRJNA385064 | 7095 | 165 | 0.87931 | 1.4508615 | Geobacillus virus E3 | 1572712 | Viruses | Viruses | 272 | 9.73e-69 | NTclustered | gi|985758336|ref|NC_029073.1| | 1572712 | g6970 | i0 | 96.364 | 1 | 165 | 6 | 100 | 0 | 1 | 165 | 68618 | 68454 | Geobacillus virus E3, complete genome | blastn | 165 | 272 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Geobacillus virus E3 | |||||
| 19531226 | 19531226 | PRJNA385064_P_NODE_7056_length_165_cov_0.879310_g6931_i0 | PRJNA385064 | 7056 | 165 | 0.87931 | 1.4508615 | Idaeovirus ligustri | 2560648 | Viruses | Viruses | 267 | 4.53e-67 | NTclustered | gi|2896092820|gb|PQ786943.1| | 1811408 | g6931 | i0 | 95.758 | 3 | 165 | 7 | 100 | 0 | 1 | 165 | 1138 | 974 | Privet leaf blotch-associated virus isolate Fr segment RNA2, partial sequence | blastn | 495 | 267 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Mayoviridae | Idaeovirus | Idaeovirus ligustri | ||
| 19531230 | 19531230 | PRJNA385064_P_NODE_7476_length_163_cov_0.894737_g7351_i0 | PRJNA385064 | 7476 | 163 | 0.894737 | 1.45842131 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 241 | 2.7000000000000008e-59 | NTclustered | gi|2054427358|tpg|BK035868.1| | 2832643 | g7351 | i0 | 93.252 | 7 | 163 | 11 | 100 | 0 | 1 | 163 | 165666 | 165828 | MAG TPA_asm: Caudoviricetes sp. isolate ctExz15, partial genome | blastn | 1141 | 241 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24631762 | 24631762 | PRJNA385064_P_NODE_6360_length_168_cov_1.714286_g6235_i0 | PRJNA385064 | 6360 | 168 | 1.714286 | 2.88000048 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 233 | 4.7e-57 | NTclustered | gi|2057092551|tpg|BK038147.1| | 2832643 | g6235 | i0 | 91.667 | 1 | 168 | 14 | 100 | 0 | 1 | 168 | 6871 | 7038 | MAG TPA_asm: Caudoviricetes sp. isolate ctGN732, partial genome | blastn | 168 | 233 | 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);;