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

6 rows where analysis = "diamond", bioproject = "PRJNA473201" and tax_kingdom = "Heunggongvirae"

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_genus	tax_species
26696200	26696200	PRJNA473201_P_NODE_16441_length_491_cov_2.050239_g15700_i0	PRJNA473201	16441	491	2.050239	10.06667349	Phage DSL-LC	3058958	Viruses	Viruses	48.9	8.18e-4	NR	WJZ48090.1	3058958	g15700	i0	32.1	0.476578411405295	78	49	47.7	1	420	187	7	80	WJZ48090.1 hypothetical protein [Phage DSL-LC04]	diamond	234	48.9	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Phage DSL-LC04
26981188	26981188	PRJNA473201_P_NODE_40202_length_315_cov_34.024793_g39460_i0	PRJNA473201	40202	315	34.024793	107.17809795	Escherichia phage D2	2915331	Viruses	Viruses	79.7	4.26e-17	NR	ULG00791.1	2915331	g39460	i0	53.3	0.714285714285714	75	35	71.4	0	4	228	6	80	ULG00791.1 hypothetical protein, partial [Escherichia phage D2]	diamond	225	79.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Bievrevirus	Escherichia phage D2
27392393	27392393	PRJNA473201_P_NODE_54583_length_280_cov_10.096618_g53841_i0	PRJNA473201	54583	280	10.096618	28.2705304	Escherichia Stx1 converting phage	194948	Viruses	Viruses	55.1	1.77e-7	NR	NP_859240.1	194948	g53841	i0	71.1	0.407142857142857	38	11	40.7	0	150	263	9	46	NP_859240.1 hypothetical protein Stx1_p161 [Escherichia Stx1 converting phage]	diamond	114	55.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Traversvirus	Escherichia Stx1 converting phage
29981407	29981407	PRJNA473201_P_NODE_62031_length_261_cov_1.026596_g61289_i0	PRJNA473201	62031	261	1.026596	2.67941556	Microbacterium phage PauloDiaboli	2704039	Viruses	Viruses	99	6.9899999999999995e-25	NR	QIG57849.1	2704039	g61289	i0	60	2.4367816091954	70	28	80.5	0	257	48	20	89	QIG57849.1 hypothetical protein SEA_PAULODIABOLI_115 [Microbacterium phage PauloDiaboli]	diamond	636	99	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Microbacterium phage PauloDiaboli
30266028	30266028	PRJNA473201_P_NODE_21912_length_421_cov_23.112069_g21170_i0	PRJNA473201	21912	421	23.112069	97.30181049	Lambdavirus lambda	10710	Viruses	Viruses	68.6	2.92e-12	NR	8DSB_A	10710	g21170	i0	47.5	0.869358669833729	61	32	43.5	0	419	237	17	77	8DSB_A Chain A, Xis (Excision72) [Lambdavirus lambda]	diamond	366	68.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Lambdavirus	Lambdavirus lambda
31782785	31782785	PRJNA473201_P_NODE_9837_length_644_cov_27.462347_g2062_i1	PRJNA473201	9837	644	27.462347	176.85751468	Campylobacter phage CJLB-4	2781358	Viruses	Viruses	92.4	1.66e-20	NR	QPB10280.1	2781358	g2062	i1	64.4	0.340062111801242	73	26	34	0	478	260	17	89	QPB10280.1 hypothetical protein [Campylobacter phage CJLB-4]	diamond	219	92.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Lambdavirus	Campylobacter phage CJLB-4

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