RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA609258" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA609258 · 15 ✖

analysis 1

  • blastn · 15 ✖

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
3138521 3138521 PRJNA609258_P_NODE_47763_length_258_cov_1.940541_g47378_i0 PRJNA609258 47763 258 1.940541 5.00659578 Apis cripavirus 2873540 Viruses Viruses 457 4.26e-124   NTclustered gi|2111829803|gb|MZ822074.1| 2873540 g47378 i0 98.828 3.96899224806202 256 3 99 0 3 258 3211 2956 MAG: Apis cripavirus isolate No8-AM-LN-2017-11, complete genome blastn 1024 457 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Apis cripavirus
5691150 5691150 PRJNA609258_P_NODE_44385_length_272_cov_1.547739_g44000_i0 PRJNA609258 44385 272 1.547739 4.20985008 Bactrocera dorsalis cripavirus isolate Bl 2933662 Viruses Viruses 433 7.63e-117   NTclustered gi|2232978153|gb|MW310363.1| 2933662 g44000 i0 95.556 6.9375 270 12 99 0 3 272 7988 7719 MAG: Bactrocera dorsalis cripavirus isolate Bl isolate Bl-V1, complete genome blastn 1887 433 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Bactrocera dorsalis cripavirus isolate Bl
6964933 6964933 PRJNA609258_P_NODE_18946_length_439_cov_1.207650_g18562_i0 PRJNA609258 18946 439 1.20765 5.3015835 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 265 5.01e-66   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g18562 i0 94.22 0.514806378132118 173 10 51 0 267 439 1708 1536 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 226 265 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
8239623 8239623 PRJNA609258_P_NODE_17847_length_453_cov_1.668421_g17463_i0 PRJNA609258 17847 453 1.668421 7.55794713 Apis cripavirus 2873540 Viruses Viruses 815 0   NTclustered gi|2111829803|gb|MZ822074.1| 2873540 g17463 i0 99.117 7 453 4 100 0 1 453 3831 3379 MAG: Apis cripavirus isolate No8-AM-LN-2017-11, complete genome blastn 3171 815 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Apis cripavirus
9514831 9514831 PRJNA609258_P_NODE_14108_length_515_cov_1.970588_g13726_i0 PRJNA609258 14108 515 1.970588 10.1485282 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 763 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g13726 i0 93.398 1 515 34 100 0 1 515 6616 6102 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 515 763 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
12065839 12065839 PRJNA609258_P_NODE_14850_length_501_cov_1.245327_g14468_i0 PRJNA609258 14850 501 1.245327 6.23908827 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 693 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g14468 i0 91.633 1.00199600798403 502 41 100 1 1 501 5433 5934 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 502 693 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
12065873 12065873 PRJNA609258_P_NODE_15850_length_483_cov_2.160976_g15467_i0 PRJNA609258 15850 483 2.160976 10.43751408 Bactrocera dorsalis cripavirus isolate Bl 2933662 Viruses Viruses 754 0   NTclustered gi|2232978153|gb|MW310363.1| 2933662 g15467 i0 94.824 5.86749482401656 483 25 100 0 1 483 8064 8546 MAG: Bactrocera dorsalis cripavirus isolate Bl isolate Bl-V1, complete genome blastn 2834 754 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Bactrocera dorsalis cripavirus isolate Bl
12065874 12065874 PRJNA609258_P_NODE_15870_length_483_cov_1.590244_g15467_i1 PRJNA609258 15870 483 1.590244 7.68087852 Bactrocera dorsalis cripavirus isolate Bl 2933662 Viruses Viruses 754 0   NTclustered gi|2232978153|gb|MW310363.1| 2933662 g15467 i1 94.824 5.86749482401656 483 25 100 0 1 483 8064 8546 MAG: Bactrocera dorsalis cripavirus isolate Bl isolate Bl-V1, complete genome blastn 2834 754 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Bactrocera dorsalis cripavirus isolate Bl
13341437 13341437 PRJNA609258_P_NODE_40391_length_288_cov_2.279070_g40006_i0 PRJNA609258 40391 288 2.27907 6.5637216 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 381 2.9899999999999995e-101   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g40006 i0 90.526 0.989583333333333 285 27 99 0 1 285 6672 6956 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 285 381 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
14617186 14617186 PRJNA609258_P_NODE_92_length_2807_cov_2.869788_g82_i0 PRJNA609258 92 2807 2.869788 80.55494916 Bactrocera dorsalis cripavirus 2739222 Viruses Viruses 4375 0   NTclustered gi|1847622119|gb|MN738553.1| 2739222 g82 i0 94.799 21.4641966512291 2807 146 100 0 1 2807 6291 9097 Bactrocera dorsalis cripavirus, complete genome blastn 60250 4375 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Bactrocera dorsalis cripavirus
15889300 15889300 PRJNA609258_P_NODE_1173_length_1531_cov_3.074074_g1068_i0 PRJNA609258 1173 1531 3.074074 47.06407294 Bactrocera dorsalis partiti-like virus 2 2933675 Viruses Viruses 2601 0   NTclustered gi|2232976385|gb|MW310330.1| 2933675 g1068 i0 97.322 2.99738732854344 1531 41 100 0 1 1531 1563 33 MAG: Bactrocera dorsalis partiti-like virus 2 isolate CQ-Bd-V12, complete genome blastn 4589 2601 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Bactrocera dorsalis partiti-like virus 2
18438778 18438778 PRJNA609258_P_NODE_22615_length_398_cov_2.003077_g22231_i0 PRJNA609258 22615 398 2.003077 7.97224646 Bactrocera dorsalis cripavirus isolate Bl 2933662 Viruses Viruses 652 0   NTclustered gi|2232978153|gb|MW310363.1| 2933662 g22231 i0 96.231 5.37939698492462 398 15 100 0 1 398 8680 9077 MAG: Bactrocera dorsalis cripavirus isolate Bl isolate Bl-V1, complete genome blastn 2141 652 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Bactrocera dorsalis cripavirus isolate Bl
18440153 18440153 PRJNA609258_P_NODE_8055_length_694_cov_1.381643_g7690_i0 PRJNA609258 8055 694 1.381643 9.58860242 Bactrocera dorsalis cripavirus isolate Bl 2933662 Viruses Viruses 1136 0   NTclustered gi|2232978153|gb|MW310363.1| 2933662 g7690 i0 96.248 5.98703170028818 693 26 99 0 2 694 7631 6939 MAG: Bactrocera dorsalis cripavirus isolate Bl isolate Bl-V1, complete genome blastn 4155 1136 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Bactrocera dorsalis cripavirus isolate Bl
20989022 20989022 PRJNA609258_P_NODE_20037_length_425_cov_2.508523_g19653_i0 PRJNA609258 20037 425 2.508523 10.66122275 Apis cripavirus 2873540 Viruses Viruses 769 0   NTclustered gi|2111829803|gb|MZ822074.1| 2873540 g19653 i0 99.294 6.95764705882353 425 3 100 0 1 425 3942 4366 MAG: Apis cripavirus isolate No8-AM-LN-2017-11, complete genome blastn 2957 769 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Apis cripavirus
20989232 20989232 PRJNA609258_P_NODE_2537_length_1170_cov_1.286235_g2335_i0 PRJNA609258 2537 1170 1.286235 15.0489495 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 749 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g2335 i0 93.137 0.675213675213675 510 35 68 0 515 1024 4704 4195 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 790 749 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);;