RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB76780" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 6 ✖

tax_clade 1

bioproject 1

  • PRJEB76780 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
19264295 19264295 PRJEB76780_P_NODE_2956_length_477_cov_3.242574_g2856_i0 PRJEB76780 2956 477 3.242574 15.46707798 Harvfovirus sp. 2487768 Viruses Viruses 120 2.2799999999999997e-31   NR AYV81692.1 2487768 g2856 i0 42.6 1.67295597484277 141 80 88.7 1 36 458 13 152 AYV81692.1 MAG: putative eukaryotic translation initiation factor 5A-1 [Harvfovirus sp.] diamond 798 120 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Harvfovirus sp.
26590751 26590751 PRJEB76780_P_NODE_10161_length_254_cov_1.386740_g10061_i0 PRJEB76780 10161 254 1.38674 3.5223196 Prokaryotic dsDNA virus sp. 2591644 Viruses Viruses 84.3 1.67e-18   NR QDP66566.1 2591644 g10061 i0 51.2 0.992125984251969 84 38 95.7 1 245 3 16 99 QDP66566.1 MAG: hypothetical protein Tp1111DCM1126091_72 [Prokaryotic dsDNA virus sp.] diamond 252 84.3 1 Viruses               Prokaryotic dsDNA virus sp.
26685923 26685923 PRJEB76780_P_NODE_12301_length_246_cov_0.901734_g12201_i0 PRJEB76780 12301 246 0.901734 2.21826564 uncultured Caudovirales phage 2100421 Viruses Viruses 91.3 9e-20   NR CAB4159274.1 2100421 g12201 i0 56.1 1 82 35 100 1 1 246 202 282 CAB4159274.1 LGT_TIGR03299, phage/plasmid-like protein TIGR03299 [uncultured Caudovirales phage] diamond 246 91.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
27918600 27918600 PRJEB76780_P_NODE_8365_length_280_cov_1.468599_g8265_i0 PRJEB76780 8365 280 1.468599 4.1120772 Prokaryotic dsDNA virus sp. 2591644 Viruses Viruses 164 5.21e-47   NR QDP66582.1 2591644 g8265 i0 77.4 0.996428571428571 93 21 99.6 0 280 2 97 189 QDP66582.1 MAG: putative terminase large subunit [Prokaryotic dsDNA virus sp.] diamond 279 164 1 Viruses               Prokaryotic dsDNA virus sp.
28676584 28676584 PRJEB76780_P_NODE_1327_length_718_cov_2.486822_g1234_i0 PRJEB76780 1327 718 2.486822 17.85538196 Solumvirus sp. 2487773 Viruses Viruses 206 3.6100000000000003e-63   NR AYV86227.1 2487773 g1234 i0 68.4 0.647632311977716 155 49 64.8 0 671 207 28 182 AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] diamond 465 206 1 Viruses Pithoviruses             Solumvirus sp.
30792484 30792484 PRJEB76780_P_NODE_12594_length_245_cov_0.906977_g12494_i0 PRJEB76780 12594 245 0.906977 2.22209365 Harvfovirus sp. 2487768 Viruses Viruses 57.8 1.89e-7   NR AYV81013.1 2487768 g12494 i0 60 0.489795918367347 40 16 49 0 6 125 362 401 AYV81013.1 MAG: SPFH domain / Band 7 domain containing protein [Harvfovirus sp.] diamond 120 57.8 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Harvfovirus sp.

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