contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1122875" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4104553 | 4104553 | PRJNA1122875_P_NODE_19564_length_377_cov_1.519737_g19340_i0 | PRJNA1122875 | 19564 | 377 | 1.519737 | 5.72940849 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.01 | NTclustered | gi|2052241503|tpg|BK019419.1| | 2832643 | g19340 | i0 | 96.97 | 0.0875331564986737 | 33 | 0 | 8 | 1 | 148 | 179 | 101378 | 101410 | MAG TPA_asm: Caudoviricetes sp. isolate ctyBb16, partial genome | blastn | 33 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11756098 | 11756098 | PRJNA1122875_P_NODE_25170_length_331_cov_1.089147_g24946_i0 | PRJNA1122875 | 25170 | 331 | 1.089147 | 3.60507657 | Crassvirales sp. | 2960088 | Viruses | Viruses | 612 | 1.14e-170 | NTclustered | gi|2053230001|tpg|BK035415.1| | 2960088 | g24946 | i0 | 100 | 4 | 331 | 0 | 100 | 0 | 1 | 331 | 43654 | 43984 | MAG TPA_asm: Crassvirales sp. isolate ctuIB16, partial genome | blastn | 1324 | 612 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Crassvirales | Crassvirales sp. | ||||
| 11756375 | 11756375 | PRJNA1122875_P_NODE_50890_length_244_cov_0.900585_g50666_i0 | PRJNA1122875 | 50890 | 244 | 0.900585 | 2.1974274 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 451 | 1.86e-122 | NTclustered | gi|2057950350|tpg|BK046180.1| | 2832643 | g50666 | i0 | 100 | 1 | 244 | 0 | 100 | 0 | 1 | 244 | 6186 | 6429 | MAG TPA_asm: Caudoviricetes sp. isolate ctgei1, partial genome | blastn | 244 | 451 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15580323 | 15580323 | PRJNA1122875_P_NODE_17613_length_398_cov_0.947692_g17389_i0 | PRJNA1122875 | 17613 | 398 | 0.947692 | 3.77181416 | Dulem virus 40 | 3145758 | Viruses | Viruses | 187 | 9.999999999999999e-43 | NTclustered | gi|2750933247|gb|PP511379.1| | 3145758 | g17389 | i0 | 81.982 | 0.557788944723618 | 222 | 38 | 56 | 2 | 3 | 223 | 37001 | 37221 | Dulem virus 40 isolate Duke_21_1, complete genome | blastn | 222 | 187 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Dulem virus 40 | |||||
| 19403551 | 19403551 | PRJNA1122875_P_NODE_34936_length_280_cov_1.391304_g34712_i0 | PRJNA1122875 | 34936 | 280 | 1.391304 | 3.8956512 | Propionibacterium phage QueenBey | 1654782 | Viruses | Viruses | 468 | 2.16e-127 | NTclustered | gi|1725329243|ref|NC_031005.2| | 1654782 | g34712 | i0 | 96.786 | 99.6285714285714 | 280 | 9 | 100 | 0 | 1 | 280 | 12120 | 11841 | Propionibacterium phage QueenBey, complete genome | blastn | 27896 | 468 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Propionibacterium phage QueenBey | ||||
| 19403704 | 19403704 | PRJNA1122875_P_NODE_48276_length_246_cov_0.890173_g48052_i0 | PRJNA1122875 | 48276 | 246 | 0.890173 | 2.18982558 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 444 | 3.14e-120 | NTclustered | gi|2053147871|tpg|BK018915.1| | 2832643 | g48052 | i0 | 99.187 | 7.02845528455285 | 246 | 2 | 100 | 0 | 1 | 246 | 15762 | 15517 | MAG TPA_asm: Caudoviricetes sp. isolate ctZfJ1, partial genome | blastn | 1729 | 444 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20679202 | 20679202 | PRJNA1122875_P_NODE_43617_length_251_cov_0.865169_g43393_i0 | PRJNA1122875 | 43617 | 251 | 0.865169 | 2.17157419 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 128 | 3.67e-25 | NTclustered | gi|2057984038|tpg|BK046807.1| | 2832643 | g43393 | i0 | 90.909 | 0.681274900398406 | 99 | 3 | 39 | 6 | 143 | 241 | 126826 | 126918 | MAG TPA_asm: Caudoviricetes sp. isolate ct57N1, partial genome | blastn | 171 | 128 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20679252 | 20679252 | PRJNA1122875_P_NODE_47417_length_247_cov_0.885057_g47193_i0 | PRJNA1122875 | 47417 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 76.8 | 1.32e-9 | NTclustered | gi|2914786415|gb|OR222567.1| | 2832643 | g47193 | i0 | 86.111 | 1.93927125506073 | 72 | 8 | 29 | 2 | 170 | 240 | 84161 | 84231 | MAG: Caudoviricetes sp. isolate MSP0365 genomic sequence | blastn | 479 | 76.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23230039 | 23230039 | PRJNA1122875_P_NODE_3999_length_765_cov_1.803468_g3803_i0 | PRJNA1122875 | 3999 | 765 | 1.803468 | 13.7965302 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.021 | NTclustered | gi|2914964766|gb|OR222006.1| | 2832643 | g3803 | i0 | 100 | 0.0379084967320261 | 29 | 0 | 4 | 0 | 652 | 680 | 15184 | 15156 | MAG: Caudoviricetes sp. isolate MSP0115 genomic sequence | blastn | 29 | 54.7 | 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);;