RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA1123436" 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

bioproject 1

  • PRJNA1123436 · 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
2830133 2830133 PRJNA1123436_P_NODE_26983_length_498_cov_1.449412_g25775_i0 PRJNA1123436 26983 498 1.449412 7.21807176 Betacoronavirus pandemicum 3418604 Viruses Viruses 920 0   NTclustered gi|2551850806|gb|OR345918.1| 2697049 g25775 i0 100 100 498 0 100 0 1 498 28929 28432 Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/CA-LACPHL-AY00055/2023 ORF1ab polyprotein (ORF1ab), ORF1a polyprotein (ORF1ab), surface glycoprotein (S), ORF3a protein (ORF3a), envelope protein (E), membrane glycoprotein (M), ORF6 protein (ORF6), ORF7a protein (ORF7a), and ORF7b (ORF7b) genes, complete cds; ORF8 gene, complete sequence; and nucleocapsid phosphoprotein (N) and ORF10 protein (ORF10) genes, complete cds blastn 49800 920 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
2830411 2830411 PRJNA1123436_P_NODE_43963_length_379_cov_1.758170_g42749_i0 PRJNA1123436 43963 379 1.75817 6.6634643 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 616 1.0199999999999997e-171   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g42749 i0 96.032 0.997361477572559 378 15 99 0 2 379 2488 2111 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 378 616 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
4106468 4106468 PRJNA1123436_P_NODE_24_length_7841_cov_10.615989_g20_i0 PRJNA1123436 24 7841 10.615989 832.39969749 Zebrafish picornavirus 1 2304617 Viruses Viruses 12591 0   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g20 i0 95.654 2.99362326233899 7846 331 100 6 1 7841 7868 28 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 23473 12591 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
4106592 4106592 PRJNA1123436_P_NODE_33224_length_443_cov_0.829730_g32012_i0 PRJNA1123436 33224 443 0.82973 3.6757039 Betacoronavirus pandemicum 3418604 Viruses Viruses 819 0   NTclustered gi|2316342856|gb|OP624554.1| 2697049 g32012 i0 100 100 443 0 100 0 1 443 17422 16980 Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/OH-CDC-QDX41755282/2022, complete genome blastn 44300 819 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
4107614 4107614 PRJNA1123436_P_NODE_84684_length_269_cov_1.571429_g83470_i0 PRJNA1123436 84684 269 1.571429 4.22714401 Zebrafish picornavirus 1 2304617 Viruses Viruses 479 9.539999999999999e-131   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g83470 i0 98.881 3.94795539033457 268 3 99 0 2 269 8109 7842 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 1062 479 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
6657401 6657401 PRJNA1123436_P_NODE_34646_length_432_cov_2.331476_g33434_i0 PRJNA1123436 34646 432 2.331476 10.07197632 Enterovirus cerhino 3428504 Viruses Viruses 370 1.01e-97   NTclustered gi|2271979367|gb|ON729335.1| 2045075 g33434 i0 93.878 39.8310185185185 245 15 97 0 187 431 5811 5567 Rhinovirus C34 strain SC647, complete genome blastn 17207 370 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Enterovirus Enterovirus cerhino
9208112 9208112 PRJNA1123436_P_NODE_64408_length_311_cov_0.970588_g63194_i0 PRJNA1123436 64408 311 0.970588 3.01852868 Zebrafish picornavirus 1 2304617 Viruses Viruses 520 6.629999999999998e-143   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g63194 i0 96.785 3 311 10 100 0 1 311 5651 5341 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 933 520 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
16856178 16856178 PRJNA1123436_P_NODE_113214_length_245_cov_1.343023_g112000_i0 PRJNA1123436 113214 245 1.343023 3.29040635 Betacoronavirus pandemicum 3418604 Viruses Viruses 453 5.1900000000000006e-123   NTclustered gi|2233468913|emb|OW399202.1| 2697049 g112000 i0 100 100 245 0 100 0 1 245 26851 26607 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 24500 453 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
18131813 18131813 PRJNA1123436_P_NODE_61615_length_318_cov_1.571429_g60401_i0 PRJNA1123436 61615 318 1.571429 4.99714422 Enterovirus cerhino 3428504 Viruses Viruses 544 4.0299999999999996e-150   NTclustered gi|2271979367|gb|ON729335.1| 2045075 g60401 i0 97.484 55.6383647798742 318 8 100 0 1 318 6167 6484 Rhinovirus C34 strain SC647, complete genome blastn 17693 544 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Enterovirus Enterovirus cerhino
20680965 20680965 PRJNA1123436_P_NODE_2957_length_1820_cov_3.603320_g2467_i0 PRJNA1123436 2957 1820 3.60332 65.580424 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 2344 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g2467 i0 96.108 0.884615384615385 1439 52 88 4 203 1639 5329 6765 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 1610 2344 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
20681274 20681274 PRJNA1123436_P_NODE_4717_length_1432_cov_2.077999_g4015_i0 PRJNA1123436 4717 1432 2.077999 29.75694568 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 876 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g4015 i0 97.647 0.665502793296089 510 12 67 0 233 742 4704 4195 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 953 876 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
23231761 23231761 PRJNA1123436_P_NODE_29959_length_470_cov_1.314861_g28748_i0 PRJNA1123436 29959 470 1.314861 6.1798467 Betacoronavirus pandemicum 3418604 Viruses Viruses 859 0   NTclustered gi|2453879726|emb|OX445193.1| 2697049 g28748 i0 99.786 103.478723404255 468 1 99 0 1 468 27810 27343 Severe acute respiratory syndrome coronavirus 2 isolate 19070486 genome assembly, complete genome: monopartite blastn 48635 859 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
23231900 23231900 PRJNA1123436_P_NODE_37119_length_416_cov_1.402332_g35905_i0 PRJNA1123436 37119 416 1.402332 5.83370112 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 460 5.61e-125   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g35905 i0 97.753 0.641826923076923 267 6 64 0 119 385 1442 1708 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 267 460 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
24506097 24506097 PRJNA1123436_P_NODE_64360_length_311_cov_1.147059_g63146_i0 PRJNA1123436 64360 311 1.147059 3.56735349 Alphacoronavirus amsterdamense 3433809 Viruses Viruses 573 5.019999999999999e-159   NTclustered gi|2447465036|dbj|LC756668.1| 277944 g63146 i0 100 99.6784565916399 310 0 99 0 2 311 25961 25652 Human coronavirus NL63 HCoVNL63_Fukushima_O230_2018 RNA, nearly complete genome blastn 31000 573 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Alphacoronavirus Alphacoronavirus amsterdamense
24506235 24506235 PRJNA1123436_P_NODE_7160_length_1119_cov_2.673040_g6252_i0 PRJNA1123436 7160 1119 2.67304 29.9113176 Alphacoronavirus amsterdamense 3433809 Viruses Viruses 2056 0   NTclustered gi|2447465036|dbj|LC756668.1| 277944 g6252 i0 99.821 100.050938337802 1119 2 100 0 1 1119 27119 26001 Human coronavirus NL63 HCoVNL63_Fukushima_O230_2018 RNA, nearly complete genome blastn 111957 2056 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Alphacoronavirus Alphacoronavirus amsterdamense
24506414 24506414 PRJNA1123436_P_NODE_80660_length_277_cov_1.132353_g79446_i0 PRJNA1123436 80660 277 1.132353 3.13661781 Betacoronavirus pandemicum 3418604 Viruses Viruses 512 9.73e-141   NTclustered gi|2316342856|gb|OP624554.1| 2697049 g79446 i0 100 100 277 0 100 0 1 277 26117 25841 Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/OH-CDC-QDX41755282/2022, complete genome blastn 27700 512 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
30407305 30407305 PRJNA1123436_P_NODE_24913_length_522_cov_1.525612_g23706_i0 PRJNA1123436 24913 522 1.525612 7.96369464 Viruses 10239 Viruses Viruses 107 3.11e-23   NR AVM87441.1 2116205 g23706 i0 36.8 2.11494252873563 185 101 99.4 4 520 2 1020 1200 AVM87441.1 polyprotein [Wenling rattails picornavirus] diamond 1104 108 0.990740740740741 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Wenling rattails picornavirus
32093327 32093327 PRJNA1123436_P_NODE_112938_length_245_cov_2.156977_g111724_i0 PRJNA1123436 112938 245 2.156977 5.28459365 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 70.5 6.64e-12   NR AVM87418.1 3063761 g111724 i0 62 1.17551020408163 50 16 58.8 2 146 3 779 827 AVM87418.1 polyprotein [Yancheng osbecks grenadier anchovy picornavirus] diamond 288 70.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2

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