RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA608894" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA608894 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
584993 584993 PRJNA608894_P_NODE_16401_length_532_cov_1.919390_g15907_i0 PRJNA608894 16401 532 1.91939 10.2111548 Hordeum vulgare dicistro-like virus 1 2872415 Viruses Viruses 84.2 1.85e-11   NTclustered gi|2261582442|tpg|BK059252.1| 2872415 g15907 i0 94.444 0.206766917293233 54 3 10 0 1 54 350 403 TPA_asm: Hordeum vulgare dicistro-like virus 1 isolate Hv1 non-structural polyprotein gene, complete cds; and structural polyprotein gene, partial cds blastn 110 84.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Hordeum vulgare dicistro-like virus 1
4413492 4413492 PRJNA608894_P_NODE_62344_length_204_cov_4.129771_g61845_i0 PRJNA608894 62344 204 4.129771 8.42473284 Bundaberg bee virus 2 2201285 Viruses Viruses 241 3.54e-59   NTclustered gi|1390040422|gb|MG995700.1| 2201285 g61845 i0 90.426 0.92156862745098 188 11 90 7 17 199 7931 7746 Bundaberg bee virus 2 isolate QLD-4 nonstructural polyprotein gene, partial cds; and structural polyprotein gene, complete cds blastn 188 241 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Bundaberg bee virus 2
5689337 5689337 PRJNA608894_P_NODE_465_length_3739_cov_5.513366_g431_i0 PRJNA608894 465 3739 5.513366 206.14475474 Bemisia tabaci dicistro-like virus 1 2840019 Viruses Viruses 3011 0   NTclustered gi|2047377804|gb|MW256674.1| 2840019 g431 i0 94.516 1.90612463225461 1951 107 52 0 1789 3739 1 1951 Bemisia tabaci dicistro-like virus 1 isolate CAU-Q1 ORF1 gene, complete cds; and ORF2 gene, partial cds blastn 7127 3011 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Bemisia tabaci dicistro-like virus 1
13339889 13339889 PRJNA608894_P_NODE_56471_length_244_cov_1.964912_g55972_i0 PRJNA608894 56471 244 1.964912 4.79438528 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 350 6.969999999999998e-92   NTclustered gi|2214231615|gb|OM622294.1| 3003959 g55972 i0 92.917 1.97540983606557 240 17 98 0 5 244 8867 8628 MAG: Picornavirales sp. isolate HPLV-39 genomic sequence blastn 482 350 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
14614086 14614086 PRJNA608894_P_NODE_2012_length_2265_cov_5.244069_g1878_i0 PRJNA608894 2012 2265 5.244069 118.77816285 Bemisia tabaci dicistro-like virus 1 2840019 Viruses Viruses 3485 0   NTclustered gi|2047377804|gb|MW256674.1| 2840019 g1878 i0 94.437 2.90066225165563 2265 126 100 0 1 2265 1915 4179 Bemisia tabaci dicistro-like virus 1 isolate CAU-Q1 ORF1 gene, complete cds; and ORF2 gene, partial cds blastn 6570 3485 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Bemisia tabaci dicistro-like virus 1
20988299 20988299 PRJNA608894_P_NODE_917_length_3086_cov_5.810488_g857_i0 PRJNA608894 917 3086 5.810488 179.31165968 Bemisia tabaci dicistro-like virus 1 2840019 Viruses Viruses 4929 0   NTclustered gi|2047377804|gb|MW256674.1| 2840019 g857 i0 96.098 5.4598185353208 3024 117 98 1 1 3023 4178 7201 Bemisia tabaci dicistro-like virus 1 isolate CAU-Q1 ORF1 gene, complete cds; and ORF2 gene, partial cds blastn 16849 4929 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Bemisia tabaci dicistro-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);;