contig_metadata
10 rows where bioproject = "PRJNA492280", tax_kingdom = "Orthornavirae" 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 | |||
| 30361222 | 30361222 | PRJNA492280_P_NODE_16272_length_164_cov_4.149606_g16165_i0 | PRJNA492280 | 16272 | 164 | 4.149606 | 6.80535384 | Erysiphales associated mitovirus 1 | 2719863 | Viruses | Viruses | 44.3 | 0.00368 | NR | QIP68031.1 | 2719863 | g16165 | i0 | 79.2 | 0.439024390243902 | 24 | 5 | 43.9 | 0 | 4 | 75 | 224 | 247 | QIP68031.1 RNA-dependent RNA polymerase [Erysiphales associated mitovirus 1] | diamond | 72 | 44.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Erysiphales associated mitovirus 1 | ||
| 31909718 | 31909718 | PRJNA492280_P_NODE_28477_length_155_cov_4.737288_g28370_i0 | PRJNA492280 | 28477 | 155 | 4.737288 | 7.3427964 | Xiaogan botourmia-like virus 3 | 2970214 | Viruses | Viruses | 52.4 | 4.43e-6 | NR | UUW21033.1 | 2970214 | g28370 | i0 | 87.5 | 0.929032258064516 | 24 | 3 | 46.5 | 0 | 76 | 5 | 189 | 212 | UUW21033.1 MAG: putative RNA-dependent RNA polymerase [Xiaogan botourmia-like virus 3] | diamond | 144 | 52.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Xiaogan botourmia-like virus 3 | |||
| 32668495 | 32668495 | PRJNA492280_P_NODE_18720_length_164_cov_3.551181_g18613_i0 | PRJNA492280 | 18720 | 164 | 3.551181 | 5.82393684 | Leviviridae sp. | 2027243 | Viruses | Viruses | 44.3 | 0.00366 | NR | URG15268.1 | 2027243 | g18613 | i0 | 83.3 | 0.439024390243902 | 24 | 4 | 43.9 | 0 | 91 | 162 | 254 | 277 | URG15268.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 72 | 44.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. |
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);;