RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA549880" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Orthornavirae · 6 ✖

bioproject 1

  • PRJNA549880 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
3062788 3062788 PRJNA549880_P_NODE_163_length_1452_cov_2.090645_g132_i0 PRJNA549880 163 1452 2.090645 30.3561654 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 2037 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g132 i0 92 0.99862258953168 1450 114 99 2 4 1452 6956 5508 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 1450 2037 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
3062946 3062946 PRJNA549880_P_NODE_9623_length_261_cov_2.148936_g9530_i0 PRJNA549880 9623 261 2.148936 5.60872296 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 377 3.46e-100   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g9530 i0 92.72 1 261 19 100 0 1 261 4267 4527 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 261 377 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
8164739 8164739 PRJNA549880_P_NODE_2747_length_439_cov_1.598361_g2654_i0 PRJNA549880 2747 439 1.598361 7.01680479 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 632 1.1899999999999998e-176   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g2654 i0 94.217 0.945330296127563 415 22 95 1 1 415 2512 2100 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 415 632 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
11990807 11990807 PRJNA549880_P_NODE_7230_length_296_cov_2.349776_g7137_i0 PRJNA549880 7230 296 2.349776 6.95533696 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 309 1.48e-79   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g7137 i0 96.277 0.635135135135135 188 7 64 0 2 189 4517 4704 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 188 309 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
19638022 19638022 PRJNA549880_P_NODE_11316_length_249_cov_1.431818_g11223_i0 PRJNA549880 11316 249 1.431818 3.56522682 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 156 1.67e-33   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g11223 i0 97.778 0.36144578313253 90 2 36 0 160 249 1 90 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 90 156 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
24738006 24738006 PRJNA549880_P_NODE_6600_length_308_cov_2.429787_g6507_i0 PRJNA549880 6600 308 2.429787 7.48374396 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 187 7.55e-43   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g6507 i0 90.21 0.464285714285714 143 14 46 0 166 308 5194 5052 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 143 187 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);;