contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA631796" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3154250 | 3154250 | PRJNA631796_P_NODE_1323_length_627_cov_26.408127_g1062_i0 | PRJNA631796 | 1323 | 627 | 26.408127 | 165.57895629 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 843 | 0 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g1062 | i0 | 92.027 | 489.969696969697 | 602 | 44 | 96 | 4 | 2 | 601 | 17758 | 18357 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 307211 | 843 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 3703703 | 3703703 | PRJNA631796_P_NODE_8543_length_233_cov_2.226744_g8265_i0 | PRJNA631796 | 8543 | 233 | 2.226744 | 5.18831352 | Viruses | 10239 | Viruses | Viruses | 409 | 1.07e-109 | NTclustered | gi|2051096702|tpg|BK014951.1| | 2826270 | g8265 | i0 | 98.283 | 11.9828326180258 | 233 | 4 | 100 | 0 | 1 | 233 | 19905 | 20137 | MAG TPA_asm: Siphoviridae sp. ct0yq10, partial genome | blastn | 2792 | 409 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ct0yq10 | |||||
| 8256556 | 8256556 | PRJNA631796_P_NODE_3007_length_405_cov_4.494186_g2730_i0 | PRJNA631796 | 3007 | 405 | 4.494186 | 18.2014533 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 449 | 1.18e-121 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g2730 | i0 | 86.732 | 453.876543209877 | 407 | 51 | 100 | 3 | 1 | 405 | 17917 | 18322 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 183820 | 449 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8256583 | 8256583 | PRJNA631796_P_NODE_8067_length_239_cov_1.842697_g7789_i0 | PRJNA631796 | 8067 | 239 | 1.842697 | 4.40404583 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 364 | 2.4299999999999993e-96 | NTclustered | gi|2052983880|tpg|BK030690.1| | 2832643 | g7789 | i0 | 92.05 | 1 | 239 | 19 | 100 | 0 | 1 | 239 | 16843 | 17081 | MAG TPA_asm: Caudoviricetes sp. isolate ctP5a7, partial genome | blastn | 239 | 364 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12082799 | 12082799 | PRJNA631796_P_NODE_11650_length_206_cov_2.668966_g11372_i0 | PRJNA631796 | 11650 | 206 | 2.668966 | 5.49806996 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 353 | 4.41e-93 | NTclustered | gi|2914792039|gb|OR222787.1| | 2832643 | g11372 | i0 | 97.573 | 1 | 206 | 5 | 100 | 0 | 1 | 206 | 10400 | 10605 | MAG: Caudoviricetes sp. isolate MSP0571 genomic sequence | blastn | 206 | 353 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13905964 | 13905964 | PRJNA631796_P_NODE_9171_length_226_cov_3.496970_g8893_i0 | PRJNA631796 | 9171 | 226 | 3.49697 | 7.9031522 | root | 1 | Root_unresolved | Root_unresolved | 403 | 4.82e-108 | NTclustered | gi|2083029198|gb|MZ375249.1| | 10760 | g8893 | i0 | 99.548 | 97.787610619469 | 221 | 1 | 98 | 0 | 6 | 226 | 9885 | 10105 | Mutant Escherichia phage T7 clone T7_90L, complete genome | blastn | 22100 | 403 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autotranscriptaviridae | Teseptimavirus | Teseptimavirus T7 | ||
| 14632300 | 14632300 | PRJNA631796_P_NODE_1212_length_655_cov_16.111111_g953_i0 | PRJNA631796 | 1212 | 655 | 16.111111 | 105.52777705 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1014 | 0 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g953 | i0 | 94.665 | 394.810687022901 | 656 | 31 | 99 | 4 | 2 | 655 | 17758 | 18411 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 258601 | 1014 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15906254 | 15906254 | PRJNA631796_P_NODE_873_length_795_cov_33.980926_g638_i0 | PRJNA631796 | 873 | 795 | 33.980926 | 270.1483617 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1011 | 0 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g638 | i0 | 94.039 | 408.049056603774 | 671 | 32 | 84 | 8 | 2 | 667 | 17758 | 18425 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 324399 | 1011 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17181359 | 17181359 | PRJNA631796_P_NODE_12474_length_203_cov_1.802817_g12196_i0 | PRJNA631796 | 12474 | 203 | 1.802817 | 3.65971851 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 209 | 9.92e-50 | NTclustered | gi|2914850580|gb|OR221535.1| | 2832643 | g12196 | i0 | 85.572 | 0.990147783251232 | 201 | 28 | 99 | 1 | 1 | 201 | 27310 | 27111 | MAG: Caudoviricetes sp. isolate MSP1543 genomic sequence | blastn | 201 | 209 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17181410 | 17181410 | PRJNA631796_P_NODE_874_length_795_cov_33.373297_g639_i0 | PRJNA631796 | 874 | 795 | 33.373297 | 265.31771115 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1105 | 0 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g639 | i0 | 96.567 | 430.776100628931 | 670 | 17 | 84 | 6 | 129 | 794 | 18425 | 17758 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 342467 | 1105 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18455450 | 18455450 | PRJNA631796_P_NODE_14015_length_188_cov_2.015748_g13737_i0 | PRJNA631796 | 14015 | 188 | 2.015748 | 3.78960624 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 337 | 3.97e-88 | NTclustered | gi|2054391765|tpg|BK031039.1| | 2832643 | g13737 | i0 | 98.936 | 8.01595744680851 | 188 | 2 | 100 | 0 | 1 | 188 | 46164 | 45977 | MAG TPA_asm: Caudoviricetes sp. isolate ctBil5, partial genome | blastn | 1507 | 337 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22280469 | 22280469 | PRJNA631796_P_NODE_13758_length_192_cov_2.442748_g13480_i0 | PRJNA631796 | 13758 | 192 | 2.442748 | 4.69007616 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 244 | 2.5399999999999997e-60 | NTclustered | gi|2914794206|gb|OR222901.1| | 2832643 | g13480 | i0 | 91.111 | 0.9375 | 180 | 16 | 94 | 0 | 1 | 180 | 80412 | 80591 | MAG: Caudoviricetes sp. isolate MSP0450 genomic sequence | blastn | 180 | 244 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23555974 | 23555974 | PRJNA631796_P_NODE_5499_length_294_cov_1.373391_g5221_i0 | PRJNA631796 | 5499 | 294 | 1.373391 | 4.03776954 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 455 | 1.7800000000000002e-123 | NTclustered | gi|2054756036|tpg|BK043522.1| | 2832643 | g5221 | i0 | 94.558 | 12.7619047619048 | 294 | 16 | 100 | 0 | 1 | 294 | 55107 | 55400 | MAG TPA_asm: Caudoviricetes sp. isolate ctxnN8, partial genome | blastn | 3752 | 455 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24829694 | 24829694 | PRJNA631796_P_NODE_8640_length_232_cov_2.040936_g8362_i0 | PRJNA631796 | 8640 | 232 | 2.040936 | 4.73497152 | Siphoviridae sp. ctJ0s2 | 2827834 | Viruses | Viruses | 424 | 3.82e-114 | NTclustered | gi|2052880678|tpg|BK032813.1| | 2827834 | g8362 | i0 | 99.569 | 1.97844827586207 | 232 | 1 | 100 | 0 | 1 | 232 | 5473 | 5704 | MAG TPA_asm: Siphoviridae sp. ctJ0s2, partial genome | blastn | 459 | 424 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctJ0s2 |
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);;