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

5 rows where analysis = "diamond", bioproject = "PRJNA493244" and tax_phylum = "Preplasmiviricota"

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_species
27392711	27392711	PRJNA493244_P_NODE_865583_length_471_cov_3.104878_g842699_i0	PRJNA493244	865583	471	3.104878	14.62397538	Thermus phage phiKo	2301535	Viruses	Viruses	91.3	1.63e-19	NR	AYJ74689.1	2301535	g842699	i0	62.1	0.420382165605096	66	23	40.8	1	424	233	137	202	AYJ74689.1 DNA packaging ATPase [Thermus phage phiKo]	diamond	198	91.3	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae	Thermus phage phiKo
27455894	27455894	PRJNA493244_P_NODE_89683_length_1586_cov_10.311475_g83282_i0	PRJNA493244	89683	1586	10.311475	163.5399935	Bos-associated insect adintovirus	2597806	Viruses	Viruses	332	1.9e-97	NR	DAC80278.1	2597806	g83282	i0	37.2	4.06305170239596	541	301	97.8	13	25	1575	498	1023	DAC80278.1 TPA_asm: PolB [Bos-associated insect adintovirus]	diamond	6444	332	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Bos-associated insect adintovirus
27960862	27960862	PRJNA493244_P_NODE_1533925_length_235_cov_1.471264_g1510800_i0	PRJNA493244	1533925	235	1.471264	3.4574704	Thermus phage phiKo	2301535	Viruses	Viruses	64.7	1.07e-11	NR	AYJ74697.1	2301535	g1510800	i0	50.7	0.931914893617021	73	32	90.6	2	20	232	1	71	AYJ74697.1 hypothetical protein phiKo_22 [Thermus phage phiKo]	diamond	219	64.7	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae	Thermus phage phiKo
29571054	29571054	PRJNA493244_P_NODE_891130_length_458_cov_2.725441_g868187_i0	PRJNA493244	891130	458	2.725441	12.48251978	Adintovirus homo33	3115912	Viruses	Viruses	105	9.92e-25	NR	DBA48443.1	3115912	g868187	i0	46	2.9410480349345	113	60	74	1	1	339	122	233	DBA48443.1 MAG TPA_asm: PacK [Adintovirus homo3309]	diamond	1347	105	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Adintovirus homo3309
32731713	32731713	PRJNA493244_P_NODE_1466500_length_251_cov_1.347368_g1443375_i0	PRJNA493244	1466500	251	1.347368	3.38189368	Drosophila-associated adintovirus 2	2744817	Viruses	Viruses	103	2.26e-24	NR	QKS69576.1	2744817	g1443375	i0	67.1	0.872509960159363	73	24	87.3	0	232	14	116	188	QKS69576.1 putative integrase [Drosophila-associated adintovirus 2]	diamond	219	103	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Drosophila-associated adintovirus 2

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