RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "blastn", bioproject = "PRJNA1214993" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 21 ✖

bioproject 1

  • PRJNA1214993 · 21 ✖

analysis 1

  • blastn · 21 ✖

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
1605106 1605106 PRJNA1214993_P_NODE_3062_length_603_cov_3.081132_g2883_i0 PRJNA1214993 3062 603 3.081132 18.57922596 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 409 3.08e-109   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g2883 i0 89.937 0.782752902155887 318 31 78 1 1 318 1087 771 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 472 409 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
2881194 2881194 PRJNA1214993_P_NODE_15763_length_281_cov_1.197115_g15577_i0 PRJNA1214993 15763 281 1.197115 3.36389315 Riboviria sp. 2585031 Viruses Viruses 350 8.2e-92   NTclustered gi|2697180697|gb|OR869539.1| 2585031 g15577 i0 98.01 0.715302491103203 201 4 72 0 81 281 1 201 MAG: Riboviria sp. isolate HPHCC15/9147 genomic sequence blastn 201 350 1 Viruses               Riboviria sp.
2881216 2881216 PRJNA1214993_P_NODE_18323_length_261_cov_6.281915_g18137_i0 PRJNA1214993 18323 261 6.281915 16.39579815 Mitovirus sp. 2587224 Viruses Viruses 156 1.76e-33   NTclustered gi|1698234317|gb|MN033515.1| 2587224 g18137 i0 91.228 1.1264367816092 114 10 44 0 148 261 116 3 MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence blastn 294 156 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae Mitovirus Mitovirus sp.
2881347 2881347 PRJNA1214993_P_NODE_9543_length_354_cov_0.971530_g9357_i0 PRJNA1214993 9543 354 0.97153 3.4392162 Zebrafish picornavirus 1 2304617 Viruses Viruses 588 2.0599999999999994e-163   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g9357 i0 96.884 2.99717514124294 353 8 99 3 5 354 3032 3384 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 1061 588 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
4873540 4873540 PRJNA1214993_P_NODE_2944_length_615_cov_1.197417_g2765_i0 PRJNA1214993 2944 615 1.197417 7.36411455 root 1 Root_unresolved Root_unresolved 981 0   NTclustered gi|331934|gb|J02255.1|MLMCG 11786 g2765 i0 95.447 100.008130081301 615 28 100 0 1 615 1714 2328 Moloney murine leukemia virus, complete genome blastn 61505 981 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
6708215 6708215 PRJNA1214993_P_NODE_7746_length_388_cov_2.495238_g7560_i0 PRJNA1214993 7746 388 2.495238 9.68152344 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 634 2.8899999999999995e-177   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g7560 i0 96.134 1 388 15 100 0 1 388 90 477 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 388 634 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
7983720 7983720 PRJNA1214993_P_NODE_1827_length_772_cov_1.961373_g1662_i0 PRJNA1214993 1827 772 1.961373 15.14179956 Zebrafish picornavirus 1 2304617 Viruses Viruses 1299 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g1662 i0 97.021 3 772 23 100 0 1 772 3824 4595 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 2316 1299 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
13083923 13083923 PRJNA1214993_P_NODE_10411_length_340_cov_1.168539_g10225_i0 PRJNA1214993 10411 340 1.168539 3.9730326 Riboviria sp. 2585031 Viruses Viruses 278 4.87e-70   NTclustered gi|2697180697|gb|OR869539.1| 2585031 g10225 i0 98.113 0.467647058823529 159 3 47 0 182 340 509 351 MAG: Riboviria sp. isolate HPHCC15/9147 genomic sequence blastn 159 278 1 Viruses               Riboviria sp.
13083995 13083995 PRJNA1214993_P_NODE_19571_length_253_cov_1.344444_g19385_i0 PRJNA1214993 19571 253 1.344444 3.40144332 Zebrafish picornavirus 1 2304617 Viruses Viruses 388 1.5399999999999998e-103   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g19385 i0 94.444 2.98814229249012 252 14 99 0 1 252 1909 2160 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 756 388 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
13084049 13084049 PRJNA1214993_P_NODE_26771_length_225_cov_5.592105_g26585_i0 PRJNA1214993 26771 225 5.592105 12.58223625 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 178 3.16e-40   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g26585 i0 97.143 0.466666666666667 105 3 47 0 121 225 1 105 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 105 178 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
14359265 14359265 PRJNA1214993_P_NODE_12_length_4932_cov_16.048570_g6_i0 PRJNA1214993 12 4932 16.04857 791.5154724 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 2342 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g6 i0 91.529 0.684712084347121 1700 140 68 4 3235 4932 5329 7026 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 3377 2342 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
15633147 15633147 PRJNA1214993_P_NODE_14593_length_290_cov_1.078341_g14407_i0 PRJNA1214993 14593 290 1.078341 3.1271889 Caudoviricetes sp. 2832643 Viruses Viruses 145 4.31e-30   NTclustered gi|2914756769|gb|OR221558.1| 2832643 g14407 i0 78.788 1.23103448275862 231 37 77 12 69 290 38593 38366 MAG: Caudoviricetes sp. isolate MSP1507 genomic sequence blastn 357 145 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
15633153 15633153 PRJNA1214993_P_NODE_15033_length_286_cov_1.521127_g14847_i0 PRJNA1214993 15033 286 1.521127 4.35042322 Phage sp. ctGns7 2828003 Viruses Viruses 52.8 0.026   NTclustered gi|2052866262|tpg|BK032555.1| 2828003 g14847 i0 100 0.0979020979020979 28 0 10 0 221 248 98443 98470 MAG TPA_asm: Phage sp. ctGns7, partial genome blastn 28 52.8 1 Viruses               Phage sp. ctGns7
15633274 15633274 PRJNA1214993_P_NODE_5593_length_453_cov_1.589474_g5408_i0 PRJNA1214993 5593 453 1.589474 7.20031722 Zebrafish picornavirus 1 2304617 Viruses Viruses 793 0   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g5408 i0 98.234 3 453 8 100 0 1 453 3866 3414 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 1359 793 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
19456436 19456436 PRJNA1214993_P_NODE_3416_length_573_cov_2.746000_g3234_i0 PRJNA1214993 3416 573 2.746 15.73458 Caudoviricetes sp. 2832643 Viruses Viruses 62.1 9.39e-5   NTclustered gi|2056890690|tpg|BK053688.1| 2832643 g3234 i0 87.5 0.387434554973822 56 3 11 4 34 88 24695 24747 MAG TPA_asm: Caudoviricetes sp. isolate ctmD823, partial genome blastn 222 62.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
23282440 23282440 PRJNA1214993_P_NODE_15259_length_284_cov_24.654028_g15073_i0 PRJNA1214993 15259 284 24.654028 70.01743952 Mitovirus sp. 2587224 Viruses Viruses 134 9.1e-27   NTclustered gi|1698234317|gb|MN033515.1| 2587224 g15073 i0 88.393 0.394366197183099 112 12 39 1 5 116 1 111 MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence blastn 112 134 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae Mitovirus Mitovirus sp.
23282455 23282455 PRJNA1214993_P_NODE_1819_length_774_cov_2.400856_g1654_i0 PRJNA1214993 1819 774 2.400856 18.58262544 Zebrafish picornavirus 1 2304617 Viruses Viruses 1236 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g1654 i0 95.478 3 774 35 100 0 1 774 4853 5626 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 2322 1236 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
23282594 23282594 PRJNA1214993_P_NODE_99_length_2294_cov_3.776677_g66_i0 PRJNA1214993 99 2294 3.776677 86.63697038 Zebrafish picornavirus 1 2304617 Viruses Viruses 3904 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g66 i0 97.384 3 2294 60 100 0 1 2294 5568 7861 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 6882 3904 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
24556398 24556398 PRJNA1214993_P_NODE_13760_length_297_cov_2.040179_g13574_i0 PRJNA1214993 13760 297 2.040179 6.05933163 Bacteriophage sp. 38018 Viruses Viruses 58.4 5.93e-4   NTclustered gi|2293621936|gb|OP072883.1| 38018 g13574 i0 100 0.400673400673401 31 0 10 0 57 87 70705 70675 MAG: Bacteriophage sp. isolate 4259_72191, partial genome blastn 119 58.4 1 Viruses               Bacteriophage sp.
24556400 24556400 PRJNA1214993_P_NODE_1420_length_863_cov_5.131646_g1268_i0 PRJNA1214993 1420 863 5.131646 44.28610498 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 388 5.84e-103   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g1268 i0 92.884 0.309385863267671 267 19 31 0 336 602 1708 1442 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 267 388 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
24556545 24556545 PRJNA1214993_P_NODE_7320_length_399_cov_1.343558_g7134_i0 PRJNA1214993 7320 399 1.343558 5.36079642 Zebrafish picornavirus 1 2304617 Viruses Viruses 616 1.0799999999999999e-171   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g7134 i0 94.486 3 399 22 100 0 1 399 1249 1647 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 1197 616 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1

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