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

6 rows where analysis = "diamond", bioproject = "PRJNA825466" 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
27054526	27054526	PRJNA825466_P_NODE_15942_length_252_cov_2.335196_g15841_i0	PRJNA825466	15942	252	2.335196	5.88469392	Halorubrum phage GNf2	889959	Viruses	Viruses	77.8	4.35e-15	NR	AGF91222.1	889959	g15841	i0	75	0.523809523809524	44	11	52.4	0	120	251	118	161	AGF91222.1 hypothetical protein HAPG_00036 [Halorubrum phage GNf2]	diamond	132	77.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Thumleimavirales	Soleiviridae		Halorubrum phage GNf2
27117453	27117453	PRJNA825466_P_NODE_27942_length_242_cov_0.905325_g27841_i0	PRJNA825466	27942	242	0.905325	2.1908865	uncultured Caudovirales phage	2100421	Viruses	Viruses	46.6	2.6e-4	NR	CAB4140437.1	2100421	g27841	i0	54.3	0.570247933884298	46	19	54.5	1	240	109	50	95	CAB4140437.1 hypothetical protein UFOVP406_25 [uncultured Caudovirales phage]	diamond	138	46.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
30023045	30023045	PRJNA825466_P_NODE_28531_length_241_cov_0.916667_g28430_i0	PRJNA825466	28531	241	0.916667	2.20916747	Acinetobacter phage At2	3385009	Viruses	Viruses	151	1.67e-40	NR	XLQ30931.1	3385009	g28430	i0	86.3	2.98755186721992	80	11	99.6	0	240	1	359	438	XLQ30931.1 hypothetical protein NNFDKGAK_00074 [Acinetobacter phage At2]	diamond	720	151	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Acinetobacter phage At2
31128348	31128348	PRJNA825466_P_NODE_13695_length_265_cov_1.604167_g13594_i0	PRJNA825466	13695	265	1.604167	4.25104255	environmental Halophage eHP-3	1168831	Viruses	Viruses	112	1.13e-26	NR	AFH22611.1	1168832	g13594	i0	58.6	0.984905660377358	87	36	98.5	0	3	263	414	500	AFH22611.1 terminase [environmental Halophage eHP-30]	diamond	261	112	1	Viruses							environmental Halophage eHP-30
32466152	32466152	PRJNA825466_P_NODE_11479_length_278_cov_1.297561_g11378_i0	PRJNA825466	11479	278	1.297561	3.60721958	root	1	Root_unresolved	Root_unresolved	79.7	5.68e-15	NR	YP_007378996.1	1262528	g11378	i0	48.8	2.7841726618705	86	44	92.8	0	2	259	377	462	YP_007378996.1 DNA polymerase [Haloarcula vallismortis tailed virus 1]	diamond	774	79.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Thumleimavirales	Druskaviridae	Tredecimvirus	Tredecimvirus thailandense
32677958	32677958	PRJNA825466_P_NODE_3460_length_402_cov_1.537994_g3359_i0	PRJNA825466	3460	402	1.537994	6.18273588	Chuvivirus	2842604	Viruses	Viruses	175	2.64e-49	NR	UVF58769.1	2842604	g3359	i0	59	1	134	55	100	0	1	402	284	417	UVF58769.1 MAG: S protein [Salarius guttatus piscichuvirus]	diamond	402	175	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Chuvivirus

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