metadata: contig_metadata: 8 rows where bioproject = "PRJNA695140" and tax

8 rows where bioproject = "PRJNA695140" and tax_phylum = "Uroviricota"

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
6285522	6285522	PRJNA695140_S_NODE_4085_length_259_cov_1.761261_g3904_i0	PRJNA695140	4085	259	1.761261	4.56166599	Biquartavirus	1912143	Viruses	Viruses	148	2.9199999999999998e-31	NTclustered	gi\|2320097220\|gb\|MZ768930.1\|	2973715	g3904	i0	77.47	11.969111969112	253	53	97	4	9	259	1085	835	Aeromonas phage vB_AehM_DM1 major capsid protein gene, complete cds	blastn	3100	148	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae	Biquartavirus	Aeromonas phage vB_AehM_DM1
11385045	11385045	PRJNA695140_S_NODE_11989_length_156_cov_1.630252_g11808_i0	PRJNA695140	11989	156	1.630252	2.54319312	root	1	Root_unresolved	Root_unresolved	92.8	2.44e-20	NR	YP_009196464.1	1327935	g11808	i0	84.6	4	52	8	100	0	1	156	263	314	YP_009196464.1 major head protein [Cronobacter phage S13]	diamond	624	93.2	0.995708154506438	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae		Cronobacter phage S13
16484479	16484479	PRJNA695140_S_NODE_9773_length_170_cov_2.037594_g9592_i0	PRJNA695140	9773	170	2.037594	3.4639098	Straboviridae	2946170	Viruses	Viruses	115	1.79e-21	NTclustered	gi\|2223880102\|gb\|ON042478.1\|	2907222	g9592	i0	95.775	42.1117647058824	71	3	42	0	100	170	150515	150445	Aeromonas phage AhFM11, partial genome	blastn	7159	115	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae	Biquartavirus	Aeromonas phage AhFM11
21078531	21078531	PRJNA695140_S_NODE_4997_length_235_cov_1.545455_g4816_i0	PRJNA695140	4997	235	1.545455	3.63181925	Aquaneticvirus ApT65	3154060	Viruses	Viruses	115	2.6500000000000003e-21	NTclustered	gi\|2347352278\|gb\|OP491958.1\|	2982914	g4816	i0	90.909	6.05106382978723	88	5	37	3	52	137	45685	45771	Aeromonas phage APT65, complete genome	blastn	1422	115	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Aquaneticvirus	Aquaneticvirus ApT65
27683227	27683227	PRJNA695140_S_NODE_5124_length_232_cov_2.194872_g4943_i0	PRJNA695140	5124	232	2.194872	5.09210304	Pseudomonas phage PspYZU	2956010	Viruses	Viruses	60.8	1.08e-8	NR	YP_010090637.1	1983556	g4943	i0	43.8	3	80	36	98.3	2	5	232	199	273	YP_010090637.1 single strand DNA binding protein [Pseudomonas phage PspYZU05]	diamond	696	60.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae	Jiangsuvirus	Jiangsuvirus pspyzu05
30947182	30947182	PRJNA695140_S_NODE_5874_length_217_cov_1.933333_g5693_i0	PRJNA695140	5874	217	1.933333	4.19533261	Kanagawavirus	2843399	Viruses	Viruses	69.7	8.26e-12	NR	YP_009856186.1	2696340	g5693	i0	48.6	2.98617511520737	72	29	99.5	1	217	2	118	181	YP_009856186.1 major head protein [Enterobacter phage vB_EclM_CIP9]	diamond	648	69.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae	Kanagawavirus	Kanagawavirus cipnine
31124919	31124919	PRJNA695140_S_NODE_7095_length_198_cov_1.254658_g6914_i0	PRJNA695140	7095	198	1.254658	2.48422284	Myoviridae environmental samples	336724	Viruses	Viruses	83.2	8.15e-18	NR	BAF37241.1	336724	g6914	i0	64.2	1.01515151515152	67	22	98.5	1	196	2	77	143	BAF37241.1 major capsid protein, partial [Myoviridae environmental samples]	diamond	201	83.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Myoviridae environmental samples
31251644	31251644	PRJNA695140_S_NODE_4595_length_245_cov_1.110577_g4414_i0	PRJNA695140	4595	245	1.110577	2.72091365	Cronobacter phage S13	1327935	Viruses	Viruses	79.7	1.23e-15	NR	YP_009196465.1	1327935	g4414	i0	57.5	0.979591836734694	80	34	98	0	243	4	133	212	YP_009196465.1 head scaffolding protein [Cronobacter phage S13]	diamond	240	79.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae		Cronobacter phage S13

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