RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA854078" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA854078 · 5 ✖

analysis 1

  • blastn · 5 ✖

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