RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJEB50332" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Orthornavirae · 4 ✖

bioproject 1

  • PRJEB50332 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
1393784 1393784 PRJEB50332_P_NODE_1322_length_477_cov_2.144231_g1241_i0 PRJEB50332 1322 477 2.144231 10.22798187 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 688 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g1241 i0 93.682 0.962264150943396 459 29 96 0 2 460 4246 4704 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 459 688 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
1393889 1393889 PRJEB50332_P_NODE_562_length_723_cov_1.435045_g492_i0 PRJEB50332 562 723 1.435045 10.37537535 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1009 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g492 i0 91.851 1.00138312586445 724 57 100 2 1 723 6489 5767 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 724 1009 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
9046699 9046699 PRJEB50332_P_NODE_3868_length_300_cov_1.899582_g3786_i0 PRJEB50332 3868 300 1.899582 5.698746 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 505 1.7799999999999995e-138   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g3786 i0 97 1 300 9 100 0 1 300 572 273 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 300 505 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
10322412 10322412 PRJEB50332_P_NODE_5109_length_270_cov_2.224880_g5027_i0 PRJEB50332 5109 270 2.22488 6.007176 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 296 1.04e-75   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g5027 i0 91.589 0.792592592592593 214 18 79 0 2 215 1655 1442 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 214 296 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);;