contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA1095825" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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. | |||
| 2751487 | 2751487 | PRJNA1095825_P_NODE_252103_length_248_cov_1.760000_g249040_i0 | PRJNA1095825 | 252103 | 248 | 1.76 | 4.3648 | Sunflower rust-associated mitovirus 1 | 2761498 | Viruses | Viruses | 433 | 6.86e-117 | NTclustered | gi|1886953899|gb|MT860451.1| | 2761498 | g249040 | i0 | 98.008 | 1.01209677419355 | 251 | 1 | 100 | 2 | 1 | 248 | 19 | 268 | Sunflower rust-associated mitovirus 1 isolate sunflower_SDSU RNA-dependent RNA polymerase gene, partial cds | blastn | 251 | 433 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Sunflower rust-associated mitovirus 1 | ||
| 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. | |||
| 4026871 | 4026871 | PRJNA1095825_P_NODE_195664_length_280_cov_0.821256_g192601_i0 | PRJNA1095825 | 195664 | 280 | 0.821256 | 2.2995168 | Sunflower rust-associated mitovirus 1 | 2761498 | Viruses | Viruses | 453 | 6.05e-123 | NTclustered | gi|1886953899|gb|MT860451.1| | 2761498 | g192601 | i0 | 96.057 | 0.996428571428571 | 279 | 10 | 99 | 1 | 3 | 280 | 1186 | 1464 | Sunflower rust-associated mitovirus 1 isolate sunflower_SDSU RNA-dependent RNA polymerase gene, partial cds | blastn | 279 | 453 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Sunflower rust-associated mitovirus 1 | ||
| 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. | |||
| 7853854 | 7853854 | PRJNA1095825_P_NODE_291907_length_242_cov_0.905325_g288844_i0 | PRJNA1095825 | 291907 | 242 | 0.905325 | 2.1908865 | Pestivirus bovis | 3052619 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|1169640532|emb|LT837585.1| | 11099 | g288844 | i0 | 100 | 0.119834710743802 | 29 | 0 | 12 | 0 | 1 | 29 | 12189 | 12161 | Bovine viral diarrhea virus 1 genome assembly, complete genome: monopartite | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 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 | ||
| 11679708 | 11679708 | PRJNA1095825_P_NODE_280390_length_244_cov_0.871345_g277327_i0 | PRJNA1095825 | 280390 | 244 | 0.871345 | 2.1260818 | Puccinia narnavirus B | 2592749 | Viruses | Viruses | 302 | 1.98e-77 | NTclustered | gi|1722559313|gb|MK231032.1| | 2592749 | g277327 | i0 | 91.031 | 0.913934426229508 | 223 | 20 | 91 | 0 | 22 | 244 | 2265 | 2487 | Puccinia narnavirus B isolate Won, partial genome | blastn | 223 | 302 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Puccinia narnavirus B | |||
| 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. | |||
| 14228868 | 14228868 | PRJNA1095825_P_NODE_186432_length_286_cov_1.474178_g183369_i0 | PRJNA1095825 | 186432 | 286 | 1.474178 | 4.21614908 | Sunflower rust-associated mitovirus 1 | 2761498 | Viruses | Viruses | 479 | 1.02e-130 | NTclustered | gi|1886953899|gb|MT860451.1| | 2761498 | g183369 | i0 | 96.864 | 1.0034965034965 | 287 | 8 | 100 | 1 | 1 | 286 | 444 | 730 | Sunflower rust-associated mitovirus 1 isolate sunflower_SDSU RNA-dependent RNA polymerase gene, partial cds | blastn | 287 | 479 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Sunflower rust-associated mitovirus 1 | ||
| 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. |
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);;