RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA774958" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA774958 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
7131161 7131161 PRJNA774958_P_NODE_14246_length_431_cov_2.365922_g13999_i0 PRJNA774958 14246 431 2.365922 10.19712382 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 656 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g13999 i0 93.968 1 431 26 100 0 1 431 6538 6968 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 431 656 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
7131366 7131366 PRJNA774958_P_NODE_33566_length_251_cov_0.865169_g33319_i0 PRJNA774958 33566 251 0.865169 2.17157419 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 263 9.65e-66   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g33319 i0 98.649 0.589641434262948 148 2 59 0 104 251 2 149 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 148 263 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
8405785 8405785 PRJNA774958_P_NODE_27_length_3701_cov_5.208931_g23_i0 PRJNA774958 27 3701 5.208931 192.78253631 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 2743 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g23 i0 95.767 0.792758713861119 1701 68 79 4 2003 3701 5329 7027 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 2934 2743 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
9681032 9681032 PRJNA774958_P_NODE_19848_length_359_cov_1.325175_g19601_i0 PRJNA774958 19848 359 1.325175 4.75737825 Tribolium castaneum iflavirus 2059679 Viruses Viruses 592 1.6199999999999999e-164   NTclustered gi|1308042380|gb|MG012488.1| 2059679 g19601 i0 96.379 2 359 13 100 0 1 359 6286 6644 Tribolium castaneum iflavirus isolate a3 polyprotein gene, partial cds blastn 718 592 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae   Tribolium castaneum iflavirus
9681040 9681040 PRJNA774958_P_NODE_20128_length_356_cov_1.088339_g19881_i0 PRJNA774958 20128 356 1.088339 3.87448684 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 499 1e-136   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g19881 i0 92.09 0.99438202247191 354 28 99 0 1 354 6003 6356 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 354 499 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
10956584 10956584 PRJNA774958_P_NODE_13089_length_450_cov_1.633952_g12842_i0 PRJNA774958 13089 450 1.633952 7.352784 Tribolium castaneum iflavirus 2059679 Viruses Viruses 784 0   NTclustered gi|1308042380|gb|MG012488.1| 2059679 g12842 i0 98.009 2.00888888888889 452 7 100 1 1 450 7897 8348 Tribolium castaneum iflavirus isolate a3 polyprotein gene, partial cds blastn 904 784 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae   Tribolium castaneum iflavirus
13506327 13506327 PRJNA774958_P_NODE_23471_length_323_cov_0.968000_g23224_i0 PRJNA774958 23471 323 0.968 3.12664 Tribolium castaneum iflavirus 2059679 Viruses Viruses 542 1.48e-149   NTclustered gi|1308042380|gb|MG012488.1| 2059679 g23224 i0 96.904 2 323 10 100 0 1 323 9063 8741 Tribolium castaneum iflavirus isolate a3 polyprotein gene, partial cds blastn 646 542 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae   Tribolium castaneum iflavirus
21155437 21155437 PRJNA774958_P_NODE_6837_length_630_cov_1.100539_g6607_i0 PRJNA774958 6837 630 1.100539 6.9333957 Tribolium castaneum iflavirus 2059679 Viruses Viruses 551 5.059999999999998e-152   NTclustered gi|1308042380|gb|MG012488.1| 2059679 g6607 i0 96.677 2.01587301587302 331 11 100 0 300 630 4895 5225 Tribolium castaneum iflavirus isolate a3 polyprotein gene, partial cds blastn 1270 551 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae   Tribolium castaneum iflavirus

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