RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA540466", 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 · 6 ✖

tax_kingdom 1

  • Orthornavirae · 6 ✖

bioproject 1

  • PRJNA540466 · 6 ✖

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
1783531 1783531 PRJNA540466_S_NODE_47522_length_270_cov_0.964467_g46973_i0 PRJNA540466 47522 270 0.964467 2.6040609 Periplaneta americana dicistro-like virus 3032225 Viruses Viruses 331 2.84e-86   NTclustered gi|2754804027|tpg|BK063169.1| 3032225 g46973 i0 93.013 0.848148148148148 229 13 85 3 40 268 4666 4441 TPA_asm: Periplaneta americana dicistro-like virus hypothetical protein gene, partial cds blastn 229 331 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Periplaneta americana dicistro-like virus
3058887 3058887 PRJNA540466_S_NODE_30703_length_325_cov_2.527778_g30154_i0 PRJNA540466 30703 325 2.527778 8.2152785 Hansenia oviformis nepovirus 3115769 Viruses Viruses 303 7.64e-78   NTclustered gi|2752247862|tpg|BK065088.1| 3115769 g30154 i0 84.211 3.28615384615385 323 40 97 10 1 316 7998 7680 TPA_asm: Hansenia oviformis nepovirus segment RNA1 polyprotein gene, complete cds blastn 1068 303 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Hansenia oviformis nepovirus
11986593 11986593 PRJNA540466_S_NODE_19090_length_404_cov_4.939577_g18541_i0 PRJNA540466 19090 404 4.939577 19.95589108 Skokie dicistro-like virus 2789443 Viruses Viruses 645 1.3999999999999996e-180   NTclustered gi|2806502719|gb|PQ054859.1| 2789443 g18541 i0 99.438 1.88366336633663 356 0 88 1 1 354 4968 5323 MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence blastn 761 645 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Skokie dicistro-like virus
13261877 13261877 PRJNA540466_S_NODE_40711_length_288_cov_1.079070_g40162_i0 PRJNA540466 40711 288 1.07907 3.1077216 Neurospora intermedia fusarivirus 1 2715688 Viruses Viruses 401 2.2999999999999994e-107   NTclustered gi|1908106092|dbj|LC530174.1| 2715688 g40162 i0 93.704 5.51736111111111 270 13 93 3 1 267 7732 7464 Neurospora intermedia fusarivirus 1 FGSC 2559 RNA, complete genome blastn 1589 401 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Fusariviridae   Neurospora intermedia fusarivirus 1
16421239 16421239 PRJNA540466_S_NODE_3733_length_731_cov_2.996960_g3377_i0 PRJNA540466 3733 731 2.99696 21.9077776 Viruses 10239 Viruses Viruses 65.8 9.4e-6   NTclustered gi|2165835433|emb|OV196499.1| 2697049 g3377 i0 95.238 14.7318741450068 42 1 6 1 680 721 30124 30164 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 10769 65.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
29319874 29319874 PRJNA540466_S_NODE_58369_length_249_cov_0.875000_g57820_i0 PRJNA540466 58369 249 0.875 2.17875 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 119 4.83e-29   NR WKU61618.1 3063761 g57820 i0 98.2 0.674698795180723 56 1 67.5 0 240 73 2165 2220 WKU61618.1 polyprotein [Zebrafish picornavirus 2] diamond 168 119 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   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);;