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

6 rows where bioproject = "PRJNA557895" and tax_kingdom = "Bamfordvirae"

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
28658020	28658020	PRJNA557895_P_NODE_2527_length_639_cov_3.115254_g2197_i0	PRJNA557895	2527	639	3.115254	19.90647306	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	105	6.1e-23	NR	BCT22626.1	RQ14	g2197	i0	37.2	0.882629107981221	188	111	86.4	5	556	5	3	187	BCT22626.1 putative DNA-binding virion core protein [Carp edema virus]	diamond	564	105	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Zebrafish jaw poxvirus
28910178	28910178	PRJNA557895_P_NODE_8008_length_316_cov_1.505618_g7653_i0	PRJNA557895	8008	316	1.505618	4.75775288	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	86.3	4.65e-17	NR	BCT22717.1	RQ14	g7653	i0	40.8	0.977848101265823	103	57	94	2	299	3	1022	1124	BCT22717.1 B22R family protein [Carp edema virus]	diamond	309	86.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Zebrafish jaw poxvirus
30236841	30236841	PRJNA557895_P_NODE_5132_length_400_cov_2.917379_g4777_i0	PRJNA557895	5132	400	2.917379	11.669516	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	51.6	9.09e-5	NR	BCT22707.1	RQ14	g4777	i0	30.5	0.9825	131	71	95.3	6	12	392	1	115	BCT22707.1 hypothetical protein [Carp edema virus]	diamond	393	51.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Zebrafish jaw poxvirus
30678986	30678986	PRJNA557895_P_NODE_23693_length_190_cov_1.446809_g23338_i0	PRJNA557895	23693	190	1.446809	2.7489371	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	58.5	4.82e-8	NR	BCT22716.1	RQ14	g23338	i0	46.3	0.852631578947368	54	29	85.3	0	164	3	1620	1673	BCT22716.1 variola B22R family protein [Carp edema virus]	diamond	162	58.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Zebrafish jaw poxvirus
32355372	32355372	PRJNA557895_P_NODE_14299_length_244_cov_1.046154_g13944_i0	PRJNA557895	14299	244	1.046154	2.55261576	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	73.9	3.96e-13	NR	BCT22715.1	RQ14	g13944	i0	45.2	1.84426229508197	73	40	89.8	0	240	22	357	429	BCT22715.1 putative membrane-associated glycoprotein [Carp edema virus]	diamond	450	73.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Zebrafish jaw poxvirus
32369452	32369452	PRJNA557895_P_NODE_31579_length_166_cov_0.871795_g31224_i0	PRJNA557895	31579	166	0.871795	1.4471797	Moumouvirus	3080801	Viruses	Viruses	45.8	0.00109	NR	QFG74124.1	1737588	g31224	i0	46.5	4.91566265060241	43	23	77.7	0	141	13	469	511	QFG74124.1 MAG: DNA topoisomerase I-like protein [Megaviridae environmental sample]	diamond	816	46.2	0.991341991341991	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Megaviridae environmental sample

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