contig_metadata
6 rows where bioproject = "PRJEB39643" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5159779 | 5159779 | PRJEB39643_P_NODE_13625_length_510_cov_607.228833_g13434_i0 | PRJEB39643 | 13625 | 510 | 607.228833 | 3096.8670483 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 126 | 2.9e-24 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g13434 | i0 | 100 | 3.25490196078431 | 68 | 0 | 33 | 0 | 1 | 68 | 4 | 71 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 1660 | 126 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 | |||
| 8642646 | 8642646 | PRJEB39643_P_NODE_35827_length_311_cov_35.714286_g35634_i0 | PRJEB39643 | 35827 | 311 | 35.714286 | 111.07142946 | root | 1 | Root_unresolved | Root_unresolved | 158 | 5.9899999999999985e-34 | NTclustered | gi|1366793707|gb|MH085239.1| | 11320 | g35634 | i0 | 100 | 36.8231511254019 | 85 | 0 | 38 | 0 | 1 | 85 | 1448 | 1364 | Influenza A virus (A/Puerto Rico/8/1934(H1N1)) clone OP7-4 segment 5 nucleocapsid protein (NP) gene, complete cds | blastn | 11452 | 158 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 10260591 | 10260591 | PRJEB39643_P_NODE_17809_length_433_cov_494.475000_g17616_i0 | PRJEB39643 | 17809 | 433 | 494.475 | 2141.07675 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 126 | 2.4299999999999994e-24 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g17616 | i0 | 100 | 3.22170900692841 | 68 | 0 | 30 | 0 | 210 | 277 | 71 | 4 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 1395 | 126 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 | |||
| 12811541 | 12811541 | PRJEB39643_P_NODE_40371_length_296_cov_1.381166_g40178_i0 | PRJEB39643 | 40371 | 296 | 1.381166 | 4.08825136 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 52.8 | 0.027 | NTclustered | gi|2756424380|gb|PP745982.1| | 3003959 | g40178 | i0 | 100 | 0.0945945945945946 | 28 | 0 | 9 | 0 | 146 | 173 | 1087 | 1060 | MAG: Picornavirales sp. isolate 319_50993 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 18840994 | 18840994 | PRJEB39643_P_NODE_112475_length_255_cov_2.115385_g112282_i0 | PRJEB39643 | 112475 | 255 | 2.115385 | 5.39423175 | root | 1 | Root_unresolved | Root_unresolved | 67.6 | 8.27e-7 | NTclustered | gi|297841|emb|X17218.1| | 12730 | g112282 | i0 | 100 | 11.9764705882353 | 36 | 0 | 14 | 0 | 1 | 36 | 1614 | 1649 | Sendai virus strain Fushimi genomic RNA for nucleocapsid protein (NP) | blastn | 3054 | 67.6 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Respirovirus | Respirovirus laryngotracheitidis | ||
| 24283557 | 24283557 | PRJEB39643_P_NODE_17580_length_436_cov_496.796143_g17387_i0 | PRJEB39643 | 17580 | 436 | 496.796143 | 2166.03118348 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 126 | 2.45e-24 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g17387 | i0 | 100 | 3.17889908256881 | 68 | 0 | 30 | 0 | 213 | 280 | 71 | 4 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 1386 | 126 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 |
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);;