metadata: contig_metadata: 10 rows where bioproject = "PRJNA1233465" and tax

10 rows where bioproject = "PRJNA1233465" 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
32914664	32914664	PRJNA1233465a_S_NODE_40649_length_317_cov_1.843284_g39375_i0	PRJNA1233465	40649	317	1.843284	5.84321028	Adintovirus puccinia15	3115942	Viruses	Viruses	66.2	3.33e-10	NR	DBA48645.1	3115942	g39375	i0	41	0.738170347003155	78	33	73.8	2	298	65	236	300	DBA48645.1 MAG TPA_asm: Mael [Adintovirus puccinia15046]	diamond	234	66.2	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Adintovirus puccinia15046
32932504	32932504	PRJNA1233465b_S_NODE_52977_length_345_cov_1.364865_g51292_i0	PRJNA1233465	52977	345	1.364865	4.70878425	Adintovirus puccinia15	3115942	Viruses	Viruses	66.2	4.52e-10	NR	DBA48645.1	3115942	g51292	i0	41	0.678260869565217	78	33	67.8	2	12	245	236	300	DBA48645.1 MAG TPA_asm: Mael [Adintovirus puccinia15046]	diamond	234	66.2	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Adintovirus puccinia15046
32950626	32950626	PRJNA1233465e_S_NODE_32714_length_308_cov_4.830116_g31404_i0	PRJNA1233465	32714	308	4.830116	14.87675728	Astyanax tetra cavefish adintovirus	2609866	Viruses	Viruses	57.4	3.71e-7	NR	DAC81253.1	2609866	g31404	i0	55.1	0.974025974025974	49	22	47.7	0	265	119	131	179	DAC81253.1 TPA_asm: penton [Astyanax tetra cavefish adintovirus]	diamond	300	57.4	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Astyanax tetra cavefish adintovirus
32967258	32967258	PRJNA1233465d_S_NODE_29194_length_306_cov_2.591440_g28083_i0	PRJNA1233465	29194	306	2.59144	7.9298064	Adintovirus anguilla10665	3115889	Viruses	Viruses	57.4	3.59e-7	NR	DAC81253.1	3115889	g28083	i0	55.1	0.980392156862745	49	22	48	0	42	188	131	179	DAC81253.1 TPA_asm: penton [Astyanax tetra cavefish adintovirus]	diamond	300	57.4	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Adintovirus anguilla10665
33000469	33000469	PRJNA1233465b_S_NODE_178363_length_219_cov_13.788235_g176678_i0	PRJNA1233465	178363	219	13.788235	30.19623465	Pimephales minnow adintovirus	2609864	Viruses	Viruses	59.3	2.07e-8	NR	DAC81394.1	2609864	g176678	i0	66.7	0.534246575342466	39	13	53.4	0	146	30	7	45	DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus]	diamond	117	59.3	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Pimephales minnow adintovirus
33002495	33002495	PRJNA1233465f_S_NODE_247459_length_164_cov_2.660870_g245179_i0	PRJNA1233465	247459	164	2.66087	4.3638268	Pimephales minnow adintovirus	2609864	Viruses	Viruses	58.2	2.71e-8	NR	DAC81394.1	2609864	g245179	i0	69.4	0.658536585365854	36	11	65.9	0	109	2	7	42	DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus]	diamond	108	58.2	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Pimephales minnow adintovirus
33068573	33068573	PRJNA1233465b_S_NODE_133437_length_247_cov_1.287879_g131752_i0	PRJNA1233465	133437	247	1.287879	3.18106113	Lake Baikal virophage 9	3086132	Viruses	Viruses	43.5	0.0207	NR	WPF46692.1	3086132	g131752	i0	39.7	0.825910931174089	68	31	82.6	3	42	245	15	72	WPF46692.1 MAG: hypothetical protein [Lake Baikal virophage 9]	diamond	204	43.5	1	Viruses	Bamfordvirae	Preplasmiviricota	Virophaviricetes	Priklausovirales	Lavidaviridae	Lake Baikal virophage 9
33070500	33070500	PRJNA1233465f_S_NODE_194813_length_180_cov_0.984733_g192533_i0	PRJNA1233465	194813	180	0.984733	1.7725194	Astyanax tetra cavefish adintovirus	2609866	Viruses	Viruses	69.7	4.33e-12	NR	DAC81252.1	2609866	g192533	i0	65.2	0.766666666666667	46	16	76.7	0	43	180	263	308	DAC81252.1 TPA_asm: integrase [Astyanax tetra cavefish adintovirus]	diamond	138	69.7	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Astyanax tetra cavefish adintovirus
33105096	33105096	PRJNA1233465f_S_NODE_55222_length_307_cov_6.205426_g52942_i0	PRJNA1233465	55222	307	6.205426	19.05065782	Astyanax tetra cavefish adintovirus	2609866	Viruses	Viruses	57.4	3.71e-7	NR	DAC81253.1	2609866	g52942	i0	55.1	0.977198697068404	49	22	47.9	0	264	118	131	179	DAC81253.1 TPA_asm: penton [Astyanax tetra cavefish adintovirus]	diamond	300	57.4	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Astyanax tetra cavefish adintovirus
33153352	33153352	PRJNA1233465a_S_NODE_144056_length_198_cov_7.939597_g142782_i0	PRJNA1233465	144056	198	7.939597	15.72040206	Pimephales minnow adintovirus	2609864	Viruses	Viruses	61.2	3.01e-9	NR	DAC81394.1	2609864	g142782	i0	68.4	0.575757575757576	38	12	57.6	0	139	26	7	44	DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus]	diamond	114	61.2	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae	Pimephales minnow adintovirus

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