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

5 rows where analysis = "diamond" and tax_clade = "Duplodnaviria"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_family	tax_genus	tax_species
27924444	27924444	PRJNA1148190_P_NODE_666025_length_247_cov_0.885057_g654852_i0	PRJNA1148190	666025	247	0.885057	2.18609079	Pseudomonas phage phi-2	1450169	Viruses	Viruses	85.5	8.65e-19	NR	YP_003345491.1	693582	g654852	i0	55.3	0.923076923076923	76	34	92.3	0	11	238	56	131	YP_003345491.1 HNH endonuclease [Pseudomonas phage phi-2]	diamond	228	85.5	1	Viruses	Duplodnaviria	Heunggongvirae	Uroviricota	Caudoviricetes	Autographiviridae	Tunggulvirus	Tunggulvirus f2
30722865	30722865	PRJNA1145574_P_NODE_2234_length_550_cov_1.471698_g2052_i0	PRJNA1145574	2234	550	1.471698	8.094339	Demerecviridae	2731690	Viruses	Viruses	103	3.48e-24	NR	YP_009804592.1	2053625	g2052	i0	43	3.94909090909091	142	76	74.7	3	114	524	5	146	YP_009804592.1 HNH endonuclease [Salmonella phage SP3]	diamond	2172	103	1	Viruses	Duplodnaviria	Heunggongvirae	Uroviricota	Caudoviricetes	Demerecviridae	Tequintavirus	Tequintavirus SP3
30992566	30992566	PRJNA473824_P_NODE_144774_length_151_cov_4.421053_g144136_i0	PRJNA473824	144774	151	4.421053	6.67579003	Pseudomonas phage phi-2	1450169	Viruses	Viruses	45.4	0.00114	NR	YP_003345487.1	693582	g144136	i0	83.3	0.47682119205298	24	4	47.7	0	74	3	168	191	YP_003345487.1 DNA polymerase exonuclease subunit [Pseudomonas phage phi-2]	diamond	72	45.4	1	Viruses	Duplodnaviria	Heunggongvirae	Uroviricota	Caudoviricetes	Autographiviridae	Tunggulvirus	Tunggulvirus f2
31405616	31405616	PRJNA556992_P_NODE_1002956_length_230_cov_3.273885_g1000766_i0	PRJNA556992	1002956	230	3.273885	7.5299355	Pseudomonas phage phi-2	1450169	Viruses	Viruses	65.9	2.03e-10	NR	YP_003345474.1	693582	g1000766	i0	50.6	1.08260869565217	83	27	99.1	4	2	229	268	343	YP_003345474.1 hypothetical protein SBWP25_0009 [Pseudomonas phage phi-2]	diamond	249	65.9	1	Viruses	Duplodnaviria	Heunggongvirae	Uroviricota	Caudoviricetes	Autographiviridae	Tunggulvirus	Tunggulvirus f2
31659900	31659900	PRJNA596870_P_NODE_9877_length_402_cov_1.142857_g9744_i0	PRJNA596870	9877	402	1.142857	4.59428514	Pseudomonas phage phi-2	1450169	Viruses	Viruses	128	6.31e-33	NR	YP_003345487.1	693582	g9744	i0	58	0.835820895522388	112	43	80.6	2	77	400	8	119	YP_003345487.1 DNA polymerase exonuclease subunit [Pseudomonas phage phi-2]	diamond	336	128	1	Viruses	Duplodnaviria	Heunggongvirae	Uroviricota	Caudoviricetes	Autographiviridae	Tunggulvirus	Tunggulvirus f2

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