RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB20058" 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

  • PRJEB20058 · 6 ✖

analysis 1

  • diamond · 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
26329952 26329952 PRJEB20058_P_NODE_1199_length_4958_cov_18.301613_g932_i0 PRJEB20058 1199 4958 18.301613 907.39397254 Viruses 10239 Viruses Viruses 526 7.310000000000001e-154   NR XCO48968.1 1955144 g932 i0 51.7 3.25413473174667 489 234 29.5 2 4947 3487 1241 1729 XCO48968.1 MAG: putative ORF1 protein [Dicistroviridae sp.] diamond 16134 528 0.996212121212121 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
32962935 32962935 PRJEB20058_P_NODE_60458_length_539_cov_2.054393_g57698_i0 PRJEB20058 60458 539 2.054393 11.07317827 Equine rhinitis B virus 1 47001 Viruses Viruses 58.5 2.01e-6   NR NP_740368.1 47001 g57698 i0 31.3 2.13729128014842 128 71 69 2 13 384 272 386 NP_740368.1 3D (RNA polymerase) [Equine rhinitis B virus 1] diamond 1152 58.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Erbovirus Erbovirus aequirhi
32979963 32979963 PRJEB20058_P_NODE_5459_length_1880_cov_276.865860_g4516_i0 PRJEB20058 5459 1880 276.86586 5205.078168 Qianjiang picorna-like virus 21 3348746 Viruses Viruses 123 6.08e-25   NR XHA88474.1 3348746 g4516 i0 28.3 0.552127659574468 346 238 54.7 6 1849 821 2428 2766 XHA88474.1 MAG: polyprotein [Qianjiang picorna-like virus 21] diamond 1038 123 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 21
33059575 33059575 PRJEB20058_P_NODE_5733_length_1820_cov_12.065378_g4749_i0 PRJEB20058 5733 1820 12.065378 219.5898796 Viruses 10239 Viruses Viruses 116 7.42e-23   NR WFS39126.1 3038626 g4749 i0 26.9 1.72912087912088 350 195 56.7 9 759 1790 65 359 WFS39126.1 MAG: putative replicase polyprotein [StochSRVP_1 picorna-like virus] diamond 3147 116 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   StochSRVP_1 picorna-like virus
33065274 33065274 PRJEB20058_P_NODE_8621_length_1433_cov_44.546647_g7316_i0 PRJEB20058 8621 1433 44.546647 638.35345151 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 245 2.2799999999999999e-69   NR QDH87375.1 3003959 g7316 i0 37.9 3.28053035589672 398 230 81.9 10 1411 239 334 721 QDH87375.1 MAG: hypothetical protein H3RhizoLitter1458_000001 [Picornavirales sp.] diamond 4701 245 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
33161801 33161801 PRJEB20058_P_NODE_188976_length_266_cov_3.121951_g186152_i0 PRJEB20058 188976 266 3.121951 8.30438966 Durnavirales 2732549 Viruses Viruses 125 1.45e-33   NR AIS37549.1 1551557 g186152 i0 80 2.75187969924812 80 16 90.2 0 26 265 148 227 AIS37549.1 hypothetical protein, partial [Valsa cypri partitivirus] diamond 732 125 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Valsa cypri partitivirus

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