RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1120203" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1120203 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
28227664 28227664 PRJNA1120203_P_NODE_25126_length_487_cov_2.603865_g24113_i0 PRJNA1120203 25126 487 2.603865 12.68082255 Viruses 10239 Viruses Viruses 179 1.48e-48   NR AVM87226.1 2116158 g24113 i0 55.5 1.92197125256674 155 69 95.5 0 469 5 40 194 AVM87226.1 polyprotein [Zhejiang gunthers frog calicivirus 1] diamond 936 179 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zhejiang gunthers frog calicivirus 1
28459843 28459843 PRJNA1120203_P_NODE_68046_length_272_cov_1.889447_g67030_i0 PRJNA1120203 68046 272 1.889447 5.13929584 Zebrafish gut calicivirus RQ08 Viruses Viruses 67.4 1.15e-10   NR AVM87550.1 RQ08 g67030 i0 38.2 1.94117647058824 89 54 97.1 1 269 6 727 815 AVM87550.1 polyprotein, partial [Yancheng osbecks grenadier anchovy calicivirus] diamond 528 67.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
29533202 29533202 PRJNA1120203_P_NODE_73370_length_261_cov_1.212766_g72354_i0 PRJNA1120203 73370 261 1.212766 3.16531926 Zebrafish gut calicivirus RQ08 Viruses Viruses 88.2 5.03e-18   NR XBS25272.1 RQ08 g72354 i0 51.4 0.850574712643678 74 36 85.1 0 1 222 1543 1616 XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] diamond 222 88.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
31112503 31112503 PRJNA1120203_P_NODE_27055_length_463_cov_2.117949_g26041_i0 PRJNA1120203 27055 463 2.117949 9.80610387 Zebrafish gut calicivirus RQ08 Viruses Viruses 190 9.62e-53   NR XBS25272.1 RQ08 g26041 i0 59.9 0.98488120950324 152 61 98.5 0 458 3 1306 1457 XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] diamond 456 190 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus

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