contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA1065838" and tax_phylum = "Peploviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2730472 | 2730472 | PRJNA1065838_S_NODE_12563_length_228_cov_5.821229_g12461_i0 | PRJNA1065838 | 12563 | 228 | 5.821229 | 13.27240212 | Iltovirus gallidalpha1 | 3050286 | Viruses | Viruses | 80.5 | 9.32e-11 | NTclustered | gi|2451390879|gb|OQ354887.1| | 10386 | g12461 | i0 | 97.826 | 181.083333333333 | 46 | 1 | 20 | 0 | 6 | 51 | 139709 | 139664 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CPBDh_UL12, complete genome | blastn | 41287 | 80.5 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 2730688 | 2730688 | PRJNA1065838_S_NODE_5903_length_304_cov_339.388235_g5801_i0 | PRJNA1065838 | 5903 | 304 | 339.388235 | 1031.7402344 | Iltovirus gallidalpha1 | 3050286 | Viruses | Viruses | 111 | 4.61e-20 | NTclustered | gi|2451390879|gb|OQ354887.1| | 10386 | g5801 | i0 | 90.476 | 183.401315789474 | 84 | 8 | 28 | 0 | 221 | 304 | 368 | 285 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CPBDh_UL12, complete genome | blastn | 55754 | 111 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 2730693 | 2730693 | PRJNA1065838_S_NODE_6363_length_295_cov_7028.040650_g6261_i0 | PRJNA1065838 | 6363 | 295 | 7028.04065 | 20732.7199175 | Iltovirus gallidalpha1 | 3050286 | Viruses | Viruses | 159 | 1.57e-34 | NTclustered | gi|2451391033|gb|OQ354889.1| | 10386 | g6261 | i0 | 98.876 | 415.149152542373 | 89 | 1 | 60 | 0 | 1 | 89 | 139686 | 139598 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CUD_1/6th_UL12, complete genome | blastn | 122469 | 159 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 6557898 | 6557898 | PRJNA1065838_S_NODE_13346_length_224_cov_964.268571_g13244_i0 | PRJNA1065838 | 13346 | 224 | 964.268571 | 2159.96159904 | Iltovirus gallidalpha1 | 3050286 | Viruses | Viruses | 111 | 3.24e-20 | NTclustered | gi|2451390879|gb|OQ354887.1| | 10386 | g13244 | i0 | 90.476 | 532.441964285714 | 84 | 8 | 75 | 0 | 1 | 84 | 285 | 368 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CPBDh_UL12, complete genome | blastn | 119267 | 111 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 7832569 | 7832569 | PRJNA1065838_S_NODE_14027_length_221_cov_1248.715116_g13925_i0 | PRJNA1065838 | 14027 | 221 | 1248.715116 | 2759.66040636 | Iltovirus gallidalpha1 | 3050286 | Viruses | Viruses | 111 | 3.19e-20 | NTclustered | gi|2451390879|gb|OQ354887.1| | 10386 | g13925 | i0 | 90.476 | 601.10407239819 | 84 | 8 | 75 | 0 | 138 | 221 | 368 | 285 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CPBDh_UL12, complete genome | blastn | 132844 | 111 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 9107572 | 9107572 | PRJNA1065838_S_NODE_13568_length_223_cov_1203.442529_g13466_i0 | PRJNA1065838 | 13568 | 223 | 1203.442529 | 2683.67683967 | Iltovirus gallidalpha1 | 3050286 | Viruses | Viruses | 111 | 3.22e-20 | NTclustered | gi|2451390879|gb|OQ354887.1| | 10386 | g13466 | i0 | 90.476 | 638.121076233184 | 84 | 8 | 74 | 0 | 1 | 84 | 285 | 368 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CPBDh_UL12, complete genome | blastn | 142301 | 111 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 9107577 | 9107577 | PRJNA1065838_S_NODE_14028_length_221_cov_1225.034884_g13926_i0 | PRJNA1065838 | 14028 | 221 | 1225.034884 | 2707.32709364 | Iltovirus gallidalpha1 | 3050286 | Viruses | Viruses | 111 | 3.19e-20 | NTclustered | gi|2451390879|gb|OQ354887.1| | 10386 | g13926 | i0 | 90.476 | 582.647058823529 | 84 | 8 | 75 | 0 | 1 | 84 | 285 | 368 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CPBDh_UL12, complete genome | blastn | 128765 | 111 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 12933892 | 12933892 | PRJNA1065838_S_NODE_6251_length_297_cov_5340.157258_g6149_i0 | PRJNA1065838 | 6251 | 297 | 5340.157258 | 15860.26705626 | Iltovirus gallidalpha1 | 3050286 | Viruses | Viruses | 159 | 1.58e-34 | NTclustered | gi|2451391033|gb|OQ354889.1| | 10386 | g6149 | i0 | 98.876 | 361.023569023569 | 89 | 1 | 56 | 0 | 1 | 89 | 139686 | 139598 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CUD_1/6th_UL12, complete genome | blastn | 107224 | 159 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 14208839 | 14208839 | PRJNA1065838_S_NODE_5552_length_312_cov_1405.657795_g5450_i0 | PRJNA1065838 | 5552 | 312 | 1405.657795 | 4385.6523204 | Iltovirus gallidalpha1 | 3050286 | Viruses | Viruses | 159 | 1.67e-34 | NTclustered | gi|2451391033|gb|OQ354889.1| | 10386 | g5450 | i0 | 98.876 | 175.621794871795 | 89 | 1 | 29 | 0 | 224 | 312 | 139598 | 139686 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CUD_1/6th_UL12, complete genome | blastn | 54794 | 159 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 14208848 | 14208848 | PRJNA1065838_S_NODE_6852_length_286_cov_9058.582278_g6750_i0 | PRJNA1065838 | 6852 | 286 | 9058.582278 | 25907.54531508 | Iltovirus gallidalpha1 | 3050286 | Viruses | Viruses | 161 | 4.21e-35 | NTclustered | gi|2451391033|gb|OQ354889.1| | 10386 | g6750 | i0 | 98.889 | 462.027972027972 | 90 | 1 | 56 | 0 | 1 | 90 | 139686 | 139597 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CUD_1/6th_UL12, complete genome | blastn | 132140 | 161 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 16757061 | 16757061 | PRJNA1065838_S_NODE_5474_length_314_cov_320.086792_g5372_i0 | PRJNA1065838 | 5474 | 314 | 320.086792 | 1005.07252688 | Iltovirus gallidalpha1 | 3050286 | Viruses | Viruses | 113 | 1.33e-20 | NTclustered | gi|2451390879|gb|OQ354887.1| | 10386 | g5372 | i0 | 89.13 | 177.503184713376 | 92 | 9 | 29 | 1 | 223 | 314 | 139666 | 139756 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CPBDh_UL12, complete genome | blastn | 55736 | 113 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 16757082 | 16757082 | PRJNA1065838_S_NODE_9254_length_254_cov_5.443902_g9152_i0 | PRJNA1065838 | 9254 | 254 | 5.443902 | 13.82751108 | Iltovirus gallidalpha1 | 3050286 | Viruses | Viruses | 76.8 | 1.37e-9 | NTclustered | gi|2451391033|gb|OQ354889.1| | 10386 | g9152 | i0 | 97.727 | 158.165354330709 | 44 | 1 | 17 | 0 | 1 | 44 | 139640 | 139597 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CUD_1/6th_UL12, complete genome | blastn | 40174 | 76.8 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 17590535 | 17590535 | PRJNA1065838_S_NODE_5634_length_310_cov_4259.203065_g5532_i0 | PRJNA1065838 | 5634 | 310 | 4259.203065 | 13203.5295015 | root | 1 | Root_unresolved | Root_unresolved | 113 | 1.31e-20 | NTclustered | gi|2451391033|gb|OQ354889.1| | 10386 | g5532 | i0 | 93.506 | 196.735483870968 | 77 | 3 | 25 | 2 | 1 | 76 | 139671 | 139596 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CUD_1/6th_UL12, complete genome | blastn | 60988 | 113 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 20581230 | 20581230 | PRJNA1065838_S_NODE_4557_length_338_cov_3342.314879_g4455_i0 | PRJNA1065838 | 4557 | 338 | 3342.314879 | 11297.02429102 | Iltovirus gallidalpha1 | 3050286 | Viruses | Viruses | 117 | 1.1200000000000002e-21 | NTclustered | gi|2451391033|gb|OQ354889.1| | 10386 | g4455 | i0 | 93.59 | 166.53550295858 | 78 | 5 | 23 | 0 | 261 | 338 | 139597 | 139674 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CUD_1/6th_UL12, complete genome | blastn | 56289 | 117 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 21856969 | 21856969 | PRJNA1065838_S_NODE_3778_length_365_cov_3672.316456_g3676_i0 | PRJNA1065838 | 3778 | 365 | 3672.316456 | 13403.9550644 | Iltovirus gallidalpha1 | 3050286 | Viruses | Viruses | 115 | 4.3600000000000006e-21 | NTclustered | gi|2451390879|gb|OQ354887.1| | 10386 | g3676 | i0 | 93.506 | 140.271232876712 | 77 | 5 | 21 | 0 | 289 | 365 | 139670 | 139746 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CPBDh_UL12, complete genome | blastn | 51199 | 115 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 21856987 | 21856987 | PRJNA1065838_S_NODE_818_length_625_cov_642.140625_g724_i0 | PRJNA1065838 | 818 | 625 | 642.140625 | 4013.37890625 | Iltovirus gallidalpha1 | 3050286 | Viruses | Viruses | 159 | 3.5499999999999998e-34 | NTclustered | gi|2451391033|gb|OQ354889.1| | 10386 | g724 | i0 | 98.876 | 98.464 | 89 | 1 | 14 | 0 | 537 | 625 | 139598 | 139686 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CUD_1/6th_UL12, complete genome | blastn | 61540 | 159 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 23132260 | 23132260 | PRJNA1065838_S_NODE_14559_length_219_cov_999.441176_g14457_i0 | PRJNA1065838 | 14559 | 219 | 999.441176 | 2188.77617544 | Iltovirus gallidalpha1 | 3050286 | Viruses | Viruses | 111 | 3.15e-20 | NTclustered | gi|2451390879|gb|OQ354887.1| | 10386 | g14457 | i0 | 90.476 | 548.748858447489 | 84 | 8 | 77 | 0 | 1 | 84 | 285 | 368 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CPBDh_UL12, complete genome | blastn | 120176 | 111 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 | ||
| 23132449 | 23132449 | PRJNA1065838_S_NODE_4659_length_335_cov_869.013986_g4557_i0 | PRJNA1065838 | 4659 | 335 | 869.013986 | 2911.1968531 | Iltovirus gallidalpha1 | 3050286 | Viruses | Viruses | 111 | 5.14e-20 | NTclustered | gi|2451390879|gb|OQ354887.1| | 10386 | g4557 | i0 | 90.476 | 373.074626865672 | 84 | 8 | 50 | 0 | 252 | 335 | 368 | 285 | Mutant Gallid alphaherpesvirus 1 isolate CSW-1_CPBDh_UL12, complete genome | blastn | 124980 | 111 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Iltovirus | Iltovirus gallidalpha1 |
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);;