RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA493632", tax_kingdom = "Orthornavirae" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 18 ✖

tax_kingdom 1

  • Orthornavirae · 18 ✖

bioproject 1

  • PRJNA493632 · 18 ✖

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
3016543 3016543 PRJNA493632_P_NODE_539783_length_249_cov_0.875000_g536344_i0 PRJNA493632 539783 249 0.875 2.17875 Potyvirus rapae 3240607 Viruses Viruses 409 1.16e-109   NTclustered gi|51556027|dbj|AB188938.1| 12230 g536344 i0 96.371 99.8152610441767 248 9 99 0 1 248 624 377 Turnip mosaic virus gene for polyprotein, partial cds, isolate: GBR51 blastn 24854 409 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus rapae
6845010 6845010 PRJNA493632_P_NODE_639986_length_242_cov_0.911243_g636545_i0 PRJNA493632 639986 242 0.911243 2.20520806 Qianjiang picorna-like virus 63 3348791 Viruses Viruses 436 5.1499999999999985e-118   NTclustered gi|2806504100|gb|PQ055390.1| 3348791 g636545 i0 99.174 1 242 2 100 0 1 242 3539 3780 MAG: Qianjiang picorna-like virus 63 isolate QJ5DS3176 genomic sequence blastn 242 436 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 63
8114245 8114245 PRJNA493632_P_NODE_292647_length_298_cov_2.791111_g289210_i0 PRJNA493632 292647 298 2.791111 8.31751078 Betacoronavirus pandemicum 3418604 Viruses Viruses 54.7 0.008   NTclustered gi|2155043487|emb|OV016108.1| 2697049 g289210 i0 100 0.0973154362416107 29 0 10 0 1 29 30290 30262 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 29 54.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
8121992 8121992 PRJNA493632_P_NODE_730687_length_200_cov_5.614173_g727244_i0 PRJNA493632 730687 200 5.614173 11.228346 Cripavirus drosophilae 3047809 Viruses Viruses 351 1.53e-92   NTclustered gi|2147549872|gb|MW834587.1| 64279 g727244 i0 98.492 8.95 199 3 99 0 1 199 3354 3552 Drosophila C virus isolate caf replicase polyprotein gene, partial cds; and capsid polyprotein gene, complete cds blastn 1790 351 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus drosophilae
9386032 9386032 PRJNA493632_P_NODE_108_length_7208_cov_26.432095_g20_i0 PRJNA493632 108 7208 26.432095 1905.2254076 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 2477 0   NR WKU61618.1 3063761 g20 i0 63.4 0.92480577136515 2222 787 91.5 4 6687 94 1 2220 WKU61618.1 polyprotein [Zebrafish picornavirus 2] diamond 6666 2477 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
9393653 9393653 PRJNA493632_P_NODE_536908_length_249_cov_0.875000_g533469_i0 PRJNA493632 536908 249 0.875 2.17875 Raphanus sativus cryptic virus 2 351495 Viruses Viruses 438 1.4799999999999996e-118   NTclustered gi|2166635491|gb|MZ437438.1| 351495 g533469 i0 98.394 3 249 4 100 0 1 249 512 264 Raphanus sativus cryptic virus 2 isolate PQ hypothetical protein gene, complete cds blastn 747 438 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Raphanus sativus cryptic virus 2
13215910 13215910 PRJNA493632_P_NODE_34951_length_705_cov_2.093354_g31920_i0 PRJNA493632 34951 705 2.093354 14.7581457 Potyvirus rapae 3240607 Viruses Viruses 1275 0   NTclustered gi|31074765|emb|AJ488152.1| 12230 g31920 i0 99.291 100 705 5 100 0 1 705 1349 645 Turnip mosaic virus partial gene for polyprotein, genomic RNA blastn 70500 1275 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus rapae
13216209 13216209 PRJNA493632_P_NODE_363951_length_280_cov_1.222222_g360512_i0 PRJNA493632 363951 280 1.222222 3.4222216 Cripavirus drosophilae 3047809 Viruses Viruses 496 9.92e-136   NTclustered gi|2147549872|gb|MW834587.1| 64279 g360512 i0 98.917 13.1142857142857 277 3 99 0 4 280 4303 4027 Drosophila C virus isolate caf replicase polyprotein gene, partial cds; and capsid polyprotein gene, complete cds blastn 3672 496 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus drosophilae
13219231 13219231 PRJNA493632_P_NODE_527211_length_250_cov_0.870056_g523772_i0 PRJNA493632 527211 250 0.870056 2.17514 Bat Coronavirus RfYN20 3018890 Viruses Viruses 52.8 0.023   NTclustered gi|2431689318|gb|OQ175057.1| 3018890 g523772 i0 100 0.112 28 0 11 0 208 235 11603 11576 Bat Coronavirus RfYN20 isolate BtRf-AlphaCoV/YN2020-Q37, complete genome blastn 28 52.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae   Bat Coronavirus RfYN20
15767145 15767145 PRJNA493632_P_NODE_469833_length_258_cov_1.394595_g466394_i0 PRJNA493632 469833 258 1.394595 3.5980551 Potyvirus rapae 3240607 Viruses Viruses 477 3.2699999999999985e-130   NTclustered gi|2019445926|dbj|LC537497.1| 12230 g466394 i0 100 100 258 0 100 0 1 258 9794 9537 Turnip mosaic virus CHN204 RNA, nearly complete sequence blastn 25800 477 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus rapae
17038276 17038276 PRJNA493632_P_NODE_281194_length_304_cov_1.623377_g277758_i0 PRJNA493632 281194 304 1.623377 4.93506608 Potyvirus rapae 3240607 Viruses Viruses 562 1.06e-155   NTclustered gi|2019445986|dbj|LC537527.1| 12230 g277758 i0 100 99.9605263157895 304 0 100 0 1 304 8015 8318 Turnip mosaic virus CHZH34A RNA, nearly complete sequence blastn 30388 562 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus rapae
19586442 19586442 PRJNA493632_P_NODE_255376_length_311_cov_7.176471_g251940_i0 PRJNA493632 255376 311 7.176471 22.31882481 Hangzhou dicistrovirus 1 2905409 Viruses Viruses 569 6.489999999999998e-158   NTclustered gi|2168955240|gb|MZ209655.1| 2905409 g251940 i0 100 0.990353697749196 308 0 99 0 4 311 2536 2229 MAG: Hangzhou dicistrovirus 1 isolate JM1FY83932, complete genome blastn 308 569 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Hangzhou dicistrovirus 1
20864899 20864899 PRJNA493632_P_NODE_401337_length_272_cov_1.236181_g397898_i0 PRJNA493632 401337 272 1.236181 3.36241232 Dicistroviridae sp. 1955144 Viruses Viruses 52.8 0.025   NTclustered gi|1836405939|gb|MN918769.1| 1955144 g397898 i0 94.118 0.125 34 2 13 0 103 136 6779 6812 MAG: Dicistroviridae sp. isolate war204dic1 genomic sequence, sequence blastn 34 52.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
20868499 20868499 PRJNA493632_P_NODE_603537_length_244_cov_5.929825_g600096_i0 PRJNA493632 603537 244 5.929825 14.468773 Hangzhou dicistrovirus 1 2905409 Viruses Viruses 451 1.86e-122   NTclustered gi|2168955240|gb|MZ209655.1| 2905409 g600096 i0 100 1 244 0 100 0 1 244 3656 3413 MAG: Hangzhou dicistrovirus 1 isolate JM1FY83932, complete genome blastn 244 451 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Hangzhou dicistrovirus 1
21503121 21503121 PRJNA493632_P_NODE_221397_length_331_cov_1.410853_g217962_i0 PRJNA493632 221397 331 1.410853 4.66992343 Viruses 10239 Viruses Viruses 73.1 2.39e-8   NTclustered gi|2165837707|emb|OV197600.1| 2697049 g217962 i0 100 45.2749244712991 39 0 12 0 20 58 29954 29992 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 14986 73.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
29192548 29192548 PRJNA493632_P_NODE_520509_length_250_cov_1.305085_g517070_i0 PRJNA493632 520509 250 1.305085 3.2627125 Sobelivirales sp. 2809868 Viruses Viruses 50.8 4.9e-5   NR WRQ64796.1 2809868 g517070 i0 60.5 0.456 38 15 45.6 0 249 136 189 226 WRQ64796.1 hypothetical protein, partial [Sobelivirales sp.] diamond 114 50.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales     Sobelivirales sp.
31008724 31008724 PRJNA493632_P_NODE_499514_length_252_cov_1.670391_g496075_i0 PRJNA493632 499514 252 1.670391 4.20938532 Viruses 10239 Viruses Viruses 47.8 3.17e-4   NR WWV86706.1 1530251 g496075 i0 39.3 1.28571428571429 61 32 66.7 2 240 73 97 157 WWV86706.1 MAG: hypothetical protein, partial [Picornaviridae sp.] diamond 324 48.1 0.993762993762994 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
32273994 32273994 PRJNA493632_P_NODE_334158_length_286_cov_2.164319_g330719_i0 PRJNA493632 334158 286 2.164319 6.18995234 Viruses 10239 Viruses Viruses 58.9 1.34e-7   NR UCS96409.1 1955145 g330719 i0 37.2 3.95454545454545 94 47 98.6 2 285 4 1759 1840 UCS96409.1 MAG: polyprotein [Iflaviridae sp.] diamond 1131 58.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae   Iflaviridae sp.

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