RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA1120586" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Orthornavirae · 12 ✖

bioproject 1

  • PRJNA1120586 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
2826427 2826427 PRJNA1120586_P_NODE_1583_length_813_cov_3.888441_g1425_i0 PRJNA1120586 1583 813 3.888441 31.61302533 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 442 4.149999999999998e-119   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g1425 i0 90.476 0.413284132841328 336 31 41 1 374 709 1105 771 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 336 442 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
2827117 2827117 PRJNA1120586_P_NODE_55243_length_193_cov_5.016129_g55052_i0 PRJNA1120586 55243 193 5.016129 9.68112897 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 307 3.2200000000000003e-79   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g55052 i0 95.337 1 193 9 100 0 1 193 4382 4574 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 193 307 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
2827156 2827156 PRJNA1120586_P_NODE_803_length_1076_cov_2.632572_g684_i0 PRJNA1120586 803 1076 2.632572 28.32647472 Iflavirus sp. 1916690 Viruses Viruses 1905 0   NTclustered gi|2895513725|tpg|BK068483.1| 1916690 g684 i0 98.606 7.83736059479554 1076 15 100 0 1 1076 52 1127 TPA_asm: Iflavirus sp. isolate WUR12 polyprotein gene, complete cds blastn 8433 1905 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Iflavirus sp.
4102761 4102761 PRJNA1120586_P_NODE_12524_length_351_cov_5.400709_g12333_i0 PRJNA1120586 12524 351 5.400709 18.95648859 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 494 4.58e-135   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g12333 i0 92.045 1.002849002849 352 27 100 1 1 351 5793 5442 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 352 494 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
6654321 6654321 PRJNA1120586_P_NODE_5686_length_475_cov_5.847291_g5496_i0 PRJNA1120586 5686 475 5.847291 27.77463225 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 658 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g5496 i0 91.561 0.997894736842105 474 40 99 0 1 474 6927 6454 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 474 658 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
7929229 7929229 PRJNA1120586_P_NODE_47_length_3068_cov_5.600534_g40_i0 PRJNA1120586 47 3068 5.600534 171.82438312 Iflavirus sp. 1916690 Viruses Viruses 5221 0   NTclustered gi|2895513723|tpg|BK068482.1| 1916690 g40 i0 97.726 9.72946544980443 3034 69 99 0 1 3034 1194 4227 TPA_asm: Iflavirus sp. isolate WUR11 polyprotein gene, complete cds blastn 29850 5221 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Iflavirus sp.
7929396 7929396 PRJNA1120586_P_NODE_927_length_1008_cov_5.093717_g798_i0 PRJNA1120586 927 1008 5.093717 51.34466736 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 671 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g798 i0 94.676 0.624007936507937 432 23 62 0 577 1008 2100 2531 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 629 671 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
9203654 9203654 PRJNA1120586_P_NODE_12608_length_350_cov_6.167260_g12417_i0 PRJNA1120586 12608 350 6.16726 21.58541 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 187 8.689999999999999e-43   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g12417 i0 89.865 0.422857142857143 148 12 42 3 3 148 5475 5329 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 148 187 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
9203738 9203738 PRJNA1120586_P_NODE_1768_length_774_cov_4.662411_g1603_i0 PRJNA1120586 1768 774 4.662411 36.08706114 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 641 3.619999999999999e-179   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g1603 i0 92.777 0.57235142118863 443 32 57 0 127 569 3703 4145 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 443 641 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
14305309 14305309 PRJNA1120586_P_NODE_5552_length_480_cov_7.236010_g5362_i0 PRJNA1120586 5552 480 7.23601 34.732848 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 233 1.5599999999999998e-56   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g5362 i0 96.454 0.29375 141 5 29 0 2 142 4564 4704 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 141 233 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
16853041 16853041 PRJNA1120586_P_NODE_14_length_5439_cov_25.248790_g12_i0 PRJNA1120586 14 5439 25.24879 1373.2816881 Iflavirus sp. 1916690 Viruses Viruses 9642 0   NTclustered gi|2895513727|tpg|BK068484.1| 1916690 g12 i0 98.676 24.4261812833241 5437 72 99 0 1 5437 9599 4163 TPA_asm: Iflavirus sp. isolate WUR13 polyprotein gene, complete cds blastn 132854 9642 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Iflavirus sp.
23228078 23228078 PRJNA1120586_P_NODE_1659_length_797_cov_5.434066_g1499_i0 PRJNA1120586 1659 797 5.434066 43.30950602 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1018 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g1499 i0 95.866 0.789209535759097 629 26 79 0 1 629 629 1 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 629 1018 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);;