metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA752572" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA752572" 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
3753062	3753062	PRJNA752572_P_NODE_12323_length_745_cov_6.233803_g11951_i0	PRJNA752572	12323	745	6.233803	46.44183235	Terrestrivirus sp.	2487775	Viruses	Viruses	224	5.64e-69	NR	AYV76217.1	2487775	g11951	i0	46	1.01476510067114	252	125	98.3	6	732	1	43	291	AYV76217.1 MAG: DUF3050 domain-containing protein [Terrestrivirus sp.]	diamond	756	224	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
26926315	26926315	PRJNA752572_P_NODE_3742_length_1174_cov_2.842845_g3544_i0	PRJNA752572	3742	1174	2.842845	33.3750003	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	458	5.7599999999999986e-157	NR	YP_010803269.1	3060017	g3544	i0	66.8	0.830494037478705	325	107	83	1	1172	198	91	414	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	975	458	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
27274154	27274154	PRJNA752572_P_NODE_236263_length_172_cov_2.591241_g235756_i0	PRJNA752572	236263	172	2.591241	4.45693452	Mimivirus LCMiAC	2506609	Viruses	Viruses	47.8	2.43e-4	NR	QBK89257.1	2506609	g235756	i0	39.3	0.976744186046512	56	33	97.7	1	1	168	257	311	QBK89257.1 MAG: protein phosphatase 2C [Mimivirus LCMiAC02]	diamond	168	47.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Mimivirus LCMiAC02
27874129	27874129	PRJNA752572_P_NODE_90085_length_285_cov_3.144000_g89578_i0	PRJNA752572	90085	285	3.144	8.9604	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	112	7.12e-27	NR	YP_010803269.1	3060017	g89578	i0	59.8	0.863157894736842	82	33	86.3	0	251	6	8	89	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	246	112	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
29800047	29800047	PRJNA752572_P_NODE_2151_length_1394_cov_4.524650_g2004_i0	PRJNA752572	2151	1394	4.52465	63.073621	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	398	3.5799999999999987e-132	NR	YP_010803269.1	3060017	g2004	i0	48.1	0.871592539454806	405	208	87.2	2	1359	145	11	413	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	1215	398	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
31000850	31000850	PRJNA752572_P_NODE_63994_length_341_cov_1.745098_g63487_i0	PRJNA752572	63994	341	1.745098	5.95078418	Klosneuvirus KNV1	1977640	Viruses	Viruses	86.3	5.45e-17	NR	ARF11468.1	1977640	g63487	i0	38.5	0.914956011730205	104	61	91.5	1	339	28	64	164	ARF11468.1 deoxyribodipyrimidine photolyase [Klosneuvirus KNV1]	diamond	312	86.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
31126745	31126745	PRJNA752572_P_NODE_240075_length_171_cov_2.036765_g239568_i0	PRJNA752572	240075	171	2.036765	3.48286815	Dishui Lake phycodnavirus 4	2704072	Viruses	Viruses	73.2	2.42e-13	NR	QIG59965.1	2704072	g239568	i0	64.7	0.894736842105263	51	18	89.5	0	1	153	351	401	QIG59965.1 ornithine decarboxylase [Dishui Lake phycodnavirus 4]	diamond	153	73.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae		Dishui Lake phycodnavirus 4
32075995	32075995	PRJNA752572_P_NODE_123698_length_241_cov_3.082524_g123191_i0	PRJNA752572	123698	241	3.082524	7.42888284	Megaviridae environmental sample	1737588	Viruses	Viruses	45.1	0.00221	NR	QFG74487.1	1737588	g123191	i0	51.2	0.535269709543568	43	20	53.5	1	209	81	101	142	QFG74487.1 MAG: hypothetical protein [Megaviridae environmental sample]	diamond	129	45.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Megaviridae environmental sample
32550917	32550917	PRJNA752572_P_NODE_29199_length_505_cov_1.261702_g28721_i0	PRJNA752572	29199	505	1.261702	6.3715951	Klosneuvirus KNV1	1977640	Viruses	Viruses	85.1	2.07e-16	NR	ARF12509.1	1977640	g28721	i0	31.1	0.992079207920792	167	115	99.2	0	502	2	78	244	ARF12509.1 stomatin family protein [Klosneuvirus KNV1]	diamond	501	85.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1

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