contig_metadata
28 rows where analysis = "blastn", bioproject = "PRJNA1253698" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1634420 | 1634420 | PRJNA1253698_S_NODE_16522_length_174_cov_2.464000_g16156_i0 | PRJNA1253698 | 16522 | 174 | 2.464 | 4.28736 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 289 | 1.02e-73 | NTclustered | gi|2054444339|tpg|BK036214.1| | 2832643 | g16156 | i0 | 96.552 | 43.2126436781609 | 174 | 6 | 100 | 0 | 1 | 174 | 4052 | 3879 | MAG TPA_asm: Caudoviricetes sp. isolate ctre31, partial genome | blastn | 7519 | 289 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4186738 | 4186738 | PRJNA1253698_S_NODE_13104_length_193_cov_1.222222_g12738_i0 | PRJNA1253698 | 13104 | 193 | 1.222222 | 2.35888846 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 316 | 5.34e-82 | NTclustered | gi|2058147380|tpg|BK034438.1| | 2832643 | g12738 | i0 | 96.354 | 1.80310880829016 | 192 | 7 | 99 | 0 | 1 | 192 | 16963 | 16772 | MAG TPA_asm: Caudoviricetes sp. isolate ctAXZ35, partial genome | blastn | 348 | 316 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4186786 | 4186786 | PRJNA1253698_S_NODE_4404_length_332_cov_1.190813_g4038_i0 | PRJNA1253698 | 4404 | 332 | 1.190813 | 3.95349916 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 586 | 6.929999999999998e-163 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g4038 | i0 | 98.494 | 398.286144578313 | 332 | 5 | 100 | 0 | 1 | 332 | 18004 | 18335 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 132231 | 586 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5462991 | 5462991 | PRJNA1253698_S_NODE_19705_length_167_cov_0.872881_g19339_i0 | PRJNA1253698 | 19705 | 167 | 0.872881 | 1.45771127 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 298 | 1.63e-76 | NTclustered | gi|2057151004|tpg|BK058514.1| | 2832643 | g19339 | i0 | 98.802 | 3 | 167 | 2 | 100 | 0 | 1 | 167 | 39321 | 39487 | MAG TPA_asm: Caudoviricetes sp. isolate ctNZM8, partial genome | blastn | 501 | 298 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5462995 | 5462995 | PRJNA1253698_S_NODE_21205_length_165_cov_0.887931_g20839_i0 | PRJNA1253698 | 21205 | 165 | 0.887931 | 1.46508615 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 270 | 3.4999999999999993e-68 | NTclustered | gi|2058083181|tpg|BK043181.1| | 2832643 | g20839 | i0 | 96.341 | 18.3636363636364 | 164 | 6 | 99 | 0 | 2 | 165 | 2727 | 2564 | MAG TPA_asm: Caudoviricetes sp. isolate ctdrx24, partial genome | blastn | 3030 | 270 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6737430 | 6737430 | PRJNA1253698_S_NODE_6906_length_261_cov_1.608491_g6540_i0 | PRJNA1253698 | 6906 | 261 | 1.608491 | 4.19816151 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 394 | 3.429999999999999e-105 | NTclustered | gi|2058167954|tpg|BK034825.1| | 2832643 | g6540 | i0 | 93.87 | 39.9885057471264 | 261 | 16 | 100 | 0 | 1 | 261 | 5383 | 5643 | MAG TPA_asm: Caudoviricetes sp. isolate ctPXZ8, partial genome | blastn | 10437 | 394 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9287914 | 9287914 | PRJNA1253698_S_NODE_9428_length_224_cov_1.765714_g9062_i0 | PRJNA1253698 | 9428 | 224 | 1.765714 | 3.95519936 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 326 | 1.06e-84 | NTclustered | gi|2058070015|tpg|BK042928.1| | 2832643 | g9062 | i0 | 93.213 | 39.2366071428571 | 221 | 15 | 99 | 0 | 4 | 224 | 1600 | 1380 | MAG TPA_asm: Caudoviricetes sp. isolate ctr523, partial genome | blastn | 8789 | 326 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10563746 | 10563746 | PRJNA1253698_S_NODE_17469_length_170_cov_1.702479_g17103_i0 | PRJNA1253698 | 17469 | 170 | 1.702479 | 2.8942143 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 289 | 9.949999999999999e-74 | NTclustered | gi|2054444339|tpg|BK036214.1| | 2832643 | g17103 | i0 | 97.619 | 23.6 | 168 | 4 | 99 | 0 | 2 | 169 | 2053 | 1886 | MAG TPA_asm: Caudoviricetes sp. isolate ctre31, partial genome | blastn | 4012 | 289 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13113525 | 13113525 | PRJNA1253698_S_NODE_19891_length_166_cov_1.333333_g19525_i0 | PRJNA1253698 | 19891 | 166 | 1.333333 | 2.21333278 | Podoviridae sp. ctJYR5 | 2826551 | Viruses | Viruses | 270 | 3.5299999999999998e-68 | NTclustered | gi|2051100547|tpg|BK015028.1| | 2826551 | g19525 | i0 | 96.341 | 38.433734939759 | 164 | 6 | 99 | 0 | 2 | 165 | 8350 | 8513 | MAG TPA_asm: Podoviridae sp. ctJYR5, partial genome | blastn | 6380 | 270 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Podoviridae sp. ctJYR5 | |||||
| 14388774 | 14388774 | PRJNA1253698_S_NODE_18892_length_168_cov_0.865546_g18526_i0 | PRJNA1253698 | 18892 | 168 | 0.865546 | 1.45411728 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 283 | 4.6e-72 | NTclustered | gi|2052951674|tpg|BK030019.1| | 2832643 | g18526 | i0 | 97.024 | 99.9702380952381 | 168 | 5 | 100 | 0 | 1 | 168 | 14313 | 14146 | MAG TPA_asm: Caudoviricetes sp. isolate ctrWD8, partial genome | blastn | 16795 | 283 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16355282 | 16355282 | PRJNA1253698_S_NODE_6813_length_263_cov_1.640187_g6447_i0 | PRJNA1253698 | 6813 | 263 | 1.640187 | 4.31369181 | root | 1 | Root_unresolved | Root_unresolved | 484 | 1.9999999999999993e-132 | NTclustered | gi|2915034053|gb|OR222678.1| | 2832643 | g6447 | i0 | 100 | 66.425855513308 | 262 | 0 | 99 | 0 | 2 | 263 | 30545 | 30284 | MAG: Caudoviricetes sp. isolate MSP0255 genomic sequence | blastn | 17470 | 484 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16936920 | 16936920 | PRJNA1253698_S_NODE_19714_length_167_cov_0.872881_g19348_i0 | PRJNA1253698 | 19714 | 167 | 0.872881 | 1.45771127 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 307 | 2.71e-79 | NTclustered | gi|2058140838|tpg|BK034296.1| | 2832643 | g19348 | i0 | 100 | 30.2035928143713 | 166 | 0 | 99 | 0 | 2 | 167 | 11590 | 11755 | MAG TPA_asm: Caudoviricetes sp. isolate ctS8R1, partial genome | blastn | 5044 | 307 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16936936 | 16936936 | PRJNA1253698_S_NODE_23834_length_161_cov_2.491071_g23468_i0 | PRJNA1253698 | 23834 | 161 | 2.491071 | 4.01062431 | Siphoviridae sp. ctHip2 | 2827830 | Viruses | Viruses | 291 | 2.6e-74 | NTclustered | gi|2052861377|tpg|BK032497.1| | 2827830 | g23468 | i0 | 99.375 | 3.90062111801242 | 160 | 1 | 99 | 0 | 1 | 160 | 312370 | 312529 | MAG TPA_asm: Siphoviridae sp. ctHip2, partial genome | blastn | 628 | 291 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctHip2 | |||||
| 18211343 | 18211343 | PRJNA1253698_S_NODE_12535_length_197_cov_1.040541_g12169_i0 | PRJNA1253698 | 12535 | 197 | 1.040541 | 2.04986577 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 272 | 1.2e-68 | NTclustered | gi|2056962428|tpg|BK022941.1| | 2832643 | g12169 | i0 | 97.484 | 206.578680203046 | 159 | 4 | 81 | 0 | 38 | 196 | 8118 | 7960 | MAG TPA_asm: Caudoviricetes sp. isolate ctk4c3, partial genome | blastn | 40696 | 272 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19485645 | 19485645 | PRJNA1253698_S_NODE_11816_length_202_cov_1.346405_g11450_i0 | PRJNA1253698 | 11816 | 202 | 1.346405 | 2.7197381 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 348 | 2e-91 | NTclustered | gi|2054430967|tpg|BK035939.1| | 2832643 | g11450 | i0 | 98 | 41.7227722772277 | 200 | 4 | 99 | 0 | 2 | 201 | 15947 | 15748 | MAG TPA_asm: Caudoviricetes sp. isolate ctwdH2, partial genome | blastn | 8428 | 348 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19485651 | 19485651 | PRJNA1253698_S_NODE_13076_length_193_cov_1.493056_g12710_i0 | PRJNA1253698 | 13076 | 193 | 1.493056 | 2.88159808 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 291 | 3.2399999999999994e-74 | NTclustered | gi|2054565656|tpg|BK048337.1| | 2832643 | g12710 | i0 | 94.241 | 29.7046632124352 | 191 | 10 | 99 | 1 | 2 | 192 | 11871 | 11682 | MAG TPA_asm: Caudoviricetes sp. isolate ctV5H8, partial genome | blastn | 5733 | 291 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19485685 | 19485685 | PRJNA1253698_S_NODE_21836_length_164_cov_0.904348_g21470_i0 | PRJNA1253698 | 21836 | 164 | 0.904348 | 1.48313072 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 294 | 2.06e-75 | NTclustered | gi|2057970079|tpg|BK046553.1| | 2832643 | g21470 | i0 | 99.383 | 50.7073170731707 | 162 | 1 | 99 | 0 | 2 | 163 | 10659 | 10498 | MAG TPA_asm: Caudoviricetes sp. isolate ctwCi2, partial genome | blastn | 8316 | 294 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19485704 | 19485704 | PRJNA1253698_S_NODE_4056_length_346_cov_1.548822_g3690_i0 | PRJNA1253698 | 4056 | 346 | 1.548822 | 5.35892412 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 518 | 2.69e-142 | NTclustered | gi|2059850002|tpg|BK040481.1| | 2832643 | g3690 | i0 | 93.878 | 35.4797687861272 | 343 | 21 | 99 | 0 | 3 | 345 | 8554 | 8212 | MAG TPA_asm: Caudoviricetes sp. isolate ctfwV5, partial genome | blastn | 12276 | 518 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22036302 | 22036302 | PRJNA1253698_S_NODE_14098_length_187_cov_1.101449_g13732_i0 | PRJNA1253698 | 14098 | 187 | 1.101449 | 2.05970963 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 274 | 3.14e-69 | NTclustered | gi|2056950521|tpg|BK022685.1| | 2832643 | g13732 | i0 | 93.048 | 28.6737967914438 | 187 | 13 | 100 | 0 | 1 | 187 | 13335 | 13521 | MAG TPA_asm: Caudoviricetes sp. isolate ctgZb22, partial genome | blastn | 5362 | 274 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22036305 | 22036305 | PRJNA1253698_S_NODE_14478_length_185_cov_1.000000_g14112_i0 | PRJNA1253698 | 14478 | 185 | 1 | 1.85 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 327 | 2.34e-85 | NTclustered | gi|2059609252|tpg|BK037270.1| | 2832643 | g14112 | i0 | 98.907 | 25.6594594594595 | 183 | 2 | 99 | 0 | 2 | 184 | 7188 | 7006 | MAG TPA_asm: Caudoviricetes sp. isolate ctudR4, partial genome | blastn | 4747 | 327 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22036318 | 22036318 | PRJNA1253698_S_NODE_19118_length_167_cov_1.322034_g18752_i0 | PRJNA1253698 | 19118 | 167 | 1.322034 | 2.20779678 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 213 | 6.07e-51 | NTclustered | gi|2056962428|tpg|BK022941.1| | 2832643 | g18752 | i0 | 89.759 | 12.8562874251497 | 166 | 17 | 99 | 0 | 2 | 167 | 14388 | 14553 | MAG TPA_asm: Caudoviricetes sp. isolate ctk4c3, partial genome | blastn | 2147 | 213 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23311839 | 23311839 | PRJNA1253698_S_NODE_12459_length_197_cov_2.094595_g12093_i0 | PRJNA1253698 | 12459 | 197 | 2.094595 | 4.12635215 | Escherichia phage Lambda_ev058 | 2742950 | Viruses | Viruses | 69.4 | 1.69e-7 | NTclustered | gi|1779414893|emb|LR597651.1| | 2742950 | g12093 | i0 | 100 | 195.868020304569 | 37 | 0 | 19 | 0 | 161 | 197 | 47322 | 47358 | Escherichia phage Lambda_ev058 genome assembly, chromosome: 1 | blastn | 38586 | 69.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Jouyvirus | Escherichia phage Lambda_ev058 | ||||
| 23311910 | 23311910 | PRJNA1253698_S_NODE_7859_length_245_cov_1.173469_g7493_i0 | PRJNA1253698 | 7859 | 245 | 1.173469 | 2.87499905 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 357 | 4.18e-94 | NTclustered | gi|2054444339|tpg|BK036214.1| | 2832643 | g7493 | i0 | 93.361 | 37.0244897959184 | 241 | 16 | 98 | 0 | 4 | 244 | 8911 | 8671 | MAG TPA_asm: Caudoviricetes sp. isolate ctre31, partial genome | blastn | 9071 | 357 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24585916 | 24585916 | PRJNA1253698_S_NODE_11540_length_204_cov_1.329032_g11174_i0 | PRJNA1253698 | 11540 | 204 | 1.329032 | 2.71122528 | Siphoviridae sp. ctHip2 | 2827830 | Viruses | Viruses | 307 | 3.44e-79 | NTclustered | gi|2052861377|tpg|BK032497.1| | 2827830 | g11174 | i0 | 94.059 | 3.84313725490196 | 202 | 12 | 99 | 0 | 3 | 204 | 312159 | 311958 | MAG TPA_asm: Siphoviridae sp. ctHip2, partial genome | blastn | 784 | 307 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctHip2 | |||||
| 24585928 | 24585928 | PRJNA1253698_S_NODE_13620_length_190_cov_1.092199_g13254_i0 | PRJNA1253698 | 13620 | 190 | 1.092199 | 2.0751781 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 333 | 5.209999999999999e-87 | NTclustered | gi|2056851131|tpg|BK044328.1| | 2832643 | g13254 | i0 | 98.413 | 26.6210526315789 | 189 | 3 | 99 | 0 | 2 | 190 | 20724 | 20536 | MAG TPA_asm: Caudoviricetes sp. isolate ctN4411, partial genome | blastn | 5058 | 333 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24585940 | 24585940 | PRJNA1253698_S_NODE_16180_length_176_cov_1.220472_g15814_i0 | PRJNA1253698 | 16180 | 176 | 1.220472 | 2.14803072 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 270 | 3.77e-68 | NTclustered | gi|2053057886|tpg|BK024583.1| | 2832643 | g15814 | i0 | 94.798 | 26.6306818181818 | 173 | 9 | 98 | 0 | 4 | 176 | 12347 | 12175 | MAG TPA_asm: Caudoviricetes sp. isolate ctsEX10, partial genome | blastn | 4687 | 270 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24585965 | 24585965 | PRJNA1253698_S_NODE_22260_length_163_cov_1.359649_g21894_i0 | PRJNA1253698 | 22260 | 163 | 1.359649 | 2.21622787 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 289 | 9.51e-74 | NTclustered | gi|2058028762|tpg|BK042096.1| | 2832643 | g21894 | i0 | 98.765 | 98.2944785276074 | 162 | 2 | 99 | 0 | 2 | 163 | 22682 | 22521 | MAG TPA_asm: Caudoviricetes sp. isolate ctH0J1, partial genome | blastn | 16022 | 289 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24585987 | 24585987 | PRJNA1253698_S_NODE_6900_length_261_cov_1.702830_g6534_i0 | PRJNA1253698 | 6900 | 261 | 1.70283 | 4.4443863 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 320 | 5.91e-83 | NTclustered | gi|2058147380|tpg|BK034438.1| | 2832643 | g6534 | i0 | 88.846 | 15.6590038314176 | 260 | 29 | 99 | 0 | 2 | 261 | 12665 | 12924 | MAG TPA_asm: Caudoviricetes sp. isolate ctAXZ35, partial genome | blastn | 4087 | 320 | 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);;