RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA1092581", tax_kingdom = "Orthornavirae" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 11 ✖

tax_kingdom 1

  • Orthornavirae · 11 ✖

bioproject 1

  • PRJNA1092581 · 11 ✖

analysis 1

tax_clade 0

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
1017942 1017942 PRJNA1092581_P_NODE_18361_length_649_cov_16.623264_g17845_i0 PRJNA1092581 18361 649 16.623264 107.88498336 Potyvirus 12195 Viruses Viruses 1186 0   NTclustered gi|2165402893|gb|OK491086.1| 12216 g17845 i0 100 99.5285053929122 642 0 99 0 8 649 9681 9040 Potato virus Y isolate SXQY-4, complete genome blastn 64594 1186 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus yituberosi
3568903 3568903 PRJNA1092581_P_NODE_46103_length_398_cov_11.036923_g45570_i0 PRJNA1092581 46103 398 11.036923 43.92695354 Potyvirus 12195 Viruses Viruses 697 0   NTclustered gi|2582377801|gb|OP179327.1| 12216 g45570 i0 100 94.7286432160804 377 0 95 0 21 397 5463 5839 Potato virus Y isolate GZ 137, complete genome blastn 37702 697 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus yituberosi
4022661 4022661 PRJNA1092581_P_NODE_124044_length_210_cov_2.890511_g123511_i0 PRJNA1092581 124044 210 2.890511 6.0700731 Aphthovirus vesiculae 3426401 Viruses Viruses 56.5 0.001   NTclustered gi|1164579649|dbj|LC149658.1| 12118 g123511 i0 100 14.2857142857143 30 0 14 0 91 120 3526 3497 Foot-and-mouth disease virus - type O gene for polyprotein, complete cds, strain: O/JPN/2010-103/1S blastn 3000 56.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Aphthovirus Aphthovirus vesiculae
7850700 7850700 PRJNA1092581_P_NODE_85827_length_277_cov_3.019608_g85294_i0 PRJNA1092581 85827 277 3.019608 8.36431416 Fusarium poae partitivirus 3 2974658 Viruses Viruses 182 3.12e-41   NTclustered gi|2295827863|gb|OK524191.1| 2974658 g85294 i0 83.756 0.711191335740072 197 27 70 5 25 217 1805 1610 Fusarium poae partitivirus 3 strain F.1189 segment 2, complete sequence blastn 197 182 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Fusarium poae partitivirus 3
12951574 12951574 PRJNA1092581_P_NODE_78291_length_293_cov_2.081818_g77758_i0 PRJNA1092581 78291 293 2.081818 6.09972674 Potyvirus yituberosi 3240642 Viruses Viruses 542 1.32e-149   NTclustered gi|2583174907|gb|OR359626.1| 12216 g77758 i0 100 99.9965870307167 293 0 100 0 1 293 457 165 Potato virus Y isolate PVY-P10 polyprotein gene, partial cds blastn 29299 542 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus yituberosi
19321494 19321494 PRJNA1092581_P_NODE_111996_length_237_cov_2.109756_g111463_i0 PRJNA1092581 111996 237 2.109756 5.00012172 Skokie picorna-like virus 2789431 Viruses Viruses 409 1.1e-109   NTclustered gi|1935607038|gb|MT747994.1| 2789431 g111463 i0 97.881 2.9873417721519 236 5 99 0 2 237 4435 4200 Skokie picorna-like virus strain USAdp-2 polyprotein gene, complete cds blastn 708 409 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Skokie picorna-like virus
20597082 20597082 PRJNA1092581_P_NODE_124077_length_209_cov_43.360294_g123544_i0 PRJNA1092581 124077 209 43.360294 90.62301446 Betacoronavirus pandemicum 3418604 Viruses Viruses 110 1.07e-19   NTclustered gi|2326415437|gb|OP789280.1| 2697049 g123544 i0 98.413 30.1435406698565 63 0 30 1 120 182 28462 28401 Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/OKPHL0020340/2022 ORF1ab polyprotein (ORF1ab) and ORF1a polyprotein (ORF1ab) genes, partial cds; and surface glycoprotein (S), ORF3a protein (ORF3a), envelope protein (E), membrane glycoprotein (M), ORF6 protein (ORF6), ORF7a protein (ORF7a), ORF7b (ORF7b), ORF8 protein (ORF8), nucleocapsid phosphoprotein (N), and ORF10 protein (ORF10) genes, complete cds blastn 6300 110 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
21873937 21873937 PRJNA1092581_P_NODE_49658_length_382_cov_3.097087_g49125_i0 PRJNA1092581 49658 382 3.097087 11.83087234 Astroviridae sp. 2585114 Viruses Viruses 667 0   NTclustered gi|1851856021|gb|MT138002.1| 2585114 g49125 i0 98.168 1 382 7 100 0 1 382 5384 5003 MAG: Astroviridae sp. isolate cra070ast1 genomic sequence, sequence blastn 382 667 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Astroviridae sp.
21874015 21874015 PRJNA1092581_P_NODE_52858_length_368_cov_3.905085_g52325_i0 PRJNA1092581 52858 368 3.905085 14.3707128 Stralarivirus lychnis 3052754 Viruses Viruses 270 8.869999999999999e-68   NTclustered gi|2063685004|gb|MW035176.1| 1676256 g52325 i0 87.712 60.9375 236 23 99 5 135 368 3563 3332 Lychnis mottle virus isolate AR_44 segment RNA2, complete sequence blastn 22425 270 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Stralarivirus Stralarivirus lychnis
23149691 23149691 PRJNA1092581_P_NODE_63699_length_330_cov_11.214008_g63166_i0 PRJNA1092581 63699 330 11.214008 37.0062264 Hansenia oviformis nepovirus 3115769 Viruses Viruses 366 9.77e-97   NTclustered gi|2752247854|tpg|BK065084.1| 3115769 g63166 i0 89.86 3.18181818181818 286 28 86 1 22 306 7575 7860 TPA_asm: Hansenia oviformis nepovirus segment RNA1 polyprotein gene, complete cds blastn 1050 366 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Hansenia oviformis nepovirus
23150204 23150204 PRJNA1092581_P_NODE_83619_length_281_cov_7.899038_g83086_i0 PRJNA1092581 83619 281 7.899038 22.19629678 Betacoronavirus pandemicum 3418604 Viruses Viruses 472 1.6799999999999998e-128   NTclustered gi|2230647867|gb|ON343363.1| 2697049 g83086 i0 99.237 93.2384341637011 262 0 93 1 1 260 29870 29609 Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/CA-CDPH-2000013366/2020, complete genome blastn 26200 472 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;