contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJEB29441" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26364 | 26364 | PRJEB29441_P_NODE_22101_length_225_cov_1.159091_g21660_i0 | PRJEB29441 | 22101 | 225 | 1.159091 | 2.60795475 | Chemarfal virus 258 | 3063149 | Viruses | Viruses | 394 | 2.89e-105 | NTclustered | gi|2626079799|gb|OR270470.1| | 3063149 | g21660 | i0 | 98.222 | 4 | 225 | 4 | 100 | 0 | 1 | 225 | 1465 | 1241 | MAG: Chemarfal virus 258 isolate ML188 genomic sequence | blastn | 900 | 394 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 258 | ||||
| 1301071 | 1301071 | PRJEB29441_P_NODE_46562_length_161_cov_1.366071_g46121_i0 | PRJEB29441 | 46562 | 161 | 1.366071 | 2.19937431 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 298 | 1.56e-76 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g46121 | i0 | 100 | 1 | 161 | 0 | 100 | 0 | 1 | 161 | 1917 | 2077 | Malassezia restricta virus MrV40L, complete genome | blastn | 161 | 298 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 2576801 | 2576801 | PRJEB29441_P_NODE_8283_length_399_cov_1.477143_g7844_i0 | PRJEB29441 | 8283 | 399 | 1.477143 | 5.89380057 | Chemarfal virus 260 | 3063286 | Viruses | Viruses | 665 | 0 | NTclustered | gi|2626079958|gb|OR270550.1| | 3063286 | g7844 | i0 | 96.97 | 0.992481203007519 | 396 | 12 | 99 | 0 | 1 | 396 | 137 | 532 | MAG: Chemarfal virus 260 isolate ML188 genomic sequence | blastn | 396 | 665 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 260 | ||||
| 3852429 | 3852429 | PRJEB29441_P_NODE_14904_length_283_cov_1.337607_g14463_i0 | PRJEB29441 | 14904 | 283 | 1.337607 | 3.78542781 | Chemarfal virus 258 | 3063149 | Viruses | Viruses | 494 | 3.61e-135 | NTclustered | gi|2626079799|gb|OR270470.1| | 3063149 | g14463 | i0 | 98.227 | 0.996466431095406 | 282 | 5 | 99 | 0 | 2 | 283 | 1852 | 2133 | MAG: Chemarfal virus 258 isolate ML188 genomic sequence | blastn | 282 | 494 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 258 | ||||
| 11504863 | 11504863 | PRJEB29441_P_NODE_43790_length_163_cov_1.631579_g43349_i0 | PRJEB29441 | 43790 | 163 | 1.631579 | 2.65947377 | Seadornavirus kadipiroense | 3241299 | Viruses | Viruses | 302 | 1.22e-77 | NTclustered | gi|2083529915|tpd|BR001722.1| | 104580 | g43349 | i0 | 100 | 2 | 163 | 0 | 100 | 0 | 1 | 163 | 2295 | 2133 | TPA_asm: Kadipiro virus rat/2019/410 gene for VP2 protein, complete cds | blastn | 326 | 302 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Seadornavirus | Seadornavirus kadipiroense | ||
| 12467339 | 12467339 | PRJEB29441_P_NODE_25210_length_210_cov_0.944099_g24769_i0 | PRJEB29441 | 25210 | 210 | 0.944099 | 1.9826079 | Totivirus | 11007 | Viruses | Viruses | 355 | 1.25e-93 | NTclustered | gi|2512878154|emb|OX637980.1| | 3048758 | g24769 | i0 | 97.143 | 2 | 210 | 6 | 100 | 0 | 1 | 210 | 711 | 920 | Malassezia restricta associated totivirus 2 CP gene for capsid protein | blastn | 420 | 355 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 2 | ||
| 17878223 | 17878223 | PRJEB29441_P_NODE_32935_length_182_cov_1.887218_g32494_i0 | PRJEB29441 | 32935 | 182 | 1.887218 | 3.43473676 | Chemarfal virus 258 | 3063149 | Viruses | Viruses | 189 | 1.13e-43 | NTclustered | gi|2626079799|gb|OR270470.1| | 3063149 | g32494 | i0 | 98.148 | 1 | 108 | 2 | 59 | 0 | 1 | 108 | 2108 | 2215 | MAG: Chemarfal virus 258 isolate ML188 genomic sequence | blastn | 182 | 189 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 258 | ||||
| 17878380 | 17878380 | PRJEB29441_P_NODE_42535_length_164_cov_1.478261_g42094_i0 | PRJEB29441 | 42535 | 164 | 1.478261 | 2.42434804 | Chemarfal virus 260 | 3063286 | Viruses | Viruses | 270 | 3.4699999999999992e-68 | NTclustered | gi|2626079958|gb|OR270550.1| | 3063286 | g42094 | i0 | 96.341 | 1 | 164 | 6 | 100 | 0 | 1 | 164 | 694 | 531 | MAG: Chemarfal virus 260 isolate ML188 genomic sequence | blastn | 164 | 270 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 260 | ||||
| 19151911 | 19151911 | PRJEB29441_P_NODE_21516_length_228_cov_1.642458_g21075_i0 | PRJEB29441 | 21516 | 228 | 1.642458 | 3.74480424 | Chemarfal virus 260 | 3063286 | Viruses | Viruses | 361 | 2.97e-95 | NTclustered | gi|2626079958|gb|OR270550.1| | 3063286 | g21075 | i0 | 95.175 | 1 | 228 | 11 | 100 | 0 | 1 | 228 | 1415 | 1188 | MAG: Chemarfal virus 260 isolate ML188 genomic sequence | blastn | 228 | 361 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 260 | ||||
| 24252362 | 24252362 | PRJEB29441_P_NODE_32040_length_185_cov_1.308824_g31599_i0 | PRJEB29441 | 32040 | 185 | 1.308824 | 2.4213244 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 320 | 3.92e-83 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g31599 | i0 | 97.838 | 2 | 185 | 4 | 100 | 0 | 1 | 185 | 604 | 420 | Malassezia restricta virus MrV40L, complete genome | blastn | 370 | 320 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L |
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);;