contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA1146029" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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. | |||||
| 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. | |||||
| 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. | |||||
| 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);;