RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA1174207" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1174207 · 13 ✖

analysis 1

  • blastn · 13 ✖

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
1590053 1590053 PRJNA1174207_P_NODE_14702_length_378_cov_2.026230_g14173_i0 PRJNA1174207 14702 378 2.02623 7.6591494 Varroa picorna-like virus 2873563 Viruses Viruses 366 1.1299999999999996e-96   NTclustered gi|2111829811|gb|MZ822077.1| 2873563 g14173 i0 84.392 1 378 54 99 5 2 378 841 468 MAG: Varroa picorna-like virus isolate No11-Mi016-HLJ2018, complete genome blastn 378 366 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Varroa picorna-like virus
1590134 1590134 PRJNA1174207_P_NODE_19242_length_323_cov_2.208000_g18713_i0 PRJNA1174207 19242 323 2.208 7.13184 Varroa picorna-like virus 2873563 Viruses Viruses 560 4.08e-155   NTclustered gi|2111829811|gb|MZ822077.1| 2873563 g18713 i0 98.131 1.98761609907121 321 6 99 0 3 323 5484 5164 MAG: Varroa picorna-like virus isolate No11-Mi016-HLJ2018, complete genome blastn 642 560 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Varroa picorna-like virus
4868967 4868967 PRJNA1174207_P_NODE_9744_length_492_cov_1.439141_g9218_i0 PRJNA1174207 9744 492 1.439141 7.08057372 Viruses 10239 Viruses Viruses 749 0   NTclustered gi|2756423860|gb|PP745721.1| 1955144 g9218 i0 94.106 2 492 29 100 0 1 492 2717 3208 MAG: Dicistroviridae sp. isolate 017_5547 genomic sequence blastn 984 749 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
6693372 6693372 PRJNA1174207_P_NODE_20226_length_315_cov_1.586777_g19697_i0 PRJNA1174207 20226 315 1.586777 4.99834755 Varroa picorna-like virus 2873563 Viruses Viruses 494 4.08e-135   NTclustered gi|2111829811|gb|MZ822077.1| 2873563 g19697 i0 94.921 2 315 16 100 0 1 315 3389 3075 MAG: Varroa picorna-like virus isolate No11-Mi016-HLJ2018, complete genome blastn 630 494 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Varroa picorna-like virus
9243223 9243223 PRJNA1174207_P_NODE_11528_length_440_cov_2.833787_g11001_i0 PRJNA1174207 11528 440 2.833787 12.4686628 Dicistroviridae sp. 1955144 Viruses Viruses 488 2.7399999999999993e-133   NTclustered gi|2756423860|gb|PP745721.1| 1955144 g11001 i0 87.215 1.99090909090909 438 44 98 9 2 433 1794 2225 MAG: Dicistroviridae sp. isolate 017_5547 genomic sequence blastn 876 488 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
10519623 10519623 PRJNA1174207_P_NODE_809_length_2121_cov_42.583008_g640_i0 PRJNA1174207 809 2121 42.583008 903.18559968 Dicistroviridae sp. 1955144 Viruses Viruses 3217 0   NTclustered gi|2756423860|gb|PP745721.1| 1955144 g640 i0 96.368 1.89297501178689 1955 71 92 0 2 1956 3161 5115 MAG: Dicistroviridae sp. isolate 017_5547 genomic sequence blastn 4015 3217 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
14344488 14344488 PRJNA1174207_P_NODE_21352_length_309_cov_1.580508_g20823_i0 PRJNA1174207 21352 309 1.580508 4.88376972 Dicistroviridae sp. 1955144 Viruses Viruses 316 9.269999999999999e-82   NTclustered gi|2756423860|gb|PP745721.1| 1955144 g20823 i0 85.342 1.98705501618123 307 43 99 2 3 308 700 1005 MAG: Dicistroviridae sp. isolate 017_5547 genomic sequence blastn 614 316 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
14344934 14344934 PRJNA1174207_P_NODE_552_length_2568_cov_73.924248_g430_i0 PRJNA1174207 552 2568 73.924248 1898.37468864 Varroa picorna-like virus 2873563 Viruses Viruses 3504 0   NTclustered gi|2111829811|gb|MZ822077.1| 2873563 g430 i0 91.849 1.91471962616822 2515 199 98 6 1 2512 5421 7932 MAG: Varroa picorna-like virus isolate No11-Mi016-HLJ2018, complete genome blastn 4917 3504 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Varroa picorna-like virus
15618740 15618740 PRJNA1174207_P_NODE_8393_length_543_cov_1.631915_g7869_i0 PRJNA1174207 8393 543 1.631915 8.86129845 Varroa picorna-like virus 2873563 Viruses Viruses 976 0   NTclustered gi|2111829811|gb|MZ822077.1| 2873563 g7869 i0 99.079 2 543 5 100 0 1 543 4690 4148 MAG: Varroa picorna-like virus isolate No11-Mi016-HLJ2018, complete genome blastn 1086 976 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Varroa picorna-like virus
16342883 16342883 PRJNA1174207_P_NODE_12053_length_428_cov_1.636620_g11526_i0 PRJNA1174207 12053 428 1.63662 7.0047336 Viruses 10239 Viruses Viruses 425 2.11e-114   NTclustered gi|2756423860|gb|PP745721.1| 1955144 g11526 i0 84.941 1.98598130841122 425 58 99 5 5 426 1740 1319 MAG: Dicistroviridae sp. isolate 017_5547 genomic sequence blastn 850 425 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
16892409 16892409 PRJNA1174207_P_NODE_11774_length_434_cov_3.277008_g11247_i0 PRJNA1174207 11774 434 3.277008 14.22221472 Varroa picorna-like virus 2873563 Viruses Viruses 725 0   NTclustered gi|2111829811|gb|MZ822077.1| 2873563 g11247 i0 96.984 1.98617511520737 431 13 99 0 4 434 5114 4684 MAG: Varroa picorna-like virus isolate No11-Mi016-HLJ2018, complete genome blastn 862 725 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Varroa picorna-like virus
19441348 19441348 PRJNA1174207_P_NODE_14516_length_381_cov_1.250000_g13987_i0 PRJNA1174207 14516 381 1.25 4.7625 Varroa picorna-like virus 2873563 Viruses Viruses 442 1.8399999999999993e-119   NTclustered gi|2111829811|gb|MZ822077.1| 2873563 g13987 i0 87.632 0.99737532808399 380 47 99 0 2 381 3399 3020 MAG: Varroa picorna-like virus isolate No11-Mi016-HLJ2018, complete genome blastn 380 442 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Varroa picorna-like virus
25266707 25266707 PRJNA1174207_P_NODE_15220_length_370_cov_2.296296_g14691_i0 PRJNA1174207 15220 370 2.296296 8.4962952 Viruses 10239 Viruses Viruses 623 5.939999999999999e-174   NTclustered gi|2756423860|gb|PP745721.1| 1955144 g14691 i0 97.027 2 370 11 100 0 1 370 948 1317 MAG: Dicistroviridae sp. isolate 017_5547 genomic sequence blastn 740 623 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.

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