contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1132896" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2834310 | 2834310 | PRJNA1132896_P_NODE_7163_length_250_cov_0.870056_g7072_i0 | PRJNA1132896 | 7163 | 250 | 0.870056 | 2.17514 | Rollinsvirus ph04 | 3060671 | Viruses | Viruses | 429 | 8.949999999999998e-116 | NTclustered | gi|2438090144|ref|NC_070890.1| | 2024263 | g7072 | i0 | 97.6 | 1 | 250 | 6 | 100 | 0 | 1 | 250 | 23894 | 23645 | Agrobacterium phage Atu_ph04, complete genome | blastn | 250 | 429 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pootjesviridae | Rollinsvirus | Rollinsvirus ph04 | |||
| 9211594 | 9211594 | PRJNA1132896_P_NODE_10288_length_241_cov_0.916667_g10197_i0 | PRJNA1132896 | 10288 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 444 | 3.06e-120 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g10197 | i0 | 100 | 0.995850622406639 | 240 | 0 | 99 | 0 | 1 | 240 | 9511 | 9750 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 240 | 444 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10487111 | 10487111 | PRJNA1132896_P_NODE_2069_length_376_cov_2.330033_g1978_i0 | PRJNA1132896 | 2069 | 376 | 2.330033 | 8.76092408 | Myoviridae sp. ct5xX4 | 2826616 | Viruses | Viruses | 364 | 4.049999999999999e-96 | NTclustered | gi|2051144302|tpg|BK015793.1| | 2826616 | g1978 | i0 | 99.5 | 79.9840425531915 | 200 | 1 | 53 | 0 | 1 | 200 | 20191 | 19992 | MAG TPA_asm: Myoviridae sp. ct5xX4, partial genome | blastn | 30074 | 364 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Myoviridae sp. ct5xX4 | |||||
| 13037333 | 13037333 | PRJNA1132896_P_NODE_4291_length_285_cov_1.146226_g4200_i0 | PRJNA1132896 | 4291 | 285 | 1.146226 | 3.2667441 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 494 | 3.64e-135 | NTclustered | gi|2060029275|tpg|BK027293.1| | 2832643 | g4200 | i0 | 97.895 | 48.3649122807018 | 285 | 6 | 100 | 0 | 1 | 285 | 11703 | 11987 | MAG TPA_asm: Caudoviricetes sp. isolate ctENK15, partial genome | blastn | 13784 | 494 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15586578 | 15586578 | PRJNA1132896_P_NODE_9033_length_244_cov_1.538012_g8942_i0 | PRJNA1132896 | 9033 | 244 | 1.538012 | 3.75274928 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 416 | 6.769999999999999e-112 | NTclustered | gi|2060029275|tpg|BK027293.1| | 2832643 | g8942 | i0 | 97.531 | 10.9590163934426 | 243 | 6 | 99 | 0 | 1 | 243 | 14498 | 14740 | MAG TPA_asm: Caudoviricetes sp. isolate ctENK15, partial genome | blastn | 2674 | 416 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16860805 | 16860805 | PRJNA1132896_P_NODE_3274_length_311_cov_1.294118_g3183_i0 | PRJNA1132896 | 3274 | 311 | 1.294118 | 4.02470698 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 575 | 1.3899999999999995e-159 | NTclustered | gi|2060029275|tpg|BK027293.1| | 2832643 | g3183 | i0 | 100 | 10.491961414791 | 311 | 0 | 100 | 0 | 1 | 311 | 12413 | 12103 | MAG TPA_asm: Caudoviricetes sp. isolate ctENK15, partial genome | blastn | 3263 | 575 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18135354 | 18135354 | PRJNA1132896_P_NODE_10175_length_241_cov_0.916667_g10084_i0 | PRJNA1132896 | 10175 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 385 | 1.88e-102 | NTclustered | gi|2052901204|tpg|BK017687.1| | 2832643 | g10084 | i0 | 95.436 | 1 | 241 | 11 | 100 | 0 | 1 | 241 | 9807 | 10047 | MAG TPA_asm: Caudoviricetes sp. isolate ctXTf36, partial genome | blastn | 241 | 385 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18135415 | 18135415 | PRJNA1132896_P_NODE_7295_length_250_cov_0.870056_g7204_i0 | PRJNA1132896 | 7295 | 250 | 0.870056 | 2.17514 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 272 | 1.6e-68 | NTclustered | gi|2052963916|tpg|BK030275.1| | 2832643 | g7204 | i0 | 96.914 | 34.956 | 162 | 5 | 65 | 0 | 1 | 162 | 17349 | 17510 | MAG TPA_asm: Caudoviricetes sp. isolate ctP9N3, partial genome | blastn | 8739 | 272 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19409569 | 19409569 | PRJNA1132896_P_NODE_8796_length_245_cov_0.895349_g8705_i0 | PRJNA1132896 | 8796 | 245 | 0.895349 | 2.19360505 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 453 | 5.1900000000000006e-123 | NTclustered | gi|2057080427|tpg|BK037909.1| | 2832643 | g8705 | i0 | 100 | 68.8530612244898 | 245 | 0 | 100 | 0 | 1 | 245 | 32289 | 32045 | MAG TPA_asm: Caudoviricetes sp. isolate ctslE2, partial genome | blastn | 16869 | 453 | 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);;