contig_metadata
17 rows where bioproject = "PRJNA982106", tax_phylum = "Negarnaviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 963636 | 963636 | PRJNA982106_P_NODE_12081_length_307_cov_0.803419_g11841_i0 | PRJNA982106 | 12081 | 307 | 0.803419 | 2.46649633 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 307 | 5.540000000000001e-79 | NTclustered | gi|1418589526|gb|MG663512.1| | 696863 | g11841 | i0 | 84.691 | 1 | 307 | 47 | 100 | 0 | 1 | 307 | 420 | 726 | Sprivivirus cyprinus isolate ADC-SVC2016-5, complete genome | blastn | 307 | 307 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 963763 | 963763 | PRJNA982106_P_NODE_1_length_11072_cov_6838.070097_g0_i0 | PRJNA982106 | 1 | 11072 | 6838.070097 | 757111.12113984 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 17668 | 0 | NTclustered | gi|698945648|gb|KJ513477.1| | 696863 | g0 | i0 | 95.584 | 29.8548591040462 | 11029 | 485 | 99 | 2 | 17 | 11044 | 11029 | 2 | Spring viraemia of carp virus isolate SVCV-265, complete genome | blastn | 330553 | 17668 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 2239290 | 2239290 | PRJNA982106_P_NODE_2_length_10938_cov_6616.600184_g0_i1 | PRJNA982106 | 2 | 10938 | 6616.600184 | 723723.72812592 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 14654 | 0 | NTclustered | gi|93280035|gb|DQ491000.1| | 696863 | g0 | i1 | 95.708 | 29.6337538855367 | 9110 | 387 | 99 | 4 | 17 | 9123 | 10990 | 1882 | Spring viremia of carp virus isolate A2, complete genome | blastn | 324134 | 14654 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 3514590 | 3514590 | PRJNA982106_P_NODE_3_length_9714_cov_3642.659164_g0_i2 | PRJNA982106 | 3 | 9714 | 3642.659164 | 353847.91119096 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 13236 | 0 | NTclustered | gi|93280035|gb|DQ491000.1| | 696863 | g0 | i2 | 95.859 | 30.3640107061972 | 8186 | 336 | 98 | 3 | 1515 | 9698 | 2806 | 10990 | Spring viremia of carp virus isolate A2, complete genome | blastn | 294956 | 13236 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 3514601 | 3514601 | PRJNA982106_P_NODE_463_length_1362_cov_26879.271528_g0_i5 | PRJNA982106 | 463 | 1362 | 26879.271528 | 366095.67821136 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 2204 | 0 | NTclustered | gi|89280756|gb|DQ097384.2| | 696863 | g0 | i5 | 96.477 | 25.0337738619677 | 1334 | 47 | 98 | 0 | 1 | 1334 | 1335 | 2 | Spring viraemia of carp virus isolate A1, complete genome | blastn | 34096 | 2204 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 7341462 | 7341462 | PRJNA982106_P_NODE_146_length_2090_cov_20437.693109_g0_i3 | PRJNA982106 | 146 | 2090 | 20437.693109 | 427147.7859781 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 2761 | 0 | NTclustered | gi|89280756|gb|DQ097384.2| | 696863 | g0 | i3 | 94.417 | 31.7363636363636 | 1809 | 80 | 99 | 9 | 257 | 2062 | 1792 | 2 | Spring viraemia of carp virus isolate A1, complete genome | blastn | 66329 | 2761 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 7649001 | 7649001 | PRJNA982106_P_NODE_16846_length_272_cov_1.683417_g16606_i0 | PRJNA982106 | 16846 | 272 | 1.683417 | 4.57889424 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 222 | 1.8e-53 | NTclustered | gi|1808629704|gb|MT049059.1| | RQ01 | g16606 | i0 | 82.129 | 96.8014705882353 | 263 | 44 | 96 | 3 | 7 | 268 | 344 | 604 | Influenza B virus (B/California/78/2019) segment 7 matrix protein 1 (M1) and BM2 protein (BM2) genes, complete cds | blastn | 26330 | 222 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 12442769 | 12442769 | PRJNA982106_P_NODE_1190_length_820_cov_14578.069612_g0_i6 | PRJNA982106 | 1190 | 820 | 14578.069612 | 119540.1708184 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 1131 | 0 | NTclustered | gi|1418589526|gb|MG663512.1| | 696863 | g0 | i6 | 96.623 | 19.8451219512195 | 681 | 23 | 96 | 0 | 112 | 792 | 682 | 2 | Sprivivirus cyprinus isolate ADC-SVC2016-5, complete genome | blastn | 16273 | 1131 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 20090180 | 20090180 | PRJNA982106_P_NODE_156_length_2038_cov_20723.741476_g0_i4 | PRJNA982106 | 156 | 2038 | 20723.741476 | 422349.85128088 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 3053 | 0 | NTclustered | gi|698945648|gb|KJ513477.1| | 696863 | g0 | i4 | 94.229 | 34.3022571148185 | 2010 | 98 | 99 | 6 | 29 | 2038 | 2 | 1993 | Spring viraemia of carp virus isolate SVCV-265, complete genome | blastn | 69908 | 3053 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 26715377 | 26715377 | PRJNA982106_P_NODE_2961_length_508_cov_1.482759_g2722_i0 | PRJNA982106 | 2961 | 508 | 1.482759 | 7.53241572 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 291 | 2.4099999999999998e-95 | NR | AXG64379.1 | RQ01 | g2722 | i0 | 87.6 | 6.98622047244094 | 169 | 21 | 99.8 | 0 | 2 | 508 | 18 | 186 | AXG64379.1 nucleoprotein, partial [Influenza B virus] | diamond | 3549 | 291 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 28194745 | 28194745 | PRJNA982106_P_NODE_28406_length_244_cov_0.900585_g28166_i0 | PRJNA982106 | 28406 | 244 | 0.900585 | 2.1974274 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 118 | 2.19e-29 | NR | NP_116744.1 | 696863 | g28166 | i0 | 71.6 | 2.98770491803279 | 81 | 23 | 99.6 | 0 | 2 | 244 | 222 | 302 | NP_116744.1 nucleocapsid protein [Sprivivirus cyprinus] | diamond | 729 | 118 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 29205483 | 29205483 | PRJNA982106_P_NODE_24009_length_248_cov_0.880000_g23769_i0 | PRJNA982106 | 24009 | 248 | 0.88 | 2.1824 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 123 | 1.52e-30 | NR | NP_116748.1 | 696863 | g23769 | i0 | 80.5 | 0.991935483870968 | 82 | 16 | 99.2 | 0 | 1 | 246 | 1748 | 1829 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 246 | 123 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 29495453 | 29495453 | PRJNA982106_P_NODE_16850_length_272_cov_1.547739_g16610_i0 | PRJNA982106 | 16850 | 272 | 1.547739 | 4.20985008 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 173 | 2.7799999999999995e-48 | NR | NP_056659.1 | RQ01 | g16610 | i0 | 92.2 | 18.8602941176471 | 90 | 7 | 99.3 | 0 | 3 | 272 | 570 | 659 | NP_056659.1 polymerase PA [Influenza B virus (B/Lee/1940)] | diamond | 5130 | 173 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 29552387 | 29552387 | PRJNA982106_P_NODE_26190_length_246_cov_0.890173_g25950_i0 | PRJNA982106 | 26190 | 246 | 0.890173 | 2.18982558 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 102 | 2.86e-23 | NR | NP_116748.1 | 696863 | g25950 | i0 | 65.4 | 0.98780487804878 | 81 | 28 | 98.8 | 0 | 3 | 245 | 1828 | 1908 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 243 | 102 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 30184263 | 30184263 | PRJNA982106_P_NODE_32272_length_241_cov_0.916667_g32032_i0 | PRJNA982106 | 32272 | 241 | 0.916667 | 2.20916747 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 118 | 7.6e-29 | NR | NP_116748.1 | 696863 | g32032 | i0 | 72.2 | 0.983402489626556 | 79 | 22 | 98.3 | 0 | 3 | 239 | 1825 | 1903 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 237 | 118 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 31131879 | 31131879 | PRJNA982106_P_NODE_31195_length_242_cov_0.911243_g30955_i0 | PRJNA982106 | 31195 | 242 | 0.911243 | 2.20520806 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 118 | 1.4999999999999996e-29 | NR | NP_116744.1 | 696863 | g30955 | i0 | 78.2 | 1.93388429752066 | 78 | 17 | 96.7 | 0 | 2 | 235 | 3 | 80 | NP_116744.1 nucleocapsid protein [Sprivivirus cyprinus] | diamond | 468 | 118 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 31638062 | 31638062 | PRJNA982106_P_NODE_2476_length_552_cov_1.202505_g2238_i0 | PRJNA982106 | 2476 | 552 | 1.202505 | 6.6378276 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 217 | 7.87e-66 | NR | 7XVR_A | RQ01 | g2238 | i0 | 61.7 | 1.98913043478261 | 183 | 70 | 99.5 | 0 | 550 | 2 | 172 | 354 | 7XVR_A Chain A, Neuraminidase [Wuhan spiny eel influenza virus] | diamond | 1098 | 217 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza B-like virus |
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);;