RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA508758" 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

  • PRJNA508758 · 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
484372 484372 PRJNA508758_P_NODE_1801_length_1887_cov_6.003308_g1559_i0 PRJNA508758 1801 1887 6.003308 113.28242196 Picornaviridae sp. 1530251 Viruses Viruses 3450 0   NTclustered gi|2245485642|gb|ON161938.1| 1530251 g1559 i0 99.682 1.51033386327504 1886 6 99 0 2 1887 6258 4373 MAG: Picornaviridae sp. isolate 81b-k141_69037_2 RNA dependent RNA polymerase gene, partial cds; and capsid protein gene, complete cds blastn 2850 3450 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
484416 484416 PRJNA508758_P_NODE_21_length_7225_cov_36.531739_g13_i0 PRJNA508758 21 7225 36.531739 2639.41814275 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 2483 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g13 i0 91.812 0.65038062283737 1783 141 65 5 13 1792 7109 5329 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 4699 2483 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
484573 484573 PRJNA508758_P_NODE_3961_length_1258_cov_1.241350_g3461_i0 PRJNA508758 3961 1258 1.24135 15.616183 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 852 0   NTclustered gi|2754691796|gb|PP872666.1| 3003959 g3461 i0 78.985 2.64149443561208 1261 255 99 10 1 1256 4952 6207 MAG: Picornavirales sp. isolate TC-PLV-110 MR233-17E/426 genomic sequence blastn 3323 852 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
1760101 1760101 PRJNA508758_P_NODE_82022_length_245_cov_1.447674_g80974_i0 PRJNA508758 82022 245 1.447674 3.5468013 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 403 5.299999999999998e-108   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g80974 i0 96.327 1 245 9 100 0 1 245 6839 7083 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 245 403 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
8137920 8137920 PRJNA508758_P_NODE_71727_length_254_cov_4.961326_g70679_i0 PRJNA508758 71727 254 4.961326 12.60176804 Dicistroviridae sp. 1955144 Viruses Viruses 464 2.4999999999999994e-126   NTclustered gi|2196304120|gb|MZ679074.1| 1955144 g70679 i0 99.606 4.20866141732283 254 1 100 0 1 254 3958 4211 MAG: Dicistroviridae sp. isolate 165b-k141_223275 hypothetical protein 1 and hypothetical protein 2 genes, partial cds blastn 1069 464 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
11963021 11963021 PRJNA508758_P_NODE_10490_length_661_cov_2.469388_g9514_i0 PRJNA508758 10490 661 2.469388 16.32265468 Picornaviridae sp. 1530251 Viruses Viruses 1192 0   NTclustered gi|2245485642|gb|ON161938.1| 1530251 g9514 i0 99.242 9.1482602118003 660 5 99 0 2 661 3932 3273 MAG: Picornaviridae sp. isolate 81b-k141_69037_2 RNA dependent RNA polymerase gene, partial cds; and capsid protein gene, complete cds blastn 6047 1192 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
15138730 15138730 PRJNA508758_P_NODE_83512_length_244_cov_1.350877_g82464_i0 PRJNA508758 83512 244 1.350877 3.29613988 Picornavirales 464095 Viruses Viruses 446 8.639999999999999e-121   NTclustered gi|2245485642|gb|ON161938.1| 1530251 g82464 i0 99.59 6 244 1 100 0 1 244 1967 1724 MAG: Picornaviridae sp. isolate 81b-k141_69037_2 RNA dependent RNA polymerase gene, partial cds; and capsid protein gene, complete cds blastn 1464 446 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
17061687 17061687 PRJNA508758_P_NODE_14_length_8150_cov_10.687879_g7_i0 PRJNA508758 14 8150 10.687879 871.0621385 Zebrafish picornavirus 1 2304617 Viruses Viruses 13319 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g7 i0 96.162 3.04208588957055 8156 304 100 6 1 8150 8175 23 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 24793 13319 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
17062156 17062156 PRJNA508758_P_NODE_70214_length_257_cov_2.510870_g69166_i0 PRJNA508758 70214 257 2.51087 6.4529359 Zebrafish picornavirus 1 2304617 Viruses Viruses 448 2.5499999999999995e-121   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g69166 i0 98.054 3 257 5 100 0 1 257 4704 4448 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 771 448 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
21512587 21512587 PRJNA508758_P_NODE_30477_length_368_cov_1.793220_g29429_i0 PRJNA508758 30477 368 1.79322 6.5990496 Picornavirales 464095 Viruses Viruses 658 0   NTclustered gi|2245485642|gb|ON161938.1| 1530251 g29429 i0 98.913 5.51630434782609 368 4 100 0 1 368 1232 1599 MAG: Picornaviridae sp. isolate 81b-k141_69037_2 RNA dependent RNA polymerase gene, partial cds; and capsid protein gene, complete cds blastn 2030 658 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
23437005 23437005 PRJNA508758_P_NODE_3579_length_1334_cov_3.076923_g3123_i0 PRJNA508758 3579 1334 3.076923 41.04615282 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 1003 0   NTclustered gi|2214231615|gb|OM622294.1| 3003959 g3123 i0 80.27 0.999250374812594 1333 261 99 2 1 1332 7368 8699 MAG: Picornavirales sp. isolate HPLV-39 genomic sequence blastn 1333 1003 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
23437127 23437127 PRJNA508758_P_NODE_5399_length_1044_cov_7.892894_g7_i1 PRJNA508758 5399 1044 7.892894 82.40181336 Zebrafish picornavirus 1 2304617 Viruses Viruses 1797 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g7 i1 97.708 3.37164750957854 1047 21 100 1 1 1044 8175 7129 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 3520 1797 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
24710575 24710575 PRJNA508758_P_NODE_41460_length_324_cov_1.932271_g40412_i0 PRJNA508758 41460 324 1.932271 6.26055804 Freshwater macrophyte associated picorna-like virus 1 2946039 Viruses Viruses 521 1.9299999999999993e-143   NTclustered gi|2242598914|gb|ON125119.1| 2946039 g40412 i0 95.679 1 324 14 100 0 1 324 9416 9739 Freshwater macrophyte associated picorna-like virus 1 isolate P-N1_1, complete genome blastn 324 521 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Freshwater macrophyte associated picorna-like virus 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);;