contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1249535" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2907964 | 2907964 | PRJNA1249535_S_NODE_267443_length_270_cov_5.147208_g264060_i0 | PRJNA1249535 | 267443 | 270 | 5.147208 | 13.8974616 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 58.4 | 5.32e-4 | NTclustered | gi|2500384359|ref|NC_077067.1| | 3060017 | g264060 | i0 | 89.362 | 0.174074074074074 | 47 | 4 | 17 | 1 | 185 | 230 | 1008520 | 1008566 | Fadolivirus 1 strain FV1/VV64, partial genome | blastn | 47 | 58.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 6737036 | 6737036 | PRJNA1249535_S_NODE_99026_length_376_cov_3.016502_g95643_i0 | PRJNA1249535 | 99026 | 376 | 3.016502 | 11.34204752 | Catovirus sp. 'naegleriensis' | 3072188 | Viruses | Viruses | 52.8 | 0.036 | NTclustered | gi|2661003910|emb|OZ003748.1| | 3072188 | g95643 | i0 | 100 | 0.074468085106383 | 28 | 0 | 7 | 0 | 233 | 260 | 261172 | 261145 | Catovirus sp. 'naegleriensis' strain 1 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus sp. 'naegleriensis' | ||
| 10561207 | 10561207 | PRJNA1249535_S_NODE_256869_length_276_cov_3.093596_g253486_i0 | PRJNA1249535 | 256869 | 276 | 3.093596 | 8.53832496 | Moumouvirus sp. 'lavasanguinem' | 3138182 | Viruses | Viruses | 52.8 | 0.025 | NTclustered | gi|2733972295|dbj|LC813553.1| | 3138182 | g253486 | i0 | 100 | 0.101449275362319 | 28 | 0 | 10 | 0 | 145 | 172 | 226738 | 226711 | Moumouvirus lavasanguinem DNA, nearly complete genome | blastn | 28 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Moumouvirus | Moumouvirus sp. 'lavasanguinem' | ||
| 14384363 | 14384363 | PRJNA1249535_S_NODE_119752_length_356_cov_39.303887_g116369_i0 | PRJNA1249535 | 119752 | 356 | 39.303887 | 139.92183772 | Betaentomopoxvirus amoorei | 28321 | Viruses | Viruses | 52.8 | 0.034 | NTclustered | gi|9964314|ref|NC_002520.1| | 28321 | g116369 | i0 | 94.286 | 0.098314606741573 | 35 | 1 | 10 | 1 | 109 | 142 | 153475 | 153509 | Amsacta moorei entomopoxvirus 'L', complete genome | blastn | 35 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Betaentomopoxvirus | Betaentomopoxvirus amoorei | ||
| 15658738 | 15658738 | PRJNA1249535_S_NODE_158233_length_330_cov_2.669261_g154850_i0 | PRJNA1249535 | 158233 | 330 | 2.669261 | 8.8085613 | Organic Lake phycodnavirus 1 | 938081 | Viruses | Viruses | 52.8 | 0.031 | NTclustered | gi|322510471|gb|HQ704802.1| | 938081 | g154850 | i0 | 100 | 0.0848484848484849 | 28 | 0 | 8 | 0 | 3 | 30 | 329421 | 329394 | Organic Lake phycodnavirus 1 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Organic Lake phycodnavirus 1 | |||
| 16932254 | 16932254 | PRJNA1249535_S_NODE_101854_length_373_cov_2.553333_g98471_i0 | PRJNA1249535 | 101854 | 373 | 2.553333 | 9.52393209 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 52.8 | 0.035 | NTclustered | gi|1512471659|gb|MK071985.1| | 2487775 | g98471 | i0 | 100 | 0.0750670241286863 | 28 | 0 | 8 | 0 | 50 | 77 | 60260 | 60233 | MAG: Terrestrivirus sp. clone Terrestrivirus_7 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 18209478 | 18209478 | PRJNA1249535_S_NODE_316075_length_244_cov_3.327485_g312692_i0 | PRJNA1249535 | 316075 | 244 | 3.327485 | 8.1190634 | Hokovirus HKV1 | 1977638 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|1174572237|gb|KY684106.1| | 1977638 | g312692 | i0 | 100 | 0.118852459016393 | 29 | 0 | 12 | 0 | 150 | 178 | 5933 | 5905 | Hokovirus HKV1 isolate HKV1 clone Hokovirus_4, sequence | blastn | 29 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hokovirus | Hokovirus HKV1 | ||
| 20178569 | 20178569 | PRJNA1249535_S_NODE_204916_length_303_cov_6.900000_g201533_i0 | PRJNA1249535 | 204916 | 303 | 6.9 | 20.907 | Mimiviridae | 549779 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|371944294|gb|JN885993.1| | 1128135 | g201533 | i0 | 94.286 | 1.05610561056106 | 35 | 2 | 12 | 0 | 209 | 243 | 59155 | 59189 | Megavirus courdo7 isolate Mv13-c7, partial genome | blastn | 320 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Megavirus | Megavirus courdo7 | ||
| 23308047 | 23308047 | PRJNA1249535_S_NODE_149039_length_336_cov_2.117871_g145656_i0 | PRJNA1249535 | 149039 | 336 | 2.117871 | 7.11604656 | Moumouvirus moumou | 1128137 | Viruses | Viruses | 52.8 | 0.032 | NTclustered | gi|441431943|ref|NC_020104.1| | 1269028 | g145656 | i0 | 100 | 0.0833333333333333 | 28 | 0 | 8 | 0 | 90 | 117 | 962447 | 962474 | Acanthamoeba polyphaga moumouvirus, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Moumouvirus | Moumouvirus moumou | ||
| 23308242 | 23308242 | PRJNA1249535_S_NODE_163259_length_327_cov_2.578740_g159876_i0 | PRJNA1249535 | 163259 | 327 | 2.57874 | 8.4324798 | Mimivirus sp. | 2742700 | Viruses | Viruses | 52.8 | 0.031 | NTclustered | gi|2246796486|gb|MT663335.2| | 2742700 | g159876 | i0 | 100 | 0.171253822629969 | 28 | 0 | 9 | 0 | 68 | 95 | 653975 | 653948 | Mimivirus sp. strain daqing, partial genome | blastn | 56 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus | Mimivirus 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);;