contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA492280" and tax_phylum = "Lenarviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 452135 | 452135 | PRJNA492280_P_NODE_31521_length_151_cov_3.043860_g31414_i0 | PRJNA492280 | 31521 | 151 | 3.04386 | 4.5962286 | Ripathuj virus | 3131458 | Viruses | Viruses | 84.2 | 4.37e-12 | NTclustered | gi|2717322573|gb|PP173760.1| | 3131458 | g31414 | i0 | 92.982 | 0.814569536423841 | 57 | 4 | 80 | 0 | 76 | 132 | 413 | 469 | MAG: Ripathuj virus isolate RCCP2_k141_221326 genomic sequence | blastn | 123 | 84.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripathuj virus | |||||
| 3002607 | 3002607 | PRJNA492280_P_NODE_14283_length_164_cov_4.897638_g14176_i0 | PRJNA492280 | 14283 | 164 | 4.897638 | 8.03212632 | Erysiphe necator associated ourmia-like virus 87 | 2741867 | Viruses | Viruses | 115 | 1.72e-21 | NTclustered | gi|1848976707|gb|MN611615.1| | 2741867 | g14176 | i0 | 94.595 | 1.3109756097561 | 74 | 4 | 88 | 0 | 89 | 162 | 1702 | 1775 | Erysiphe necator associated ourmia-like virus 87 isolate PMS5_114, complete genome | blastn | 215 | 115 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 87 | ||
| 4279067 | 4279067 | PRJNA492280_P_NODE_27764_length_160_cov_4.715447_g27657_i0 | PRJNA492280 | 27764 | 160 | 4.715447 | 7.5447152 | Erysiphe necator associated ourmia-like virus 41 | 2741821 | Viruses | Viruses | 250 | 4.38e-62 | NTclustered | gi|2396039960|gb|ON812995.1| | 2741821 | g27657 | i0 | 96.078 | 2.775 | 153 | 6 | 96 | 0 | 5 | 157 | 682 | 530 | MAG: Erysiphe necator associated ourmia-like virus 41 isolate TIGMIC_10, complete genome | blastn | 444 | 250 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 41 | ||
| 11930723 | 11930723 | PRJNA492280_P_NODE_4690_length_234_cov_2.329949_g4583_i0 | PRJNA492280 | 4690 | 234 | 2.329949 | 5.45208066 | Erysiphe necator associated ourmia-like virus 41 | 2741821 | Viruses | Viruses | 372 | 1.42e-98 | NTclustered | gi|2396039960|gb|ON812995.1| | 2741821 | g4583 | i0 | 96.104 | 6.0042735042735 | 231 | 4 | 99 | 1 | 3 | 233 | 1980 | 2205 | MAG: Erysiphe necator associated ourmia-like virus 41 isolate TIGMIC_10, complete genome | blastn | 1405 | 372 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 41 | ||
| 15754488 | 15754488 | PRJNA492280_P_NODE_13673_length_164_cov_5.251969_g13566_i0 | PRJNA492280 | 13673 | 164 | 5.251969 | 8.61322916 | Sopafab virus | 3131770 | Viruses | Viruses | 130 | 6.15e-26 | NTclustered | gi|2717323354|gb|PP174071.1| | 3131770 | g13566 | i0 | 98.63 | 28.2560975609756 | 73 | 1 | 45 | 0 | 89 | 161 | 122 | 194 | MAG: Sopafab virus isolate SP1C_k141_220867 genomic sequence | blastn | 4634 | 130 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopafab virus | |||||
| 20853802 | 20853802 | PRJNA492280_P_NODE_7757_length_189_cov_4.414474_g7650_i0 | PRJNA492280 | 7757 | 189 | 4.414474 | 8.34335586 | Penoulivirus alphaerysiphe | 3060537 | Viruses | Viruses | 182 | 1.98e-41 | NTclustered | gi|2500387314|ref|NC_077170.1| | 2741801 | g7650 | i0 | 99.01 | 1.71957671957672 | 101 | 1 | 53 | 0 | 1 | 101 | 1704 | 1604 | Erysiphe necator associated ourmia-like virus 21 isolate RDPM33, complete genome | blastn | 325 | 182 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Penoulivirus | Penoulivirus alphaerysiphe | ||
| 24678028 | 24678028 | PRJNA492280_P_NODE_2520_length_294_cov_9.124514_g2413_i0 | PRJNA492280 | 2520 | 294 | 9.124514 | 26.82607116 | Chrocabarb virus | 3129305 | Viruses | Viruses | 255 | 1.94e-63 | NTclustered | gi|2717317232|gb|PP171753.1| | 3129305 | g2413 | i0 | 92.063 | 85.8605442176871 | 189 | 4 | 76 | 2 | 105 | 292 | 147 | 325 | MAG: Chrocabarb virus isolate CC1A_k141_102991 genomic sequence | blastn | 25243 | 255 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Chrocabarb 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);;