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

6 rows where analysis = "diamond", bioproject = "PRJNA489308" 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
17675757	17675757	PRJNA489308_P_NODE_31754_length_250_cov_0.870056_g31678_i0	PRJNA489308	31754	250	0.870056	2.17514	Catovirus sp. 'naegleriensis'	3072188	Viruses	Viruses	147	4.96e-39	NR	CAK7597324.1	3072188	g31678	i0	83.1	1.968	83	14	99.6	0	250	2	272	354	CAK7597324.1 Vesicle-fusing ATPase [Catovirus sp. 'naegleriensis']	diamond	492	147	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus sp. 'naegleriensis'
21499981	21499981	PRJNA489308_P_NODE_35777_length_245_cov_0.895349_g35701_i0	PRJNA489308	35777	245	0.895349	2.19360505	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	109	5.4e-26	NR	YP_010803343.1	3060017	g35701	i0	72.8	1.98367346938776	81	22	99.2	0	243	1	216	296	YP_010803343.1 inosine-5'-monophosphate dehydrogenase [Fadolivirus algeromassiliense]	diamond	486	109	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
27676852	27676852	PRJNA489308_P_NODE_15504_length_310_cov_1.565401_g15428_i0	PRJNA489308	15504	310	1.565401	4.8527431	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	116	1.9000000000000003e-28	NR	YP_010803269.1	3060017	g15428	i0	49.5	0.996774193548387	103	52	99.7	0	1	309	277	379	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	309	116	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
28766053	28766053	PRJNA489308_P_NODE_10527_length_350_cov_2.072202_g10451_i0	PRJNA489308	10527	350	2.072202	7.252707	Megaviricetes	2732523	Viruses	Viruses	92.8	3.5e-19	NR	YP_007676312.1	755272	g10451	i0	45.7	6.96	116	54	99.4	1	1	348	231	337	YP_007676312.1 heat shock protein 70 [Micromonas pusilla virus 12T]	diamond	2436	92.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Prasinovirus	Micromonas pusilla virus 12T
28939676	28939676	PRJNA489308_P_NODE_12848_length_329_cov_1.203125_g12772_i0	PRJNA489308	12848	329	1.203125	3.95828125	Orpheovirus IHUMI-LCC2	2023057	Viruses	Viruses	75.1	4.24e-13	NR	YP_009448666.1	2023057	g12772	i0	52.8	0.984802431610942	108	51	98.5	0	328	5	277	384	YP_009448666.1 Flotillin domain-containing protein [Orpheovirus IHUMI-LCC2]	diamond	324	75.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Orpheoviridae	Alphaorpheovirus	Alphaorpheovirus massiliense
29286754	29286754	PRJNA489308_P_NODE_26669_length_262_cov_2.037037_g26593_i0	PRJNA489308	26669	262	2.037037	5.33703694	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	67	1.88e-11	NR	YP_010804033.1	3060017	g26593	i0	42.4	0.973282442748092	85	49	97.3	0	2	256	61	145	YP_010804033.1 mitochondrial 18kda protein [Fadolivirus algeromassiliense]	diamond	255	67	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);;