contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA642647" and tax_phylum = "Kitrinoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3168823 | 3168823 | PRJNA642647_P_NODE_3_length_4370_cov_44.282022_g2_i0 | PRJNA642647 | 3 | 4370 | 44.282022 | 1935.1243614 | Tolivirales sp. | 2809914 | Viruses | Viruses | 6841 | 0 | NTclustered | gi|2647549457|gb|OR843652.1| | 2809914 | g2 | i0 | 95.136 | 1.38443935926773 | 4338 | 210 | 99 | 1 | 18 | 4354 | 1 | 4338 | Tolivirales sp. strain MR233-17E/2125 polyprotein, tombus P33-like protein, and structural protein genes, complete cds | blastn | 6050 | 6841 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 4445678 | 4445678 | PRJNA642647_P_NODE_3744_length_184_cov_5.653061_g3694_i0 | PRJNA642647 | 3744 | 184 | 5.653061 | 10.40163224 | Qianjiang tombus-like virus 183 | 3347850 | Viruses | Viruses | 63.9 | 7.25e-6 | NTclustered | gi|2806501255|gb|PQ054305.1| | 3347850 | g3694 | i0 | 91.304 | 0.25 | 46 | 4 | 25 | 0 | 113 | 158 | 3535 | 3580 | MAG: Qianjiang tombus-like virus 183 isolate QJ3DG70 genomic sequence | blastn | 46 | 63.9 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Qianjiang tombus-like virus 183 | |||
| 4986918 | 4986918 | PRJNA642647_P_NODE_5244_length_166_cov_1.186047_g5194_i0 | PRJNA642647 | 5244 | 166 | 1.186047 | 1.96883802 | Orthornavirae | 2732396 | Viruses | Viruses | 244 | 2.1399999999999998e-60 | NTclustered | gi|2171145510|gb|MZ218417.1| | 1955165 | g5194 | i0 | 93.333 | 3.97590361445783 | 165 | 11 | 99 | 0 | 2 | 166 | 1611 | 1775 | MAG: Luteoviridae sp. isolate 375R-k141_269975 genomic sequence | blastn | 660 | 244 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Luteoviridae sp. | ||||
| 8271253 | 8271253 | PRJNA642647_P_NODE_2187_length_232_cov_4.030769_g2137_i0 | PRJNA642647 | 2187 | 232 | 4.030769 | 9.35138408 | Qianjiang tombus-like virus 89 | 3348160 | Viruses | Viruses | 147 | 9.25e-31 | NTclustered | gi|2806500896|gb|PQ054208.1| | 3348160 | g2137 | i0 | 79.327 | 0.896551724137931 | 208 | 43 | 90 | 0 | 21 | 228 | 2987 | 3194 | MAG: Qianjiang tombus-like virus 89 isolate QJ3DG3301 genomic sequence | blastn | 208 | 147 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Qianjiang tombus-like virus 89 | |||
| 9546567 | 9546567 | PRJNA642647_P_NODE_2868_length_206_cov_2.065089_g2818_i0 | PRJNA642647 | 2868 | 206 | 2.065089 | 4.25408334 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 353 | 4.41e-93 | NTclustered | gi|1240393781|gb|MF141070.1| | 2034334 | g2818 | i0 | 98.03 | 1.91747572815534 | 203 | 4 | 99 | 0 | 1 | 203 | 4953 | 4751 | Norway luteo-like virus 4 isolate NOR/B1V/Tofte/2014 RNA-dependent RNA-polymerase and coat protein genes, complete cds | blastn | 395 | 353 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 9546577 | 9546577 | PRJNA642647_P_NODE_3548_length_188_cov_2.602649_g3498_i0 | PRJNA642647 | 3548 | 188 | 2.602649 | 4.89298012 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 159 | 9.229999999999999e-35 | NTclustered | gi|1240393781|gb|MF141070.1| | 2034334 | g3498 | i0 | 82.796 | 2.17021276595745 | 186 | 25 | 97 | 5 | 6 | 187 | 4654 | 4472 | Norway luteo-like virus 4 isolate NOR/B1V/Tofte/2014 RNA-dependent RNA-polymerase and coat protein genes, complete cds | blastn | 408 | 159 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 9546580 | 9546580 | PRJNA642647_P_NODE_3728_length_185_cov_1.466216_g3678_i0 | PRJNA642647 | 3728 | 185 | 1.466216 | 2.7124996 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 337 | 3.89e-88 | NTclustered | gi|1240393781|gb|MF141070.1| | 2034334 | g3678 | i0 | 100 | 3.93513513513514 | 182 | 0 | 98 | 0 | 4 | 185 | 2341 | 2522 | Norway luteo-like virus 4 isolate NOR/B1V/Tofte/2014 RNA-dependent RNA-polymerase and coat protein genes, complete cds | blastn | 728 | 337 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 10822251 | 10822251 | PRJNA642647_P_NODE_909_length_372_cov_1.946269_g859_i0 | PRJNA642647 | 909 | 372 | 1.946269 | 7.24012068 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 638 | 2.1399999999999997e-178 | NTclustered | gi|1240393781|gb|MF141070.1| | 2034334 | g859 | i0 | 97.832 | 3.53225806451613 | 369 | 8 | 99 | 0 | 1 | 369 | 3590 | 3222 | Norway luteo-like virus 4 isolate NOR/B1V/Tofte/2014 RNA-dependent RNA-polymerase and coat protein genes, complete cds | blastn | 1314 | 638 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 11361978 | 11361978 | PRJNA642647_P_NODE_729_length_416_cov_8.839050_g679_i0 | PRJNA642647 | 729 | 416 | 8.83905 | 36.770448 | Viruses | 10239 | Viruses | Viruses | 102 | 3.92e-17 | NTclustered | gi|2647550202|gb|OR843855.1| | 2809914 | g679 | i0 | 96.721 | 2.63461538461538 | 61 | 2 | 15 | 0 | 182 | 242 | 2486 | 2426 | Tolivirales sp. strain MR233-17E/13238 polyprotein and hypothetical protein genes, partial cds; and structural protein gene, complete cds | blastn | 1096 | 102 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 12097389 | 12097389 | PRJNA642647_P_NODE_1150_length_330_cov_2.003413_g1100_i0 | PRJNA642647 | 1150 | 330 | 2.003413 | 6.6112629 | Qianjiang tombus-like virus 183 | 3347850 | Viruses | Viruses | 115 | 3.91e-21 | NTclustered | gi|2806501255|gb|PQ054305.1| | 3347850 | g1100 | i0 | 79.769 | 2.71515151515152 | 173 | 23 | 50 | 9 | 51 | 216 | 1846 | 1679 | MAG: Qianjiang tombus-like virus 183 isolate QJ3DG70 genomic sequence | blastn | 896 | 115 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Qianjiang tombus-like virus 183 | |||
| 12637752 | 12637752 | PRJNA642647_P_NODE_770_length_401_cov_2.524725_g720_i0 | PRJNA642647 | 770 | 401 | 2.524725 | 10.12414725 | Viruses | 10239 | Viruses | Viruses | 693 | 0 | NTclustered | gi|2626076121|gb|OQ986806.1| | 3067845 | g720 | i0 | 99.735 | 2.82793017456359 | 378 | 1 | 94 | 0 | 21 | 398 | 506 | 129 | MAG: Mite nodavirus isolate MESO genomic sequence | blastn | 1134 | 693 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodaviridae | Mite nodavirus | |||
| 14646939 | 14646939 | PRJNA642647_P_NODE_732_length_416_cov_3.825858_g682_i0 | PRJNA642647 | 732 | 416 | 3.825858 | 15.91556928 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 708 | 0 | NTclustered | gi|1240393784|gb|MF141071.1| | 2034334 | g682 | i0 | 97.585 | 3.98076923076923 | 414 | 8 | 99 | 2 | 3 | 415 | 1873 | 2285 | Norway luteo-like virus 4 isolate NOR/S5/Kilen/2014 RNA-dependent RNA-polymerase gene, partial cds | blastn | 1656 | 708 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 17195944 | 17195944 | PRJNA642647_P_NODE_4354_length_173_cov_4.183824_g4304_i0 | PRJNA642647 | 4354 | 173 | 4.183824 | 7.23801552 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 311 | 2.17e-80 | NTclustered | gi|1240393781|gb|MF141070.1| | 2034334 | g4304 | i0 | 100 | 1.94219653179191 | 168 | 0 | 97 | 0 | 4 | 171 | 61 | 228 | Norway luteo-like virus 4 isolate NOR/B1V/Tofte/2014 RNA-dependent RNA-polymerase and coat protein genes, complete cds | blastn | 336 | 311 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 18470258 | 18470258 | PRJNA642647_P_NODE_615_length_455_cov_2.358852_g566_i0 | PRJNA642647 | 615 | 455 | 2.358852 | 10.7327766 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 758 | 0 | NTclustered | gi|1240393781|gb|MF141070.1| | 2034334 | g566 | i0 | 96.903 | 3.94725274725275 | 452 | 14 | 99 | 0 | 4 | 455 | 2738 | 3189 | Norway luteo-like virus 4 isolate NOR/B1V/Tofte/2014 RNA-dependent RNA-polymerase and coat protein genes, complete cds | blastn | 1796 | 758 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 19744849 | 19744849 | PRJNA642647_P_NODE_3476_length_190_cov_1.496732_g3426_i0 | PRJNA642647 | 3476 | 190 | 1.496732 | 2.8437908 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 340 | 3.1099999999999993e-89 | NTclustered | gi|1240393781|gb|MF141070.1| | 2034334 | g3426 | i0 | 99.465 | 2.95263157894737 | 187 | 1 | 98 | 0 | 2 | 188 | 2757 | 2571 | Norway luteo-like virus 4 isolate NOR/B1V/Tofte/2014 RNA-dependent RNA-polymerase and coat protein genes, complete cds | blastn | 561 | 340 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 21020368 | 21020368 | PRJNA642647_P_NODE_2097_length_238_cov_2.243781_g2047_i0 | PRJNA642647 | 2097 | 238 | 2.243781 | 5.34019878 | Qianjiang tombus-like virus 183 | 3347850 | Viruses | Viruses | 165 | 2.63e-36 | NTclustered | gi|2806501255|gb|PQ054305.1| | 3347850 | g2047 | i0 | 86.667 | 0.630252100840336 | 150 | 19 | 63 | 1 | 87 | 235 | 618 | 469 | MAG: Qianjiang tombus-like virus 183 isolate QJ3DG70 genomic sequence | blastn | 150 | 165 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Qianjiang tombus-like virus 183 | |||
| 22295071 | 22295071 | PRJNA642647_P_NODE_3118_length_199_cov_1.746914_g3068_i0 | PRJNA642647 | 3118 | 199 | 1.746914 | 3.47635886 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 357 | 3.2699999999999996e-94 | NTclustered | gi|1240393784|gb|MF141071.1| | 2034334 | g3068 | i0 | 99.49 | 1.96984924623116 | 196 | 1 | 98 | 0 | 4 | 199 | 257 | 452 | Norway luteo-like virus 4 isolate NOR/S5/Kilen/2014 RNA-dependent RNA-polymerase gene, partial cds | blastn | 392 | 357 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 23570738 | 23570738 | PRJNA642647_P_NODE_619_length_454_cov_2.489209_g570_i0 | PRJNA642647 | 619 | 454 | 2.489209 | 11.30100886 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 830 | 0 | NTclustered | gi|1240393781|gb|MF141070.1| | 2034334 | g570 | i0 | 99.779 | 3.99118942731278 | 452 | 1 | 99 | 0 | 3 | 454 | 726 | 1177 | Norway luteo-like virus 4 isolate NOR/B1V/Tofte/2014 RNA-dependent RNA-polymerase and coat protein genes, complete cds | blastn | 1812 | 830 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 24844339 | 24844339 | PRJNA642647_P_NODE_5680_length_160_cov_1.243902_g5630_i0 | PRJNA642647 | 5680 | 160 | 1.243902 | 1.9902432 | Flumine tombus-like virus 13 | 2941398 | Viruses | Viruses | 248 | 1.5799999999999998e-61 | NTclustered | gi|2235495262|gb|OM954047.1| | 2941398 | g5630 | i0 | 94.304 | 0.9875 | 158 | 9 | 99 | 0 | 3 | 160 | 935 | 1092 | Flumine tombus-like virus 13 RNA polymerase gene, complete cds | blastn | 158 | 248 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Flumine tombus-like virus 13 |
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);;