contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA951412" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3814820 | 3814820 | PRJNA951412_P_NODE_3523_length_265_cov_1.614583_g3438_i0 | PRJNA951412 | 3523 | 265 | 1.614583 | 4.27864495 | Moineauvirus | 1623304 | Viruses | Viruses | 473 | 4.3599999999999987e-129 | NTclustered | gi|2437985630|ref|NC_070691.1| | 1971415 | g3438 | i0 | 98.868 | 100.581132075472 | 265 | 3 | 100 | 0 | 1 | 265 | 9340 | 9604 | Streptococcus phage P3681, complete genome | blastn | 26654 | 473 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aliceevansviridae | Moineauvirus | Moineauvirus P3681 | |||
| 11466576 | 11466576 | PRJNA951412_P_NODE_6229_length_246_cov_0.901734_g6144_i0 | PRJNA951412 | 6229 | 246 | 0.901734 | 2.21826564 | Viruses | 10239 | Viruses | Viruses | 405 | 1.48e-108 | NTclustered | gi|2053070936|tpg|BK016058.1| | 2825571 | g6144 | i0 | 97.863 | 23.5121951219512 | 234 | 5 | 95 | 0 | 1 | 234 | 364 | 131 | MAG TPA_asm: Siphoviridae sp. ctcK97, partial genome | blastn | 5784 | 405 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctcK97 | |||||
| 13688484 | 13688484 | PRJNA951412_P_NODE_6431_length_246_cov_0.895954_g6346_i0 | PRJNA951412 | 6431 | 246 | 0.895954 | 2.20404684 | Acinetobacter phage vB_AbaS_TRS1 | 1852629 | Viruses | Viruses | 422 | 1.47e-113 | NTclustered | gi|1070104669|ref|NC_031098.1| | 1852629 | g6346 | i0 | 97.561 | 7.89430894308943 | 246 | 6 | 100 | 0 | 1 | 246 | 33941 | 33696 | Acinetobacter phage vB_AbaS_TRS1, complete genome | blastn | 1942 | 422 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Acinetobacter phage vB_AbaS_TRS1 | |||||
| 14962651 | 14962651 | PRJNA951412_P_NODE_3752_length_259_cov_1.672043_g3667_i0 | PRJNA951412 | 3752 | 259 | 1.672043 | 4.33059137 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 359 | 1.24e-94 | NTclustered | gi|2914804504|gb|OR221411.1| | 2832643 | g3667 | i0 | 94.421 | 95.0579150579151 | 233 | 13 | 90 | 0 | 27 | 259 | 27143 | 26911 | MAG: Caudoviricetes sp. isolate MSP1680 genomic sequence | blastn | 24620 | 359 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17512913 | 17512913 | PRJNA951412_P_NODE_2334_length_309_cov_1.224576_g2249_i0 | PRJNA951412 | 2334 | 309 | 1.224576 | 3.78393984 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 226 | 1.6099999999999998e-54 | NTclustered | gi|2914792039|gb|OR222787.1| | 2832643 | g2249 | i0 | 90.23 | 0.563106796116505 | 174 | 16 | 56 | 1 | 136 | 309 | 27841 | 27669 | MAG: Caudoviricetes sp. isolate MSP0571 genomic sequence | blastn | 174 | 226 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17512955 | 17512955 | PRJNA951412_P_NODE_5694_length_248_cov_0.880000_g5609_i0 | PRJNA951412 | 5694 | 248 | 0.88 | 2.1824 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 453 | 5.2600000000000005e-123 | NTclustered | gi|2059803870|tpg|BK039751.1| | 2832643 | g5609 | i0 | 99.597 | 1.28225806451613 | 248 | 1 | 100 | 0 | 1 | 248 | 30960 | 31207 | MAG TPA_asm: Caudoviricetes sp. isolate ctkVX2, partial genome | blastn | 318 | 453 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22611840 | 22611840 | PRJNA951412_P_NODE_5658_length_248_cov_0.885714_g5573_i0 | PRJNA951412 | 5658 | 248 | 0.885714 | 2.19657072 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 429 | 8.869999999999998e-116 | NTclustered | gi|2915040595|gb|OR222730.1| | 2832643 | g5573 | i0 | 97.976 | 1.20161290322581 | 247 | 5 | 99 | 0 | 1 | 247 | 48884 | 49130 | MAG: Caudoviricetes sp. isolate MSP0629 genomic sequence | blastn | 298 | 429 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 25160940 | 25160940 | PRJNA951412_P_NODE_4060_length_253_cov_0.866667_g3975_i0 | PRJNA951412 | 4060 | 253 | 0.866667 | 2.19266751 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 363 | 9.339999999999996e-96 | NTclustered | gi|2057857637|tpg|BK050476.1| | 2832643 | g3975 | i0 | 93.145 | 2.61660079051383 | 248 | 15 | 98 | 2 | 1 | 248 | 19418 | 19663 | MAG TPA_asm: Caudoviricetes sp. isolate ctwJB10, partial genome | blastn | 662 | 363 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 25160958 | 25160958 | PRJNA951412_P_NODE_5520_length_248_cov_0.891429_g5435_i0 | PRJNA951412 | 5520 | 248 | 0.891429 | 2.21074392 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 442 | 1.1399999999999995e-119 | NTclustered | gi|2915040595|gb|OR222730.1| | 2832643 | g5435 | i0 | 98.79 | 1 | 248 | 3 | 100 | 0 | 1 | 248 | 24683 | 24930 | MAG: Caudoviricetes sp. isolate MSP0629 genomic sequence | blastn | 248 | 442 | 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);;