RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "blastn", bioproject = "PRJNA1069776" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 27 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1069776 · 27 ✖

analysis 1

  • blastn · 27 ✖

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
184624 184624 PRJNA1069776_S_NODE_21561_length_227_cov_488.326087_g21247_i0 PRJNA1069776 21561 227 488.326087 1108.50021749 Betacoronavirus pandemicum 3418604 Viruses Viruses 121 5.46e-23   NTclustered gi|2165835030|emb|OV196298.1| 2697049 g21247 i0 94.872 41.1541850220264 78 2 34 2 10 87 75 150 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 9342 121 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
184972 184972 PRJNA1069776_S_NODE_50601_length_155_cov_2.517857_g50287_i0 PRJNA1069776 50601 155 2.517857 3.90267835 Betacoronavirus pandemicum 3418604 Viruses Viruses 287 3.21e-73   NTclustered gi|2186340933|gb|OM464523.1| 2697049 g50287 i0 100 100 155 0 100 0 1 155 18422 18268 Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/OH-CDC-STM-9XEERMHV2/2022, complete genome blastn 15500 287 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
1459110 1459110 PRJNA1069776_S_NODE_1122_length_646_cov_5.540630_g884_i0 PRJNA1069776 1122 646 5.54063 35.7924698 Betacoronavirus pandemicum 3418604 Viruses Viruses 1194 0   NTclustered gi|2155894178|emb|OV044165.1| 2697049 g884 i0 100 100 646 0 100 0 1 646 26399 25754 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 64600 1194 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
1459301 1459301 PRJNA1069776_S_NODE_24782_length_214_cov_4.204678_g24468_i0 PRJNA1069776 24782 214 4.204678 8.99801092 Betacoronavirus pandemicum 3418604 Viruses Viruses 396 7.559999999999996e-106   NTclustered gi|2028980905|gb|MZ002360.1| 2697049 g24468 i0 100 100 214 0 100 0 1 214 21639 21852 Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/WI-CDC-LC0038184/2021, complete genome blastn 21400 396 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
1459398 1459398 PRJNA1069776_S_NODE_32402_length_190_cov_6.000000_g32088_i0 PRJNA1069776 32402 190 6 11.4 Betacoronavirus pandemicum 3418604 Viruses Viruses 351 1.4399999999999997e-92   NTclustered gi|2055103307|emb|OU198267.1| 2697049 g32088 i0 100 100 190 0 100 0 1 190 19872 20061 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 19000 351 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
1459478 1459478 PRJNA1069776_S_NODE_38362_length_176_cov_3.887218_g38048_i0 PRJNA1069776 38362 176 3.887218 6.84150368 Betacoronavirus pandemicum 3418604 Viruses Viruses 326 7.92e-85   NTclustered gi|2028980905|gb|MZ002360.1| 2697049 g38048 i0 100 100 176 0 100 0 1 176 23028 23203 Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/WI-CDC-LC0038184/2021, complete genome blastn 17600 326 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
4010990 4010990 PRJNA1069776_S_NODE_1164_length_635_cov_7.096284_g913_i0 PRJNA1069776 1164 635 7.096284 45.0614034 Betacoronavirus pandemicum 3418604 Viruses Viruses 1173 0   NTclustered gi|2040238967|emb|OU007694.1| 2697049 g913 i0 100 100 635 0 100 0 1 635 25710 25076 Severe acute respiratory syndrome coronavirus 2 isolate hCoV-19/Switzerland/UR-ETHZ-260020/2020 genome assembly, chromosome: 1 blastn 63500 1173 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
4010997 4010997 PRJNA1069776_S_NODE_12024_length_288_cov_4.216327_g11710_i0 PRJNA1069776 12024 288 4.216327 12.14302176 Betacoronavirus pandemicum 3418604 Viruses Viruses 532 7.8e-147   NTclustered gi|2164092590|gb|OL820718.1| 2697049 g11710 i0 100 100 288 0 100 0 1 288 18228 17941 Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/CO-CDPHE-2102190097/2021 ORF1ab polyprotein (ORF1ab), ORF1a polyprotein (ORF1ab), surface glycoprotein (S), ORF3a protein (ORF3a), envelope protein (E), membrane glycoprotein (M), ORF6 protein (ORF6), ORF7a protein (ORF7a), ORF7b (ORF7b), ORF8 protein (ORF8), and nucleocapsid phosphoprotein (N) genes, complete cds; and ORF10 protein (ORF10) gene, partial cds blastn 28800 532 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
5287887 5287887 PRJNA1069776_S_NODE_8025_length_328_cov_4830.382456_g7711_i0 PRJNA1069776 8025 328 4830.382456 15843.65445568 Betacoronavirus pandemicum 3418604 Viruses Viruses 126 1.79e-24   NTclustered gi|2165835030|emb|OV196298.1| 2697049 g7711 i0 96.154 29.0884146341463 78 1 25 2 10 87 75 150 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 9541 126 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
6117757 6117757 PRJNA1069776_S_NODE_16905_length_252_cov_13112.430622_g16591_i0 PRJNA1069776 16905 252 13112.430622 33043.32516744 Viruses 10239 Viruses Viruses 115 2.8700000000000003e-21   NTclustered gi|2165832904|emb|OV195202.1| 2697049 g16591 i0 93.59 54.3134920634921 78 3 31 2 8 85 86 161 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 13687 115 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
9112557 9112557 PRJNA1069776_S_NODE_47708_length_159_cov_4.456897_g47394_i0 PRJNA1069776 47708 159 4.456897 7.08646623 Betacoronavirus pandemicum 3418604 Viruses Viruses 294 1.98e-75   NTclustered gi|2499447400|emb|OX492971.1| 2697049 g47394 i0 100 100 159 0 100 0 1 159 18745 18903 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 15900 294 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
10388146 10388146 PRJNA1069776_S_NODE_409_length_2007_cov_16.252546_g401_i0 PRJNA1069776 409 2007 16.252546 326.18859822 Betacoronavirus pandemicum 3418604 Viruses Viruses 3701 0   NTclustered gi|1854182511|gb|MT605815.1| 2697049 g401 i0 99.95 100.057299451918 2007 1 100 0 1 2007 29838 27832 Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/WA-S112/2020, complete genome blastn 200815 3701 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
10388156 10388156 PRJNA1069776_S_NODE_42129_length_169_cov_2.436508_g41815_i0 PRJNA1069776 42129 169 2.436508 4.11769852 Betacoronavirus pandemicum 3418604 Viruses Viruses 313 5.859999999999999e-81   NTclustered gi|2028980905|gb|MZ002360.1| 2697049 g41815 i0 100 100 169 0 100 0 1 169 22103 22271 Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/WI-CDC-LC0038184/2021, complete genome blastn 16900 313 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
11663310 11663310 PRJNA1069776_S_NODE_2370_length_470_cov_5.501171_g2058_i0 PRJNA1069776 2370 470 5.501171 25.8555037 Betacoronavirus pandemicum 3418604 Viruses Viruses 869 0   NTclustered gi|2028980905|gb|MZ002360.1| 2697049 g2058 i0 100 100 470 0 100 0 1 470 27700 27231 Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/WI-CDC-LC0038184/2021, complete genome blastn 47000 869 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
11663534 11663534 PRJNA1069776_S_NODE_38850_length_175_cov_3.825758_g38536_i0 PRJNA1069776 38850 175 3.825758 6.6950765 Betacoronavirus pandemicum 3418604 Viruses Viruses 324 2.83e-84   NTclustered gi|2028980905|gb|MZ002360.1| 2697049 g38536 i0 100 100 175 0 100 0 1 175 23412 23586 Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/WI-CDC-LC0038184/2021, complete genome blastn 17500 324 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
12938270 12938270 PRJNA1069776_S_NODE_1091_length_653_cov_7.232787_g864_i0 PRJNA1069776 1091 653 7.232787 47.23009911 Betacoronavirus pandemicum 3418604 Viruses Viruses 1206 0   NTclustered gi|2156878052|gb|OL678782.1| 2697049 g864 i0 100 100 653 0 100 0 1 653 26571 27223 Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/CO-CDPHE-2011114568/2020, complete genome blastn 65300 1206 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
12938522 12938522 PRJNA1069776_S_NODE_30571_length_195_cov_3.914474_g30257_i0 PRJNA1069776 30571 195 3.914474 7.6332243 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.005   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g30257 i0 100 0.292307692307692 29 0 15 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
15487296 15487296 PRJNA1069776_S_NODE_19773_length_236_cov_5.347150_g19459_i0 PRJNA1069776 19773 236 5.34715 12.619274 Betacoronavirus pandemicum 3418604 Viruses Viruses 436 4.999999999999999e-118   NTclustered gi|2499447400|emb|OX492971.1| 2697049 g19459 i0 100 100 236 0 100 0 1 236 24311 24076 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 23600 436 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
15487323 15487323 PRJNA1069776_S_NODE_22113_length_225_cov_3.445055_g21799_i0 PRJNA1069776 22113 225 3.445055 7.75137375 Betacoronavirus pandemicum 3418604 Viruses Viruses 416 6.159999999999998e-112   NTclustered gi|2499447400|emb|OX492971.1| 2697049 g21799 i0 100 100 225 0 100 0 1 225 17750 17974 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 22500 416 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
15487455 15487455 PRJNA1069776_S_NODE_31553_length_193_cov_1.600000_g31239_i0 PRJNA1069776 31553 193 1.6 3.088 Porcine bastrovirus 2588662 Viruses Viruses 58.4 3.58e-4   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g31239 i0 100 0.305699481865285 31 0 16 0 1 31 13 43 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 59 58.4 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
15487649 15487649 PRJNA1069776_S_NODE_4793_length_378_cov_4.435821_g4479_i0 PRJNA1069776 4793 378 4.435821 16.76740338 Betacoronavirus pandemicum 3418604 Viruses Viruses 695 0   NTclustered gi|2120308425|gb|OK617576.1| 2697049 g4479 i0 99.735 100 378 1 100 0 1 378 24671 25048 Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/MO-CDC-ASC210091322/2021 ORF1ab polyprotein (ORF1ab) gene, partial cds; ORF1a polyprotein (ORF1ab) gene, complete cds; surface glycoprotein (S) gene, partial cds; ORF3a protein (ORF3a), envelope protein (E), and membrane glycoprotein (M) genes, complete cds; ORF6 protein (ORF6) gene, partial cds; ORF7a protein (ORF7a) gene, complete cds; ORF7b (ORF7b) gene, partial cds; and ORF8 protein (ORF8), nucleocapsid phosphoprotein (N), and ORF10 protein (ORF10) genes, complete cds blastn 37800 695 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
16317058 16317058 PRJNA1069776_S_NODE_13013_length_279_cov_11605.105932_g12699_i0 PRJNA1069776 13013 279 11605.105932 32378.24555028 Viruses 10239 Viruses Viruses 115 3.23e-21   NTclustered gi|2165832904|emb|OV195202.1| 2697049 g12699 i0 93.59 22.9354838709677 78 3 28 2 8 85 86 161 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 6399 115 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
16761447 16761447 PRJNA1069776_S_NODE_14294_length_269_cov_6432.787611_g13980_i0 PRJNA1069776 14294 269 6432.787611 17304.19867359 Betacoronavirus pandemicum 3418604 Viruses Viruses 128 3.9799999999999998e-25   NTclustered gi|2165832904|emb|OV195202.1| 2697049 g13980 i0 94.118 27.4200743494424 85 3 32 2 10 94 30108 30026 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 7376 128 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
19310263 19310263 PRJNA1069776_S_NODE_20556_length_232_cov_5.322751_g20242_i0 PRJNA1069776 20556 232 5.322751 12.34878232 Betacoronavirus pandemicum 3418604 Viruses Viruses 429 8.2e-116   NTclustered gi|2499447400|emb|OX492971.1| 2697049 g20242 i0 100 100 232 0 100 0 1 232 26613 26382 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 23200 429 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
20585683 20585683 PRJNA1069776_S_NODE_20617_length_232_cov_3.502646_g20303_i0 PRJNA1069776 20617 232 3.502646 8.12613872 Betacoronavirus pandemicum 3418604 Viruses Viruses 429 8.2e-116   NTclustered gi|1854182511|gb|MT605815.1| 2697049 g20303 i0 100 100 232 0 100 0 1 232 23218 23449 Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/WA-S112/2020, complete genome blastn 23200 429 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
20585714 20585714 PRJNA1069776_S_NODE_23057_length_221_cov_3.252809_g22743_i0 PRJNA1069776 23057 221 3.252809 7.18870789 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.005   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g22743 i0 100 0.257918552036199 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
24410564 24410564 PRJNA1069776_S_NODE_22820_length_222_cov_3.351955_g22506_i0 PRJNA1069776 22820 222 3.351955 7.4413401 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.005   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g22506 i0 100 0.256756756756757 29 0 13 0 194 222 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus

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