metadata: contig_metadata: 6 rows where bioproject = "PRJNA432257" and tax

6 rows where bioproject = "PRJNA432257" 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
26600673	26600673	PRJNA432257_S_NODE_94601_length_180_cov_93.783217_g94220_i0	PRJNA432257	94601	180	93.783217	168.8097906	Thermus phage phiKo	2301535	Viruses	Viruses	48.9	3.55e-5	NR	AYJ74679.1	2301535	g94220	i0	45.8	0.8	48	26	80	0	146	3	15	62	AYJ74679.1 hypothetical protein phiKo_04 [Thermus phage phiKo]	diamond	144	48.9	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae	Thermus phage phiKo
27486612	27486612	PRJNA432257_S_NODE_22963_length_307_cov_3.744444_g22582_i0	PRJNA432257	22963	307	3.744444	11.49544308	Thermus phage phiKo	2301535	Viruses	Viruses	64.7	1.38e-10	NR	AYJ74679.1	2301535	g22582	i0	50	0.644951140065147	66	31	63.5	2	8	202	79	143	AYJ74679.1 hypothetical protein phiKo_04 [Thermus phage phiKo]	diamond	198	64.7	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae	Thermus phage phiKo
27549632	27549632	PRJNA432257_S_NODE_18864_length_328_cov_86.226804_g18483_i0	PRJNA432257	18864	328	86.226804	282.82391712	Thermus phage phiKo	2301535	Viruses	Viruses	64.7	1.75e-10	NR	AYJ74679.1	2301535	g18483	i0	49.2	0.594512195121951	65	31	58.5	2	321	130	79	142	AYJ74679.1 hypothetical protein phiKo_04 [Thermus phage phiKo]	diamond	195	64.7	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae	Thermus phage phiKo
28275857	28275857	PRJNA432257_S_NODE_76386_length_196_cov_147.484277_g76005_i0	PRJNA432257	76386	196	147.484277	289.06918292	Thermus phage phiKo	2301535	Viruses	Viruses	65.1	7.28e-11	NR	AYJ74689.1	2301535	g76005	i0	61.4	0.673469387755102	44	17	67.3	0	62	193	1	44	AYJ74689.1 DNA packaging ATPase [Thermus phage phiKo]	diamond	132	65.1	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae	Thermus phage phiKo
28370605	28370605	PRJNA432257_S_NODE_40666_length_249_cov_164.599057_g40285_i0	PRJNA432257	40666	249	164.599057	409.85165193	Thermus phage phiKo	2301535	Viruses	Viruses	52.8	3.94e-7	NR	AYJ74684.1	2301535	g40285	i0	66.7	0.469879518072289	39	13	47	0	165	49	12	50	AYJ74684.1 hypothetical protein phiKo_09 [Thermus phage phiKo]	diamond	117	52.8	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae	Thermus phage phiKo
29886415	29886415	PRJNA432257_S_NODE_37911_length_256_cov_27.607306_g37530_i0	PRJNA432257	37911	256	27.607306	70.67470336	Thermus phage phiKo	2301535	Viruses	Viruses	74.3	4.44e-14	NR	AYJ74689.1	2301535	g37530	i0	67.3	0.57421875	49	16	57.4	0	221	75	126	174	AYJ74689.1 DNA packaging ATPase [Thermus phage phiKo]	diamond	147	74.3	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae	Thermus phage phiKo

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