contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJEB81327" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6517788 | 6517788 | PRJEB81327_P_NODE_18026_length_318_cov_2.804082_g17418_i0 | PRJEB81327 | 18026 | 318 | 2.804082 | 8.91698076 | Chrocomolt virus | 3129476 | Viruses | Viruses | 420 | 7.09e-113 | NTclustered | gi|2717317674|gb|PP171924.1| | 3129476 | g17418 | i0 | 96.813 | 29.122641509434 | 251 | 8 | 79 | 0 | 1 | 251 | 4150 | 4400 | MAG: Chrocomolt virus isolate CC1B_k141_48525 genomic sequence | blastn | 9261 | 420 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Chrocomolt virus | ||||
| 7374631 | 7374631 | PRJEB81327_P_NODE_48586_length_250_cov_0.870056_g47978_i0 | PRJEB81327 | 48586 | 250 | 0.870056 | 2.17514 | Orthorubulavirus | 2560195 | Viruses | Viruses | 457 | 4.1099999999999985e-124 | NTclustered | gi|1036558485|gb|KU341108.1| | 149595 | g47978 | i0 | 99.6 | 87.576 | 250 | 1 | 100 | 0 | 1 | 250 | 189 | 438 | Canine parainfluenza virus isolate shelter 1.84 nucleocapsid protein gene, partial cds | blastn | 21894 | 457 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Canine parainfluenza virus | |||
| 11618150 | 11618150 | PRJEB81327_P_NODE_17930_length_319_cov_2.321138_g17322_i0 | PRJEB81327 | 17930 | 319 | 2.321138 | 7.40443022 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 422 | 1.98e-113 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g17322 | i0 | 90.596 | 1 | 319 | 28 | 99 | 2 | 1 | 318 | 6003 | 5686 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 319 | 422 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 12893125 | 12893125 | PRJEB81327_P_NODE_20911_length_303_cov_2.960870_g20303_i0 | PRJEB81327 | 20911 | 303 | 2.96087 | 8.9714361 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 169 | 2.69e-37 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g20303 | i0 | 93.75 | 0.36963696369637 | 112 | 7 | 37 | 0 | 192 | 303 | 3703 | 3814 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 112 | 169 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 12893800 | 12893800 | PRJEB81327_P_NODE_8491_length_476_cov_2.828784_g7883_i0 | PRJEB81327 | 8491 | 476 | 2.828784 | 13.46501184 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 366 | 1.4599999999999993e-96 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g7883 | i0 | 92.549 | 0.535714285714286 | 255 | 19 | 54 | 0 | 1 | 255 | 5169 | 4915 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 255 | 366 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 15442306 | 15442306 | PRJEB81327_P_NODE_33893_length_271_cov_2.156566_g33285_i0 | PRJEB81327 | 33893 | 271 | 2.156566 | 5.84429386 | Chrocagost virus | 3129398 | Viruses | Viruses | 355 | 1.69e-93 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g33285 | i0 | 91.221 | 794.571955719557 | 262 | 22 | 96 | 1 | 4 | 264 | 5862 | 5601 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 215329 | 355 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 16716733 | 16716733 | PRJEB81327_P_NODE_51234_length_248_cov_1.760000_g50626_i0 | PRJEB81327 | 51234 | 248 | 1.76 | 4.3648 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 267 | 7.36e-67 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g50626 | i0 | 91.327 | 0.790322580645161 | 196 | 16 | 79 | 1 | 53 | 248 | 4145 | 3951 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 196 | 267 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 20540922 | 20540922 | PRJEB81327_P_NODE_47897_length_250_cov_1.468927_g47289_i0 | PRJEB81327 | 47897 | 250 | 1.468927 | 3.6723175 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 331 | 2.6e-86 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g47289 | i0 | 90.726 | 0.992 | 248 | 23 | 99 | 0 | 3 | 250 | 4195 | 4442 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 248 | 331 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 23091578 | 23091578 | PRJEB81327_P_NODE_2019_length_1080_cov_4.189672_g1617_i0 | PRJEB81327 | 2019 | 1080 | 4.189672 | 45.2484576 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 1531 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g1617 | i0 | 92.365 | 0.994444444444444 | 1074 | 80 | 99 | 1 | 5 | 1078 | 7108 | 6037 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 1074 | 1531 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 23091970 | 23091970 | PRJEB81327_P_NODE_53319_length_247_cov_1.511494_g52711_i0 | PRJEB81327 | 53319 | 247 | 1.511494 | 3.73339018 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 435 | 1.9e-117 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g52711 | i0 | 98.381 | 3 | 247 | 4 | 100 | 0 | 1 | 247 | 6857 | 7103 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 741 | 435 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 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);;