contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA315314" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2931612 | 2931612 | PRJNA315314_S_NODE_3543_length_423_cov_1905.835025_g3223_i0 | PRJNA315314 | 3543 | 423 | 1905.835025 | 8061.68215575 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 71.3 | 1.12e-7 | NTclustered | gi|2059768599|tpg|BK039092.1| | 2832643 | g3223 | i0 | 97.619 | 10.1489361702128 | 42 | 0 | 10 | 1 | 1 | 42 | 48696 | 48656 | MAG TPA_asm: Caudoviricetes sp. isolate ctnV51, partial genome | blastn | 4293 | 71.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5484502 | 5484502 | PRJNA315314_S_NODE_5125_length_354_cov_42.809231_g4804_i0 | PRJNA315314 | 5125 | 354 | 42.809231 | 151.54467774 | Escherichia phage vB_EcoM_Skers | 2836116 | Viruses | Viruses | 65.8 | 4.3e-6 | NTclustered | gi|2067458654|gb|MW748999.1| | 2836116 | g4804 | i0 | 100 | 0.177966101694915 | 35 | 0 | 10 | 0 | 291 | 325 | 78599 | 78633 | Escherichia phage vB_EcoM_Skers, complete genome | blastn | 63 | 65.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Krischvirus | Escherichia phage vB_EcoM_Skers | ||
| 6168231 | 6168231 | PRJNA315314_S_NODE_7345_length_297_cov_2866.772388_g7024_i0 | PRJNA315314 | 7345 | 297 | 2866.772388 | 8514.31399236 | root | 1 | Root_unresolved | Root_unresolved | 69.4 | 2.74e-7 | NTclustered | gi|1465382783|emb|LS992247.1| | 10376 | g7024 | i0 | 92 | 14.4175084175084 | 50 | 2 | 16 | 2 | 1 | 48 | 88199 | 88248 | Human gammaherpesvirus 4 isolate Human herpesvirus 4 genome assembly, chromosome: I | blastn | 4282 | 69.4 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 8034347 | 8034347 | PRJNA315314_S_NODE_8287_length_280_cov_56.693227_g7966_i0 | PRJNA315314 | 8287 | 280 | 56.693227 | 158.7410356 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 58.4 | 5.55e-4 | NTclustered | gi|2056808531|tpg|BK057475.1| | 2832643 | g7966 | i0 | 97.143 | 12.0928571428571 | 35 | 0 | 13 | 1 | 246 | 280 | 56 | 23 | MAG TPA_asm: Caudoviricetes sp. isolate ctwEd7, partial genome | blastn | 3386 | 58.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9993478 | 9993478 | PRJNA315314_S_NODE_29508_length_156_cov_1.913386_g29187_i0 | PRJNA315314 | 29508 | 156 | 1.913386 | 2.98488216 | root | 1 | Root_unresolved | Root_unresolved | 58.4 | 2.76e-4 | NTclustered | gi|2057947797|tpg|BK046128.1| | 2832643 | g29187 | i0 | 100 | 10.1153846153846 | 31 | 0 | 20 | 0 | 1 | 31 | 1755 | 1725 | MAG TPA_asm: Caudoviricetes sp. isolate ctDPK14, partial genome | blastn | 1578 | 58.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12543785 | 12543785 | PRJNA315314_S_NODE_21990_length_177_cov_2.500000_g21669_i0 | PRJNA315314 | 21990 | 177 | 2.5 | 4.425 | Cimandefvirus | 2843366 | Viruses | Viruses | 102 | 1.46e-17 | NTclustered | gi|2046355625|ref|NC_054957.1| | 2759724 | g21669 | i0 | 91.781 | 2.52542372881356 | 73 | 6 | 41 | 0 | 1 | 73 | 7291 | 7219 | Ralstonia phage Eline, complete genome | blastn | 447 | 102 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Cimandefvirus | Cimandefvirus eline | ||||
| 14409502 | 14409502 | PRJNA315314_S_NODE_10912_length_245_cov_3.847222_g10591_i0 | PRJNA315314 | 10912 | 245 | 3.847222 | 9.4256939 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 453 | 5.1900000000000006e-123 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g10591 | i0 | 100 | 1 | 245 | 0 | 100 | 0 | 1 | 245 | 44224 | 44468 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 245 | 453 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14409625 | 14409625 | PRJNA315314_S_NODE_17192_length_198_cov_4.656805_g16871_i0 | PRJNA315314 | 17192 | 198 | 4.656805 | 9.2204739 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 351 | 1.51e-92 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g16871 | i0 | 100 | 0.95959595959596 | 190 | 0 | 96 | 0 | 9 | 198 | 53245 | 53434 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 190 | 351 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15683326 | 15683326 | PRJNA315314_S_NODE_13553_length_221_cov_34.187500_g13232_i0 | PRJNA315314 | 13553 | 221 | 34.1875 | 75.554375 | Bacillus phage vB_BthP-HD73phi | 2500580 | Viruses | Viruses | 62.1 | 3.25e-5 | NTclustered | gi|1549120968|gb|MK310228.1| | 2500580 | g13232 | i0 | 100 | 14.8461538461538 | 33 | 0 | 15 | 0 | 189 | 221 | 78 | 46 | Bacillus phage vB_BthP-HD73phi, complete genome | blastn | 3281 | 62.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Salasmaviridae | Claudivirus | Bacillus phage vB_BthP-HD73phi | |||
| 15683523 | 15683523 | PRJNA315314_S_NODE_25293_length_166_cov_70.007299_g24972_i0 | PRJNA315314 | 25293 | 166 | 70.007299 | 116.21211634 | Pseudomonas phage sp. 30-3 | 2972143 | Viruses | Viruses | 106 | 1.05e-18 | NTclustered | gi|2296132097|dbj|LC727698.1| | 2972143 | g24972 | i0 | 95.455 | 29.2048192771084 | 66 | 3 | 40 | 0 | 75 | 140 | 239382 | 239317 | Pseudomonas phage sp. 30-3 phi30-3 DNA, complete genome | blastn | 4848 | 106 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Arenbergviridae | Wroclawvirus | Pseudomonas phage sp. 30-3 | |||
| 16367795 | 16367795 | PRJNA315314_S_NODE_1553_length_620_cov_1514.807107_g1299_i0 | PRJNA315314 | 1553 | 620 | 1514.807107 | 9391.8040634 | root | 1 | Root_unresolved | Root_unresolved | 69.4 | 6.11e-7 | NTclustered | gi|1465382783|emb|LS992247.1| | 10376 | g1299 | i0 | 100 | 7.07903225806452 | 37 | 0 | 6 | 0 | 1 | 37 | 88199 | 88235 | Human gammaherpesvirus 4 isolate Human herpesvirus 4 genome assembly, chromosome: I | blastn | 4389 | 69.4 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 16958318 | 16958318 | PRJNA315314_S_NODE_28194_length_159_cov_1.753846_g27873_i0 | PRJNA315314 | 28194 | 159 | 1.753846 | 2.78861514 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 294 | 1.98e-75 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g27873 | i0 | 100 | 1 | 159 | 0 | 100 | 0 | 1 | 159 | 35964 | 35806 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 159 | 294 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18232476 | 18232476 | PRJNA315314_S_NODE_21735_length_178_cov_2.342282_g21414_i0 | PRJNA315314 | 21735 | 178 | 2.342282 | 4.16926196 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 313 | 6.259999999999999e-81 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g21414 | i0 | 98.315 | 2.57303370786517 | 178 | 3 | 100 | 0 | 1 | 178 | 44449 | 44626 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 458 | 313 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23332727 | 23332727 | PRJNA315314_S_NODE_15879_length_205_cov_4219.323864_g15558_i0 | PRJNA315314 | 15879 | 205 | 4219.323864 | 8649.6139212 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 71.3 | 4.94e-8 | NTclustered | gi|2056930576|tpg|BK054506.1| | 2832643 | g15558 | i0 | 93.617 | 21.3024390243902 | 47 | 3 | 23 | 0 | 1 | 47 | 11489 | 11443 | MAG TPA_asm: Caudoviricetes sp. isolate ct9WC4, partial genome | blastn | 4367 | 71.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24607048 | 24607048 | PRJNA315314_S_NODE_30600_length_154_cov_1.088000_g30279_i0 | PRJNA315314 | 30600 | 154 | 1.088 | 1.67552 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 117 | 4.42e-22 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g30279 | i0 | 98.485 | 0.798701298701299 | 66 | 1 | 43 | 0 | 1 | 66 | 16397 | 16462 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 123 | 117 | 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);;