metadata: contig_metadata: 9 rows where bioproject = "PRJNA312615" and tax

9 rows where bioproject = "PRJNA312615" 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
20190020	20190020	PRJNA312615_P_NODE_35236_length_206_cov_51.191083_g35085_i0	PRJNA312615	35236	206	51.191083	105.45363098	root	1	Root_unresolved	Root_unresolved	267	5.91e-67	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g35085	i0	100	69.9029126213592	144	0	70	0	7	150	11379	11236	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	14400	267	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
24015780	24015780	PRJNA312615_P_NODE_36379_length_203_cov_23.019481_g36228_i0	PRJNA312615	36379	203	23.019481	46.72954643	root	1	Root_unresolved	Root_unresolved	274	3.47e-69	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g36228	i0	100	92.2955665024631	148	0	93	0	1	148	28637	28490	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	18736	274	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
25289857	25289857	PRJNA312615_P_NODE_16240_length_304_cov_20.929412_g16089_i0	PRJNA312615	16240	304	20.929412	63.62541248	root	1	Root_unresolved	Root_unresolved	516	8.36e-142	NTclustered	gi\|2620236085\|gb\|OR777220.1\|	10515	g16089	i0	98.962	95.0822368421053	289	1	95	2	6	293	14830	15117	Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome	blastn	28905	516	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
25290095	25290095	PRJNA312615_P_NODE_35980_length_204_cov_42.277419_g35829_i0	PRJNA312615	35980	204	42.277419	86.24593476	root	1	Root_unresolved	Root_unresolved	263	7.549999999999999e-66	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g35829	i0	98.658	73.0392156862745	149	1	73	1	1	148	11551	11403	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	14900	263	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
27737998	27737998	PRJNA312615_P_NODE_56904_length_163_cov_0.894737_g56753_i0	PRJNA312615	56904	163	0.894737	1.45842131	Klosneuvirus KNV1	1977640	Viruses	Viruses	55.1	5.41e-7	NR	ARF12097.1	1977640	g56753	i0	51.9	0.957055214723926	52	24	93.9	1	9	161	107	158	ARF12097.1 hypothetical protein Klosneuvirus_3_232 [Klosneuvirus KNV1]	diamond	156	55.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
29537326	29537326	PRJNA312615_P_NODE_45190_length_181_cov_1.515152_g45039_i0	PRJNA312615	45190	181	1.515152	2.74242512	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	89.7	2.95e-19	NR	YP_010803269.1	3060017	g45039	i0	70.7	0.961325966850829	58	17	96.1	0	179	6	292	349	YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense]	diamond	174	89.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
29916471	29916471	PRJNA312615_P_NODE_44071_length_184_cov_1.133333_g43920_i0	PRJNA312615	44071	184	1.133333	2.08533272	Adintovirus bos4377	3115894	Viruses	Viruses	57	4.79e-8	NR	DBA50495.1	3115894	g43920	i0	46.7	0.978260869565217	60	32	97.8	0	3	182	110	169	DBA50495.1 MAG TPA_asm: Adenain [Adintovirus bos4377]	diamond	180	57	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus bos4377
30168844	30168844	PRJNA312615_P_NODE_50092_length_169_cov_0.866667_g49941_i0	PRJNA312615	50092	169	0.866667	1.46466723	Adintovirus bos4377	3115894	Viruses	Viruses	47.4	2.79e-4	NR	DBA50496.1	3115894	g49941	i0	65.6	0.568047337278107	32	11	56.8	0	3	98	178	209	DBA50496.1 MAG TPA_asm: Adintoc2 [Adintovirus bos4377]	diamond	96	47.4	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus bos4377
30800843	30800843	PRJNA312615_P_NODE_24954_length_245_cov_0.872449_g24803_i0	PRJNA312615	24954	245	0.872449	2.13750005	Pimephales minnow adintovirus	2609864	Viruses	Viruses	68.6	2.59e-11	NR	DAC81401.1	2609864	g24803	i0	48.8	2.00816326530612	82	41	99.2	1	244	2	169	250	DAC81401.1 TPA_asm: integrase [Pimephales minnow adintovirus]	diamond	492	68.6	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);;