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

6 rows where bioproject = "PRJNA493828" 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
12585431	12585431	PRJNA493828_P_NODE_2730_length_644_cov_2.250438_g2389_i0	PRJNA493828	2730	644	2.250438	14.49282072	root	1	Root_unresolved	Root_unresolved	481	6.89e-131	NTclustered	gi\|2616465679\|gb\|OR735196.1\|	10515	g2389	i0	99.621	75.7562111801242	264	0	99	1	382	644	3587	3850	Human adenovirus 2 isolate HAdV-C2/USA/11A6/2013, complete genome	blastn	48787	481	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
24058672	24058672	PRJNA493828_P_NODE_8319_length_390_cov_4.722397_g7904_i0	PRJNA493828	8319	390	4.722397	18.4173483	root	1	Root_unresolved	Root_unresolved	684	0	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g7904	i0	99.208	97.1794871794872	379	3	97	0	3	381	2072	1694	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	37900	689	0.992743105950653	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
26792145	26792145	PRJNA493828_P_NODE_45121_length_218_cov_4.537931_g44702_i0	PRJNA493828	45121	218	4.537931	9.89268958	Moumouvirus Monve	1128131	Viruses	Viruses	44.3	0.00604	NR	AEX63088.1	1128131	g44702	i0	41.8	1.91284403669725	67	35	92.2	2	17	217	130	192	AEX63088.1 hypothetical protein mv_R886 [Moumouvirus Monve]	diamond	417	44.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Moumouvirus	Moumouvirus sp. 'Monve'
26855611	26855611	PRJNA493828_P_NODE_41461_length_235_cov_3.376543_g41042_i0	PRJNA493828	41461	235	3.376543	7.93487605	Adintovirus sediment12437	3115945	Viruses	Viruses	67	9.27e-11	NR	DBA50653.1	3115945	g41042	i0	40.3	0.982978723404255	77	46	98.3	0	233	3	1021	1097	DBA50653.1 MAG TPA_asm: PolBa [Adintovirus sediment12437]	diamond	231	67	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus sediment12437
31277502	31277502	PRJNA493828_P_NODE_36555_length_245_cov_0.895349_g36136_i0	PRJNA493828	36555	245	0.895349	2.19360505	Adintovirus sediment12437	3115945	Viruses	Viruses	97.4	2.2100000000000003e-21	NR	DBA50653.1	3115945	g36136	i0	53.8	0.979591836734694	80	36	96.7	1	9	245	1065	1144	DBA50653.1 MAG TPA_asm: PolBa [Adintovirus sediment12437]	diamond	240	97.4	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus sediment12437
32732166	32732166	PRJNA493828_P_NODE_26460_length_266_cov_1.595855_g26041_i0	PRJNA493828	26460	266	1.595855	4.2449743	Homavirus sp.	2487769	Viruses	Viruses	77	2.4e-14	NR	AYV82419.1	2487769	g26041	i0	46.5	0.800751879699248	71	38	80.1	0	4	216	256	326	AYV82419.1 MAG: elongation factor 1-alpha-like protein [Homavirus sp.]	diamond	213	77	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Homavirus sp.

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