contig_metadata
11 rows where 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 | |||
| 27107688 | 27107688 | PRJNA482207_P_NODE_22382_length_248_cov_1.760000_g22272_i0 | PRJNA482207 | 22382 | 248 | 1.76 | 4.3648 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 60.8 | 1.69e-8 | NR | AVM87439.1 | 3063761 | g22272 | i0 | 55.1 | 0.592741935483871 | 49 | 22 | 59.3 | 0 | 147 | 1 | 928 | 976 | AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] | diamond | 147 | 60.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Danio blood picornavirus/Zebrafish picornavirus 2 | ||||
| 28118431 | 28118431 | PRJNA482207_P_NODE_25865_length_245_cov_0.895349_g25755_i0 | PRJNA482207 | 25865 | 245 | 0.895349 | 2.19360505 | Lindangsbacken virus | 2651947 | Viruses | Viruses | 46.2 | 0.00231 | NR | QGA70947.1 | 2651947 | g25755 | i0 | 41.1 | 1.99591836734694 | 56 | 32 | 67.3 | 1 | 45 | 209 | 311 | 366 | QGA70947.1 RNA-dependent RNA polymerase [Lindangsbacken virus] | diamond | 489 | 46.2 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Lindangsbacken virus | ||
| 31814674 | 31814674 | PRJNA482207_P_NODE_10617_length_323_cov_1.232000_g10507_i0 | PRJNA482207 | 10617 | 323 | 1.232 | 3.97936 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 85.9 | 7.23e-17 | NR | UVF58820.1 | 3063761 | g10507 | i0 | 69.4 | 0.575851393188854 | 62 | 17 | 55.7 | 1 | 128 | 307 | 829 | 890 | UVF58820.1 MAG: polyprotein [Asterropteryx spinosa picornavirus] | diamond | 186 | 85.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 32668393 | 32668393 | PRJNA482207_P_NODE_8240_length_352_cov_2.182796_g8130_i0 | PRJNA482207 | 8240 | 352 | 2.182796 | 7.68344192 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 130 | 3.2399999999999996e-32 | NR | AVM87439.1 | 3063761 | g8130 | i0 | 50.8 | 1.05681818181818 | 124 | 54 | 99.7 | 1 | 2 | 352 | 1019 | 1142 | AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] | diamond | 372 | 130 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | 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);;