contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA1249042" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 354644 | 354644 | PRJNA1249042_S_NODE_75361_length_182_cov_2.258993_g75147_i0 | PRJNA1249042 | 75361 | 182 | 2.258993 | 4.11136726 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g75147 | i0 | 100 | 0.774725274725275 | 29 | 0 | 16 | 0 | 1 | 29 | 13 | 41 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 2905181 | 2905181 | PRJNA1249042_S_NODE_30743_length_240_cov_1.629442_g30529_i0 | PRJNA1249042 | 30743 | 240 | 1.629442 | 3.9106608 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g30529 | i0 | 100 | 0.616666666666667 | 29 | 0 | 12 | 0 | 212 | 240 | 41 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 148 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 2905188 | 2905188 | PRJNA1249042_S_NODE_31883_length_238_cov_1.087179_g31669_i0 | PRJNA1249042 | 31883 | 238 | 1.087179 | 2.58748602 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g31669 | i0 | 100 | 0.239495798319328 | 29 | 0 | 12 | 0 | 210 | 238 | 41 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 4181947 | 4181947 | PRJNA1249042_S_NODE_78904_length_179_cov_1.470588_g78690_i0 | PRJNA1249042 | 78904 | 179 | 1.470588 | 2.63235252 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g78690 | i0 | 100 | 0.787709497206704 | 29 | 0 | 16 | 0 | 151 | 179 | 41 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 5458069 | 5458069 | PRJNA1249042_S_NODE_64125_length_193_cov_3.853333_g63911_i0 | PRJNA1249042 | 64125 | 193 | 3.853333 | 7.43693269 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g63911 | i0 | 100 | 0.295336787564767 | 29 | 0 | 15 | 0 | 165 | 193 | 34 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 8007551 | 8007551 | PRJNA1249042_S_NODE_10707_length_303_cov_5.111538_g10493_i0 | PRJNA1249042 | 10707 | 303 | 5.111538 | 15.48796014 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g10493 | i0 | 100 | 0.188118811881188 | 29 | 0 | 10 | 0 | 275 | 303 | 41 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 10558610 | 10558610 | PRJNA1249042_S_NODE_43569_length_219_cov_1.329545_g43355_i0 | PRJNA1249042 | 43569 | 219 | 1.329545 | 2.91170355 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g43355 | i0 | 100 | 0.26027397260274 | 29 | 0 | 13 | 0 | 191 | 219 | 34 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 14383255 | 14383255 | PRJNA1249042_S_NODE_101192_length_160_cov_3.000000_g100978_i0 | PRJNA1249042 | 101192 | 160 | 3 | 4.8 | Botrytimonavirus botrytidis | 2843870 | Viruses | Viruses | 52.8 | 0.013 | NTclustered | gi|2500379340|ref|NC_076491.1| | 2731253 | g100978 | i0 | 100 | 0.175 | 28 | 0 | 18 | 0 | 63 | 90 | 315 | 342 | Botrytis cinerea negative-stranded RNA virus 7 isolate BCS13_DN1 hypothetical protein (QKO64_gp1), RNA-dependent RNA polymerase (QKO64_gp2), hypothetical protein (QKO64_gp3), and hypothetical protein (QKO64_gp4) genes, complete cds | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Mymonaviridae | Botrytimonavirus | Botrytimonavirus botrytidis | ||
| 16931889 | 16931889 | PRJNA1249042_S_NODE_60194_length_198_cov_1.516129_g59980_i0 | PRJNA1249042 | 60194 | 198 | 1.516129 | 3.00193542 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 52.8 | 0.017 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g59980 | i0 | 100 | 0.141414141414141 | 28 | 0 | 14 | 0 | 1 | 28 | 15 | 42 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 18206267 | 18206267 | PRJNA1249042_S_NODE_46215_length_215_cov_1.982558_g46001_i0 | PRJNA1249042 | 46215 | 215 | 1.982558 | 4.2624997 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g46001 | i0 | 100 | 0.265116279069767 | 29 | 0 | 13 | 0 | 187 | 215 | 41 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 18206484 | 18206484 | PRJNA1249042_S_NODE_74535_length_183_cov_1.700000_g74321_i0 | PRJNA1249042 | 74535 | 183 | 1.7 | 3.111 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g74321 | i0 | 100 | 0.316939890710383 | 30 | 0 | 16 | 0 | 154 | 183 | 42 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 20756139 | 20756139 | PRJNA1249042_S_NODE_54237_length_205_cov_1.358025_g54023_i0 | PRJNA1249042 | 54237 | 205 | 1.358025 | 2.78395125 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g54023 | i0 | 100 | 0.278048780487805 | 29 | 0 | 14 | 0 | 177 | 205 | 41 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 22031183 | 22031183 | PRJNA1249042_S_NODE_36218_length_230_cov_2.192513_g36004_i0 | PRJNA1249042 | 36218 | 230 | 2.192513 | 5.0427799 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g36004 | i0 | 100 | 0.247826086956522 | 29 | 0 | 13 | 0 | 1 | 29 | 13 | 41 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 23306839 | 23306839 | PRJNA1249042_S_NODE_41079_length_222_cov_2.932961_g40865_i0 | PRJNA1249042 | 41079 | 222 | 2.932961 | 6.51117342 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g40865 | i0 | 100 | 0.256756756756757 | 29 | 0 | 13 | 0 | 1 | 29 | 6 | 34 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 24004277 | 24004277 | PRJNA1249042_S_NODE_5179_length_383_cov_10.302941_g4965_i0 | PRJNA1249042 | 5179 | 383 | 10.302941 | 39.46026403 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.01 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g4965 | i0 | 100 | 0.793733681462141 | 29 | 0 | 15 | 0 | 1 | 29 | 13 | 41 | Carnation latent virus isolate KL, complete genome | blastn | 304 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 24580643 | 24580643 | PRJNA1249042_S_NODE_19080_length_267_cov_2.165179_g18866_i0 | PRJNA1249042 | 19080 | 267 | 2.165179 | 5.78102793 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g18866 | i0 | 100 | 0.213483146067416 | 29 | 0 | 11 | 0 | 1 | 29 | 13 | 41 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 24580754 | 24580754 | PRJNA1249042_S_NODE_30760_length_240_cov_1.441624_g30546_i0 | PRJNA1249042 | 30760 | 240 | 1.441624 | 3.4598976 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g30546 | i0 | 100 | 0.2375 | 29 | 0 | 12 | 0 | 212 | 240 | 41 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 24580774 | 24580774 | PRJNA1249042_S_NODE_3320_length_488_cov_11.541573_g3111_i0 | PRJNA1249042 | 3320 | 488 | 11.541573 | 56.32287624 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 647 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g3111 | i0 | 90.852 | 0.985655737704918 | 481 | 42 | 99 | 1 | 1 | 481 | 6630 | 7108 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 481 | 647 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 24581133 | 24581133 | PRJNA1249042_S_NODE_74840_length_183_cov_1.157143_g74626_i0 | PRJNA1249042 | 74840 | 183 | 1.157143 | 2.11757169 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g74626 | i0 | 96.875 | 0.327868852459016 | 32 | 1 | 17 | 0 | 152 | 183 | 44 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 60 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus |
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);;