metadata: contig_metadata: 6 rows where bioproject = "PRJNA376117" and tax

6 rows where bioproject = "PRJNA376117" and tax_kingdom = "Bamfordvirae"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26790158	26790158	PRJNA376117_P_NODE_43321_length_242_cov_0.911243_g43019_i0	PRJNA376117	43321	242	0.911243	2.20520806	Pimephales minnow adintovirus	2609864	Viruses	Viruses	85.1	3.91e-18	NR	DBA50340.1	2609864	g43019	i0	50	2.97520661157025	80	40	99.2	0	1	240	74	153	DBA50340.1 MAG TPA_asm: PacK [Adintovirus pavo15764]	diamond	720	85.1	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Pimephales minnow adintovirus
27643772	27643772	PRJNA376117_P_NODE_43704_length_242_cov_0.911243_g43402_i0	PRJNA376117	43704	242	0.911243	2.20520806	Adintovirus bos4377	3115894	Viruses	Viruses	54.3	2.26e-6	NR	DBA50496.1	3115894	g43402	i0	43	0.979338842975207	79	45	97.9	0	1	237	73	151	DBA50496.1 MAG TPA_asm: Adintoc2 [Adintovirus bos4377]	diamond	237	54.3	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus bos4377
31370694	31370694	PRJNA376117_P_NODE_16336_length_340_cov_2.269663_g16034_i0	PRJNA376117	16336	340	2.269663	7.7168542	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	63.5	5.5e-9	NR	VBB18109.1	2420051	g16034	i0	56.3	0.847058823529412	48	19	42.4	1	144	1	358	403	VBB18109.1 Cytochrome b5-like heme/steroid binding domain [Yasminevirus sp. GU-2018]	diamond	288	63.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
31387773	31387773	PRJNA376117_P_NODE_34316_length_251_cov_0.865169_g34014_i0	PRJNA376117	34316	251	0.865169	2.17157419	Prasinovirus	181084	Viruses	Viruses	54.3	7.39e-7	NR	AET84477.1	754063	g34014	i0	44.2	4.49402390438247	43	24	51.4	0	105	233	3	45	AET84477.1 hypothetical protein OLOG_00011 [Ostreococcus lucimarinus virus OlV4]	diamond	1128	54.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Prasinovirus	Ostreococcus lucimarinus virus OlV4
31528733	31528733	PRJNA376117_P_NODE_27616_length_273_cov_2.560000_g27314_i0	PRJNA376117	27616	273	2.56	6.9888	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	54.7	1.01e-6	NR	YP_010803991.1	3060017	g27314	i0	39.7	0.802197802197802	73	43	80.2	1	259	41	1	72	YP_010803991.1 hypothetical protein QKU48_gp1108 [Fadolivirus algeromassiliense]	diamond	219	54.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
32414576	32414576	PRJNA376117_P_NODE_37819_length_247_cov_1.683908_g37517_i0	PRJNA376117	37819	247	1.683908	4.15925276	Terrestrivirus sp.	2487775	Viruses	Viruses	46.6	3.96e-4	NR	AYV76392.1	2487775	g37517	i0	52	0.607287449392713	50	22	58.3	1	235	92	1	50	AYV76392.1 MAG: hypothetical protein Terrestrivirus6_18 [Terrestrivirus sp.]	diamond	150	46.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.

Advanced export

JSON shape: default, array, newline-delimited

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