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

5 rows where analysis = "diamond", bioproject = "PRJNA692200" 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_family	tax_genus	tax_species
27367337	27367337	PRJNA692200_S_NODE_13603_length_196_cov_1.394558_g13546_i0	PRJNA692200	13603	196	1.394558	2.73333368	Podoviridae sp. ctbj_2	2675442	Viruses	Viruses	52	9.02e-6	NR	AXH71985.1	2675442	g13546	i0	56	2.31122448979592	50	22	76.5	0	188	39	42	91	AXH71985.1 MAG: type I restriction enzyme EcoKI subunit R [Podoviridae sp. ctbj_2]	diamond	453	52	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Zobellviridae		Podoviridae sp. ctbj_2
28850814	28850814	PRJNA692200_S_NODE_10888_length_215_cov_4.915663_g10831_i0	PRJNA692200	10888	215	4.915663	10.56867545	Prokaryotic dsDNA virus sp.	2591644	Viruses	Viruses	42.4	0.0201	NR	QDP53382.1	2591644	g10831	i0	47.1	0.711627906976744	51	26	69.8	1	213	64	101	151	QDP53382.1 MAG: hypothetical protein Unbinned6805contig1000_44 [Prokaryotic dsDNA virus sp.]	diamond	153	42.4	1	Viruses						Prokaryotic dsDNA virus sp.
30536231	30536231	PRJNA692200_S_NODE_4093_length_309_cov_7.900000_g4036_i0	PRJNA692200	4093	309	7.9	24.411	Paundecimvirus	2842942	Viruses	Viruses	122	2.2299999999999996e-31	NR	YP_009304488.1	1784982	g4036	i0	83.1	2.06796116504854	71	12	68.9	0	244	32	1	71	YP_009304488.1 putative capsid protein [Pseudomonas phage O4]	diamond	639	123	0.991869918699187	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Zobellviridae	Paundecimvirus	Pseudomonas phage O4
30746092	30746092	PRJNA692200_S_NODE_12374_length_204_cov_1.322581_g12317_i0	PRJNA692200	12374	204	1.322581	2.69806524	Prunus yellow spot-associated virus	2600310	Viruses	Viruses	69.3	1.3e-12	NR	QED94455.1	2600310	g12317	i0	66.7	0.661764705882353	45	15	66.2	0	1	135	135	179	QED94455.1 coat protein [Prunus yellow spot-associated virus]	diamond	135	69.3	1	Viruses						Prunus yellow spot-associated virus
32548950	32548950	PRJNA692200_S_NODE_11919_length_207_cov_2.107595_g11862_i0	PRJNA692200	11919	207	2.107595	4.36272165	Prokaryotic dsDNA virus sp.	2591644	Viruses	Viruses	102	2.68e-23	NR	QDP53377.1	2591644	g11862	i0	74.1	3.44927536231884	58	15	84.1	0	12	185	458	515	QDP53377.1 MAG: putative terminase large subunit [Prokaryotic dsDNA virus sp.]	diamond	714	102	1	Viruses						Prokaryotic dsDNA virus sp.

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