metadata: contig_metadata: 8 rows where bioproject = "PRJNA781427" and tax

8 rows where bioproject = "PRJNA781427" and tax_phylum = "Nucleocytoviricota"

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_genus	tax_species
4588253	4588253	PRJNA781427_P_NODE_15144_length_649_cov_3.967014_g14314_i0	PRJNA781427	15144	649	3.967014	25.74592086	Trichoplusia ni ascovirus 6b	2077183	Viruses	Viruses	56.5	0.005	NTclustered	gi\|1334372357\|gb\|KY434117.1\|	2077183	g14314	i0	100	0.0462249614791988	30	0	5	0	288	317	12221	12250	Trichoplusia ni ascovirus 6b isolate TnAV-6b	blastn	30	56.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Ascoviridae	Ascovirus	Trichoplusia ni ascovirus 6b
26990047	26990047	PRJNA781427_P_NODE_34142_length_394_cov_3.065421_g33261_i0	PRJNA781427	34142	394	3.065421	12.07775874	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	48.5	0.00161	NR	BCT22626.1	RQ14	g33261	i0	32.7	0.791878172588833	104	67	76.9	2	89	391	3	106	BCT22626.1 putative DNA-binding virion core protein [Carp edema virus]	diamond	312	48.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
27590904	27590904	PRJNA781427_P_NODE_82124_length_248_cov_0.880000_g81240_i0	PRJNA781427	82124	248	0.88	2.1824	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	97.8	1.32e-22	NR	BCT22606.1	RQ14	g81240	i0	45.7	0.979838709677419	81	44	98	0	2	244	178	258	BCT22606.1 hypothetical protein AL387_gp060 [Carp edema virus]	diamond	243	97.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
29832425	29832425	PRJNA781427_P_NODE_69011_length_264_cov_1.115183_g68127_i0	PRJNA781427	69011	264	1.115183	2.94408312	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	72.8	5.02e-13	NR	BCT22625.1	RQ14	g68127	i0	44.4	0.920454545454545	81	45	92	0	11	253	111	191	BCT22625.1 hypothetical protein [Carp edema virus]	diamond	243	72.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
29863978	29863978	PRJNA781427_P_NODE_21951_length_513_cov_1.588636_g21075_i0	PRJNA781427	21951	513	1.588636	8.14970268	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	118	1.9699999999999999e-28	NR	BCT22626.1	RQ14	g21075	i0	39.2	1	171	100	99.4	3	510	1	100	267	BCT22626.1 putative DNA-binding virion core protein [Carp edema virus]	diamond	513	118	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
30401592	30401592	PRJNA781427_P_NODE_83773_length_247_cov_0.885057_g82889_i0	PRJNA781427	83773	247	0.885057	2.18609079	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	114	3.4600000000000005e-27	NR	BCT22646.1	RQ14	g82889	i0	67.9	0.947368421052632	78	25	94.7	0	1	234	374	451	BCT22646.1 virion core protein P4b [Carp edema virus]	diamond	234	114	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
31823479	31823479	PRJNA781427_P_NODE_97577_length_230_cov_2.452229_g96693_i0	PRJNA781427	97577	230	2.452229	5.6401267	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	44.3	0.00882	NR	BCT22628.1	RQ14	g96693	i0	39.1	0.9	69	38	84.8	3	221	27	4	72	BCT22628.1 hypothetical protein [Carp edema virus]	diamond	207	44.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus
32235242	32235242	PRJNA781427_P_NODE_64298_length_276_cov_1.231527_g63414_i0	PRJNA781427	64298	276	1.231527	3.39901452	Zebrafish jaw poxvirus	RQ14	Viruses	Viruses	43.9	0.0222	NR	BCT22708.1	RQ14	g63414	i0	31.3	0.869565217391304	80	49	87	3	30	269	261	334	BCT22708.1 hypothetical protein [Carp edema virus]	diamond	240	43.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Zebrafish jaw poxvirus

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