contig_metadata
19 rows where bioproject = "PRJNA495391", tax_phylum = "Kitrinoviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 477289 | 477289 | PRJNA495391_S_NODE_70681_length_150_cov_2.165217_g69629_i0 | PRJNA495391 | 70681 | 150 | 2.165217 | 3.2478255 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 267 | 4.009999999999999e-67 | NTclustered | gi|564614830|gb|KF421939.1| | 12188 | g69629 | i0 | 98.667 | 33.84 | 150 | 2 | 100 | 0 | 1 | 150 | 5248 | 5397 | White clover mosaic virus isolate 05TGP00172 putative RNA replicase, putative triple gene block protein 1, putative triple gene block protein 2, putative triple gene block protein 3, and putative coat protein genes, complete cds | blastn | 5076 | 267 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 1750855 | 1750855 | PRJNA495391_S_NODE_19642_length_271_cov_1.644068_g18590_i0 | PRJNA495391 | 19642 | 271 | 1.644068 | 4.45542428 | Pestivirus bovis | 3052619 | Viruses | Viruses | 451 | 2.0999999999999997e-122 | NTclustered | gi|380719829|gb|JQ071528.1| | 11099 | g18590 | i0 | 96.679 | 99.3579335793358 | 271 | 9 | 100 | 0 | 1 | 271 | 16 | 286 | Bovine viral diarrhea virus 1 strain GS2 polyprotein gene, partial cds | blastn | 26926 | 451 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 1750900 | 1750900 | PRJNA495391_S_NODE_2142_length_949_cov_11.221007_g1285_i0 | PRJNA495391 | 2142 | 949 | 11.221007 | 106.48735643 | Pestivirus brazilense | 3052620 | Viruses | Viruses | 1642 | 0 | NTclustered | gi|2813517649|gb|PQ362002.1| | 381707 | g1285 | i0 | 97.803 | 66.4257112750263 | 956 | 13 | 99 | 4 | 2 | 949 | 1017 | 62 | Bovine viral diarrhea virus 3 isolate HN2009, partial genome | blastn | 63038 | 1642 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus brazilense | ||
| 1751225 | 1751225 | PRJNA495391_S_NODE_33102_length_211_cov_3.125000_g32050_i0 | PRJNA495391 | 33102 | 211 | 3.125 | 6.59375 | Erysiphe necator associated deltaflexivirus 4 | 2743097 | Viruses | Viruses | 390 | 3.459999999999999e-104 | NTclustered | gi|2288523299|gb|ON811606.1| | 2743097 | g32050 | i0 | 100 | 1.51184834123223 | 211 | 0 | 100 | 0 | 1 | 211 | 6837 | 7047 | MAG: Erysiphe necator associated deltaflexivirus 4 isolate TIGMIC_2, complete genome | blastn | 319 | 390 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexivirus | Erysiphe necator associated deltaflexivirus 4 | ||
| 1751329 | 1751329 | PRJNA495391_S_NODE_36982_length_201_cov_1.542169_g35930_i0 | PRJNA495391 | 36982 | 201 | 1.542169 | 3.09975969 | Pestivirus bovis | 3052619 | Viruses | Viruses | 333 | 5.569999999999999e-87 | NTclustered | gi|2440740783|gb|ON411191.1| | 11099 | g35930 | i0 | 96.517 | 22.9800995024876 | 201 | 7 | 100 | 0 | 1 | 201 | 9588 | 9388 | Bovine viral diarrhea virus 1 isolate 21NM-44 polyprotein gene, complete cds | blastn | 4619 | 333 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 8129835 | 8129835 | PRJNA495391_S_NODE_51747_length_172_cov_1.737226_g50695_i0 | PRJNA495391 | 51747 | 172 | 1.737226 | 2.98802872 | Pestivirus bovis | 3052619 | Viruses | Viruses | 278 | 2.19e-70 | NTclustered | gi|586616531|gb|KF896608.1| | 11099 | g50695 | i0 | 95.906 | 95.8662790697674 | 171 | 7 | 99 | 0 | 2 | 172 | 6754 | 6924 | Bovine viral diarrhea virus 1 isolate Bega-like polyprotein gene, complete cds | blastn | 16489 | 278 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 10679312 | 10679312 | PRJNA495391_S_NODE_11089_length_360_cov_5.092308_g10037_i0 | PRJNA495391 | 11089 | 360 | 5.092308 | 18.3323088 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 612 | 1.2499999999999997e-170 | NTclustered | gi|2054359742|gb|MW248353.1| | 12188 | g10037 | i0 | 97.486 | 30.1361111111111 | 358 | 9 | 99 | 0 | 3 | 360 | 5843 | 5486 | White clover mosaic virus isolate DSMZ PV-0310 replication-associated protein (ORF1), triple gene block 1 protein (ORF2), triple gene block 2 protein (ORF3), triple gene block 3 protein (ORF4), and capsid protein (ORF5) genes, complete cds | blastn | 10849 | 612 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 10679912 | 10679912 | PRJNA495391_S_NODE_32829_length_212_cov_2.435028_g31777_i0 | PRJNA495391 | 32829 | 212 | 2.435028 | 5.16225936 | Pestivirus bovis | 3052619 | Viruses | Viruses | 331 | 2.1400000000000006e-86 | NTclustered | gi|2448011657|gb|ON624287.1| | 11099 | g31777 | i0 | 94.811 | 97.3349056603774 | 212 | 11 | 100 | 0 | 1 | 212 | 7146 | 7357 | Bovine viral diarrhea virus 1 isolate 21SD-16 polyprotein gene, complete cds | blastn | 20635 | 331 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 15778400 | 15778400 | PRJNA495391_S_NODE_14333_length_316_cov_2.362989_g13281_i0 | PRJNA495391 | 14333 | 316 | 2.362989 | 7.46704524 | Pestivirus bovis | 3052619 | Viruses | Viruses | 464 | 3.2099999999999996e-126 | NTclustered | gi|2449445617|gb|OQ348280.1| | 11099 | g13281 | i0 | 92.722 | 61.1170886075949 | 316 | 23 | 100 | 0 | 1 | 316 | 8405 | 8720 | MAG: Bovine viral diarrhea virus 1 isolate ASRA5 polyprotein gene, partial cds | blastn | 19313 | 464 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 15779824 | 15779824 | PRJNA495391_S_NODE_68173_length_153_cov_1.144068_g67121_i0 | PRJNA495391 | 68173 | 153 | 1.144068 | 1.75042404 | Pestivirus bovis | 3052619 | Viruses | Viruses | 241 | 2.49e-59 | NTclustered | gi|1831805881|emb|LR760748.1| | 11099 | g67121 | i0 | 95.364 | 34.8496732026144 | 151 | 7 | 99 | 0 | 3 | 153 | 1945 | 1795 | Bovine viral diarrhea virus 1 complete genome gene for viral polyprotein | blastn | 5332 | 241 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 18327845 | 18327845 | PRJNA495391_S_NODE_29595_length_222_cov_2.711230_g28543_i0 | PRJNA495391 | 29595 | 222 | 2.71123 | 6.0189306 | Pestivirus bovis | 3052619 | Viruses | Viruses | 313 | 8.18e-81 | NTclustered | gi|2905035930|gb|PQ782224.1| | 11099 | g28543 | i0 | 91.964 | 28.3513513513514 | 224 | 16 | 100 | 2 | 1 | 222 | 10534 | 10311 | Bovine viral diarrhea virus 1 isolate BVDV-1c-IM-2018, complete genome | blastn | 6294 | 313 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 18328280 | 18328280 | PRJNA495391_S_NODE_46075_length_181_cov_3.095890_g45023_i0 | PRJNA495391 | 46075 | 181 | 3.09589 | 5.6035609 | Pestivirus bovis | 3052619 | Viruses | Viruses | 285 | 1.39e-72 | NTclustered | gi|2429573847|gb|ON098979.1| | 11099 | g45023 | i0 | 95.028 | 82.4585635359116 | 181 | 9 | 100 | 0 | 1 | 181 | 8055 | 8235 | Bovine viral diarrhea virus 1 isolate 21NX-300, complete genome | blastn | 14925 | 285 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 18958738 | 18958738 | PRJNA495391_S_NODE_25755_length_237_cov_3.069307_g24703_i0 | PRJNA495391 | 25755 | 237 | 3.069307 | 7.27425759 | root | 1 | Root_unresolved | Root_unresolved | 383 | 6.64e-102 | NTclustered | gi|1129880669|gb|KX170702.1| | 11099 | g24703 | i0 | 95.781 | 99.4725738396624 | 237 | 10 | 100 | 0 | 1 | 237 | 850 | 614 | Bovine viral diarrhea virus 1 isolate V008 NS5B gene, partial cds | blastn | 23575 | 383 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 20877575 | 20877575 | PRJNA495391_S_NODE_1477_length_1260_cov_4.899592_g713_i0 | PRJNA495391 | 1477 | 1260 | 4.899592 | 61.7348592 | Pestivirus bovis | 3052619 | Viruses | Viruses | 1733 | 0 | NTclustered | gi|2563906172|gb|ON732849.1| | 11099 | g713 | i0 | 91.515 | 80.7150793650794 | 1261 | 104 | 100 | 3 | 1 | 1260 | 10421 | 9163 | Bovine viral diarrhea virus 1 isolate SDJN01, complete genome | blastn | 101701 | 1733 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 20879136 | 20879136 | PRJNA495391_S_NODE_8457_length_416_cov_2.556430_g7406_i0 | PRJNA495391 | 8457 | 416 | 2.55643 | 10.6347488 | Pestivirus bovis | 3052619 | Viruses | Viruses | 625 | 1.8799999999999998e-174 | NTclustered | gi|2563906172|gb|ON732849.1| | 11099 | g7406 | i0 | 93.75 | 44.1129807692308 | 416 | 26 | 100 | 0 | 1 | 416 | 8815 | 8400 | Bovine viral diarrhea virus 1 isolate SDJN01, complete genome | blastn | 18351 | 625 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 22153846 | 22153846 | PRJNA495391_S_NODE_71138_length_150_cov_1.382609_g70086_i0 | PRJNA495391 | 71138 | 150 | 1.382609 | 2.0739135 | Pestivirus bovis | 3052619 | Viruses | Viruses | 265 | 1.44e-66 | NTclustered | gi|2905035930|gb|PQ782224.1| | 11099 | g70086 | i0 | 98.658 | 23.98 | 149 | 2 | 99 | 0 | 1 | 149 | 8664 | 8812 | Bovine viral diarrhea virus 1 isolate BVDV-1c-IM-2018, complete genome | blastn | 3597 | 265 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 23428475 | 23428475 | PRJNA495391_S_NODE_25559_length_238_cov_2.650246_g24507_i0 | PRJNA495391 | 25559 | 238 | 2.650246 | 6.30758548 | Pestivirus bovis | 3052619 | Viruses | Viruses | 348 | 2.4300000000000005e-91 | NTclustered | gi|1831805881|emb|LR760748.1| | 11099 | g24507 | i0 | 92.917 | 51.6554621848739 | 240 | 15 | 100 | 1 | 1 | 238 | 7982 | 7743 | Bovine viral diarrhea virus 1 complete genome gene for viral polyprotein | blastn | 12294 | 348 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 23429602 | 23429602 | PRJNA495391_S_NODE_68039_length_153_cov_1.338983_g66987_i0 | PRJNA495391 | 68039 | 153 | 1.338983 | 2.04864399 | Pestivirus brazilense | 3052620 | Viruses | Viruses | 272 | 8.84e-69 | NTclustered | gi|2813517655|gb|PQ362005.1| | 381707 | g66987 | i0 | 98.693 | 29.9738562091503 | 153 | 2 | 100 | 0 | 1 | 153 | 9630 | 9782 | Bovine viral diarrhea virus 3 isolate HN2247, partial genome | blastn | 4586 | 272 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus brazilense | ||
| 27614230 | 27614230 | PRJNA495391_S_NODE_50364_length_174_cov_2.007194_g49312_i0 | PRJNA495391 | 50364 | 174 | 2.007194 | 3.49251756 | Erysiphe necator associated flexivirus 3 | 2743100 | Viruses | Viruses | 123 | 7.019999999999999e-31 | NR | QKN22675.1 | 2743100 | g49312 | i0 | 96.5 | 0.982758620689655 | 57 | 2 | 98.3 | 0 | 3 | 173 | 1751 | 1807 | QKN22675.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 3] | diamond | 171 | 123 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Erysiphe necator associated flexivirus 3 |
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);;