contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA1144090" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2837650 | 2837650 | PRJNA1144090_P_NODE_106063_length_247_cov_0.885057_g105528_i0 | PRJNA1144090 | 106063 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 377 | 3.24e-100 | NTclustered | gi|2056894972|tpg|BK053777.1| | 2832643 | g105528 | i0 | 95.726 | 3.63967611336032 | 234 | 10 | 95 | 0 | 13 | 246 | 25109 | 24876 | MAG TPA_asm: Caudoviricetes sp. isolate ctNiS1, partial genome | blastn | 899 | 377 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4113954 | 4113954 | PRJNA1144090_P_NODE_116464_length_241_cov_0.916667_g115929_i0 | PRJNA1144090 | 116464 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 250 | 7.17e-62 | NTclustered | gi|2054776301|tpg|BK049662.1| | 2832643 | g115929 | i0 | 89.151 | 10.2489626556017 | 212 | 8 | 100 | 9 | 1 | 198 | 7484 | 7694 | MAG TPA_asm: Caudoviricetes sp. isolate ctZxG3, partial genome | blastn | 2470 | 250 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4114845 | 4114845 | PRJNA1144090_P_NODE_90604_length_263_cov_3.394737_g90069_i0 | PRJNA1144090 | 90604 | 263 | 3.394737 | 8.92815831 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 448 | 2.6199999999999995e-121 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g90069 | i0 | 97.338 | 278.395437262357 | 263 | 7 | 100 | 0 | 1 | 263 | 17937 | 17675 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 73218 | 448 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6664770 | 6664770 | PRJNA1144090_P_NODE_106406_length_247_cov_0.885057_g105871_i0 | PRJNA1144090 | 106406 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 457 | 4.05e-124 | NTclustered | gi|2059747985|tpg|BK027185.1| | 2832643 | g105871 | i0 | 100 | 15.9311740890688 | 247 | 0 | 100 | 0 | 1 | 247 | 26297 | 26051 | MAG TPA_asm: Caudoviricetes sp. isolate ctNJF4, partial genome | blastn | 3935 | 457 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7939979 | 7939979 | PRJNA1144090_P_NODE_111947_length_243_cov_1.811765_g111412_i0 | PRJNA1144090 | 111947 | 243 | 1.811765 | 4.40258895 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 58.4 | 4.71e-4 | NTclustered | gi|2914830750|gb|OR222504.1| | 2832643 | g111412 | i0 | 100 | 0.127572016460905 | 31 | 0 | 13 | 0 | 107 | 137 | 2080 | 2110 | MAG: Caudoviricetes sp. isolate MSP0877 genomic sequence | blastn | 31 | 58.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10490554 | 10490554 | PRJNA1144090_P_NODE_116049_length_241_cov_0.916667_g115514_i0 | PRJNA1144090 | 116049 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 364 | 2.4499999999999993e-96 | NTclustered | gi|2056825688|tpg|BK043834.1| | 2832643 | g115514 | i0 | 94.167 | 18.9626556016598 | 240 | 13 | 99 | 1 | 2 | 240 | 26675 | 26914 | MAG TPA_asm: Caudoviricetes sp. isolate ctmJg21, partial genome | blastn | 4570 | 364 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11765520 | 11765520 | PRJNA1144090_P_NODE_106410_length_247_cov_0.885057_g105875_i0 | PRJNA1144090 | 106410 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 252 | 2.05e-62 | NTclustered | gi|2914853603|gb|OR221864.1| | 2832643 | g105875 | i0 | 92.222 | 0.728744939271255 | 180 | 11 | 72 | 3 | 70 | 247 | 31148 | 31326 | MAG: Caudoviricetes sp. isolate MSP1141 genomic sequence | blastn | 180 | 252 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11765586 | 11765586 | PRJNA1144090_P_NODE_116710_length_241_cov_0.916667_g116175_i0 | PRJNA1144090 | 116710 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 446 | 8.519999999999999e-121 | NTclustered | gi|2058036227|tpg|BK042250.1| | 2832643 | g116175 | i0 | 100 | 54.7136929460581 | 241 | 0 | 100 | 0 | 1 | 241 | 834 | 1074 | MAG TPA_asm: Caudoviricetes sp. isolate ctXzA6, partial genome | blastn | 13186 | 446 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13040771 | 13040771 | PRJNA1144090_P_NODE_18491_length_635_cov_3.443060_g17970_i0 | PRJNA1144090 | 18491 | 635 | 3.44306 | 21.863431 | Salmondvirus JA29 | 2734142 | Viruses | Viruses | 58.4 | 0.001 | NTclustered | gi|1842024058|ref|NC_048053.1| | 2283031 | g17970 | i0 | 100 | 4.23937007874016 | 31 | 0 | 5 | 0 | 11 | 41 | 218603 | 218573 | Dickeya phage vB_DsoM_JA29, complete genome | blastn | 2692 | 58.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Salmondvirus | Salmondvirus JA29 | ||||
| 14315857 | 14315857 | PRJNA1144090_P_NODE_113332_length_243_cov_0.888235_g112797_i0 | PRJNA1144090 | 113332 | 243 | 0.888235 | 2.15841105 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 388 | 1.47e-103 | NTclustered | gi|2059603108|tpg|BK037133.1| | 2832643 | g112797 | i0 | 95.473 | 1 | 243 | 11 | 100 | 0 | 1 | 243 | 15366 | 15608 | MAG TPA_asm: Caudoviricetes sp. isolate ctWG610, partial genome | blastn | 243 | 388 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14316892 | 14316892 | PRJNA1144090_P_NODE_99572_length_251_cov_0.865169_g99037_i0 | PRJNA1144090 | 99572 | 251 | 0.865169 | 2.17157419 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 453 | 5.34e-123 | NTclustered | gi|2059891324|tpg|BK041169.1| | 2832643 | g99037 | i0 | 99.203 | 1.99203187250996 | 251 | 2 | 100 | 0 | 1 | 251 | 8407 | 8657 | MAG TPA_asm: Caudoviricetes sp. isolate ctQrd11, partial genome | blastn | 500 | 453 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16335457 | 16335457 | PRJNA1144090_P_NODE_49853_length_361_cov_3.493056_g49318_i0 | PRJNA1144090 | 49853 | 361 | 3.493056 | 12.60993216 | Cyvirus | 3044698 | Viruses | Viruses | 65.8 | 4.4e-6 | NTclustered | gi|2905000374|gb|PQ738159.1| | 317878 | g49318 | i0 | 97.368 | 3.31578947368421 | 38 | 1 | 11 | 0 | 241 | 278 | 259278 | 259315 | Cyprinid herpesvirus 2 isolate NL-1, complete genome | blastn | 1197 | 65.8 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Alloherpesviridae | Cyvirus | Cyvirus cyprinidallo2 | ||
| 18139088 | 18139088 | PRJNA1144090_P_NODE_4435_length_1344_cov_4.183320_g4168_i0 | PRJNA1144090 | 4435 | 1344 | 4.18332 | 56.2238208 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 69.4 | 1.37e-6 | NTclustered | gi|2054558084|tpg|BK048187.1| | 2832643 | g4168 | i0 | 81.707 | 0.188988095238095 | 82 | 15 | 6 | 0 | 924 | 1005 | 56608 | 56689 | MAG TPA_asm: Caudoviricetes sp. isolate ctlv32, partial genome | blastn | 254 | 69.4 | 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);;