contig_metadata
14 rows where bioproject = "PRJNA1095825", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2750259 | 2750259 | PRJNA1095825_P_NODE_108583_length_366_cov_1.720137_g105520_i0 | PRJNA1095825 | 108583 | 366 | 1.720137 | 6.29570142 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 263 | 1.47e-65 | NTclustered | gi|2780183578|gb|PP818844.1| | 1530251 | g105520 | i0 | 79.945 | 0.994535519125683 | 364 | 67 | 99 | 5 | 5 | 366 | 6769 | 6410 | Picornaviridae sp. polyprotein and capsid protein genes, complete cds | blastn | 364 | 263 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 4026644 | 4026644 | PRJNA1095825_P_NODE_171124_length_298_cov_2.395556_g168061_i0 | PRJNA1095825 | 171124 | 298 | 2.395556 | 7.13875688 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 285 | 2.51e-72 | NTclustered | gi|2780183578|gb|PP818844.1| | 1530251 | g168061 | i0 | 83.893 | 1 | 298 | 48 | 100 | 0 | 1 | 298 | 3280 | 3577 | Picornaviridae sp. polyprotein and capsid protein genes, complete cds | blastn | 298 | 285 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 6577676 | 6577676 | PRJNA1095825_P_NODE_135406_length_332_cov_1.710425_g132343_i0 | PRJNA1095825 | 135406 | 332 | 1.710425 | 5.678611 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 592 | 1.49e-164 | NTclustered | gi|2209094754|gb|OL472449.1| | 2900464 | g132343 | i0 | 98.795 | 11 | 332 | 4 | 100 | 0 | 1 | 332 | 8991 | 8660 | MAG: Brine shrimp iflavirus 3 isolate NM/94-18 RNA-dependent RNA polymerase gene, complete cds | blastn | 3652 | 592 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 7852678 | 7852678 | PRJNA1095825_P_NODE_160307_length_308_cov_1.310638_g157244_i0 | PRJNA1095825 | 160307 | 308 | 1.310638 | 4.03676504 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 547 | 3.0099999999999987e-151 | NTclustered | gi|2780183578|gb|PP818844.1| | 1530251 | g157244 | i0 | 99.338 | 0.980519480519481 | 302 | 2 | 98 | 0 | 6 | 307 | 1872 | 1571 | Picornaviridae sp. polyprotein and capsid protein genes, complete cds | blastn | 302 | 547 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 9127391 | 9127391 | PRJNA1095825_P_NODE_130688_length_337_cov_2.272727_g127625_i0 | PRJNA1095825 | 130688 | 337 | 2.272727 | 7.65908999 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 54.7 | 0.009 | NTclustered | gi|2557392663|emb|OY660716.1| | 2697049 | g127625 | i0 | 100 | 0.086053412462908 | 29 | 0 | 9 | 0 | 309 | 337 | 25724 | 25752 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 11679930 | 11679930 | PRJNA1095825_P_NODE_30750_length_716_cov_1.945568_g27783_i0 | PRJNA1095825 | 30750 | 716 | 1.945568 | 13.93026688 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 394 | 1.0299999999999999e-104 | NTclustered | gi|2780183578|gb|PP818844.1| | 1530251 | g27783 | i0 | 77.04 | 1.00977653631285 | 723 | 142 | 99 | 22 | 3 | 714 | 7695 | 6986 | Picornaviridae sp. polyprotein and capsid protein genes, complete cds | blastn | 723 | 394 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 16776813 | 16776813 | PRJNA1095825_P_NODE_133254_length_335_cov_1.000000_g130191_i0 | PRJNA1095825 | 133254 | 335 | 1 | 3.35 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2557634435|emb|OY691424.1| | 2697049 | g130191 | i0 | 96.97 | 0.0985074626865672 | 33 | 1 | 10 | 0 | 1 | 33 | 7580 | 7548 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 33 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 18051711 | 18051711 | PRJNA1095825_P_NODE_171455_length_298_cov_1.368889_g168392_i0 | PRJNA1095825 | 171455 | 298 | 1.368889 | 4.07928922 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 529 | 1.0499999999999996e-145 | NTclustered | gi|2209094746|gb|OL472445.1| | 2900464 | g168392 | i0 | 98.658 | 11 | 298 | 4 | 100 | 0 | 1 | 298 | 7350 | 7053 | MAG: Brine shrimp iflavirus 3 isolate KC/14 RNA-dependent RNA polymerase gene, complete cds | blastn | 3278 | 529 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 23152218 | 23152218 | PRJNA1095825_P_NODE_158839_length_309_cov_1.953390_g155776_i0 | PRJNA1095825 | 158839 | 309 | 1.95339 | 6.0359751 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 532 | 8.45e-147 | NTclustered | gi|2780183578|gb|PP818844.1| | 1530251 | g155776 | i0 | 97.735 | 1 | 309 | 7 | 100 | 0 | 1 | 309 | 1254 | 946 | Picornaviridae sp. polyprotein and capsid protein genes, complete cds | blastn | 309 | 532 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 26846391 | 26846391 | PRJNA1095825_P_NODE_44061_length_580_cov_1.366864_g41015_i0 | PRJNA1095825 | 44061 | 580 | 1.366864 | 7.9278112 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 360 | 1.96e-111 | NR | XDJ26655.1 | 1530251 | g41015 | i0 | 86.5 | 0.998275862068966 | 193 | 26 | 99.8 | 0 | 2 | 580 | 1317 | 1509 | XDJ26655.1 polyprotein [Picornaviridae sp.] | diamond | 579 | 360 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 26940962 | 26940962 | PRJNA1095825_P_NODE_40222_length_610_cov_1.713222_g37182_i0 | PRJNA1095825 | 40222 | 610 | 1.713222 | 10.4506542 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 400 | 1.92e-125 | NR | XDJ26655.1 | 1530251 | g37182 | i0 | 97 | 0.998360655737705 | 203 | 6 | 99.8 | 0 | 2 | 610 | 558 | 760 | XDJ26655.1 polyprotein [Picornaviridae sp.] | diamond | 609 | 400 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 28615174 | 28615174 | PRJNA1095825_P_NODE_27807_length_763_cov_2.694203_g24877_i0 | PRJNA1095825 | 27807 | 763 | 2.694203 | 20.55676889 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 520 | 5.089999999999999e-168 | NR | XDJ26655.1 | 1530251 | g24877 | i0 | 97.6 | 0.99475753604194 | 253 | 6 | 99.5 | 0 | 3 | 761 | 1046 | 1298 | XDJ26655.1 polyprotein [Picornaviridae sp.] | diamond | 759 | 520 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 29183603 | 29183603 | PRJNA1095825_P_NODE_20909_length_933_cov_1.745349_g18175_i0 | PRJNA1095825 | 20909 | 933 | 1.745349 | 16.28410617 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 551 | 9.17e-179 | NR | XDJ26655.1 | 1530251 | g18175 | i0 | 86.1 | 0.996784565916399 | 310 | 43 | 99.7 | 0 | 2 | 931 | 1571 | 1880 | XDJ26655.1 polyprotein [Picornaviridae sp.] | diamond | 930 | 551 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 30130449 | 30130449 | PRJNA1095825_P_NODE_150492_length_317_cov_1.262295_g147429_i0 | PRJNA1095825 | 150492 | 317 | 1.262295 | 4.00147515 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 197 | 5.84e-60 | NR | XDJ26656.1 | 1530251 | g147429 | i0 | 88.6 | 0.993690851735016 | 105 | 12 | 99.4 | 0 | 317 | 3 | 50 | 154 | XDJ26656.1 capsid protein [Picornaviridae sp.] | diamond | 315 | 197 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. |
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);;