metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJEB83711" and tax

16 rows where analysis = "diamond", bioproject = "PRJEB83711" 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
2694114	2694114	PRJEB83711_P_NODE_42403_length_283_cov_1.485714_g42137_i0	PRJEB83711	42403	283	1.485714	4.20457062	Caudoviricetes sp.	2832643	Viruses	Viruses	144	1.01e-39	NR	XOS47079.1	2832643	g42137	i0	72.3	1.99293286219081	94	26	99.6	0	283	2	199	292	XOS47079.1 MAG: NrdB aerobic NDP reductase, small subunit [Caudoviricetes sp.]	diamond	564	144	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
21821161	21821161	PRJEB83711_P_NODE_58998_length_252_cov_1.743017_g58732_i0	PRJEB83711	58998	252	1.743017	4.39240284	Caudoviricetes sp.	2832643	Viruses	Viruses	69.3	9.91e-12	NR	DAH77175.1	2832643	g58732	i0	48.6	0.857142857142857	72	36	85.7	1	37	252	8	78	DAH77175.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	216	69.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
26590864	26590864	PRJEB83711_P_NODE_43741_length_280_cov_1.454106_g43475_i0	PRJEB83711	43741	280	1.454106	4.0714968	uncultured Caudovirales phage	2100421	Viruses	Viruses	68.2	1.43e-12	NR	CAB4139755.1	2100421	g43475	i0	38.9	1.62857142857143	72	44	77.1	0	6	221	24	95	CAB4139755.1 hypothetical protein UFOVP353_19 [uncultured Caudovirales phage]	diamond	456	68.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch
27255526	27255526	PRJEB83711_P_NODE_29463_length_330_cov_1.128405_g29197_i0	PRJEB83711	29463	330	1.128405	3.7237365	Caudoviricetes sp.	2832643	Viruses	Viruses	83.6	4.16e-16	NR	DAJ88734.1	2832643	g29197	i0	39.6	0.827272727272727	91	55	82.7	0	27	299	280	370	DAJ88734.1 MAG TPA: DNA-directed DNA polymerase [Caudoviricetes sp.]	diamond	273	83.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
27666381	27666381	PRJEB83711_P_NODE_58464_length_253_cov_0.866667_g58198_i0	PRJEB83711	58464	253	0.866667	2.19266751	Caudoviricetes sp.	2832643	Viruses	Viruses	57.8	2.16e-7	NR	DAQ96360.1	2832643	g58198	i0	45	0.948616600790514	80	40	90.1	1	234	7	331	410	DAQ96360.1 MAG TPA: minor tail protein [Caudoviricetes sp.]	diamond	240	57.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
28424109	28424109	PRJEB83711_P_NODE_74526_length_244_cov_0.912281_g74260_i0	PRJEB83711	74526	244	0.912281	2.22596564	Caudoviricetes sp.	2832643	Viruses	Viruses	56.6	2.4e-7	NR	DAQ42194.1	2832643	g74260	i0	39.2	0.971311475409836	79	48	97.1	0	7	243	96	174	DAQ42194.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	237	56.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
28550470	28550470	PRJEB83711_P_NODE_71407_length_246_cov_0.901734_g71141_i0	PRJEB83711	71407	246	0.901734	2.21826564	Caudoviricetes sp.	2832643	Viruses	Viruses	47.8	6.51e-4	NR	XOR07357.1	2832643	g71141	i0	57.5	0.48780487804878	40	17	48.8	0	246	127	346	385	XOR07357.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	120	47.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
28865967	28865967	PRJEB83711_P_NODE_57228_length_253_cov_1.733333_g56962_i0	PRJEB83711	57228	253	1.733333	4.38533249	Pseudomonas phage POR1	1718594	Viruses	Viruses	64.7	2.02e-10	NR	ALH46286.1	1718594	g56962	i0	40	1.00790513833992	85	49	98.4	1	3	251	4	88	ALH46286.1 hypothetical protein POR1_81 [Pseudomonas phage POR1]	diamond	255	64.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Porunavirus	Porunavirus POR1
28961003	28961003	PRJEB83711_P_NODE_61348_length_251_cov_0.876404_g61082_i0	PRJEB83711	61348	251	0.876404	2.19977404	Caudoviricetes sp.	2832643	Viruses	Viruses	144	1.0899999999999998e-37	NR	XOR83182.1	2832643	g61082	i0	79.5	1.9840637450199201	83	17	99.2	0	250	2	462	544	XOR83182.1 MAG: putative tail fiber protein H [Caudoviricetes sp.]	diamond	498	144	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
29654950	29654950	PRJEB83711_P_NODE_68670_length_247_cov_0.896552_g68404_i0	PRJEB83711	68670	247	0.896552	2.21448344	Pseudomonas phage POR1	1718594	Viruses	Viruses	45.1	0.00179	NR	ALH46215.1	1718594	g68404	i0	61.3	0.376518218623482	31	12	37.7	0	247	155	91	121	ALH46215.1 hypothetical protein POR1_10 [Pseudomonas phage POR1]	diamond	93	45.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Porunavirus	Porunavirus POR1
30255825	30255825	PRJEB83711_P_NODE_68732_length_247_cov_0.896552_g68466_i0	PRJEB83711	68732	247	0.896552	2.21448344	Bacillus phage vB_BspM_AgentSmith	2836110	Viruses	Viruses	79	7.09e-15	NR	QXN70563.1	2836110	g68466	i0	43.8	0.88663967611336	73	41	88.7	0	13	231	81	153	QXN70563.1 putative virion structural protein [Bacillus phage vB_BspM_AgentSmith]	diamond	219	79	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Bacillus phage vB_BspM_AgentSmith
31171529	31171529	PRJEB83711_P_NODE_76195_length_243_cov_0.929412_g75929_i0	PRJEB83711	76195	243	0.929412	2.25847116	Phage NCTB	1857647	Viruses	Viruses	68.6	2.66e-11	NR	SBV38259.1	1857647	g75929	i0	45.5	0.950617283950617	77	42	95.1	0	6	236	183	259	SBV38259.1 hypothetical protein BN7874_090 [Phage NCTB]	diamond	231	68.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Phage NCTB
31322448	31322448	PRJEB83711_P_NODE_57335_length_253_cov_1.516667_g57069_i0	PRJEB83711	57335	253	1.516667	3.83716751	Pakpunavirus	1921407	Viruses	Viruses	107	9.14e-26	NR	AXY86885.1	2301646	g57069	i0	59	1.96837944664032	83	30	98.4	1	4	252	221	299	AXY86885.1 thymidylate synthase [Pseudomonas phage PaYy-2]	diamond	498	108	0.990740740740741	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Vandenendeviridae	Pakpunavirus	Pseudomonas phage PaYy-2
31329854	31329854	PRJEB83711_P_NODE_58696_length_253_cov_0.866667_g58430_i0	PRJEB83711	58696	253	0.866667	2.19266751	Xanthomonas phage DES1	2894399	Viruses	Viruses	147	1.91e-40	NR	UFK09591.1	2894399	g58430	i0	77.1	0.984189723320158	83	19	98.4	0	5	253	45	127	UFK09591.1 large terminase protein [Xanthomonas phage DES1]	diamond	249	147	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Xanthomonas phage DES1
31512505	31512505	PRJEB83711_P_NODE_63536_length_250_cov_0.881356_g63270_i0	PRJEB83711	63536	250	0.881356	2.20339	Rimavirus	2560214	Viruses	Viruses	124	1.6599999999999998e-31	NR	ASU04008.1	2024285	g63270	i0	74.4	5.856	82	21	98.4	0	3	248	320	401	ASU04008.1 portal protein [Streptomyces phage Spectropatronm]	diamond	1464	124	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Rimavirus	Rimavirus rima
32342464	32342464	PRJEB83711_P_NODE_57739_length_253_cov_0.866667_g57473_i0	PRJEB83711	57739	253	0.866667	2.19266751	Caudoviricetes sp.	2832643	Viruses	Viruses	147	4.87e-39	NR	XOR83179.1	2832643	g57473	i0	78	0.972332015810277	82	18	97.2	0	248	3	325	406	XOR83179.1 MAG: hypothetical protein MSP1863_37 [Caudoviricetes sp.]	diamond	246	147	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);;