RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA383995" 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

  • PRJNA383995 · 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
1680112 1680112 PRJNA383995_P_NODE_22_length_2374_cov_5.199570_g15_i0 PRJNA383995 22 2374 5.19957 123.4377918 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 2676 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g15 i0 93.775 0.868997472620051 1783 106 87 5 7 1787 7108 5329 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 2063 2676 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
1680113 1680113 PRJNA383995_P_NODE_262_length_1018_cov_8.909185_g3_i4 PRJNA383995 262 1018 8.909185 90.6955033 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 691 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g3 i4 94.432 0.546168958742633 449 25 55 0 385 833 2100 2548 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 556 691 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
1680119 1680119 PRJNA383995_P_NODE_502_length_773_cov_4.640884_g427_i0 PRJNA383995 502 773 4.640884 35.87403332 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1099 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g427 i0 92.238 1 773 60 100 0 1 773 6960 6188 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 773 1099 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
11883929 11883929 PRJNA383995_P_NODE_10_length_2887_cov_8.181818_g3_i1 PRJNA383995 10 2887 8.181818 236.20908566 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1112 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g3 i1 98.119 0.585382750259785 638 12 59 0 2086 2723 639 2 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 1690 1112 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
13158970 13158970 PRJNA383995_P_NODE_11_length_2887_cov_7.657153_g3_i2 PRJNA383995 11 2887 7.657153 221.06200711 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1079 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g3 i2 97.179 0.585382750259785 638 18 59 0 2086 2723 639 2 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 1690 1079 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);;