contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA432257" and tax_phylum = "Duplornaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2364342 | 2364342 | PRJNA432257_S_NODE_92022_length_182_cov_73.082759_g91641_i0 | PRJNA432257 | 92022 | 182 | 73.082759 | 133.01062138 | Orbivirus | 10892 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|914339860|gb|KP821033.1| | 35328 | g91641 | i0 | 100 | 8.6043956043956 | 29 | 0 | 16 | 0 | 45 | 73 | 1429 | 1457 | Bluetongue virus 2 isolate SAD2001/03 segment 2, complete sequence | blastn | 1566 | 54.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus caerulinguae | ||
| 2979880 | 2979880 | PRJNA432257_S_NODE_1423_length_865_cov_7.925121_g1317_i0 | PRJNA432257 | 1423 | 865 | 7.925121 | 68.55229665 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 1448 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g1317 | i0 | 98.079 | 0.963005780346821 | 833 | 14 | 96 | 2 | 3 | 834 | 2641 | 1810 | Malassezia restricta virus MrV40L, complete genome | blastn | 833 | 1448 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 5533608 | 5533608 | PRJNA432257_S_NODE_59545_length_216_cov_114.217877_g59164_i0 | PRJNA432257 | 59545 | 216 | 114.217877 | 246.71061432 | Rotavirus alphagastroenteritidis | 3432193 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|2314496612|gb|ON791960.1| | 28875 | g59164 | i0 | 100 | 13.5833333333333 | 30 | 0 | 14 | 0 | 153 | 182 | 1010 | 1039 | Rotavirus A strain RVA/Human-wt/MWI/CHX11U/2019/G3P[8] NSP3 gene, complete cds | blastn | 2934 | 56.5 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Rotavirus | Rotavirus alphagastroenteritidis | ||
| 6808048 | 6808048 | PRJNA432257_S_NODE_95926_length_179_cov_90.654930_g95545_i0 | PRJNA432257 | 95926 | 179 | 90.65493 | 162.2723247 | Rotavirus alphagastroenteritidis | 3432193 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|2314496612|gb|ON791960.1| | 28875 | g95545 | i0 | 100 | 16.391061452514 | 30 | 0 | 17 | 0 | 35 | 64 | 1039 | 1010 | Rotavirus A strain RVA/Human-wt/MWI/CHX11U/2019/G3P[8] NSP3 gene, complete cds | blastn | 2934 | 56.5 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Rotavirus | Rotavirus alphagastroenteritidis | ||
| 8083200 | 8083200 | PRJNA432257_S_NODE_57887_length_219_cov_1.170330_g57506_i0 | PRJNA432257 | 57887 | 219 | 1.17033 | 2.5630227 | Coltivirus dermacentoris | 3428066 | Viruses | Viruses | 254 | 4.95e-63 | NTclustered | gi|2758887253|gb|PP473574.1| | 46839 | g57506 | i0 | 90.674 | 4.37899543378995 | 193 | 15 | 88 | 3 | 15 | 206 | 4718 | 4528 | MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence | blastn | 959 | 254 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Coltivirus | Coltivirus dermacentoris | ||
| 10634229 | 10634229 | PRJNA432257_S_NODE_94589_length_180_cov_100.741259_g94208_i0 | PRJNA432257 | 94589 | 180 | 100.741259 | 181.3342662 | Rotavirus alphagastroenteritidis | 3432193 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|2314496612|gb|ON791960.1| | 28875 | g94208 | i0 | 100 | 16.3 | 30 | 0 | 17 | 0 | 35 | 64 | 1039 | 1010 | Rotavirus A strain RVA/Human-wt/MWI/CHX11U/2019/G3P[8] NSP3 gene, complete cds | blastn | 2934 | 56.5 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Rotavirus | Rotavirus alphagastroenteritidis | ||
| 14459086 | 14459086 | PRJNA432257_S_NODE_85872_length_187_cov_146.646667_g85491_i0 | PRJNA432257 | 85872 | 187 | 146.646667 | 274.22926729 | Rotavirus alphagastroenteritidis | 3432193 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|2314496612|gb|ON791960.1| | 28875 | g85491 | i0 | 100 | 15.6898395721925 | 30 | 0 | 16 | 0 | 124 | 153 | 1010 | 1039 | Rotavirus A strain RVA/Human-wt/MWI/CHX11U/2019/G3P[8] NSP3 gene, complete cds | blastn | 2934 | 56.5 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Rotavirus | Rotavirus alphagastroenteritidis | ||
| 15732854 | 15732854 | PRJNA432257_S_NODE_85793_length_187_cov_277.266667_g85412_i0 | PRJNA432257 | 85793 | 187 | 277.266667 | 518.48866729 | Rotavirus alphagastroenteritidis | 3432193 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|2314496612|gb|ON791960.1| | 28875 | g85412 | i0 | 100 | 15.6898395721925 | 30 | 0 | 16 | 0 | 124 | 153 | 1010 | 1039 | Rotavirus A strain RVA/Human-wt/MWI/CHX11U/2019/G3P[8] NSP3 gene, complete cds | blastn | 2934 | 56.5 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Rotavirus | Rotavirus alphagastroenteritidis | ||
| 19555905 | 19555905 | PRJNA432257_S_NODE_67216_length_206_cov_149.609467_g66835_i0 | PRJNA432257 | 67216 | 206 | 149.609467 | 308.19550202 | Rotavirus alphagastroenteritidis | 3432193 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|2314496612|gb|ON791960.1| | 28875 | g66835 | i0 | 100 | 14.2427184466019 | 30 | 0 | 15 | 0 | 143 | 172 | 1010 | 1039 | Rotavirus A strain RVA/Human-wt/MWI/CHX11U/2019/G3P[8] NSP3 gene, complete cds | blastn | 2934 | 56.5 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Rotavirus | Rotavirus alphagastroenteritidis | ||
| 20832057 | 20832057 | PRJNA432257_S_NODE_99537_length_176_cov_301.935252_g99156_i0 | PRJNA432257 | 99537 | 176 | 301.935252 | 531.40604352 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 237 | 3.82e-58 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g99156 | i0 | 97.81 | 0.778409090909091 | 137 | 3 | 78 | 0 | 3 | 139 | 2641 | 2505 | Malassezia restricta virus MrV40L, complete genome | blastn | 137 | 237 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 24655898 | 24655898 | PRJNA432257_S_NODE_34800_length_264_cov_214.277533_g34419_i0 | PRJNA432257 | 34800 | 264 | 214.277533 | 565.69268712 | Rotavirus alphagastroenteritidis | 3432193 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2314496612|gb|ON791960.1| | 28875 | g34419 | i0 | 100 | 11.1136363636364 | 30 | 0 | 11 | 0 | 35 | 64 | 1039 | 1010 | Rotavirus A strain RVA/Human-wt/MWI/CHX11U/2019/G3P[8] NSP3 gene, complete cds | blastn | 2934 | 56.5 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Rotavirus | Rotavirus alphagastroenteritidis |
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);;