metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA641707" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA641707" and tax_phylum = "Nucleocytoviricota"

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
26701122	26701122	PRJNA641707_P_NODE_244721_length_184_cov_7.844444_g242058_i0	PRJNA641707	244721	184	7.844444	14.43377696	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	58.5	4.36e-8	NR	YP_010803558.1	3060017	g242058	i0	60.5	0.701086956521739	43	17	70.1	0	24	152	571	613	YP_010803558.1 glucosamine-fructose-6-phosphate aminotransferase [Fadolivirus algeromassiliense]	diamond	129	58.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
27472749	27472749	PRJNA641707_P_NODE_136783_length_242_cov_14.098446_g134120_i0	PRJNA641707	136783	242	14.098446	34.11823932	Orthopoxvirus	10242	Viruses	Viruses	73.9	3.76e-13	NR	WBA78916.1	10244	g134120	i0	100	12.6570247933884	33	0	40.9	0	240	142	659	691	WBA78916.1 mRNA capping enzyme large subunit [Monkeypox virus]	diamond	3063	73.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Orthopoxvirus	Orthopoxvirus monkeypox
27776367	27776367	PRJNA641707_P_NODE_90784_length_246_cov_5.588832_g88121_i0	PRJNA641707	90784	246	5.588832	13.74852672	Barrevirus sp.	2487763	Viruses	Viruses	50.4	6.99e-5	NR	AYV77263.1	2487763	g88121	i0	33.8	1.95121951219512	80	52	96.3	1	9	245	174	253	AYV77263.1 MAG: DUF4419 domain-containing protein [Barrevirus sp.]	diamond	480	50.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Barrevirus sp.
29796713	29796713	PRJNA641707_P_NODE_269131_length_174_cov_8.912000_g266468_i0	PRJNA641707	269131	174	8.912	15.50688	Catovirus sp. 'naegleriensis'	3072188	Viruses	Viruses	60.5	8.45e-9	NR	CAK7596783.1	3072188	g266468	i0	47.3	0.948275862068966	55	29	94.8	0	7	171	698	752	CAK7596783.1 Glycosyltransferase 2-like domain containing-protein [Catovirus sp. 'naegleriensis']	diamond	165	60.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus sp. 'naegleriensis'
30334350	30334350	PRJNA641707_P_NODE_278692_length_171_cov_2.377049_g276029_i0	PRJNA641707	278692	171	2.377049	4.06475379	Klosneuvirus KNV1	1977640	Viruses	Viruses	53.9	1.37e-6	NR	ARF12509.1	1977640	g276029	i0	49	0.894736842105263	51	26	89.5	0	161	9	86	136	ARF12509.1 stomatin family protein [Klosneuvirus KNV1]	diamond	153	53.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
32167859	32167859	PRJNA641707_P_NODE_50918_length_302_cov_5.490119_g48260_i0	PRJNA641707	50918	302	5.490119	16.58015938	Edafosvirus sp.	2487765	Viruses	Viruses	45.1	0.0107	NR	AYV78808.1	2487765	g48260	i0	54.8	0.30794701986755	31	14	30.8	0	300	208	178	208	AYV78808.1 MAG: hypothetical protein Edafosvirus35_5 [Edafosvirus sp.]	diamond	93	45.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Edafosvirus 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);;