RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where bioproject = "PRJNA666695", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 23 ✖

tax_phylum 1

  • Pisuviricota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJNA666695 · 23 ✖

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
1907054 1907054 PRJNA666695_S_NODE_148502_length_178_cov_3.824818_g147408_i0 PRJNA666695 148502 178 3.824818 6.80817604 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.004   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g147408 i0 94.286 0.353932584269663 35 2 20 0 1 35 13 47 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 63 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
1908015 1908015 PRJNA666695_S_NODE_21502_length_404_cov_3.236915_g20409_i0 PRJNA666695 21502 404 3.236915 13.0771366 Porcine bastrovirus 2588662 Viruses Viruses 52.8 0.039   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g20409 i0 100 0.0693069306930693 28 0 7 0 1 28 16 43 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 28 52.8 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
1909444 1909444 PRJNA666695_S_NODE_79962_length_243_cov_1.821782_g78868_i0 PRJNA666695 79962 243 1.821782 4.42693026 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.006   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g78868 i0 100 0.234567901234568 29 0 12 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
5736505 5736505 PRJNA666695_S_NODE_7105_length_626_cov_64.642735_g6174_i0 PRJNA666695 7105 626 64.642735 404.6635211 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.017   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g6174 i0 100 0.0463258785942492 29 0 5 0 598 626 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 29 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
7010015 7010015 PRJNA666695_S_NODE_175446_length_161_cov_2.300000_g174352_i0 PRJNA666695 175446 161 2.3 3.703 Tylonycteris robustula coronavirus 2971263 Viruses Viruses 52.8 0.013   NTclustered gi|2284080987|gb|ON745166.1| 2971263 g174352 i0 94.286 0.217391304347826 35 1 22 1 38 72 15937 15970 Tylonycteris robustula coronavirus isolate 162269, partial genome blastn 35 52.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae   Tylonycteris robustula coronavirus
8286410 8286410 PRJNA666695_S_NODE_75467_length_249_cov_1.947115_g74373_i0 PRJNA666695 75467 249 1.947115 4.84831635 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.006   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g74373 i0 100 0.34136546184739 29 0 12 0 1 29 13 41 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 85 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
9558610 9558610 PRJNA666695_S_NODE_108128_length_211_cov_4.105882_g107034_i0 PRJNA666695 108128 211 4.105882 8.66341102 Porcine bastrovirus 2588662 Viruses Viruses 52.8 0.019   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g107034 i0 100 0.132701421800948 28 0 13 0 1 28 15 42 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 28 52.8 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
9559506 9559506 PRJNA666695_S_NODE_15208_length_461_cov_3.345238_g14117_i0 PRJNA666695 15208 461 3.345238 15.42154718 Porcine bastrovirus 2588662 Viruses Viruses 56.5 0.003   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g14117 i0 100 0.186550976138829 30 0 7 0 1 30 13 42 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 86 56.5 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
9561086 9561086 PRJNA666695_S_NODE_5008_length_723_cov_10.413490_g4214_i0 PRJNA666695 5008 723 10.41349 75.2895327 Porcine bastrovirus 2588662 Viruses Viruses 56.5 0.006   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g4214 i0 100 0.04149377593361 30 0 4 0 694 723 42 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 30 56.5 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
12110316 12110316 PRJNA666695_S_NODE_152570_length_176_cov_1.022222_g151476_i0 PRJNA666695 152570 176 1.022222 1.79911072 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.004   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g151476 i0 100 0.323863636363636 29 0 16 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
12111425 12111425 PRJNA666695_S_NODE_31510_length_350_cov_3.456311_g30416_i0 PRJNA666695 31510 350 3.456311 12.0970885 Biomphalaria virus 3 1931371 Viruses Viruses 597 3.39e-166   NTclustered gi|1127775799|gb|KY024323.1| 1931371 g30416 i0 97.429 2 350 9 100 0 1 350 9959 9610 Biomphalaria virus 3, complete genome blastn 700 597 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Biomphalaria virus 3
13386940 13386940 PRJNA666695_S_NODE_62331_length_269_cov_2.640351_g61237_i0 PRJNA666695 62331 269 2.640351 7.10254419 Porcine bastrovirus 2588662 Viruses Viruses 52.8 0.025   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g61237 i0 100 0.104089219330855 28 0 10 0 242 269 42 15 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 28 52.8 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
14661608 14661608 PRJNA666695_S_NODE_52792_length_287_cov_4.093496_g51698_i0 PRJNA666695 52792 287 4.093496 11.74833352 Biomphalaria virus 1 1931369 Viruses Viruses 501 2.19e-137   NTclustered gi|1127775785|gb|KY024318.1| 1931369 g51698 i0 98.258 6 287 4 100 1 1 287 9863 10148 Biomphalaria virus 1 isolate Barreiro, complete genome blastn 1722 501 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Biomphalaria virus 1
15934231 15934231 PRJNA666695_S_NODE_17093_length_441_cov_4.032500_g16002_i0 PRJNA666695 17093 441 4.0325 17.783325 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.012   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g16002 i0 100 0.129251700680272 29 0 7 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
15935320 15935320 PRJNA666695_S_NODE_43733_length_309_cov_3.223881_g42639_i0 PRJNA666695 43733 309 3.223881 9.96179229 Porcine bastrovirus 2588662 Viruses Viruses 52.8 0.029   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g42639 i0 100 0.0906148867313916 28 0 9 0 1 28 15 42 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 28 52.8 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
17208906 17208906 PRJNA666695_S_NODE_146594_length_180_cov_1.611511_g145500_i0 PRJNA666695 146594 180 1.611511 2.9007198 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.004   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g145500 i0 100 0.316666666666667 29 0 16 0 152 180 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
18482412 18482412 PRJNA666695_S_NODE_104175_length_215_cov_3.074713_g103081_i0 PRJNA666695 104175 215 3.074713 6.61063295 Porcine bastrovirus 2588662 Viruses Viruses 52.8 0.019   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g103081 i0 100 0.130232558139535 28 0 13 0 1 28 15 42 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 28 52.8 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
18484666 18484666 PRJNA666695_S_NODE_37595_length_327_cov_8.419580_g36501_i0 PRJNA666695 37595 327 8.41958 27.5320266 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.009   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g36501 i0 100 0.174311926605505 29 0 9 0 299 327 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
18486006 18486006 PRJNA666695_S_NODE_96375_length_223_cov_4.203297_g95281_i0 PRJNA666695 96375 223 4.203297 9.37335231 Porcine bastrovirus 2588662 Viruses Viruses 56.5 0.002   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g95281 i0 100 0.260089686098655 30 0 13 0 194 223 42 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 58 56.5 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
19757348 19757348 PRJNA666695_S_NODE_123856_length_197_cov_2.775641_g122762_i0 PRJNA666695 123856 197 2.775641 5.46801277 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.005   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g122762 i0 100 0.289340101522843 29 0 15 0 169 197 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
21033017 21033017 PRJNA666695_S_NODE_127057_length_195_cov_1.071429_g125963_i0 PRJNA666695 127057 195 1.071429 2.08928655 Porcine bastrovirus 2588662 Viruses Viruses 56.5 0.001   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g125963 i0 100 0.297435897435897 30 0 15 0 1 30 13 42 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 58 56.5 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
23585681 23585681 PRJNA666695_S_NODE_64159_length_266_cov_2.235556_g63065_i0 PRJNA666695 64159 266 2.235556 5.94657896 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.007   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g63065 i0 100 0.214285714285714 29 0 11 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
24859055 24859055 PRJNA666695_S_NODE_60320_length_272_cov_18.134199_g59226_i0 PRJNA666695 60320 272 18.134199 49.32502128 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.007   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g59226 i0 100 0.209558823529412 29 0 11 0 244 272 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);;