metadata: contig_metadata: 5 rows where bioproject = "PRJNA588137" and tax

5 rows where bioproject = "PRJNA588137" 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
564769	564769	PRJNA588137_S_NODE_3121_length_316_cov_160.580247_g3088_i0	PRJNA588137	3121	316	160.58024700000001	507.43358052	Betacoronavirus pandemicum	3418604	Viruses	Viruses	117	1.03e-21	NTclustered	gi\|2165834194\|emb\|OV195900.1\|	2697049	g3088	i0	94.805	28.8829113924051	77	1	24	3	4	78	30067	29992	Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1	blastn	9127	117	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
1840265	1840265	PRJNA588137_S_NODE_2962_length_322_cov_1.554217_g2929_i0	PRJNA588137	2962	322	1.554217	5.00457874	Betacoronavirus pandemicum	3418604	Viruses	Viruses	84.2	1.07e-11	NTclustered	gi\|2165835422\|emb\|OV196488.1\|	2697049	g2929	i0	94.545	19.7608695652174	55	1	17	2	269	322	118	65	Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1	blastn	6363	84.2	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
28406180	28406180	PRJNA588137_S_NODE_10906_length_241_cov_1.136905_g10873_i0	PRJNA588137	10906	241	1.136905	2.73994105	Enterobacteria phage IME1	1090133	Viruses	Viruses	64.3	5.16e-10	NR	YP_007004316.1	1090133	g10873	i0	40.5	0.983402489626556	79	47	98.3	0	239	3	36	114	YP_007004316.1 regulatory protein Q [Enterobacteria phage IME10]	diamond	237	64.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Lederbergvirus	Enterobacteria phage IME10
30630128	30630128	PRJNA588137_S_NODE_3013_length_320_cov_2.291498_g2980_i0	PRJNA588137	3013	320	2.291498	7.3327936	Viruses	10239	Viruses	Viruses	160	1.7799999999999998e-47	NR	QHJ85290.1	38018	g2980	i0	72.6	1.9875	106	29	99.4	0	319	2	66	171	QHJ85290.1 MAG: hypothetical protein [Bacteriophage sp.]	diamond	636	160	1	Viruses							Bacteriophage sp.
31565275	31565275	PRJNA588137_S_NODE_4956_length_275_cov_0.836634_g4923_i0	PRJNA588137	4956	275	0.836634	2.3007435	Caudoviricetes sp.	2832643	Viruses	Viruses	63.2	2.58e-10	NR	DAH57001.1	2832643	g4923	i0	68.1	0.512727272727273	47	15	51.3	0	225	85	65	111	DAH57001.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	141	63.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes 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);;