contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1065838" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 180013 | 180013 | PRJNA1065838_S_NODE_20181_length_201_cov_6.217105_g20079_i0 | PRJNA1065838 | 20181 | 201 | 6.217105 | 12.49638105 | CrAssphage cat_SB2894 | 2781373 | Viruses | Viruses | 67.6 | 6.24e-7 | NTclustered | gi|1933200211|gb|MW063138.1| | 2781373 | g20079 | i0 | 91.837 | 8.33830845771144 | 49 | 3 | 24 | 1 | 153 | 201 | 61689 | 61736 | MAG: CrAssphage cat_SB2894, partial genome | blastn | 1676 | 67.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Crassvirales | Intestiviridae | Carjivirus | CrAssphage cat_SB2894 | ||
| 2730617 | 2730617 | PRJNA1065838_S_NODE_3203_length_390_cov_3547.354839_g3101_i0 | PRJNA1065838 | 3203 | 390 | 3547.354839 | 13834.6838721 | Bacillus phage Maceta | 2282408 | Viruses | Viruses | 121 | 1.01e-22 | NTclustered | gi|1432229668|gb|MH538296.1| | 2282408 | g3101 | i0 | 93.827 | 244.730769230769 | 81 | 3 | 31 | 2 | 2 | 81 | 44982 | 44903 | Bacillus phage Maceta, complete genome | blastn | 95445 | 121 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Bastillevirus | Bacillus phage Maceta | |||
| 2730669 | 2730669 | PRJNA1065838_S_NODE_35703_length_163_cov_0.903509_g35601_i0 | PRJNA1065838 | 35703 | 163 | 0.903509 | 1.47271967 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 243 | 7.51e-60 | NTclustered | gi|2914986982|gb|OR222125.1| | 2832643 | g35601 | i0 | 93.789 | 0.987730061349693 | 161 | 10 | 99 | 0 | 2 | 162 | 43841 | 43681 | MAG: Caudoviricetes sp. isolate MSP0855 genomic sequence | blastn | 161 | 243 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10383428 | 10383428 | PRJNA1065838_S_NODE_5169_length_321_cov_4097.044118_g5067_i0 | PRJNA1065838 | 5169 | 321 | 4097.044118 | 13151.51161878 | Tequatrovirus gee4507 | 2844199 | Viruses | Viruses | 113 | 1.36e-20 | NTclustered | gi|1595481356|gb|MK327937.1| | 2502300 | g5067 | i0 | 93.506 | 146.542056074766 | 77 | 4 | 24 | 1 | 5 | 80 | 110087 | 110011 | Escherichia phage vB_EcoM_G10400, complete genome | blastn | 47040 | 113 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Tequatrovirus | Tequatrovirus gee4507 | ||
| 11658641 | 11658641 | PRJNA1065838_S_NODE_25950_length_185_cov_1.147059_g25848_i0 | PRJNA1065838 | 25950 | 185 | 1.147059 | 2.12205915 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 342 | 8.369999999999999e-90 | NTclustered | gi|2914806051|gb|OR221530.1| | 2832643 | g25848 | i0 | 100 | 1 | 185 | 0 | 100 | 0 | 1 | 185 | 10742 | 10926 | MAG: Caudoviricetes sp. isolate MSP1551 genomic sequence | blastn | 185 | 342 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11658753 | 11658753 | PRJNA1065838_S_NODE_6150_length_299_cov_7405.672000_g6048_i0 | PRJNA1065838 | 6150 | 299 | 7405.672 | 22142.95928 | Pseudomonas phage SaPL | 2364194 | Viruses | Viruses | 119 | 2.7e-22 | NTclustered | gi|1490512192|gb|MH973725.1| | 2364194 | g6048 | i0 | 93.827 | 60.3745819397993 | 81 | 2 | 26 | 3 | 1 | 79 | 6638 | 6717 | Pseudomonas phage SaPL, complete genome | blastn | 18052 | 119 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Bruynoghevirus | Pseudomonas phage SaPL | ||||
| 14208788 | 14208788 | PRJNA1065838_S_NODE_32172_length_168_cov_1.310924_g32070_i0 | PRJNA1065838 | 32172 | 168 | 1.310924 | 2.20235232 | Aurantimonas phage AmM-1 | 1503929 | Viruses | Viruses | 52.8 | 0.014 | NTclustered | gi|849119851|ref|NC_027334.1| | 1503929 | g32070 | i0 | 100 | 0.166666666666667 | 28 | 0 | 17 | 0 | 116 | 143 | 27241 | 27214 | Aurantimonas phage AmM-1 DNA, complete sequence | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aurantimonas phage AmM-1 | |||||
| 14208852 | 14208852 | PRJNA1065838_S_NODE_7432_length_277_cov_139.592105_g7330_i0 | PRJNA1065838 | 7432 | 277 | 139.592105 | 386.67013085 | Paenibacillus phage Pd_22F | 2836077 | Viruses | Viruses | 106 | 1.93e-18 | NTclustered | gi|2043520657|gb|MZ092003.1| | 2836077 | g7330 | i0 | 92.208 | 479.505415162455 | 77 | 3 | 54 | 3 | 202 | 277 | 28065 | 27991 | Paenibacillus phage Pd_22F, complete genome | blastn | 132823 | 106 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Paenibacillus phage Pd_22F | |||||
| 14208853 | 14208853 | PRJNA1065838_S_NODE_7552_length_275_cov_5318.973451_g7450_i0 | PRJNA1065838 | 7552 | 275 | 5318.973451 | 14627.17699025 | Escherichia phage Lambda_ev058 | 2742950 | Viruses | Viruses | 119 | 2.46e-22 | NTclustered | gi|1779414893|emb|LR597651.1| | 2742950 | g7450 | i0 | 88.235 | 393.654545454545 | 102 | 8 | 48 | 4 | 2 | 100 | 47396 | 47296 | Escherichia phage Lambda_ev058 genome assembly, chromosome: 1 | blastn | 108255 | 119 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Jouyvirus | Escherichia phage Lambda_ev058 | ||||
| 19305747 | 19305747 | PRJNA1065838_S_NODE_30376_length_172_cov_1.243902_g30274_i0 | PRJNA1065838 | 30376 | 172 | 1.243902 | 2.13951144 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 211 | 2.25e-50 | NTclustered | gi|2914750126|gb|OR221257.1| | 2832643 | g30274 | i0 | 93.056 | 3.90116279069767 | 144 | 10 | 84 | 0 | 17 | 160 | 25558 | 25701 | MAG: Caudoviricetes sp. isolate MSP1857 genomic sequence | blastn | 671 | 211 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21856815 | 21856815 | PRJNA1065838_S_NODE_19418_length_204_cov_0.800000_g19316_i0 | PRJNA1065838 | 19418 | 204 | 0.8 | 1.632 | Tequatrovirus gee4507 | 2844199 | Viruses | Viruses | 58.4 | 3.83e-4 | NTclustered | gi|2046347698|ref|NC_054919.1| | 2502306 | g19316 | i0 | 92.683 | 4.73529411764706 | 41 | 2 | 20 | 1 | 1 | 41 | 76735 | 76774 | Escherichia phage vB_EcoM_G4507, complete genome | blastn | 966 | 58.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Tequatrovirus | Tequatrovirus gee4507 |
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);;