contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA482207" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6825409 | 6825409 | PRJNA482207_P_NODE_13366_length_297_cov_1.343750_g13256_i0 | PRJNA482207 | 13366 | 297 | 1.34375 | 3.9909375 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 438 | 1.8099999999999998e-118 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g13256 | i0 | 93.266 | 1 | 297 | 20 | 100 | 0 | 1 | 297 | 4073 | 3777 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 297 | 438 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 8100947 | 8100947 | PRJNA482207_P_NODE_14887_length_284_cov_1.791469_g14777_i0 | PRJNA482207 | 14887 | 284 | 1.791469 | 5.08777196 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 475 | 1.3099999999999999e-129 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g14777 | i0 | 96.831 | 1 | 284 | 9 | 100 | 0 | 1 | 284 | 5540 | 5823 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 284 | 475 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 8101295 | 8101295 | PRJNA482207_P_NODE_87_length_2707_cov_3.667426_g77_i0 | PRJNA482207 | 87 | 2707 | 3.667426 | 99.27722182 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 2481 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g77 | i0 | 91.807 | 0.872922053934245 | 1782 | 140 | 87 | 6 | 1 | 1779 | 7107 | 5329 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 2363 | 2481 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 11926815 | 11926815 | PRJNA482207_P_NODE_3430_length_508_cov_1.632184_g3320_i0 | PRJNA482207 | 3430 | 508 | 1.632184 | 8.29149472 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 440 | 9.079999999999996e-119 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g3320 | i0 | 95 | 0.718503937007874 | 280 | 14 | 72 | 0 | 223 | 502 | 5194 | 4915 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 365 | 440 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 13201576 | 13201576 | PRJNA482207_P_NODE_2031_length_644_cov_1.252189_g1933_i0 | PRJNA482207 | 2031 | 644 | 1.252189 | 8.06409716 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 1061 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g1933 | i0 | 96.273 | 1 | 644 | 24 | 100 | 0 | 1 | 644 | 7019 | 6376 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 644 | 1061 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 19573677 | 19573677 | PRJNA482207_P_NODE_16496_length_272_cov_1.402010_g16386_i0 | PRJNA482207 | 16496 | 272 | 1.40201 | 3.8134672 | Zebrafish influenza-like virus | RQ12 | Viruses | Viruses | 401 | 2.1499999999999993e-107 | NTclustered | gi|1912436624|gb|MT926384.1| | RQ12 | g16386 | i0 | 93.358 | 0.996323529411765 | 271 | 18 | 99 | 0 | 1 | 271 | 565 | 835 | Siamese algae-eater influenza-like virus strain SAEILV/fish-T1K hemagglutinin (HA) gene, complete cds | blastn | 271 | 401 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza-like virus | |||
| 23400283 | 23400283 | PRJNA482207_P_NODE_24179_length_247_cov_0.885057_g24069_i0 | PRJNA482207 | 24179 | 247 | 0.885057 | 2.18609079 | Dalbergia cochinchinensis dicistro-like virus 1 | 2872414 | Viruses | Viruses | 398 | 2.4899999999999996e-106 | NTclustered | gi|2261582439|tpg|BK059251.1| | 2872414 | g24069 | i0 | 95.918 | 0.991902834008097 | 245 | 10 | 99 | 0 | 1 | 245 | 1100 | 1344 | TPA_asm: Dalbergia cochinchinensis dicistro-like virus 1 isolate Dc1 non-structural polyprotein gene, complete cds; and structural polyprotein gene, partial cds | blastn | 245 | 398 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dalbergia cochinchinensis dicistro-like virus 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);;