contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1068830" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1457638 | 1457638 | PRJNA1068830_P_NODE_52742_length_301_cov_0.754386_g52039_i0 | PRJNA1068830 | 52742 | 301 | 0.754386 | 2.27070186 | Macrobrachium rosenbergii levi-like virus 1 | 3132580 | Viruses | Viruses | 501 | 2.31e-137 | NTclustered | gi|2697475155|gb|PP215172.1| | 3132580 | g52039 | i0 | 96.678 | 3.33887043189369 | 301 | 10 | 100 | 0 | 1 | 301 | 2266 | 2566 | Macrobrachium rosenbergii levi-like virus 1 isolate 01/JS/201906 glycoprotein, hypothetical protein, and RNA-dependent RNA polymerase genes, complete cds | blastn | 1005 | 501 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Macrobrachium rosenbergii levi-like virus 1 | |||||
| 4009411 | 4009411 | PRJNA1068830_P_NODE_4_length_6313_cov_9.050801_g2_i0 | PRJNA1068830 | 4 | 6313 | 9.050801 | 571.37706713 | Lentinula eaodes hypovirus 2 | 2992848 | Viruses | Viruses | 4324 | 0 | NTclustered | gi|2324991072|gb|OK636212.1| | 2992848 | g2 | i0 | 79.118 | 0.998257563757326 | 6302 | 1290 | 99 | 26 | 23 | 6311 | 8429 | 2141 | Lentinula eaodes hypovirus 2 isolate LED2-8 RNA-dependent RNA polymerase (RdRp) gene, complete cds | blastn | 6302 | 4324 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Hypovirus | Lentinula eaodes hypovirus 2 | ||
| 7834790 | 7834790 | PRJNA1068830_P_NODE_1887_length_1721_cov_2.976335_g1682_i0 | PRJNA1068830 | 1887 | 1721 | 2.976335 | 51.22272535 | Macrobrachium rosenbergii levi-like virus 1 | 3132580 | Viruses | Viruses | 2663 | 0 | NTclustered | gi|2697475155|gb|PP215172.1| | 3132580 | g1682 | i0 | 95.816 | 3.03021499128414 | 1649 | 69 | 96 | 0 | 1 | 1649 | 3418 | 1770 | Macrobrachium rosenbergii levi-like virus 1 isolate 01/JS/201906 glycoprotein, hypothetical protein, and RNA-dependent RNA polymerase genes, complete cds | blastn | 5215 | 2663 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Macrobrachium rosenbergii levi-like virus 1 | |||||
| 7836248 | 7836248 | PRJNA1068830_P_NODE_7_length_6159_cov_12.035491_g4_i0 | PRJNA1068830 | 7 | 6159 | 12.035491 | 741.26589069 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 2824 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g4 | i0 | 95.674 | 0.659360285760675 | 1757 | 72 | 66 | 4 | 4405 | 6159 | 5329 | 7083 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 4061 | 2824 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 7836539 | 7836539 | PRJNA1068830_P_NODE_9127_length_841_cov_3.420573_g8501_i0 | PRJNA1068830 | 9127 | 841 | 3.420573 | 28.76701893 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 1275 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g8501 | i0 | 93.936 | 1 | 841 | 51 | 100 | 0 | 1 | 841 | 6985 | 6145 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 841 | 1275 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 10386556 | 10386556 | PRJNA1068830_P_NODE_63389_length_273_cov_1.000000_g62686_i0 | PRJNA1068830 | 63389 | 273 | 1 | 2.73 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 202 | 2.3499999999999996e-47 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g62686 | i0 | 93.985 | 0.487179487179487 | 133 | 8 | 49 | 0 | 1 | 133 | 5047 | 4915 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 133 | 202 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 12937637 | 12937637 | PRJNA1068830_P_NODE_8551_length_872_cov_2.994994_g7942_i0 | PRJNA1068830 | 8551 | 872 | 2.994994 | 26.11634768 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 1118 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g7942 | i0 | 98.276 | 0.731651376146789 | 638 | 11 | 73 | 0 | 81 | 718 | 639 | 2 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 638 | 1118 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 14211258 | 14211258 | PRJNA1068830_P_NODE_34852_length_381_cov_2.646104_g34149_i0 | PRJNA1068830 | 34852 | 381 | 2.646104 | 10.08165624 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 527 | 4.949999999999999e-145 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g34149 | i0 | 92.432 | 0.971128608923885 | 370 | 26 | 97 | 2 | 13 | 381 | 6107 | 5739 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 370 | 527 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 16760060 | 16760060 | PRJNA1068830_P_NODE_59414_length_282_cov_1.866029_g58711_i0 | PRJNA1068830 | 59414 | 282 | 1.866029 | 5.26220178 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 473 | 4.679999999999999e-129 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g58711 | i0 | 97.153 | 0.99645390070922 | 281 | 6 | 99 | 2 | 3 | 282 | 5401 | 5680 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 281 | 473 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 18035046 | 18035046 | PRJNA1068830_P_NODE_65475_length_268_cov_1.200000_g64772_i0 | PRJNA1068830 | 65475 | 268 | 1.2 | 3.216 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 171 | 6.489999999999999e-38 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g64772 | i0 | 93.103 | 0.43283582089552203 | 116 | 8 | 43 | 0 | 1 | 116 | 1588 | 1703 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 116 | 171 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 20583902 | 20583902 | PRJNA1068830_P_NODE_43677_length_334_cov_8.681992_g42974_i0 | PRJNA1068830 | 43677 | 334 | 8.681992 | 28.99785328 | Macrobrachium rosenbergii levi-like virus 1 | 3132580 | Viruses | Viruses | 479 | 1.2199999999999996e-130 | NTclustered | gi|2697475155|gb|PP215172.1| | 3132580 | g42974 | i0 | 92.749 | 1.58083832335329 | 331 | 24 | 99 | 0 | 4 | 334 | 341 | 11 | Macrobrachium rosenbergii levi-like virus 1 isolate 01/JS/201906 glycoprotein, hypothetical protein, and RNA-dependent RNA polymerase genes, complete cds | blastn | 528 | 479 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Macrobrachium rosenbergii levi-like virus 1 | |||||
| 21859495 | 21859495 | PRJNA1068830_P_NODE_39198_length_356_cov_1.639576_g38495_i0 | PRJNA1068830 | 39198 | 356 | 1.639576 | 5.83689056 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 532 | 9.869999999999998e-147 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g38495 | i0 | 93.785 | 0.99438202247191 | 354 | 22 | 99 | 0 | 3 | 356 | 2185 | 2538 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 354 | 532 | 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);;