RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA854078" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 7 ✖

bioproject 1

  • PRJNA854078 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
7219877 7219877 PRJNA854078_P_NODE_266_length_1779_cov_2.700469_g208_i0 PRJNA854078 266 1779 2.700469 48.04134351 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 708 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g208 i0 95.1 0.594154019111861 449 22 59 0 1222 1670 2100 2548 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 1057 708 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
8494525 8494525 PRJNA854078_P_NODE_1027_length_944_cov_2.764638_g861_i0 PRJNA854078 1027 944 2.764638 26.09818272 Mimivirus sp. 2742700 Viruses Viruses 58.4 0.002   NTclustered gi|2770799496|gb|PQ010613.1| 2742700 g861 i0 92.5 0.228813559322034 40 3 4 0 660 699 603605 603644 Mimivirus sp. isolate 2401, partial genome blastn 216 58.4 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Mimivirus Mimivirus sp.
9769772 9769772 PRJNA854078_P_NODE_48_length_3522_cov_12.359524_g36_i0 PRJNA854078 48 3522 12.359524 435.30243528 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 2881 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g36 i0 95.85 0.856331629755821 1783 69 86 5 1726 3506 5329 7108 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 3016 2881 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
11045382 11045382 PRJNA854078_P_NODE_49_length_3490_cov_12.729002_g36_i1 PRJNA854078 49 3490 12.729002 444.2421698 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 2580 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g36 i1 93.039 0.859598853868195 1767 118 86 5 1 1765 7092 5329 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 3000 2580 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
11045419 11045419 PRJNA854078_P_NODE_929_length_985_cov_2.825658_g769_i0 PRJNA854078 929 985 2.825658 27.8327313 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1090 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g769 i0 97.492 0.712690355329949 638 16 71 0 197 834 639 2 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 702 1090 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
23793860 23793860 PRJNA854078_P_NODE_11779_length_274_cov_3.258706_g11567_i0 PRJNA854078 11779 274 3.258706 8.92885444 Caudoviricetes sp. 2832643 Viruses Viruses 52.8 0.025   NTclustered gi|2056986943|tpg|BK023444.1| 2832643 g11567 i0 100 0.204379562043796 28 0 10 0 192 219 90271 90298 MAG TPA_asm: Caudoviricetes sp. isolate ctsre6, partial genome blastn 56 52.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
23793900 23793900 PRJNA854078_P_NODE_159_length_2313_cov_7.856696_g36_i3 PRJNA854078 159 2313 7.856696 181.72537848 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 876 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g36 i3 97.647 0.412019022913965 510 12 41 0 255 764 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

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