metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA438572" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA438572" 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
26822967	26822967	PRJNA438572_P_NODE_12481_length_292_cov_0.963470_g12362_i0	PRJNA438572	12481	292	0.96347	2.8133324	Chlorovirus sp.	2809302	Viruses	Viruses	57	6.44e-7	NR	XOK29430.1	2809302	g12362	i0	51	0.503424657534247	49	23	49.3	1	2	145	282	330	XOK29430.1 Mastigoneme-like protein [Chlorovirus sp.]	diamond	147	57	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Chlorovirus	Chlorovirus sp.
29318017	29318017	PRJNA438572_P_NODE_20669_length_247_cov_1.758621_g20550_i0	PRJNA438572	20669	247	1.758621	4.34379387	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	110	2.3e-26	NR	YP_010803269.1	3060017	g20550	i0	60.5	0.983805668016194	81	32	98.4	0	243	1	222	302	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	243	110	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
29381250	29381250	PRJNA438572_P_NODE_7049_length_379_cov_2.941176_g6930_i0	PRJNA438572	7049	379	2.941176	11.14705704	Catovirus CTV1	1977631	Viruses	Viruses	86.3	1.11e-17	NR	ARF09195.1	1977631	g6930	i0	42.1	0.846965699208443	107	59	82.3	1	63	374	73	179	ARF09195.1 hypothetical protein Catovirus_2_144 [Catovirus CTV1]	diamond	321	86.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1
30707854	30707854	PRJNA438572_P_NODE_24514_length_242_cov_0.923077_g24395_i0	PRJNA438572	24514	242	0.923077	2.23384634	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	46.6	0.00162	NR	VBB18962.1	2420051	g24395	i0	31.4	2.25619834710744	70	44	86.8	1	242	33	232	297	VBB18962.1 phosphoribosylpyrophosphate synthetase [Yasminevirus sp. GU-2018]	diamond	546	46.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
32162573	32162573	PRJNA438572_P_NODE_8898_length_342_cov_1.059480_g8779_i0	PRJNA438572	8898	342	1.05948	3.6234216	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	95.1	2.7e-20	NR	YP_010803269.1	3060017	g8779	i0	62.3	0.605263157894737	69	26	60.5	0	341	135	346	414	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	207	95.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense

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