contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA1146029" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 289965 | 289965 | PRJNA1146029_P_NODE_11741_length_280_cov_1.159420_g11460_i0 | PRJNA1146029 | 11741 | 280 | 1.15942 | 3.246376 | Luzcentumvirus LUZ100 | 3430549 | Viruses | Viruses | 268 | 2.3499999999999994e-67 | NTclustered | gi|2315201724|gb|OP329100.1| | 2973522 | g11460 | i0 | 84.211 | 2.03928571428571 | 285 | 36 | 100 | 8 | 1 | 280 | 26275 | 25995 | Pseudomonas phage LUZ100, complete genome | blastn | 571 | 268 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Luzcentumvirus | Luzcentumvirus LUZ100 | |||
| 1564655 | 1564655 | PRJNA1146029_P_NODE_12522_length_275_cov_1.143564_g12241_i0 | PRJNA1146029 | 12522 | 275 | 1.143564 | 3.144801 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 104 | 6.88e-18 | NTclustered | gi|2914784234|gb|OR222489.1| | 2832643 | g12241 | i0 | 80.142 | 0.512727272727273 | 141 | 26 | 51 | 2 | 15 | 153 | 13864 | 13724 | MAG: Caudoviricetes sp. isolate MSP0896 genomic sequence | blastn | 141 | 104 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 3584091 | 3584091 | PRJNA1146029_P_NODE_16243_length_251_cov_0.865169_g15962_i0 | PRJNA1146029 | 16243 | 251 | 0.865169 | 2.17157419 | Viruses | 10239 | Viruses | Viruses | 459 | 1.1499999999999996e-124 | NTclustered | gi|2056918092|tpg|BK054251.1| | 38018 | g15962 | i0 | 99.602 | 29.996015936255 | 251 | 1 | 100 | 0 | 1 | 251 | 7025 | 6775 | MAG TPA_asm: Bacteriophage sp. isolate ct1JY15, partial genome | blastn | 7529 | 459 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 4117117 | 4117117 | PRJNA1146029_P_NODE_18824_length_247_cov_0.879310_g18543_i0 | PRJNA1146029 | 18824 | 247 | 0.87931 | 2.1718957 | Pseudomonas phage ZRG1 | 3032262 | Viruses | Viruses | 435 | 1.9e-117 | NTclustered | gi|2512630189|gb|OQ504961.1| | 3032262 | g18543 | i0 | 98.381 | 1 | 247 | 4 | 100 | 0 | 1 | 247 | 2929 | 3175 | Pseudomonas phage ZRG1, complete genome | blastn | 247 | 435 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage ZRG1 | |||||
| 9218035 | 9218035 | PRJNA1146029_P_NODE_14388_length_262_cov_1.222222_g14107_i0 | PRJNA1146029 | 14388 | 262 | 1.222222 | 3.20222164 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 145 | 3.83e-30 | NTclustered | gi|2914921208|gb|OR221390.1| | 2832643 | g14107 | i0 | 100 | 3.58778625954198 | 78 | 0 | 30 | 0 | 185 | 262 | 10408 | 10331 | MAG: Caudoviricetes sp. isolate MSP1706 genomic sequence | blastn | 940 | 145 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9218107 | 9218107 | PRJNA1146029_P_NODE_18688_length_247_cov_0.885057_g18407_i0 | PRJNA1146029 | 18688 | 247 | 0.885057 | 2.18609079 | uncultured human fecal virus | 239364 | Viruses | Viruses | 446 | 8.759999999999998e-121 | NTclustered | gi|1569727961|gb|MK232287.1| | 239364 | g18407 | i0 | 99.19 | 6 | 247 | 2 | 100 | 0 | 1 | 247 | 2780 | 3026 | Uncultured human fecal virus clone B.wexlerae_B07.V06.J19_1-CL16_c1 sequence | blastn | 1482 | 446 | 1 | Viruses | uncultured human fecal virus | ||||||||
| 10493865 | 10493865 | PRJNA1146029_P_NODE_4249_length_416_cov_1.778426_g3971_i0 | PRJNA1146029 | 4249 | 416 | 1.778426 | 7.39825216 | Chrocagosk virus | 3129397 | Viruses | Viruses | 640 | 6.709999999999999e-179 | NTclustered | gi|2717317479|gb|PP171845.1| | 3129397 | g3971 | i0 | 99.433 | 49.1802884615385 | 353 | 1 | 85 | 1 | 64 | 416 | 3 | 354 | MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence | blastn | 20459 | 640 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagosk virus | |||||
| 11768660 | 11768660 | PRJNA1146029_P_NODE_12070_length_277_cov_2.637255_g11789_i0 | PRJNA1146029 | 12070 | 277 | 2.637255 | 7.30519635 | Chrocagosk virus | 3129397 | Viruses | Viruses | 195 | 4e-45 | NTclustered | gi|2717317479|gb|PP171845.1| | 3129397 | g11789 | i0 | 80.282 | 1.19494584837545 | 284 | 35 | 98 | 13 | 1 | 271 | 287 | 562 | MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence | blastn | 331 | 195 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagosk virus | |||||
| 11768665 | 11768665 | PRJNA1146029_P_NODE_12510_length_275_cov_1.163366_g12229_i0 | PRJNA1146029 | 12510 | 275 | 1.163366 | 3.1992565 | Chakrabartyvirus pf16 | 2560689 | Viruses | Viruses | 75 | 5.39e-9 | NTclustered | gi|1631917541|ref|NC_041881.1| | 1815630 | g12229 | i0 | 97.674 | 19.0290909090909 | 43 | 1 | 16 | 0 | 194 | 236 | 29554 | 29596 | Pseudomonas phage pf16, complete genome | blastn | 5233 | 75 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chakrabartyvirus | Chakrabartyvirus pf16 | ||||
| 11768742 | 11768742 | PRJNA1146029_P_NODE_16890_length_250_cov_0.870056_g16609_i0 | PRJNA1146029 | 16890 | 250 | 0.870056 | 2.17514 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 255 | 1.61e-63 | NTclustered | gi|2915017331|gb|OR222538.1| | 2832643 | g16609 | i0 | 94.083 | 38.668 | 169 | 9 | 67 | 1 | 83 | 250 | 45984 | 45816 | MAG: Caudoviricetes sp. isolate MSP0399 genomic sequence | blastn | 9667 | 255 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14318941 | 14318941 | PRJNA1146029_P_NODE_14032_length_264_cov_1.612565_g13751_i0 | PRJNA1146029 | 14032 | 264 | 1.612565 | 4.2571716 | Varicellovirus cervidalpha2 | 3050260 | Viruses | Viruses | 63.9 | 1.11e-5 | NTclustered | gi|2500372361|ref|NC_075563.1| | 365327 | g13751 | i0 | 84.615 | 1.48484848484848 | 65 | 8 | 24 | 2 | 74 | 137 | 94594 | 94531 | Cervid alphaherpesvirus 2 strain Norway, complete genome | blastn | 392 | 63.9 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Varicellovirus | Varicellovirus cervidalpha2 | ||
| 15592891 | 15592891 | PRJNA1146029_P_NODE_12253_length_276_cov_1.517241_g11972_i0 | PRJNA1146029 | 12253 | 276 | 1.517241 | 4.18758516 | Pakpunavirus sp. | 2833053 | Viruses | Viruses | 472 | 1.64e-128 | NTclustered | gi|2780120446|gb|PP986818.1| | 2833053 | g11972 | i0 | 98.148 | 9.77898550724638 | 270 | 5 | 98 | 0 | 1 | 270 | 2194 | 2463 | MAG: Pakpunavirus sp. isolate vContig4 genomic sequence | blastn | 2699 | 472 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Pakpunavirus | Pakpunavirus sp. | |||
| 16867210 | 16867210 | PRJNA1146029_P_NODE_17454_length_249_cov_0.875000_g17173_i0 | PRJNA1146029 | 17454 | 249 | 0.875 | 2.17875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 300 | 7.29e-77 | NTclustered | gi|2915049030|gb|OR222828.1| | 2832643 | g17173 | i0 | 88.4 | 4.43775100401606 | 250 | 28 | 100 | 1 | 1 | 249 | 43955 | 43706 | MAG: Caudoviricetes sp. isolate MSP0526 genomic sequence | blastn | 1105 | 300 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18141788 | 18141788 | PRJNA1146029_P_NODE_16655_length_250_cov_0.870056_g16374_i0 | PRJNA1146029 | 16655 | 250 | 0.870056 | 2.17514 | Cinvestavvirus PaMx74 | 3427948 | Viruses | Viruses | 178 | 3.58e-40 | NTclustered | gi|971745258|ref|NC_028809.1| | 1175663 | g16374 | i0 | 79.762 | 1.536 | 252 | 45 | 99 | 6 | 2 | 250 | 50930 | 51178 | Pseudomonas phage PaMx74, partial genome | blastn | 384 | 178 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Mesyanzhinovviridae | Cinvestavvirus | Cinvestavvirus PaMx74 | |||
| 19416299 | 19416299 | PRJNA1146029_P_NODE_6536_length_346_cov_2.095238_g6258_i0 | PRJNA1146029 | 6536 | 346 | 2.095238 | 7.24952348 | Luzcentumvirus LUZ100 | 3430549 | Viruses | Viruses | 590 | 5.609999999999999e-164 | NTclustered | gi|2315201724|gb|OP329100.1| | 2973522 | g6258 | i0 | 97.406 | 3.0028901734104 | 347 | 8 | 100 | 1 | 1 | 346 | 21629 | 21975 | Pseudomonas phage LUZ100, complete genome | blastn | 1039 | 590 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Luzcentumvirus | Luzcentumvirus LUZ100 | |||
| 20691578 | 20691578 | PRJNA1146029_P_NODE_16857_length_250_cov_0.870056_g16576_i0 | PRJNA1146029 | 16857 | 250 | 0.870056 | 2.17514 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 60.2 | 1.35e-4 | NTclustered | gi|2914838431|gb|OR222748.1| | 2832643 | g16576 | i0 | 88 | 0.2 | 50 | 6 | 20 | 0 | 169 | 218 | 9491 | 9540 | MAG: Caudoviricetes sp. isolate MSP0608 genomic sequence | blastn | 50 | 60.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20691632 | 20691632 | PRJNA1146029_P_NODE_19917_length_245_cov_0.895349_g19636_i0 | PRJNA1146029 | 19917 | 245 | 0.895349 | 2.19360505 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 431 | 2.4299999999999996e-116 | NTclustered | gi|2914803948|gb|OR221379.1| | 2832643 | g19636 | i0 | 98.367 | 2.61632653061224 | 245 | 4 | 100 | 0 | 1 | 245 | 8185 | 8429 | MAG: Caudoviricetes sp. isolate MSP1717 genomic sequence | blastn | 641 | 431 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23985903 | 23985903 | PRJNA1146029_P_NODE_18599_length_247_cov_0.885057_g18318_i0 | PRJNA1146029 | 18599 | 247 | 0.885057 | 2.18609079 | Viruses | 10239 | Viruses | Viruses | 307 | 4.32e-79 | NTclustered | gi|2899228526|gb|PQ492157.1| | 3162004 | g18318 | i0 | 89.069 | 6 | 247 | 27 | 100 | 0 | 1 | 247 | 26937 | 26691 | Stenotrophomonas phage S72, complete genome | blastn | 1482 | 307 | 1 | Viruses | Stenotrophomonas phage S72 | ||||||||
| 24515968 | 24515968 | PRJNA1146029_P_NODE_16320_length_251_cov_0.865169_g16039_i0 | PRJNA1146029 | 16320 | 251 | 0.865169 | 2.17157419 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 459 | 1.1499999999999996e-124 | NTclustered | gi|2054683676|tpg|BK052660.1| | 2832643 | g16039 | i0 | 99.602 | 40.605577689243 | 251 | 1 | 100 | 0 | 1 | 251 | 26807 | 27057 | MAG TPA_asm: Caudoviricetes sp. isolate ctieI4, partial genome | blastn | 10192 | 459 | 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);;