metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA688931" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA688931" and tax_kingdom = "Heunggongvirae"

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_family	tax_genus	tax_species
27599533	27599533	PRJNA688931_P_NODE_30684_length_183_cov_1.365672_g30471_i0	PRJNA688931	30684	183	1.365672	2.49917976	Vandenendeviridae	3424680	Viruses	Viruses	112	1.51e-29	NR	YP_010766635.1	2873460	g30471	i0	90.7	2.65573770491803	54	5	88.5	0	182	21	15	68	YP_010766635.1 endolysin [Pseudomonas phage M5.1]	diamond	486	112	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Vandenendeviridae	Kremarvirus	Kremarvirus M51
27619502	27619502	PRJNA688931_P_NODE_35724_length_168_cov_1.462185_g35511_i0	PRJNA688931	35724	168	1.462185	2.4564708	Myoviridae sp. ctThM1	2656730	Viruses	Viruses	92	4.539999999999999e-23	NR	QGH72617.1	2656730	g35511	i0	84.8	0.821428571428571	46	7	82.1	0	138	1	1	46	QGH72617.1 MAG: hypothetical protein [Myoviridae sp. ctThM1]	diamond	138	92	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Myoviridae sp. ctThM1
28010012	28010012	PRJNA688931_P_NODE_36885_length_167_cov_1.050847_g36672_i0	PRJNA688931	36885	167	1.050847	1.75491449	Otagovirus	2560197	Viruses	Viruses	51.6	7.76e-7	NR	UAV90041.1	2873461	g36672	i0	48.8	1.47305389221557	41	21	73.7	0	140	18	1	41	UAV90041.1 hypothetical protein REC_192 [Pseudomonas phage REC]	diamond	246	52	0.992307692307692	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Vandenendeviridae	Otagovirus	Pseudomonas phage REC
28945771	28945771	PRJNA688931_P_NODE_42728_length_163_cov_0.877193_g42515_i0	PRJNA688931	42728	163	0.877193	1.42982459	Caudoviricetes sp.	2832643	Viruses	Viruses	73.6	5.2e-14	NR	XOR43005.1	2832643	g42515	i0	74.1	0.993865030674847	54	14	99.4	0	1	162	10	63	XOR43005.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	162	73.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
29861176	29861176	PRJNA688931_P_NODE_42251_length_163_cov_0.903509_g42038_i0	PRJNA688931	42251	163	0.903509	1.47271967	uncultured Caudovirales phage	2100421	Viruses	Viruses	42	0.0127	NR	CAB4132255.1	2100421	g42038	i0	45.7	0.846625766871166	46	24	82.8	1	29	163	1	46	CAB4132255.1 hypothetical protein UFOVP248_4 [uncultured Caudovirales phage]	diamond	138	42	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch
30524620	30524620	PRJNA688931_P_NODE_39353_length_165_cov_0.913793_g39140_i0	PRJNA688931	39353	165	0.913793	1.50775845	Pseudomonas phage REC	2873461	Viruses	Viruses	62	1.9e-10	NR	UAV89899.1	2873461	g39140	i0	90	0.545454545454545	30	3	54.5	0	75	164	1	30	UAV89899.1 polynucleotide kinase [Pseudomonas phage REC]	diamond	90	62	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Vandenendeviridae	Otagovirus	Pseudomonas phage REC
30872162	30872162	PRJNA688931_P_NODE_44574_length_154_cov_2.571429_g44361_i0	PRJNA688931	44574	154	2.571429	3.96000066	Pseudomonas phage vB_PsyM_KIL1	1777065	Viruses	Viruses	60.1	2.82e-9	NR	YP_009276064.1	1777065	g44361	i0	77.4	0.603896103896104	31	7	60.4	0	152	60	29	59	YP_009276064.1 hypothetical protein BH774_gp067 [Pseudomonas phage vB_PsyM_KIL1]	diamond	93	60.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Vandenendeviridae	Flaumdravirus	Flaumdravirus KIL4
31630868	31630868	PRJNA688931_P_NODE_30396_length_184_cov_1.259259_g30183_i0	PRJNA688931	30396	184	1.259259	2.31703656	Pseudomonas phage vB_PseuGesM_254	3092638	Viruses	Viruses	48.9	1.22e-5	NR	WOZ57421.1	3092638	g30183	i0	41.5	0.864130434782609	53	29	83.2	1	6	158	32	84	WOZ57421.1 hypothetical protein [Pseudomonas phage vB_PseuGesM_254]	diamond	159	48.9	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Vandenendeviridae	Chemalvirus	Chemalvirus PseuGes254
31788837	31788837	PRJNA688931_P_NODE_14237_length_274_cov_1.982222_g14024_i0	PRJNA688931	14237	274	1.982222	5.43128828	Caudoviricetes sp.	2832643	Viruses	Viruses	45.1	0.00244	NR	DAS36713.1	2832643	g14024	i0	36.2	0.755474452554745	69	40	71.2	2	33	227	25	93	DAS36713.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	207	45.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
31978833	31978833	PRJNA688931_P_NODE_31378_length_180_cov_2.564885_g31165_i0	PRJNA688931	31378	180	2.564885	4.616793	Pseudomonas phage vB_PpS_SYP	3020390	Viruses	Viruses	53.1	1.46e-6	NR	WCO82025.1	3020390	g31165	i0	58	0.833333333333333	50	21	83.3	0	4	153	127	176	WCO82025.1 hypothetical protein vBPpSSYP_43 [Pseudomonas phage vB_PpS_SYP]	diamond	150	53.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Pseudomonas phage vB_PpS_SYP

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