RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1113956" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 4 ✖

bioproject 1

  • PRJNA1113956 · 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
27289228 27289228 PRJNA1113956_P_NODE_2863_length_1094_cov_2.007835_g2643_i0 PRJNA1113956 2863 1094 2.007835 21.9657149 Ips erranti-like virus 2 3077407 Viruses Viruses 127 3.93e-28   NR WPV71155.1 3077407 g2643 i0 43.9 1.12705667276051 139 78 38.1 0 579 163 433 571 WPV71155.1 MAG: replicase [Ips erranti-like virus 2] diamond 1233 127 1 Viruses               Ips erranti-like virus 2
27605245 27605245 PRJNA1113956_P_NODE_4_length_6250_cov_12.862393_g2_i1 PRJNA1113956 4 6250 12.862393 803.8995625 Fadolivirus algeromassiliense 3060017 Viruses Viruses 52 0.0173   NR YP_010803132.1 3060017 g2 i1 24.5 0.1176 245 149 10.8 9 3300 2626 27 255 YP_010803132.1 soluble N-ethylmaleimide-sensitive factor [Fadolivirus algeromassiliense] diamond 735 52 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Fadolivirus Fadolivirus algeromassiliense
28584001 28584001 PRJNA1113956_P_NODE_20927_length_247_cov_0.885057_g20587_i0 PRJNA1113956 20927 247 0.885057 2.18609079 Stenotrophomonas phage BUCT626 2860376 Viruses Viruses 142 8.569999999999996e-42   NR YP_010677399.1 2860376 g20587 i0 78 0.995951417004049 82 18 99.6 0 2 247 2 83 YP_010677399.1 hypothetical protein PQD76_gp78 [Stenotrophomonas phage BUCT626] diamond 246 142 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Bixiavirus Bixiavirus BUCT626
32534273 32534273 PRJNA1113956_P_NODE_6719_length_617_cov_1.534926_g6394_i0 PRJNA1113956 6719 617 1.534926 9.47049342 Chicken virus mg4_23 2720901 Viruses Viruses 46.6 0.0287   NR QIR82199.1 2720901 g6394 i0 33.3 0.437601296596434 90 47 43.3 4 269 3 164 241 QIR82199.1 replication associated protein [Chicken virus mg4_2302] diamond 270 46.6 1 Viruses               Chicken virus mg4_2302

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