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

5 rows where analysis = "diamond", bioproject = "PRJNA495917" 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
26601935	26601935	PRJNA495917_S_NODE_3361_length_267_cov_3.685345_g3167_i0	PRJNA495917	3361	267	3.685345	9.83987115	Aegean partiti-like virus	2912685	Viruses	Viruses	79	8.73e-15	NR	DAZ87271.1	2912685	g3167	i0	40.2	0.921348314606742	82	49	92.1	0	14	259	403	484	DAZ87271.1 TPA_asm: RNA-dependent polymerase [Aegean partiti-like virus]	diamond	246	79	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Aegean partiti-like virus
26823986	26823986	PRJNA495917_S_NODE_7141_length_196_cov_1.739130_g6947_i0	PRJNA495917	7141	196	1.73913	3.4086948	uncultured Caudovirales phage	2100421	Viruses	Viruses	59.3	1.57e-8	NR	CAB4241256.1	2100421	g6947	i0	43.5	0.948979591836735	62	35	94.9	0	3	188	171	232	CAB4241256.1 hypothetical protein UFOVP67_22 [uncultured Caudovirales phage]	diamond	186	59.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
27803672	27803672	PRJNA495917_S_NODE_184_length_982_cov_3.552270_g108_i0	PRJNA495917	184	982	3.55227	34.8832914	Aegean partiti-like virus	2912685	Viruses	Viruses	182	2.82e-49	NR	DAZ87271.1	2912685	g108	i0	32.6	1.020366598778	334	213	99.9	5	982	2	76	404	DAZ87271.1 TPA_asm: RNA-dependent polymerase [Aegean partiti-like virus]	diamond	1002	182	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Aegean partiti-like virus
28435097	28435097	PRJNA495917_S_NODE_3526_length_261_cov_4.911504_g3332_i0	PRJNA495917	3526	261	4.911504	12.81902544	dengue virus type 4	11070	Viruses	Viruses	65.5	4.71e-10	NR	WGD01105.1	11070	g3332	i0	96.7	0.67816091954023	30	1	34.5	0	224	135	2417	2446	WGD01105.1 polyprotein [dengue virus type 4]	diamond	177	65.5	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Orthoflavivirus	Orthoflavivirus denguei
28971849	28971849	PRJNA495917_S_NODE_3708_length_255_cov_1.536364_g3514_i0	PRJNA495917	3708	255	1.536364	3.9177282	Siphoviridae sp. ctdEk19	2656720	Viruses	Viruses	60.5	3.66e-9	NR	QGH72965.1	2656720	g3514	i0	51.6	0.729411764705882	62	28	72.9	1	229	44	90	149	QGH72965.1 MAG: protein of unknown function DUF669 [Siphoviridae sp. ctdEk19]	diamond	186	60.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Siphoviridae sp. ctdEk19

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