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

9 rows where analysis = "diamond", bioproject = "PRJNA1089179" and tax_superkingdom = "Viruses"

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
16320062	16320062	PRJNA1089179_P_NODE_12193_length_270_cov_1.969543_g12175_i0	PRJNA1089179	12193	270	1.969543	5.3177661	African cichlid piscichuvirus	3065075	Viruses	Viruses	85.1	6.59e-17	NR	WLN26256.1	3065075	g12175	i0	51.3	0.888888888888889	80	39	88.9	0	2	241	236	315	WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus]	diamond	240	85.1	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	African cichlid piscichuvirus
19320560	19320560	PRJNA1089179_P_NODE_16_length_2467_cov_3.189223_g13_i0	PRJNA1089179	16	2467	3.189223	78.67813141	Lake Sarah-associated circular molecule 8	1685733	Viruses	Viruses	363	3.17e-116	NR	ALE29550.1	1685733	g13	i0	62	0.975273611674098	266	100	32.3	1	145	942	3	267	ALE29550.1 replication associated protein [Lake Sarah-associated circular molecule 8]	diamond	2406	363	1	Viruses							Lake Sarah-associated circular molecule 8
27130339	27130339	PRJNA1089179_P_NODE_12962_length_263_cov_2.031579_g12944_i0	PRJNA1089179	12962	263	2.031579	5.34305277	Ariapismic virus 225	3376465	Viruses	Viruses	127	2.0699999999999998e-32	NR	XJW05418.1	3376465	g12944	i0	63.2	0.992395437262357	87	32	99.2	0	262	2	224	310	XJW05418.1 MAG: major capsid protein [Ariapismic virus 225]	diamond	261	127	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Ariapismic virus 225
27532888	27532888	PRJNA1089179_P_NODE_7843_length_321_cov_3.802419_g7825_i0	PRJNA1089179	7843	321	3.802419	12.20576499	Chuvivirus	2842604	Viruses	Viruses	139	2.12e-36	NR	WET19887.1	2842604	g7825	i0	64.2	1.98130841121495	106	38	99.1	0	2	319	249	354	WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1]	diamond	636	139	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Chuvivirus
28393904	28393904	PRJNA1089179_P_NODE_5166_length_377_cov_1.266447_g5148_i0	PRJNA1089179	5166	377	1.266447	4.77450519	Arizlama microvirus	2859450	Viruses	Viruses	116	9.33e-28	NR	QXP08659.1	2859450	g5148	i0	50.5	1.75862068965517	111	54	88.3	1	339	7	15	124	QXP08659.1 MAG: major capsid protein [Arizlama microvirus]	diamond	663	116	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Arizlama microvirus
28709902	28709902	PRJNA1089179_P_NODE_8847_length_307_cov_1.316239_g8829_i0	PRJNA1089179	8847	307	1.316239	4.04085373	Caudoviricetes sp.	2832643	Viruses	Viruses	52	1.98e-5	NR	XOQ93857.1	2832643	g8829	i0	52.4	0.41042345276873	42	20	41	0	304	179	127	168	XOQ93857.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	126	52	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
30975325	30975325	PRJNA1089179_P_NODE_9134_length_303_cov_1.517391_g9116_i0	PRJNA1089179	9134	303	1.517391	4.59769473	root	1	Root_unresolved	Root_unresolved	45.4	0.00118	NR	DAL85144.1	38018	g9116	i0	63.6	2.20792079207921	33	12	32.7	0	203	301	43	75	DAL85144.1 MAG TPA: hypothetical protein, partial [Bacteriophage sp.]	diamond	669	45.8	0.991266375545852	Viruses							Bacteriophage sp.
31110000	31110000	PRJNA1089179_P_NODE_8475_length_312_cov_1.757322_g8457_i0	PRJNA1089179	8475	312	1.757322	5.48284464	Arizlama microvirus	2859450	Viruses	Viruses	53.5	1.24e-5	NR	QXP08662.1	2859450	g8457	i0	40.9	0.634615384615385	66	39	63.5	0	311	114	308	373	QXP08662.1 MAG: replication initiator protein [Arizlama microvirus]	diamond	198	53.5	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Arizlama microvirus
31679285	31679285	PRJNA1089179_P_NODE_3297_length_446_cov_4.080429_g3279_i0	PRJNA1089179	3297	446	4.080429	18.19871334	African cichlid piscichuvirus	3065075	Viruses	Viruses	100	1.82e-21	NR	UVF58767.1	3065075	g3279	i0	39.9	1.02914798206278	153	87	99.6	2	2	445	2	154	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	diamond	459	100	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	African cichlid piscichuvirus

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