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

8 rows where analysis = "diamond", bioproject = "PRJNA807685" 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_family	tax_genus	tax_species
3357679	3357679	PRJNA807685_P_NODE_7843_length_648_cov_2.472995_g6876_i0	PRJNA807685	7843	648	2.472995	16.0250076	Caudoviricetes sp.	2832643	Viruses	Viruses	170	3.119999999999999e-47	NR	XOS54532.1	2832643	g6876	i0	44.4	0.990740740740741	214	117	98.1	1	638	3	125	338	XOS54532.1 MAG: hypothetical protein MSP0309_93 [Caudoviricetes sp.]	diamond	642	170	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
27085869	27085869	PRJNA807685_P_NODE_28122_length_245_cov_1.860577_g27049_i0	PRJNA807685	28122	245	1.860577	4.55841365	Caudoviricetes sp.	2832643	Viruses	Viruses	65.1	6.15e-12	NR	DAH57185.1	2832643	g27049	i0	60.9	1.1265306122449	46	18	56.3	0	244	107	11	56	DAH57185.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	276	65.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
30054002	30054002	PRJNA807685_P_NODE_26891_length_253_cov_1.310185_g25818_i0	PRJNA807685	26891	253	1.310185	3.31476805	uncultured Caudovirales phage	2100421	Viruses	Viruses	111	4.81e-28	NR	CAB4139607.1	2100421	g25818	i0	73.5	1.96837944664032	83	21	98.4	1	4	252	1	82	CAB4139607.1 hypothetical protein UFOVP347_43 [uncultured Caudovirales phage]	diamond	498	111	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch
30339012	30339012	PRJNA807685_P_NODE_43452_length_186_cov_1.046980_g42379_i0	PRJNA807685	43452	186	1.04698	1.9473828	Caudoviricetes sp.	2832643	Viruses	Viruses	75.1	2.23e-15	NR	QSE37118.1	2832643	g42379	i0	55.9	0.951612903225806	59	26	95.2	0	178	2	22	80	QSE37118.1 MAG: terminase large subunit, partial [Caudoviricetes sp.]	diamond	177	75.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
30496667	30496667	PRJNA807685_P_NODE_22093_length_291_cov_1.755906_g21020_i0	PRJNA807685	22093	291	1.755906	5.10968646	Caudoviricetes sp.	2832643	Viruses	Viruses	103	1.26e-23	NR	XOS54532.1	2832643	g21020	i0	58.9	0.979381443298969	95	38	97.9	1	1	285	11	104	XOS54532.1 MAG: hypothetical protein MSP0309_93 [Caudoviricetes sp.]	diamond	285	103	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
31096716	31096716	PRJNA807685_P_NODE_30195_length_233_cov_1.831633_g29122_i0	PRJNA807685	30195	233	1.831633	4.26770489	uncultured Caudovirales phage	2100421	Viruses	Viruses	81.6	1.29e-16	NR	CAB4139607.1	2100421	g29122	i0	77.8	0.579399141630901	45	10	57.9	0	2	136	210	254	CAB4139607.1 hypothetical protein UFOVP347_43 [uncultured Caudovirales phage]	diamond	135	81.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch
31254831	31254831	PRJNA807685_P_NODE_57495_length_161_cov_2.427419_g56422_i0	PRJNA807685	57495	161	2.427419	3.90814459	uncultured Caudovirales phage	2100421	Viruses	Viruses	85.9	7.38e-18	NR	CAB4161395.1	2100421	g56422	i0	66	1.97515527950311	53	18	98.8	0	159	1	156	208	CAB4161395.1 large terminase protein [uncultured Caudovirales phage]	diamond	318	85.9	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch
32203889	32203889	PRJNA807685_P_NODE_42778_length_187_cov_2.073333_g41705_i0	PRJNA807685	42778	187	2.073333	3.87713271	Pseudomonas phage pPa_SNUABM_DT	2820398	Viruses	Viruses	75.5	2.5e-15	NR	QTH80494.1	2820398	g41705	i0	54.8	0.994652406417112	62	28	99.5	0	2	187	93	154	QTH80494.1 hypothetical protein PA10_00296 [Pseudomonas phage pPa_SNUABM_DT01]	diamond	186	75.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Pseudomonas phage pPa_SNUABM_DT01

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