RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 21 ✖

bioproject 1

  • PRJNA789095 · 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
5874747 5874747 PRJNA789095_P_NODE_61525_length_260_cov_1.465241_g60191_i0 PRJNA789095 61525 260 1.465241 3.8096266 Caudoviricetes sp. 2832643 Viruses Viruses 448 2.5899999999999996e-121   NTclustered gi|2057128742|tpg|BK058097.1| 2832643 g60191 i0 97.692 4.44615384615385 260 6 100 0 1 260 127042 127301 MAG TPA_asm: Caudoviricetes sp. isolate ct7Al7, partial genome blastn 1156 448 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
5874879 5874879 PRJNA789095_P_NODE_65705_length_251_cov_1.662921_g64371_i0 PRJNA789095 65705 251 1.662921 4.17393171 Chemalvirus PseuGes254 3427870 Viruses Viruses 291 4.43e-74   NTclustered gi|2618969016|gb|OR575930.1| 3092638 g64371 i0 87.6 0.99601593625498 250 31 99 0 1 250 31581 31332 Pseudomonas phage vB_PseuGesM_254, complete genome blastn 250 291 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Vandenendeviridae Chemalvirus Chemalvirus PseuGes254
9698409 9698409 PRJNA789095_P_NODE_24068_length_462_cov_4.750643_g22736_i0 PRJNA789095 24068 462 4.750643 21.94797066 Catovirus CTV1 1977631 Viruses Viruses 52.8 0.045   NTclustered gi|1174569070|gb|KY684083.1| 1977631 g22736 i0 100 0.0606060606060606 28 0 6 0 32 59 389556 389583 Catovirus CTV1 isolate CTV1 clone Catovirus_1, sequence blastn 28 52.8 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Catovirus Catovirus CTV1
10973862 10973862 PRJNA789095_P_NODE_13389_length_783_cov_2.221127_g12154_i0 PRJNA789095 13389 783 2.221127 17.39142441 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 375 4.1e-99   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g12154 i0 95.339 0.301404853128991 236 11 30 0 547 782 3703 3938 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 236 375 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
10973887 10973887 PRJNA789095_P_NODE_14709_length_718_cov_1.883721_g13431_i0 PRJNA789095 14709 718 1.883721 13.52511678 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 379 2.9e-100   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g13431 i0 91.071 0.586350974930362 280 25 58 0 159 438 4915 5194 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 421 379 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
12250866 12250866 PRJNA789095_P_NODE_64550_length_253_cov_3.061111_g63216_i0 PRJNA789095 64550 253 3.061111 7.74461083 Caudoviricetes sp. 2832643 Viruses Viruses 448 2.5099999999999998e-121   NTclustered gi|2915012446|gb|OR222476.1| 2832643 g63216 i0 98.805 104.438735177866 251 3 99 0 3 253 9028 8778 MAG: Caudoviricetes sp. isolate MSP0915 genomic sequence blastn 26423 448 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
12694153 12694153 PRJNA789095_P_NODE_54090_length_276_cov_2.950739_g52756_i0 PRJNA789095 54090 276 2.950739 8.14403964 Gualtarvirus 2948732 Viruses Viruses 91.6 5.38e-14   NTclustered gi|1936180902|gb|MW082584.1| 2787015 g52756 i0 86.747 25.0507246376812 83 9 30 2 95 177 147219 147299 Serratia phage 4S, complete genome blastn 6914 91.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Straboviridae   Serratia phage 4S
13523692 13523692 PRJNA789095_P_NODE_17251_length_622_cov_1.735883_g15942_i0 PRJNA789095 17251 622 1.735883 10.79719226 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 641 2.8799999999999992e-179   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g15942 i0 94.076 0.678456591639871 422 25 68 0 1 422 2122 2543 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 422 641 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
13525275 13525275 PRJNA789095_P_NODE_71331_length_245_cov_2.866279_g69997_i0 PRJNA789095 71331 245 2.866279 7.02238355 Caudoviricetes sp. 2832643 Viruses Viruses 52.8 0.022   NTclustered gi|2054759203|tpg|BK043588.1| 2832643 g69997 i0 100 0.114285714285714 28 0 11 0 5 32 2655 2628 MAG TPA_asm: Caudoviricetes sp. isolate ctBlH5, partial genome blastn 28 52.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
14799037 14799037 PRJNA789095_P_NODE_34112_length_353_cov_1.375000_g32778_i0 PRJNA789095 34112 353 1.375 4.85375 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 383 1.0399999999999998e-101   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g32778 i0 92.509 0.756373937677054 267 20 76 0 11 277 1708 1442 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 267 383 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
15242909 15242909 PRJNA789095_P_NODE_63572_length_255_cov_3.961538_g62238_i0 PRJNA789095 63572 255 3.961538 10.1019219 Betacoronavirus 694002 Viruses Viruses 52.8 0.023   NTclustered gi|2054802766|tpg|BK050147.1| 38018 g62238 i0 100 0.231372549019608 28 0 11 0 228 255 31 4 MAG TPA_asm: Bacteriophage sp. isolate ctpiZ7, partial genome blastn 59 52.8 1 Viruses               Bacteriophage sp.
16073875 16073875 PRJNA789095_P_NODE_64373_length_254_cov_1.243094_g63039_i0 PRJNA789095 64373 254 1.243094 3.15745876 brine shrimp yue-like virus 3 2900455 Viruses Viruses 464 2.4999999999999994e-126   NTclustered gi|2209094280|gb|OL472816.1| 2900455 g63039 i0 99.606 4 254 1 100 0 1 254 728 981 MAG: Brine shrimp yue-like virus 3 isolate 02/QH/92-02 segment 1 RNA-dependent RNA polymerase gene, complete cds blastn 1016 464 1 Viruses   Orthornavirae Negarnaviricota Yunchangviricetes Goujianvirales Yueviridae   brine shrimp yue-like virus 3
16074010 16074010 PRJNA789095_P_NODE_69113_length_248_cov_0.880000_g67779_i0 PRJNA789095 69113 248 0.88 2.1824 Caudoviricetes sp. 2832643 Viruses Viruses 424 4.13e-114   NTclustered gi|2057112422|tpg|BK038543.1| 2832643 g67779 i0 97.581 9.73387096774194 248 5 100 1 1 248 56783 56537 MAG TPA_asm: Caudoviricetes sp. isolate ct8461, partial genome blastn 2414 424 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
17349836 17349836 PRJNA789095_P_NODE_71914_length_245_cov_0.895349_g70580_i0 PRJNA789095 71914 245 0.895349 2.19360505 Caudoviricetes sp. 2832643 Viruses Viruses 442 1.1199999999999994e-119   NTclustered gi|2052998103|tpg|BK030969.1| 2832643 g70580 i0 99.184 456.89387755102 245 2 100 0 1 245 283 39 MAG TPA_asm: Caudoviricetes sp. isolate ctdoP9, partial genome blastn 111939 442 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
18622051 18622051 PRJNA789095_P_NODE_39055_length_321_cov_1.870968_g37721_i0 PRJNA789095 39055 321 1.870968 6.00580728 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 318 2.69e-82   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g37721 i0 90.456 0.750778816199377 241 23 75 0 1 241 4435 4195 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 241 318 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
19066238 19066238 PRJNA789095_P_NODE_66455_length_250_cov_3.598870_g65121_i0 PRJNA789095 66455 250 3.59887 8.997175 Pahexavirus 1982251 Viruses Viruses 374 4.2499999999999986e-99   NTclustered gi|543171355|ref|NC_022336.1| 1235645 g65121 i0 93.927 93.476 247 15 99 0 1 247 10287 10041 Propionibacterium phage PHL010M04, complete genome blastn 23369 374 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Pahexavirus Pahexavirus PHL151N00
19896688 19896688 PRJNA789095_P_NODE_13156_length_796_cov_3.825726_g11930_i0 PRJNA789095 13156 796 3.825726 30.45277896 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1107 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g11930 i0 91.698 0.998743718592965 795 66 99 0 2 796 6912 6118 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 795 1107 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
19896769 19896769 PRJNA789095_P_NODE_16496_length_646_cov_2.369983_g15190_i0 PRJNA789095 16496 646 2.369983 15.31009018 brine shrimp chuvirus 1 2900479 Viruses Viruses 97.1 2.93e-15   NTclustered gi|2177952885|gb|OL452274.1| 2900479 g15190 i0 91.429 0.541795665634675 70 6 11 0 577 646 7030 7099 MAG: Brine shrimp chuvirus 1 isolate YC/91, complete genome blastn 350 97.1 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae   brine shrimp chuvirus 1
19896915 19896915 PRJNA789095_P_NODE_22216_length_496_cov_2.706856_g20887_i0 PRJNA789095 22216 496 2.706856 13.42600576 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 706 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g20887 i0 92.51 0.995967741935484 494 35 99 2 4 496 5996 5504 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 494 706 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
19896937 19896937 PRJNA789095_P_NODE_23156_length_478_cov_2.407407_g21826_i0 PRJNA789095 23156 478 2.407407 11.50740546 Caudoviricetes sp. 2832643 Viruses Viruses 721 0   NTclustered gi|2054434277|tpg|BK035998.1| 2832643 g21826 i0 95.565 353.941422594142 451 18 94 2 29 478 17758 18207 MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome blastn 169184 721 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
24998145 24998145 PRJNA789095_P_NODE_76760_length_237_cov_3.579268_g75426_i0 PRJNA789095 76760 237 3.579268 8.48286516 Caudoviricetes sp. 2832643 Viruses Viruses 433 6.5e-117   NTclustered gi|2915051030|gb|OR222847.1| 2832643 g75426 i0 99.578 12.7299578059072 237 1 100 0 1 237 72672 72436 MAG: Caudoviricetes sp. isolate MSP0502 genomic sequence blastn 3017 433 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes 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);;