RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA857143" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA857143 · 13 ✖

analysis 1

  • blastn · 13 ✖

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
844381 844381 PRJNA857143_S_NODE_75301_length_346_cov_1.098901_g74208_i0 PRJNA857143 75301 346 1.098901 3.80219746 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.009   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g74208 i0 100 0.164739884393064 29 0 8 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
2119043 2119043 PRJNA857143_S_NODE_180082_length_248_cov_1.337143_g178989_i0 PRJNA857143 180082 248 1.337143 3.31611464 Porcine bastrovirus 2588662 Viruses Viruses 56.5 0.002   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g178989 i0 100 0.233870967741935 30 0 12 0 219 248 42 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 58 56.5 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
2119520 2119520 PRJNA857143_S_NODE_46342_length_405_cov_73.391566_g45249_i0 PRJNA857143 46342 405 73.391566 297.2358423 Dolerus tritici iflavirus 1 3350209 Viruses Viruses 58.4 8.35e-4   NTclustered gi|2833733277|gb|PQ323359.2| 3350209 g45249 i0 100 0.28641975308642 31 0 8 0 1 31 56 86 Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds blastn 116 58.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Dolerus tritici iflavirus 1
2119529 2119529 PRJNA857143_S_NODE_47022_length_403_cov_58.903030_g45929_i0 PRJNA857143 47022 403 58.90303 237.3792109 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.011   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g45929 i0 100 0.141439205955335 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
4672418 4672418 PRJNA857143_S_NODE_34064_length_446_cov_52.731903_g32972_i0 PRJNA857143 34064 446 52.731903 235.18428738 Dolerus tritici iflavirus 1 3350209 Viruses Viruses 58.4 0.001   NTclustered gi|2833733277|gb|PQ323359.2| 3350209 g32972 i0 100 0.260089686098655 31 0 7 0 1 31 56 86 Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds blastn 116 58.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Dolerus tritici iflavirus 1
5947324 5947324 PRJNA857143_S_NODE_43105_length_414_cov_41.187683_g42012_i0 PRJNA857143 43105 414 41.187683 170.51700762 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.011   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g42012 i0 100 0.13768115942029 29 0 7 0 386 414 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
13597413 13597413 PRJNA857143_S_NODE_182291_length_247_cov_1.413793_g181198_i0 PRJNA857143 182291 247 1.413793 3.49206871 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.006   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g181198 i0 100 0.230769230769231 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
14871959 14871959 PRJNA857143_S_NODE_37592_length_432_cov_93.977716_g36500_i0 PRJNA857143 37592 432 93.977716 405.98373312 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.012   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g36500 i0 100 0.131944444444444 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
17422404 17422404 PRJNA857143_S_NODE_60494_length_372_cov_4.933110_g59401_i0 PRJNA857143 60494 372 4.93311 18.3511692 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.01   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g59401 i0 100 0.153225806451613 29 0 8 0 344 372 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
18694899 18694899 PRJNA857143_S_NODE_173655_length_251_cov_1.061798_g172562_i0 PRJNA857143 173655 251 1.061798 2.66511298 Porcine bastrovirus 2588662 Viruses Viruses 56.5 0.002   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g172562 i0 100 0.231075697211155 30 0 12 0 222 251 42 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 58 56.5 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
21246300 21246300 PRJNA857143_S_NODE_55717_length_382_cov_4.165049_g54624_i0 PRJNA857143 55717 382 4.165049 15.91048718 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.01   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g54624 i0 100 0.149214659685864 29 0 8 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
21246378 21246378 PRJNA857143_S_NODE_62997_length_367_cov_3.367347_g61904_i0 PRJNA857143 62997 367 3.367347 12.35816349 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.01   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g61904 i0 100 0.155313351498638 29 0 8 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
22520276 22520276 PRJNA857143_S_NODE_173838_length_251_cov_0.876404_g172745_i0 PRJNA857143 173838 251 0.876404 2.19977404 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.006   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g172745 i0 100 0.227091633466135 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

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