metadata: contig_metadata: 7 rows where bioproject = "PRJNA1123309" and tax

7 rows where bioproject = "PRJNA1123309" 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_genus	tax_species
14307227	14307227	PRJNA1123309_P_NODE_39372_length_272_cov_1.427136_g38992_i0	PRJNA1123309	39372	272	1.427136	3.88180992	Mimivirus U306	1932880	Viruses	Viruses	75	5.3299999999999996e-9	NTclustered	gi\|1572561086\|emb\|LT717347.1\|	1932880	g38992	i0	78.151	29.5882352941176	119	24	54	2	88	205	877992	877875	Mimivirus U306 genome assembly, complete genome: monopartite	blastn	8048	75	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Mimivirus	Mimivirus U306
26848841	26848841	PRJNA1123309_P_NODE_23901_length_328_cov_1.164706_g23521_i0	PRJNA1123309	23901	328	1.164706	3.82023568	Bodo saltans virus	2024608	Viruses	Viruses	48.1	0.00127	NR	YP_010778218.1	2024608	g23521	i0	50	0.365853658536585	40	20	36.6	0	155	36	758	797	YP_010778218.1 hypothetical protein QJ851_gp0379 [Bodo saltans virus]	diamond	120	48.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Theiavirus	Theiavirus salishense
31207149	31207149	PRJNA1123309_P_NODE_18655_length_364_cov_1.037801_g18276_i0	PRJNA1123309	18655	364	1.037801	3.77759564	Catovirus CTV1	1977631	Viruses	Viruses	174	6.94e-52	NR	ARF08994.1	1977631	g18276	i0	71.3	0.947802197802198	115	33	94.8	0	18	362	83	197	ARF08994.1 hypothetical protein Catovirus_1_1044 [Catovirus CTV1]	diamond	345	174	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1
31934988	31934988	PRJNA1123309_P_NODE_13397_length_418_cov_3.127536_g13020_i0	PRJNA1123309	13397	418	3.127536	13.07310048	Terrestrivirus sp.	2487775	Viruses	Viruses	58.9	5.63e-7	NR	AYV76628.1	2487775	g13020	i0	35.9	0.91866028708134	128	55	78.9	6	366	37	173	291	AYV76628.1 MAG: hypothetical protein Terrestrivirus10_12 [Terrestrivirus sp.]	diamond	384	58.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
32125162	32125162	PRJNA1123309_P_NODE_50458_length_251_cov_0.876404_g50078_i0	PRJNA1123309	50458	251	0.876404	2.19977404	Catovirus CTV1	1977631	Viruses	Viruses	96.3	5.839999999999999e-23	NR	ARF08745.1	1977631	g50078	i0	59.2	0.848605577689243	71	29	84.9	0	37	249	23	93	ARF08745.1 hypothetical protein Catovirus_1_795 [Catovirus CTV1]	diamond	213	96.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1
32251863	32251863	PRJNA1123309_P_NODE_64538_length_243_cov_0.917647_g64158_i0	PRJNA1123309	64538	243	0.917647	2.22988221	Harvfovirus sp.	2487768	Viruses	Viruses	62	6.07e-9	NR	AYV81013.1	2487768	g64158	i0	60	0.617283950617284	50	20	61.7	0	13	162	368	417	AYV81013.1 MAG: SPFH domain / Band 7 domain containing protein [Harvfovirus sp.]	diamond	150	62	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Harvfovirus sp.
32504859	32504859	PRJNA1123309_P_NODE_39119_length_273_cov_1.135000_g38739_i0	PRJNA1123309	39119	273	1.135	3.09855	Pimephales minnow adintovirus	2609864	Viruses	Viruses	44.7	0.0102	NR	DAC81404.1	2609864	g38739	i0	36	1.68131868131868	75	47	81.3	1	240	19	42	116	DAC81404.1 TPA_asm: hypothetical protein [Pimephales minnow adintovirus]	diamond	459	45.1	0.991130820399113	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);;