contig_metadata
7 rows where bioproject = "PRJNA1233465", tax_kingdom = "Shotokuvirae" and tax_phylum = "Cossaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25618120 | 25618120 | PRJNA1233465a_S_NODE_133481_length_205_cov_0.871795_g132207_i0 | PRJNA1233465 | 133481 | 205 | 0.871795 | 1.78717975 | Protoparvovirus | 1506574 | Viruses | Viruses | 187 | 4.6999999999999985e-43 | NTclustered | gi|1464792|gb|U34255.1|HOU34255 | 42843 | g132207 | i0 | 98.131 | 1.04390243902439 | 107 | 2 | 52 | 0 | 1 | 107 | 2447 | 2553 | Hamster parvovirus DNA | blastn | 214 | 187 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Protoparvovirus | Hamster parvovirus | ||
| 25754466 | 25754466 | PRJNA1233465a_S_NODE_152618_length_194_cov_1.227586_g151344_i0 | PRJNA1233465 | 152618 | 194 | 1.227586 | 2.38151684 | Protoparvovirus | 1506574 | Viruses | Viruses | 348 | 1.91e-91 | NTclustered | gi|478347189|gb|KC249524.1| | 35340 | g151344 | i0 | 98.969 | 21 | 194 | 2 | 100 | 0 | 1 | 194 | 1363 | 1556 | Mouse parvovirus 1 isolate UL6 VP2 gene, partial cds | blastn | 4074 | 348 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Protoparvovirus | Protoparvovirus rodent1 | ||
| 26434910 | 26434910 | PRJNA1233465a_S_NODE_203679_length_172_cov_1.243902_g202405_i0 | PRJNA1233465 | 203679 | 172 | 1.243902 | 2.13951144 | Protoparvovirus | 1506574 | Viruses | Viruses | 255 | 1.02e-63 | NTclustered | gi|525325|gb|U12469.1|MPU12469 | 35340 | g202405 | i0 | 93.182 | 11.7325581395349 | 176 | 8 | 100 | 1 | 1 | 172 | 4851 | 4676 | Mouse parvovirus 1 complete genome, nonstructural protein 1 (NS1) gene, complete cds and capsid protein (VP1) gene, complete cds | blastn | 2018 | 257 | 0.992217898832685 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Protoparvovirus | Protoparvovirus rodent1 | ||
| 32916584 | 32916584 | PRJNA1233465f_S_NODE_108809_length_230_cov_3.325967_g106529_i0 | PRJNA1233465 | 108809 | 230 | 3.325967 | 7.6497241 | Emberiza spodocephala ambidensovirus | 2794446 | Viruses | Viruses | 122 | 3.4499999999999996e-30 | NR | QTE04115.1 | 2794446 | g106529 | i0 | 72.4 | 0.991304347826087 | 76 | 21 | 99.1 | 0 | 3 | 230 | 551 | 626 | QTE04115.1 MAG: putative nonstructural protein 1 [Emberiza spodocephala ambidensovirus] | diamond | 228 | 122 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Ambidensovirus | Emberiza spodocephala ambidensovirus | ||
| 33069365 | 33069365 | PRJNA1233465d_S_NODE_35325_length_282_cov_2.364807_g34214_i0 | PRJNA1233465 | 35325 | 282 | 2.364807 | 6.66875574 | Emberiza spodocephala ambidensovirus | 2794446 | Viruses | Viruses | 157 | 8.11e-43 | NR | QTE04115.1 | 2794446 | g34214 | i0 | 75.5 | 1 | 94 | 23 | 100 | 0 | 282 | 1 | 533 | 626 | QTE04115.1 MAG: putative nonstructural protein 1 [Emberiza spodocephala ambidensovirus] | diamond | 282 | 157 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Ambidensovirus | Emberiza spodocephala ambidensovirus | ||
| 33120926 | 33120926 | PRJNA1233465e_S_NODE_109879_length_185_cov_2.889706_g108569_i0 | PRJNA1233465 | 109879 | 185 | 2.889706 | 5.3459561 | Emberiza spodocephala ambidensovirus | 2794446 | Viruses | Viruses | 102 | 1.19e-23 | NR | QTE04115.1 | 2794446 | g108569 | i0 | 76.7 | 0.972972972972973 | 60 | 14 | 97.3 | 0 | 183 | 4 | 547 | 606 | QTE04115.1 MAG: putative nonstructural protein 1 [Emberiza spodocephala ambidensovirus] | diamond | 180 | 102 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Ambidensovirus | Emberiza spodocephala ambidensovirus | ||
| 33173182 | 33173182 | PRJNA1233465f_S_NODE_253032_length_163_cov_2.684211_g250752_i0 | PRJNA1233465 | 253032 | 163 | 2.684211 | 4.37526393 | Phoenicurus auroreus ambidensovirus | 2794456 | Viruses | Viruses | 55.8 | 2.89e-7 | NR | QTZ83142.1 | 2794456 | g250752 | i0 | 79.3 | 0.533742331288344 | 29 | 6 | 53.4 | 0 | 161 | 75 | 673 | 701 | QTZ83142.1 MAG: putative non-structural protein [Phoenicurus auroreus ambidensovirus] | diamond | 87 | 55.8 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Ambidensovirus | Phoenicurus auroreus ambidensovirus |
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);;