contig_metadata
7 rows where bioproject = "PRJNA939369", tax_phylum = "Negarnaviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1256108 | 1256108 | PRJNA939369_S_NODE_661_length_1284_cov_12.716763_g420_i0 | PRJNA939369 | 661 | 1284 | 12.716763 | 163.28323692 | Deltainfluenzavirus | 1511083 | Viruses | Viruses | 2213 | 0 | NTclustered | gi|1328406500|ref|NC_036620.1| | 1511083 | g420 | i0 | 99.669 | 93.0381619937695 | 1210 | 4 | 94 | 0 | 1 | 1210 | 1211 | 2 | Influenza D virus (D/swine/Oklahoma/1334/2011) segment 6 P42 (P42) gene, complete cds | blastn | 119461 | 2224 | 0.995053956834532 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Deltainfluenzavirus | Deltainfluenzavirus | ||
| 3808090 | 3808090 | PRJNA939369_S_NODE_363_length_1768_cov_25.598820_g200_i0 | PRJNA939369 | 363 | 1768 | 25.59882 | 452.5871376 | Deltainfluenzavirus | 1511083 | Viruses | Viruses | 3230 | 0 | NTclustered | gi|2050655392|gb|MZ264975.1| | 1511083 | g200 | i0 | 99.66 | 98.3964932126697 | 1767 | 6 | 99 | 0 | 2 | 1768 | 2 | 1768 | Influenza D virus (D/bovine/Italy/287448/2015) segment 5 nucleocapsid protein (NP) gene, complete cds | blastn | 173965 | 3241 | 0.99660598580685 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Deltainfluenzavirus | Deltainfluenzavirus | ||
| 5084345 | 5084345 | PRJNA939369_S_NODE_1544_length_862_cov_34.152091_g1198_i0 | PRJNA939369 | 1544 | 862 | 34.152091 | 294.39102442 | Deltainfluenzavirus | 1511083 | Viruses | Viruses | 1580 | 0 | NTclustered | gi|1328406502|ref|NC_036621.1| | 1511083 | g1198 | i0 | 99.768 | 99.1786542923434 | 861 | 2 | 99 | 0 | 1 | 861 | 861 | 1 | Influenza D virus (D/swine/Oklahoma/1334/2011) segment 7 nonstructural protein 2 (NS2) and nonstructural protein 1 (NS1) genes, complete cds | blastn | 85492 | 1580 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Deltainfluenzavirus | Deltainfluenzavirus | ||
| 8908891 | 8908891 | PRJNA939369_S_NODE_267_length_2041_cov_12.819614_g130_i0 | PRJNA939369 | 267 | 2041 | 12.819614 | 261.64832174 | Deltainfluenzavirus | 1511083 | Viruses | Viruses | 3716 | 0 | NTclustered | gi|1847502554|gb|MT349585.1| | 1511083 | g130 | i0 | 99.51 | 98.5188633023028 | 2041 | 10 | 100 | 0 | 1 | 2041 | 2041 | 1 | Influenza D virus (D/bovine/Italy/188812-1/2017) hemagglutinin-esterase gene, complete cds | blastn | 201077 | 3718 | 0.999462076385153 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Deltainfluenzavirus | Deltainfluenzavirus | ||
| 14010035 | 14010035 | PRJNA939369_S_NODE_211_length_2346_cov_12.398592_g90_i0 | PRJNA939369 | 211 | 2346 | 12.398592 | 290.87096832 | Deltainfluenzavirus | 1511083 | Viruses | Viruses | 4294 | 0 | NTclustered | gi|1328406492|ref|NC_036616.1| | 1511083 | g90 | i0 | 99.702 | 99.5618073316283 | 2346 | 7 | 100 | 0 | 1 | 2346 | 12 | 2357 | Influenza D virus (D/swine/Oklahoma/1334/2011) segment 1 polymerase PB2 (PB2) gene, complete cds | blastn | 233572 | 4316 | 0.994902687673772 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Deltainfluenzavirus | Deltainfluenzavirus | ||
| 24207627 | 24207627 | PRJNA939369_S_NODE_219_length_2316_cov_13.310299_g94_i0 | PRJNA939369 | 219 | 2316 | 13.310299 | 308.26652484 | Deltainfluenzavirus | 1511083 | Viruses | Viruses | 4261 | 0 | NTclustered | gi|1707337734|gb|MN165245.1| | 1511083 | g94 | i0 | 99.87 | 99.5034542314335 | 2316 | 3 | 100 | 0 | 1 | 2316 | 2322 | 7 | Influenza D virus (D/bovine/Italy/12002-1/2018) segment 2 polymerase PB1 (PB1) gene, complete cds | blastn | 230450 | 4272 | 0.997425093632959 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Deltainfluenzavirus | Deltainfluenzavirus | ||
| 24207631 | 24207631 | PRJNA939369_S_NODE_239_length_2188_cov_13.160757_g109_i0 | PRJNA939369 | 239 | 2188 | 13.160757 | 287.95736316 | Deltainfluenzavirus | 1511083 | Viruses | Viruses | 3988 | 0 | NTclustered | gi|1328406498|ref|NC_036619.1| | 1511083 | g109 | i0 | 99.588 | 98.8423217550274 | 2186 | 9 | 99 | 0 | 3 | 2188 | 2 | 2187 | Influenza D virus (D/swine/Oklahoma/1334/2011) segment 3 polymerase 3 (P3) gene, complete cds | blastn | 216267 | 4026 | 0.990561351217089 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Deltainfluenzavirus | Deltainfluenzavirus |
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);;