contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1113956" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1496677 | 1496677 | PRJNA1113956_P_NODE_18702_length_263_cov_1.621053_g18362_i0 | PRJNA1113956 | 18702 | 263 | 1.621053 | 4.26336939 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 169 | 2.28e-37 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g18362 | i0 | 97 | 0.380228136882129 | 100 | 3 | 38 | 0 | 164 | 263 | 1 | 100 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 100 | 169 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 1496754 | 1496754 | PRJNA1113956_P_NODE_42_length_4383_cov_18.165197_g30_i0 | PRJNA1113956 | 42 | 4383 | 18.165197 | 796.18058451 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 2471 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g30 | i0 | 91.699 | 0.688113164499201 | 1783 | 143 | 69 | 5 | 2 | 1782 | 7108 | 5329 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 3016 | 2471 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 6599992 | 6599992 | PRJNA1113956_P_NODE_11246_length_400_cov_1.798165_g10906_i0 | PRJNA1113956 | 11246 | 400 | 1.798165 | 7.19266 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 189 | 2.8e-43 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g10906 | i0 | 94.309 | 0.3075 | 123 | 7 | 31 | 0 | 1 | 123 | 517 | 639 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 123 | 189 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 12975858 | 12975858 | PRJNA1113956_P_NODE_4151_length_866_cov_1.938209_g3873_i0 | PRJNA1113956 | 4151 | 866 | 1.938209 | 16.78488994 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 377 | 1.2699999999999999e-99 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g3873 | i0 | 92.135 | 0.431870669745958 | 267 | 21 | 43 | 0 | 230 | 496 | 1442 | 1708 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 374 | 377 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 21898809 | 21898809 | PRJNA1113956_P_NODE_13778_length_338_cov_3.192453_g13438_i0 | PRJNA1113956 | 13778 | 338 | 3.192453 | 10.79049114 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 569 | 7.119999999999998e-158 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g13438 | i0 | 97.041 | 1 | 338 | 10 | 100 | 0 | 1 | 338 | 390 | 53 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 338 | 569 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 23174337 | 23174337 | PRJNA1113956_P_NODE_7919_length_533_cov_1.676087_g7585_i0 | PRJNA1113956 | 7919 | 533 | 1.676087 | 8.93354371 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 699 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g7585 | i0 | 95.045 | 0.833020637898687 | 444 | 22 | 83 | 0 | 47 | 490 | 2100 | 2543 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 444 | 699 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 |
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);;