contig_metadata
14 rows where bioproject = "PRJNA315314" and tax_kingdom = "Bamfordvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4208290 | 4208290 | PRJNA315314_S_NODE_7644_length_291_cov_2896.732824_g7323_i0 | PRJNA315314 | 7644 | 291 | 2896.732824 | 8429.49251784 | Parapoxvirus orf | 3431389 | Viruses | Viruses | 69.4 | 2.68e-7 | NTclustered | gi|2755084565|gb|PP943426.1| | 10258 | g7323 | i0 | 100 | 14.6013745704467 | 37 | 0 | 13 | 0 | 1 | 37 | 121049 | 121085 | Orf virus isolate FX17, partial genome | blastn | 4249 | 69.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 6168042 | 6168042 | PRJNA315314_S_NODE_1125_length_720_cov_1051.157742_g898_i0 | PRJNA315314 | 1125 | 720 | 1051.157742 | 7568.3357424 | Viruses | 10239 | Viruses | Viruses | 69.4 | 7.15e-7 | NTclustered | gi|2755084441|gb|PP943425.1| | 10258 | g898 | i0 | 100 | 6.04027777777778 | 37 | 0 | 5 | 0 | 1 | 37 | 67624 | 67588 | Orf virus isolate FX10, partial genome | blastn | 4349 | 69.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 8034054 | 8034054 | PRJNA315314_S_NODE_20027_length_184_cov_4900.148387_g19706_i0 | PRJNA315314 | 20027 | 184 | 4900.148387 | 9016.27303208 | Parapoxvirus orf | 3431389 | Viruses | Viruses | 69.4 | 1.56e-7 | NTclustered | gi|2755084565|gb|PP943426.1| | 10258 | g19706 | i0 | 97.5 | 23.570652173913 | 40 | 1 | 22 | 0 | 1 | 40 | 121049 | 121088 | Orf virus isolate FX17, partial genome | blastn | 4337 | 69.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 8717842 | 8717842 | PRJNA315314_S_NODE_14907_length_211_cov_4215.175824_g14586_i0 | PRJNA315314 | 14907 | 211 | 4215.175824 | 8894.02098864 | root | 1 | Root_unresolved | Root_unresolved | 69.4 | 1.84e-7 | NTclustered | gi|2755084565|gb|PP943426.1| | 10258 | g14586 | i0 | 100 | 20.1848341232227 | 37 | 0 | 18 | 0 | 175 | 211 | 121085 | 121049 | Orf virus isolate FX17, partial genome | blastn | 4259 | 69.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 8717873 | 8717873 | PRJNA315314_S_NODE_19567_length_186_cov_4598.630573_g19246_i0 | PRJNA315314 | 19567 | 186 | 4598.630573 | 8553.45286578 | Viruses | 10239 | Viruses | Viruses | 71.3 | 4.39e-8 | NTclustered | gi|2755084441|gb|PP943425.1| | 10258 | g19246 | i0 | 97.561 | 22.3494623655914 | 41 | 1 | 22 | 0 | 146 | 186 | 67584 | 67624 | Orf virus isolate FX10, partial genome | blastn | 4157 | 71.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 14409565 | 14409565 | PRJNA315314_S_NODE_13812_length_219_cov_4049.878947_g13491_i0 | PRJNA315314 | 13812 | 219 | 4049.878947 | 8869.2348939300009 | Parapoxvirus orf | 3431389 | Viruses | Viruses | 69.4 | 1.92e-7 | NTclustered | gi|2755084441|gb|PP943425.1| | 10258 | g13491 | i0 | 100 | 19.8401826484018 | 37 | 0 | 17 | 0 | 1 | 37 | 67792 | 67828 | Orf virus isolate FX10, partial genome | blastn | 4345 | 69.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 15093099 | 15093099 | PRJNA315314_S_NODE_6192_length_324_cov_2454.033898_g5871_i0 | PRJNA315314 | 6192 | 324 | 2454.033898 | 7951.06982952 | Viruses | 10239 | Viruses | Viruses | 69.4 | 3.02e-7 | NTclustered | gi|2755084441|gb|PP943425.1| | 10258 | g5871 | i0 | 100 | 12.7469135802469 | 37 | 0 | 11 | 0 | 288 | 324 | 67588 | 67624 | Orf virus isolate FX10, partial genome | blastn | 4130 | 69.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 15093100 | 15093100 | PRJNA315314_S_NODE_6372_length_319_cov_2521.948276_g6051_i0 | PRJNA315314 | 6372 | 319 | 2521.948276 | 8045.01500044 | root | 1 | Root_unresolved | Root_unresolved | 67.6 | 1.07e-6 | NTclustered | gi|2755084441|gb|PP943425.1| | 10258 | g6051 | i0 | 100 | 13.0031347962382 | 36 | 0 | 11 | 0 | 1 | 36 | 67624 | 67589 | Orf virus isolate FX10, partial genome | blastn | 4148 | 67.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 16958279 | 16958279 | PRJNA315314_S_NODE_25474_length_166_cov_2.459854_g25153_i0 | PRJNA315314 | 25474 | 166 | 2.459854 | 4.08335764 | Mimiviridae sp. ChoanoV1 | 2596887 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|1717456131|gb|MK250089.1| | 2596887 | g25153 | i0 | 92.308 | 0.234939759036145 | 39 | 2 | 23 | 1 | 107 | 144 | 68236 | 68198 | Mimiviridae sp. ChoanoV1 genomic sequence | blastn | 39 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Schizomimiviridae | Mimiviridae sp. ChoanoV1 | |||
| 21467144 | 21467144 | PRJNA315314_S_NODE_4037_length_397_cov_2335.980978_g3716_i0 | PRJNA315314 | 4037 | 397 | 2335.980978 | 9273.84448266 | root | 1 | Root_unresolved | Root_unresolved | 69.4 | 3.77e-7 | NTclustered | gi|2755084565|gb|PP943426.1| | 10258 | g3716 | i0 | 100 | 10.9269521410579 | 37 | 0 | 9 | 0 | 1 | 37 | 121049 | 121085 | Orf virus isolate FX17, partial genome | blastn | 4338 | 69.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 23332774 | 23332774 | PRJNA315314_S_NODE_18119_length_193_cov_4686.524390_g17798_i0 | PRJNA315314 | 18119 | 193 | 4686.52439 | 9044.9920727 | Parapoxvirus orf | 3431389 | Viruses | Viruses | 71.3 | 4.59e-8 | NTclustered | gi|2755084565|gb|PP943426.1| | 10258 | g17798 | i0 | 100 | 22.3056994818653 | 38 | 0 | 20 | 0 | 1 | 38 | 121049 | 121086 | Orf virus isolate FX17, partial genome | blastn | 4305 | 71.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 27105778 | 27105778 | PRJNA315314_S_NODE_23602_length_172_cov_1.601399_g23281_i0 | PRJNA315314 | 23602 | 172 | 1.601399 | 2.75440628 | Chlorovirus sp. | 2809302 | Viruses | Viruses | 84.3 | 3.15e-17 | NR | XOK35624.1 | 2809302 | g23281 | i0 | 64.9 | 0.994186046511628 | 57 | 20 | 99.4 | 0 | 172 | 2 | 106 | 162 | XOK35624.1 Oxidoreductase [Chlorovirus sp.] | diamond | 171 | 84.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Chlorovirus | Chlorovirus sp. | ||
| 29537409 | 29537409 | PRJNA315314_S_NODE_27830_length_160_cov_1.557252_g27509_i0 | PRJNA315314 | 27830 | 160 | 1.557252 | 2.4916032 | Tetraselmis virus 1 | 2060617 | Viruses | Viruses | 43.9 | 0.00483 | NR | YP_010783200.1 | 2060617 | g27509 | i0 | 34.3 | 1.25625 | 67 | 25 | 90 | 2 | 16 | 159 | 691 | 757 | YP_010783200.1 glycine rich protein [Tetraselmis virus 1] | diamond | 201 | 43.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Allomimiviridae | Oceanusvirus | Oceanusvirus kaneohense | ||
| 32572322 | 32572322 | PRJNA315314_S_NODE_3219_length_445_cov_3.557692_g2899_i0 | PRJNA315314 | 3219 | 445 | 3.557692 | 15.8317294 | Edafosvirus sp. | 2487765 | Viruses | Viruses | 203 | 2.06e-60 | NR | AYV78014.1 | 2487765 | g2899 | i0 | 64.2 | 3.00674157303371 | 148 | 52 | 99.8 | 1 | 444 | 1 | 234 | 380 | AYV78014.1 MAG: elongation factor 1 alpha long form [Edafosvirus sp.] | diamond | 1338 | 203 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Edafosvirus 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);;