metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA1174770" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA1174770" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
24542273	24542273	PRJNA1174770_P_NODE_6320_length_186_cov_1.518248_g6231_i0	PRJNA1174770	6320	186	1.518248	2.82394128	Caudoviricetes sp.	2832643	Viruses	Viruses	95.5	4.46e-21	NR	DAX53090.1	2832643	g6231	i0	77.2	2.79032258064516	57	13	91.9	0	185	15	538	594	DAX53090.1 MAG TPA: stabilization protein [Caudoviricetes sp.]	diamond	519	95.5	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
26755480	26755480	PRJNA1174770_P_NODE_8961_length_167_cov_0.881356_g8872_i0	PRJNA1174770	8961	167	0.881356	1.47186452	Bordetella phage PY223	3118915	Viruses	Viruses	72	7.6e-14	NR	WVR18334.1	3118915	g8872	i0	66.7	0.970059880239521	54	18	97	0	162	1	20	73	WVR18334.1 hypothetical protein y223_00054 [Bordetella phage PY223]	diamond	162	72	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Bordetella phage PY223
27103671	27103671	PRJNA1174770_P_NODE_5102_length_205_cov_1.320513_g5013_i0	PRJNA1174770	5102	205	1.320513	2.70705165	Bordetella phage PY223	3118915	Viruses	Viruses	87.4	4.06e-18	NR	WVR18339.1	3118915	g5013	i0	60.3	0.995121951219512	68	27	99.5	0	2	205	252	319	WVR18339.1 TMP repeat [Bordetella phage PY223]	diamond	204	87.4	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Bordetella phage PY223
27597029	27597029	PRJNA1174770_P_NODE_1484_length_404_cov_1.374648_g1395_i0	PRJNA1174770	1484	404	1.374648	5.55357792	Viruses	10239	Viruses	Viruses	69.7	3.11e-12	NR	XOS42973.1	2832643	g1395	i0	48.1	2.25	77	28	54.2	2	3	221	52	120	XOS42973.1 MAG: hypothetical protein MSP0968_16 [Caudoviricetes sp.]	diamond	909	70.1	0.994293865905849	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
27609394	27609394	PRJNA1174770_P_NODE_5004_length_207_cov_1.329114_g4915_i0	PRJNA1174770	5004	207	1.329114	2.75126598	Bordetella phage PY223	3118915	Viruses	Viruses	57.4	5.49e-8	NR	WVR18342.1	3118915	g4915	i0	80.6	0.449275362318841	31	6	44.9	0	114	206	1	31	WVR18342.1 baseplate assembly protein V [Bordetella phage PY223]	diamond	93	57.4	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Bordetella phage PY223
27925032	27925032	PRJNA1174770_P_NODE_2065_length_334_cov_1.870175_g1976_i0	PRJNA1174770	2065	334	1.870175	6.2463845	Pimephales minnow adintovirus	2609864	Viruses	Viruses	62.8	6.02e-9	NR	DAC81404.1	2609864	g1976	i0	31.3	1.97604790419162	112	76	99.7	1	2	334	25	136	DAC81404.1 TPA_asm: hypothetical protein [Pimephales minnow adintovirus]	diamond	660	62.8	1	Viruses		Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Pimephales minnow adintovirus
28082821	28082821	PRJNA1174770_P_NODE_11225_length_163_cov_0.912281_g11136_i0	PRJNA1174770	11225	163	0.912281	1.48701803	Pseudomonas phage ZRG1	3032262	Viruses	Viruses	85.1	1.48e-17	NR	WID42089.1	3032262	g11136	i0	69.8	0.975460122699387	53	16	97.5	0	5	163	335	387	WID42089.1 cellulase family glycosylhydrolase [Pseudomonas phage ZRG1]	diamond	159	85.1	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Pseudomonas phage ZRG1
28777426	28777426	PRJNA1174770_P_NODE_10407_length_165_cov_0.870690_g10318_i0	PRJNA1174770	10407	165	0.87069	1.4366385	Corynebacterium phage Darwin	2047869	Viruses	Viruses	64.7	2.26e-10	NR	YP_009620320.1	2047869	g10318	i0	66.7	1.85454545454545	48	16	87.3	0	145	2	400	447	YP_009620320.1 ribonucleotide reductase [Corynebacterium phage Darwin]	diamond	306	64.7	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes		Zierdtviridae	Ceetrepovirus	Ceetrepovirus darwin
29125152	29125152	PRJNA1174770_P_NODE_6549_length_183_cov_1.895522_g6460_i0	PRJNA1174770	6549	183	1.895522	3.46880526	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	45.1	0.00257	NR	YP_010797600.1	2951531	g6460	i0	31.7	0.983606557377049	60	41	98.4	0	181	2	71	130	YP_010797600.1 L protein [Guangdong red-banded snake chuvirus-like virus]	diamond	180	45.1	1	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus
29851173	29851173	PRJNA1174770_P_NODE_10191_length_165_cov_0.887931_g10102_i0	PRJNA1174770	10191	165	0.887931	1.46508615	Caudoviricetes sp.	2832643	Viruses	Viruses	113	2.41e-30	NR	XOR94885.1	2832643	g10102	i0	94.5	1	55	3	100	0	165	1	81	135	XOR94885.1 MAG: helix-turn-helix DNA-binding domain-containing protein [Caudoviricetes sp.]	diamond	165	113	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
30735646	30735646	PRJNA1174770_P_NODE_4214_length_224_cov_1.760000_g4125_i0	PRJNA1174770	4214	224	1.76	3.9424	Bordetella phage PY223	3118915	Viruses	Viruses	117	1.08e-28	NR	WVR18288.1	3118915	g4125	i0	82.2	0.977678571428571	73	13	97.8	0	219	1	460	532	WVR18288.1 DNA repair exonuclease SbcCD ATPase subunit [Bordetella phage PY223]	diamond	219	117	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Bordetella phage PY223
31367995	31367995	PRJNA1174770_P_NODE_576_length_670_cov_2.763285_g501_i0	PRJNA1174770	576	670	2.763285	18.5140095	African cichlid piscichuvirus	3065075	Viruses	Viruses	126	3.24e-29	NR	WLN26256.1	3065075	g501	i0	44.1	0.649253731343284	145	81	64.9	0	7	441	90	234	WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus]	diamond	435	126	1	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	African cichlid piscichuvirus
31430970	31430970	PRJNA1174770_P_NODE_11936_length_162_cov_0.920354_g11847_i0	PRJNA1174770	11936	162	0.920354	1.49097348	Galidia ERV	1400255	Viruses	Viruses	48.9	8.17e-5	NR	AGV92853.1	1400255	g11847	i0	47.9	2.72222222222222	48	25	88.9	0	146	3	903	950	AGV92853.1 polymerase, partial [Galidia ERV]	diamond	441	48.9	1	Viruses	Reticuloendotheliosis virus group	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Galidia ERV
31652256	31652256	PRJNA1174770_P_NODE_6737_length_181_cov_1.242424_g6648_i0	PRJNA1174770	6737	181	1.242424	2.24878744	uncultured Caudovirales phage	2100421	Viruses	Viruses	81.6	3.08e-16	NR	CAB4124912.1	2100421	g6648	i0	73.1	0.861878453038674	52	14	86.2	0	158	3	654	705	CAB4124912.1 NAT_SF domain containing protein [uncultured Caudovirales phage]	diamond	156	81.6	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
32190338	32190338	PRJNA1174770_P_NODE_7858_length_169_cov_1.350000_g7769_i0	PRJNA1174770	7858	169	1.35	2.2815	Bordetella phage PY223	3118915	Viruses	Viruses	99.4	1.6000000000000002e-22	NR	WVR18294.1	3118915	g7769	i0	83.9	0.994082840236686	56	9	99.4	0	2	169	564	619	WVR18294.1 CHC2 zinc finger protein [Bordetella phage PY223]	diamond	168	99.4	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Bordetella phage PY223

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