metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA613025" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA613025" 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
5695573	5695573	PRJNA613025_S_NODE_3385_length_922_cov_4.163803_g3268_i0	PRJNA613025	3385	922	4.163803	38.39026366	Arthrobacter phage Hum25	3367557	Viruses	Viruses	511	2.789999999999999e-181	NR	XKC18196.1	3367557	g3268	i0	92.4	1.88069414316703	289	22	94	0	3	869	12	300	XKC18196.1 major capsid protein [Arthrobacter phage Hum25]	diamond	1734	511	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Arthrobacter phage Hum25
28975152	28975152	PRJNA613025_S_NODE_23148_length_198_cov_3.859060_g22994_i0	PRJNA613025	23148	198	3.85906	7.6409388	Phage 65_1	2718478	Viruses	Viruses	64.7	3.67e-10	NR	QOR55717.1	2718478	g22994	i0	59.1	1	66	20	89.4	3	196	20	750	815	QOR55717.1 MAG: hypothetical protein YHS30scaffold667_13 [Phage 65_10]	diamond	198	64.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Phage 65_10
29543288	29543288	PRJNA613025_S_NODE_23290_length_198_cov_0.879195_g23136_i0	PRJNA613025	23290	198	0.879195	1.7408061	Virus sp.	2202649	Viruses	Viruses	106	1.97e-25	NR	QVG74735.1	2202649	g23136	i0	71	2.87878787878788	62	18	93.9	0	4	189	262	323	QVG74735.1 RNA-dependent RNA polymerase, partial [Virus sp.]	diamond	570	106	1	Viruses							Virus sp.
29669304	29669304	PRJNA613025_S_NODE_24110_length_193_cov_1.604167_g23956_i0	PRJNA613025	24110	193	1.604167	3.09604231	Caudoviricetes sp.	2832643	Viruses	Viruses	49.7	6.74e-5	NR	XOR53815.1	2832643	g23956	i0	47.6	0.979274611398964	63	31	96.4	2	2	187	127	188	XOR53815.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	189	49.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
30111786	30111786	PRJNA613025_S_NODE_15752_length_267_cov_2.500000_g15598_i0	PRJNA613025	15752	267	2.5	6.675	Arthrobacter phage Bridgette	2419949	Viruses	Viruses	53.5	7.01e-6	NR	YP_009815217.1	2419949	g15598	i0	53.3	1.60674157303371	45	19	48.3	1	1	129	246	290	YP_009815217.1 tail assembly chaperone [Arthrobacter phage Bridgette]	diamond	429	53.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Bridgettevirus	Bridgettevirus bridgette
30396695	30396695	PRJNA613025_S_NODE_1893_length_1420_cov_3.266958_g1823_i0	PRJNA613025	1893	1420	3.266958	46.3908036	Arthrobacter phage Persistence	2836007	Viruses	Viruses	241	5.439999999999999e-66	NR	YP_010656019.1	2836007	g1823	i0	40.7	0.836619718309859	396	210	83.2	4	103	1284	545	917	YP_010656019.1 tail length tape measure protein [Arthrobacter phage Persistence]	diamond	1188	241	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Persistencevirus	Persistencevirus persistence
31312573	31312573	PRJNA613025_S_NODE_27835_length_175_cov_2.515873_g27681_i0	PRJNA613025	27835	175	2.515873	4.40277775	Virus sp.	2202649	Viruses	Viruses	99	8.439999999999999e-23	NR	XNT20867.1	2202649	g27681	i0	70.2	2.91428571428571	57	17	97.7	0	2	172	122	178	XNT20867.1 MAG: RNA-dependent RNA polymerase [Virus sp.]	diamond	510	99	1	Viruses							Virus sp.
32748419	32748419	PRJNA613025_S_NODE_32640_length_163_cov_0.894737_g32486_i0	PRJNA613025	32640	163	0.894737	1.45842131	Chuvivirus	2842604	Viruses	Viruses	82.8	9.1e-17	NR	WET19887.1	2842604	g32486	i0	70.4	2.98159509202454	54	16	99.4	0	2	163	303	356	WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1]	diamond	486	82.8	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Chuvivirus

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