contig_metadata
9 rows where bioproject = "PRJNA399711", tax_phylum = "Lenarviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22089917 | 22089917 | PRJNA399711_P_NODE_16718_length_171_cov_3.156716_g16652_i0 | PRJNA399711 | 16718 | 171 | 3.156716 | 5.39798436 | Aspergillus fumigatus botourmiavirus 1 | 2747486 | Viruses | Viruses | 130 | 6.43e-26 | NTclustered | gi|1917123586|dbj|LC553687.1| | 2747486 | g16652 | i0 | 96.203 | 1.83625730994152 | 79 | 3 | 46 | 0 | 1 | 79 | 1383 | 1461 | Aspergillus fumigatus botourmiavirus 1 J-YC-1 genomic RNA, complete genome | blastn | 314 | 130 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Aspergillus fumigatus botourmiavirus 1 | |||
| 25701547 | 25701547 | PRJNA399711_S_NODE_9698_length_349_cov_7.570513_g9556_i0 | PRJNA399711 | 9698 | 349 | 7.570513 | 26.42109037 | Aspergillus fumigatus narnavirus 2 | 2250450 | Viruses | Viruses | 606 | 5.61e-169 | NTclustered | gi|1917123583|dbj|LC553686.1| | 2250450 | g9556 | i0 | 97.994 | 3 | 349 | 7 | 100 | 0 | 1 | 349 | 938 | 1286 | Aspergillus fumigatus narnavirus 2 J-YC-1 genomic RNA, segment 3, complete sequence | blastn | 1047 | 606 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Divipalmivirus | Divipalmivirus aspergilli | ||
| 25760899 | 25760899 | PRJNA399711_S_NODE_24298_length_257_cov_6.804545_g24156_i0 | PRJNA399711 | 24298 | 257 | 6.804545 | 17.48768065 | Botourmiaviridae | 2560063 | Viruses | Viruses | 84.2 | 8.29e-12 | NTclustered | gi|2500381378|ref|NC_076801.1| | 2686545 | g24156 | i0 | 100 | 5.08949416342412 | 45 | 0 | 18 | 0 | 12 | 56 | 2330 | 2286 | Plasmopara viticola lesion associated ourmia-like virus 72 isolate DMG-F_43929 RNA dependent RNA polymerase (QKR77_gp1) gene, complete cds | blastn | 1308 | 84.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Scleroulivirus | Scleroulivirus lambdaplasmoparae | ||
| 25836470 | 25836470 | PRJNA399711_S_NODE_62579_length_183_cov_8.410959_g62437_i0 | PRJNA399711 | 62579 | 183 | 8.410959 | 15.39205497 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 283 | 5.08e-72 | NTclustered | gi|2396039942|gb|ON812989.1| | 2808997 | g62437 | i0 | 97.59 | 1.81420765027322 | 166 | 3 | 91 | 1 | 18 | 183 | 762 | 598 | MAG: Botourmiaviridae sp. isolate TIGMIC_22, complete genome | blastn | 332 | 283 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 25970984 | 25970984 | PRJNA399711_S_NODE_20436_length_273_cov_8.652542_g20294_i0 | PRJNA399711 | 20436 | 273 | 8.652542 | 23.62143966 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 475 | 1.2499999999999999e-129 | NTclustered | gi|2396039942|gb|ON812989.1| | 2808997 | g20294 | i0 | 98.162 | 2 | 272 | 5 | 99 | 0 | 1 | 272 | 376 | 105 | MAG: Botourmiaviridae sp. isolate TIGMIC_22, complete genome | blastn | 546 | 475 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 25972446 | 25972446 | PRJNA399711_S_NODE_55164_length_192_cov_2.987097_g55022_i0 | PRJNA399711 | 55164 | 192 | 2.987097 | 5.73522624 | Chrocarord virus | 3129644 | Viruses | Viruses | 137 | 4.44e-28 | NTclustered | gi|2717318108|gb|PP172092.1| | 3129644 | g55022 | i0 | 95.349 | 136.135416666667 | 86 | 4 | 45 | 0 | 1 | 86 | 4560 | 4475 | MAG: Chrocarord virus isolate CC1C_k141_60244 genomic sequence | blastn | 26138 | 137 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Chrocarord virus | |||||
| 26381479 | 26381479 | PRJNA399711_S_NODE_85239_length_164_cov_3.039370_g85097_i0 | PRJNA399711 | 85239 | 164 | 3.03937 | 4.9845668 | Rhizopus microsporus 23S narnavirus | 2518295 | Viruses | Viruses | 183 | 4.65e-42 | NTclustered | gi|1573349073|gb|MK204625.1| | 2518295 | g85097 | i0 | 89.655 | 0.884146341463415 | 145 | 13 | 88 | 2 | 21 | 164 | 2625 | 2482 | Rhizopus microsporus 23S narnavirus RNA-dependent RNA polymerase gene, partial cds | blastn | 145 | 183 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Rhizopus microsporus 23S narnavirus | |||
| 33037613 | 33037613 | PRJNA399711_S_NODE_99892_length_155_cov_2.254237_g99750_i0 | PRJNA399711 | 99892 | 155 | 2.254237 | 3.49406735 | Yellow silver pine associated narna-like virus 37 | 3067097 | Viruses | Viruses | 42 | 0.0213 | NR | WPR17308.1 | 3067097 | g99750 | i0 | 51.2 | 0.793548387096774 | 41 | 20 | 79.4 | 0 | 5 | 127 | 922 | 962 | WPR17308.1 MAG: RNA-dependent RNA polymerase, partial [Yellow silver pine associated narna-like virus 37] | diamond | 123 | 42 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Yellow silver pine associated narna-like virus 37 | |||
| 33173826 | 33173826 | PRJNA399711_S_NODE_41136_length_213_cov_14.693182_g40994_i0 | PRJNA399711 | 41136 | 213 | 14.693182 | 31.29647766 | Chuzhou Botou tick virus 1 | 2972077 | Viruses | Viruses | 44.3 | 0.00683 | NR | UYL95456.1 | 2972077 | g40994 | i0 | 43.5 | 0.971830985915493 | 69 | 31 | 85.9 | 3 | 208 | 26 | 127 | 195 | UYL95456.1 MAG: hypothetical protein [Chuzhou Botou tick virus 1] | diamond | 207 | 44.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Chuzhou Botou tick virus 1 |
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);;