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

5 rows where analysis = "diamond", bioproject = "PRJNA540466" and tax_phylum = "Uroviricota"

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_family	tax_genus	tax_species
27819470	27819470	PRJNA540466_S_NODE_43144_length_281_cov_1.307692_g42595_i0	PRJNA540466	43144	281	1.307692	3.67461452	root	1	Root_unresolved	Root_unresolved	48.1	4.53e-4	NR	CAB4161111.1	2100421	g42595	i0	53.7	0.939501779359431	41	19	43.8	0	6	128	14	54	CAB4161111.1 AP2/ERF domain containing protein [uncultured Caudovirales phage]	diamond	264	48.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch
28246220	28246220	PRJNA540466_S_NODE_68206_length_228_cov_3.612903_g67657_i0	PRJNA540466	68206	228	3.612903	8.23741884	Caudoviricetes sp.	2832643	Viruses	Viruses	56.6	3.85e-7	NR	XOS08246.1	2832643	g67657	i0	76.7	0.394736842105263	30	7	39.5	0	157	68	568	597	XOS08246.1 MAG: hypothetical protein MSP0190_86 [Caudoviricetes sp.]	diamond	90	56.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
29698417	29698417	PRJNA540466_S_NODE_43350_length_280_cov_2.603865_g42801_i0	PRJNA540466	43350	280	2.603865	7.290822	Thermus phage YS4	2494333	Viruses	Viruses	130	5.429999999999998e-35	NR	AZU97632.1	2494333	g42801	i0	75.3	0.910714285714286	85	21	91.1	0	256	2	174	258	AZU97632.1 hypothetical protein PGDDIFCJ_00002 [Thermus phage YS40_Isch]	diamond	255	130	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Thermus phage YS40_Isch
30425817	30425817	PRJNA540466_S_NODE_38373_length_295_cov_2.427928_g37824_i0	PRJNA540466	38373	295	2.427928	7.1623876	Caudoviricetes sp.	2832643	Viruses	Viruses	88.6	2.95e-19	NR	XOR23641.1	2832643	g37824	i0	58	0.701694915254237	69	28	70.2	1	274	68	145	212	XOR23641.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	207	88.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
32858897	32858897	PRJNA540466_S_NODE_32940_length_315_cov_3.557851_g32391_i0	PRJNA540466	32940	315	3.557851	11.20723065	Salicola phage SCTP-2	2015814	Viruses	Viruses	43.9	0.0126	NR	ASV44391.1	2015814	g32391	i0	29.9	0.828571428571429	87	56	81	2	292	38	23	106	ASV44391.1 hypothetical protein PBI_SCTP2_376 [Salicola phage SCTP-2]	diamond	261	43.9	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Salicola phage SCTP-2

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