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

6 rows where bioproject = "PRJNA407087" and tax_superkingdom = "Viruses"

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
1689812	1689812	PRJNA407087_S_NODE_7342_length_180_cov_2.450331_g6879_i0	PRJNA407087	7342	180	2.450331	4.4105958	Pandoravirus quercus	2107709	Viruses	Viruses	75	3.26e-9	NTclustered	gi\|1408259612\|ref\|NC_037667.1\|	2107709	g6879	i0	82.353	1.53333333333333	85	15	49	0	36	120	1563508	1563592	Pandoravirus quercus, complete genome	blastn	276	75	1	Viruses						Pandoravirus	Pandoravirus quercus
30945345	30945345	PRJNA407087_S_NODE_5454_length_219_cov_3.473684_g4991_i0	PRJNA407087	5454	219	3.473684	7.60736796	Tupanvirus	2094720	Viruses	Viruses	53.9	2.22e-6	NR	YP_010782374.1	2126985	g4991	i0	33.3	1.84931506849315	69	46	94.5	0	9	215	147	215	YP_010782374.1 hypothetical protein QJ857_gp0333 [Tupanvirus soda lake]	diamond	405	53.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus salinum
30960190	30960190	PRJNA407087_S_NODE_7754_length_174_cov_2.882759_g7291_i0	PRJNA407087	7754	174	2.882759	5.0160006600000004	Caudoviricetes sp.	2832643	Viruses	Viruses	41.6	0.0364	NR	DAU86091.1	2832643	g7291	i0	42.1	0.655172413793103	38	22	65.5	0	2	115	39	76	DAU86091.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	114	41.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
31529328	31529328	PRJNA407087_S_NODE_3536_length_308_cov_2.093190_g3073_i0	PRJNA407087	3536	308	2.09319	6.4470252	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	126	3.12e-32	NR	YP_010803269.1	3060017	g3073	i0	65.5	0.847402597402597	87	30	84.7	0	307	47	328	414	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	261	126	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
31908755	31908755	PRJNA407087_S_NODE_4757_length_243_cov_9.621495_g4294_i0	PRJNA407087	4757	243	9.621495	23.38023285	Xestia c-nigrum granulovirus	51677	Viruses	Viruses	80.5	6.71e-17	NR	AAB46484.1	51677	g4294	i0	54.9	2.61728395061728	71	31	86.4	1	241	32	83	153	AAB46484.1 cysteine protease homolog, partial [Xestia c-nigrum granulovirus]	diamond	636	80.5	1	Viruses			Naldaviricetes	Lefavirales	Baculoviridae	Betabaculovirus	Betabaculovirus xecnigri
32762104	32762104	PRJNA407087_S_NODE_7500_length_178_cov_2.255034_g7037_i0	PRJNA407087	7500	178	2.255034	4.01396052	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	93.2	1.6e-20	NR	YP_010803269.1	3060017	g7037	i0	72.9	0.99438202247191	59	16	99.4	0	2	178	130	188	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	177	93.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense

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