contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA494251" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1106772 | 1106772 | PRJNA494251_P_NODE_31541_length_266_cov_9.233161_g31227_i0 | PRJNA494251 | 31541 | 266 | 9.233161 | 24.56020826 | Autosignataviridae | 3424636 | Viruses | Viruses | 470 | 5.669999999999999e-128 | NTclustered | gi|15462|emb|Y00105.1| | 10761 | g31227 | i0 | 100 | 11.3270676691729 | 254 | 0 | 95 | 0 | 10 | 263 | 947 | 694 | Bacteriophage SP6 gene for RNA polymerase | blastn | 3013 | 470 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lederbergvirus | Lederbergvirus Sf6 | ||||
| 3026416 | 3026416 | PRJNA494251_P_NODE_46123_length_244_cov_0.900585_g45809_i0 | PRJNA494251 | 46123 | 244 | 0.900585 | 2.1974274 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 244 | 3.3799999999999997e-60 | NTclustered | gi|2914995474|gb|OR222237.1| | 2832643 | g45809 | i0 | 85.062 | 0.987704918032787 | 241 | 34 | 98 | 2 | 5 | 244 | 12072 | 11833 | MAG: Caudoviricetes sp. isolate MSP0729 genomic sequence | blastn | 241 | 244 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4302054 | 4302054 | PRJNA494251_P_NODE_17084_length_338_cov_17.686792_g16771_i0 | PRJNA494251 | 17084 | 338 | 17.686792 | 59.78135696 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 582 | 9.15e-162 | NTclustered | gi|2053033389|tpg|BK024106.1| | 2832643 | g16771 | i0 | 98.777 | 17.0562130177515 | 327 | 4 | 97 | 0 | 4 | 330 | 415 | 89 | MAG TPA_asm: Caudoviricetes sp. isolate ct1083, partial genome | blastn | 5765 | 582 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6210274 | 6210274 | PRJNA494251_P_NODE_25545_length_288_cov_2.762791_g25231_i0 | PRJNA494251 | 25545 | 288 | 2.762791 | 7.95683808 | Autosignataviridae | 3424636 | Viruses | Viruses | 505 | 1.7e-138 | NTclustered | gi|15462|emb|Y00105.1| | 10761 | g25231 | i0 | 100 | 9.20486111111111 | 273 | 0 | 95 | 0 | 13 | 285 | 2284 | 2012 | Bacteriophage SP6 gene for RNA polymerase | blastn | 2651 | 505 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lederbergvirus | Lederbergvirus Sf6 | ||||
| 7484864 | 7484864 | PRJNA494251_P_NODE_10426_length_415_cov_11.312865_g10120_i0 | PRJNA494251 | 10426 | 415 | 11.312865 | 46.94838975 | Autosignataviridae | 3424636 | Viruses | Viruses | 756 | 0 | NTclustered | gi|15462|emb|Y00105.1| | 10761 | g10120 | i0 | 99.758 | 8.99277108433735 | 413 | 0 | 99 | 1 | 4 | 415 | 1618 | 2030 | Bacteriophage SP6 gene for RNA polymerase | blastn | 3732 | 756 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lederbergvirus | Lederbergvirus Sf6 | ||||
| 11954018 | 11954018 | PRJNA494251_P_NODE_25930_length_287_cov_1.289720_g25616_i0 | PRJNA494251 | 25930 | 287 | 1.28972 | 3.7014964 | Bacillus phage Maceta | 2282408 | Viruses | Viruses | 67.6 | 9.48e-7 | NTclustered | gi|1432229668|gb|MH538296.1| | 2282408 | g25616 | i0 | 100 | 0.125435540069686 | 36 | 0 | 13 | 0 | 250 | 285 | 29 | 64 | Bacillus phage Maceta, complete genome | blastn | 36 | 67.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Bastillevirus | Bacillus phage Maceta | |||
| 13229338 | 13229338 | PRJNA494251_P_NODE_45611_length_244_cov_0.900585_g45297_i0 | PRJNA494251 | 45611 | 244 | 0.900585 | 2.1974274 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 451 | 1.86e-122 | NTclustered | gi|2914983096|gb|OR222107.1| | 2832643 | g45297 | i0 | 100 | 3 | 244 | 0 | 100 | 0 | 1 | 244 | 171747 | 171990 | MAG: Caudoviricetes sp. isolate MSP0002 genomic sequence | blastn | 732 | 451 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14504199 | 14504199 | PRJNA494251_P_NODE_42292_length_247_cov_0.885057_g41978_i0 | PRJNA494251 | 42292 | 247 | 0.885057 | 2.18609079 | Hapunavirus VP882 | 261726 | Viruses | Viruses | 440 | 4.079999999999999e-119 | NTclustered | gi|126010846|ref|NC_009016.1| | 2913982 | g41978 | i0 | 98.785 | 1 | 247 | 3 | 100 | 0 | 1 | 247 | 36915 | 37161 | Vibrio phage VP882, complete genome | blastn | 247 | 440 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Hapunavirus | Hapunavirus VP882 | ||||
| 16409493 | 16409493 | PRJNA494251_P_NODE_10733_length_410_cov_6.094955_g10427_i0 | PRJNA494251 | 10733 | 410 | 6.094955 | 24.9893155 | Autosignataviridae | 3424636 | Viruses | Viruses | 730 | 0 | NTclustered | gi|15462|emb|Y00105.1| | 10761 | g10427 | i0 | 100 | 10.4853658536585 | 395 | 0 | 96 | 0 | 4 | 398 | 1236 | 1630 | Bacteriophage SP6 gene for RNA polymerase | blastn | 4299 | 730 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lederbergvirus | Lederbergvirus Sf6 | ||||
| 17684707 | 17684707 | PRJNA494251_P_NODE_50754_length_235_cov_5.339506_g50440_i0 | PRJNA494251 | 50754 | 235 | 5.339506 | 12.5478391 | Autosignataviridae | 3424636 | Viruses | Viruses | 422 | 1.39e-113 | NTclustered | gi|15462|emb|Y00105.1| | 10761 | g50440 | i0 | 100 | 8.61276595744681 | 228 | 0 | 97 | 0 | 5 | 232 | 1137 | 910 | Bacteriophage SP6 gene for RNA polymerase | blastn | 2024 | 422 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lederbergvirus | Lederbergvirus Sf6 | ||||
| 21508883 | 21508883 | PRJNA494251_P_NODE_45597_length_244_cov_0.900585_g45283_i0 | PRJNA494251 | 45597 | 244 | 0.900585 | 2.1974274 | root | 1 | Root_unresolved | Root_unresolved | 285 | 1.99e-72 | NTclustered | gi|2043520657|gb|MZ092003.1| | 2836077 | g45283 | i0 | 91.707 | 697.200819672131 | 205 | 17 | 84 | 0 | 40 | 244 | 83887 | 83683 | Paenibacillus phage Pd_22F, complete genome | blastn | 170117 | 285 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Paenibacillus phage Pd_22F | |||||
| 23427784 | 23427784 | PRJNA494251_P_NODE_33699_length_260_cov_1.235294_g33385_i0 | PRJNA494251 | 33699 | 260 | 1.235294 | 3.2117644 | Littlefixvirus littlefix | 2845959 | Viruses | Viruses | 316 | 7.61e-82 | NTclustered | gi|1859648885|ref|NC_048697.1| | 2079289 | g33385 | i0 | 88.76 | 0.992307692307692 | 258 | 29 | 99 | 0 | 1 | 258 | 8341 | 8084 | Pseudomonas phage Littlefix, complete genome | blastn | 258 | 316 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Littlefixvirus | Littlefixvirus littlefix | |||
| 25333172 | 25333172 | PRJNA494251_P_NODE_23160_length_299_cov_8.840708_g22846_i0 | PRJNA494251 | 23160 | 299 | 8.840708 | 26.43371692 | Autosignataviridae | 3424636 | Viruses | Viruses | 459 | 1.4000000000000002e-124 | NTclustered | gi|15462|emb|Y00105.1| | 10761 | g22846 | i0 | 100 | 14.6153846153846 | 248 | 0 | 83 | 0 | 9 | 256 | 288 | 41 | Bacteriophage SP6 gene for RNA polymerase | blastn | 4370 | 459 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lederbergvirus | Lederbergvirus Sf6 | ||||
| 25333209 | 25333209 | PRJNA494251_P_NODE_33420_length_260_cov_5.791444_g33106_i0 | PRJNA494251 | 33420 | 260 | 5.791444 | 15.0577544 | Autosignataviridae | 3424636 | Viruses | Viruses | 449 | 7.190000000000001e-122 | NTclustered | gi|15462|emb|Y00105.1| | 10761 | g33106 | i0 | 100 | 13.9038461538462 | 243 | 0 | 93 | 0 | 15 | 257 | 599 | 357 | Bacteriophage SP6 gene for RNA polymerase | blastn | 3615 | 449 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lederbergvirus | Lederbergvirus Sf6 |
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);;