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

5 rows where analysis = "diamond", bioproject = "PRJNA902515" 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
20372974	20372974	PRJNA902515_P_NODE_5976_length_324_cov_1.513944_g5953_i0	PRJNA902515	5976	324	1.513944	4.90517856	uncultured Caudovirales phage	2100421	Viruses	Viruses	170	1.51e-50	NR	CAB4194457.1	2100421	g5953	i0	69.4	1.24074074074074	134	13	98.1	2	7	324	1	134	CAB4194457.1 THY1 Predicted alternative thymidylate synthase [uncultured Caudovirales phage]	diamond	402	170	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch
26707363	26707363	PRJNA902515_P_NODE_15621_length_243_cov_0.917647_g15598_i0	PRJNA902515	15621	243	0.917647	2.22988221	Caudoviricetes sp.	2832643	Viruses	Viruses	48.9	2.53e-4	NR	DAX06098.1	2832643	g15598	i0	31.1	0.91358024691358	74	51	91.4	0	1	222	500	573	DAX06098.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	222	48.9	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
28389835	28389835	PRJNA902515_P_NODE_11846_length_251_cov_1.674157_g11823_i0	PRJNA902515	11846	251	1.674157	4.20213407	root	1	Root_unresolved	Root_unresolved	122	1.57e-30	NR	CAB4160849.1	2100421	g11823	i0	62.7	6.94422310756972	83	31	99.2	0	3	251	332	414	CAB4160849.1 Bacteriophage P22, Gp10, DNA-stabilising [uncultured Caudovirales phage]	diamond	1743	122	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch
28792589	28792589	PRJNA902515_P_NODE_4907_length_349_cov_1.130435_g4884_i0	PRJNA902515	4907	349	1.130435	3.94521815	Caudoviricetes sp.	2832643	Viruses	Viruses	181	1.15e-50	NR	DAE78039.1	2832643	g4884	i0	74.8	0.988538681948424	115	29	98.9	0	349	5	132	246	DAE78039.1 MAG TPA: anaerobic ribonucleoside triphosphate reductase [Caudoviricetes sp.]	diamond	345	181	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
29329477	29329477	PRJNA902515_P_NODE_14349_length_246_cov_0.901734_g14326_i0	PRJNA902515	14349	246	0.901734	2.21826564	uncultured Caudovirales phage	2100421	Viruses	Viruses	73.6	5.48e-13	NR	CAB4196507.1	2100421	g14326	i0	46.3	1	82	42	97.6	1	3	242	1752	1833	CAB4196507.1 hypothetical protein UFOVP1290_27 [uncultured Caudovirales phage]	diamond	246	73.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch

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