contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA983838" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 964803 | 964803 | PRJNA983838_P_NODE_117461_length_243_cov_0.917647_g115094_i0 | PRJNA983838 | 117461 | 243 | 0.917647 | 2.22988221 | Cutibacterium phage vB_CacS-HV1 | 3236917 | Viruses | Viruses | 388 | 1.47e-103 | NTclustered | gi|2780182484|gb|PQ037195.1| | 3236917 | g115094 | i0 | 95.473 | 99.843621399177 | 243 | 11 | 100 | 0 | 1 | 243 | 5830 | 6072 | Cutibacterium phage vB_CacS-HV1, complete genome | blastn | 24262 | 388 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Cutibacterium phage vB_CacS-HV1 | ||||
| 965678 | 965678 | PRJNA983838_P_NODE_78601_length_304_cov_1.350649_g76234_i0 | PRJNA983838 | 78601 | 304 | 1.350649 | 4.10597296 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 562 | 1.06e-155 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g76234 | i0 | 100 | 1.22368421052632 | 304 | 0 | 100 | 0 | 1 | 304 | 49362 | 49059 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 372 | 562 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7342566 | 7342566 | PRJNA983838_P_NODE_115606_length_244_cov_1.543860_g113239_i0 | PRJNA983838 | 115606 | 244 | 1.54386 | 3.7670184 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 451 | 1.86e-122 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g113239 | i0 | 100 | 1.89754098360656 | 244 | 0 | 100 | 0 | 1 | 244 | 42777 | 42534 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 463 | 451 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7343517 | 7343517 | PRJNA983838_P_NODE_78206_length_305_cov_1.581897_g75839_i0 | PRJNA983838 | 78206 | 305 | 1.581897 | 4.82478585 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 564 | 2.95e-156 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g75839 | i0 | 100 | 1 | 305 | 0 | 100 | 0 | 1 | 305 | 42023 | 42327 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 305 | 564 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13718269 | 13718269 | PRJNA983838_P_NODE_108131_length_250_cov_0.881356_g105764_i0 | PRJNA983838 | 108131 | 250 | 0.881356 | 2.20339 | Podoviridae sp. ctbh1 | 2675446 | Viruses | Viruses | 313 | 9.41e-81 | NTclustered | gi|1407520932|gb|MH511048.1| | 2675446 | g105764 | i0 | 89.243 | 1.004 | 251 | 25 | 99 | 1 | 1 | 249 | 26940 | 26690 | MAG: Podoviridae sp. ctbh1, complete genome | blastn | 251 | 313 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Podoviridae sp. ctbh1 | |||||
| 14992779 | 14992779 | PRJNA983838_P_NODE_118932_length_242_cov_0.923077_g116565_i0 | PRJNA983838 | 118932 | 242 | 0.923077 | 2.23384634 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 370 | 5.3e-98 | NTclustered | gi|2914951202|gb|OR221908.1| | 2832643 | g116565 | i0 | 94.215 | 14.8801652892562 | 242 | 14 | 100 | 0 | 1 | 242 | 37783 | 37542 | MAG: Caudoviricetes sp. isolate MSP1097 genomic sequence | blastn | 3601 | 370 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14993852 | 14993852 | PRJNA983838_P_NODE_88232_length_281_cov_2.115385_g85865_i0 | PRJNA983838 | 88232 | 281 | 2.115385 | 5.94423185 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 520 | 5.909999999999999e-143 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g85865 | i0 | 100 | 1 | 281 | 0 | 100 | 0 | 1 | 281 | 47373 | 47093 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 281 | 520 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17542724 | 17542724 | PRJNA983838_P_NODE_118514_length_242_cov_0.923077_g116147_i0 | PRJNA983838 | 118514 | 242 | 0.923077 | 2.23384634 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 418 | 1.8699999999999998e-112 | NTclustered | gi|2056737341|tpg|BK045029.1| | 2832643 | g116147 | i0 | 97.925 | 7.16942148760331 | 241 | 5 | 99 | 0 | 2 | 242 | 34012 | 34252 | MAG TPA_asm: Caudoviricetes sp. isolate ctqcb9, partial genome | blastn | 1735 | 418 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18816647 | 18816647 | PRJNA983838_P_NODE_124195_length_208_cov_4.111111_g121827_i0 | PRJNA983838 | 124195 | 208 | 4.111111 | 8.55111088 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 385 | 1.58e-102 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g121827 | i0 | 100 | 1 | 208 | 0 | 100 | 0 | 1 | 208 | 23160 | 22953 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 208 | 385 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18817630 | 18817630 | PRJNA983838_P_NODE_88875_length_280_cov_1.507246_g86508_i0 | PRJNA983838 | 88875 | 280 | 1.507246 | 4.2202888 | Erythrobacter phage vB_EliS-L02 | 2909139 | Viruses | Viruses | 202 | 2.42e-47 | NTclustered | gi|2177198975|gb|OL955261.1| | 2909139 | g86508 | i0 | 79.859 | 2.66071428571429 | 283 | 51 | 100 | 6 | 1 | 280 | 56458 | 56737 | Erythrobacter phage vB_EliS-L02, complete genome | blastn | 745 | 202 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Erythrobacter phage vB_EliS-L02 |
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);;