metadata: contig_metadata: 15 rows where bioproject = "PRJNA835051" and tax

15 rows where bioproject = "PRJNA835051" 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_order	tax_family	tax_genus	tax_species
2101119	2101119	PRJNA835051_S_NODE_133262_length_150_cov_1.327103_g132966_i0	PRJNA835051	133262	150	1.327103	1.9906545	Caudoviricetes sp.	2832643	Viruses	Viruses	52.8	0.012	NTclustered	gi\|2906145171\|gb\|PQ646171.1\|	2832643	g132966	i0	100	0.186666666666667	28	0	19	0	62	89	43898	43871	MAG: Caudoviricetes sp. isolate k127_374151 genomic sequence	blastn	28	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
2101417	2101417	PRJNA835051_S_NODE_34102_length_242_cov_1.195980_g33806_i0	PRJNA835051	34102	242	1.19598	2.8942716	Caudoviricetes sp.	2832643	Viruses	Viruses	54.7	0.006	NTclustered	gi\|2053098917\|tpg\|BK020461.1\|	2832643	g33806	i0	100	0.119834710743802	29	0	12	0	208	236	85857	85885	MAG TPA_asm: Caudoviricetes sp. isolate ct8Hk17, partial genome	blastn	29	54.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
4653933	4653933	PRJNA835051_S_NODE_124184_length_154_cov_1.630631_g123888_i0	PRJNA835051	124184	154	1.630631	2.51117174	Caudoviricetes sp.	2832643	Viruses	Viruses	285	1.14e-72	NTclustered	gi\|2915002188\|gb\|OR222317.1\|	2832643	g123888	i0	100	3.94155844155844	154	0	100	0	1	154	50749	50902	MAG: Caudoviricetes sp. isolate MSP1091 genomic sequence	blastn	607	285	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
4654056	4654056	PRJNA835051_S_NODE_14364_length_299_cov_1.675781_g14068_i0	PRJNA835051	14364	299	1.675781	5.01058519	Caudoviricetes sp.	2832643	Viruses	Viruses	370	6.76e-98	NTclustered	gi\|2059992605\|tpg\|BK026306.1\|	2832643	g14068	i0	88.963	1	299	33	100	0	1	299	20598	20896	MAG TPA_asm: Caudoviricetes sp. isolate ct5Vs3, partial genome	blastn	299	370	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
8478532	8478532	PRJNA835051_S_NODE_14147_length_300_cov_1.657588_g13851_i0	PRJNA835051	14147	300	1.657588	4.972764	uncultured Mediterranean phage uvMED	1407671	Viruses	Viruses	52.8	0.028	NTclustered	gi\|557356596\|dbj\|AP013490.1\|	1407671	g13851	i0	96.774	0.103333333333333	31	1	10	0	16	46	11346	11316	Uncultured Mediterranean phage uvMED DNA, complete genome, group G19, isolate: uvMED-CGR-C30B-MedDCM-OCT-S46-C80	blastn	31	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				uncultured Mediterranean phage uvMED
16128240	16128240	PRJNA835051_S_NODE_133313_length_150_cov_1.317757_g133017_i0	PRJNA835051	133313	150	1.317757	1.9766355	Caudoviricetes sp.	2832643	Viruses	Viruses	67.6	4.36e-7	NTclustered	gi\|2915002964\|gb\|OR222328.1\|	2832643	g133017	i0	87.931	0.386666666666667	58	6	39	1	77	134	27140	27084	MAG: Caudoviricetes sp. isolate MSP1077 genomic sequence	blastn	58	67.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
17404141	17404141	PRJNA835051_S_NODE_2834_length_464_cov_4.866983_g2543_i0	PRJNA835051	2834	464	4.866983	22.58280112	Caudoviricetes sp.	2832643	Viruses	Viruses	774	0	NTclustered	gi\|2054434277\|tpg\|BK035998.1\|	2832643	g2543	i0	96.767	404.463362068966	464	15	100	0	1	464	18299	17836	MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome	blastn	187671	774	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
25052166	25052166	PRJNA835051_S_NODE_33820_length_242_cov_2.381910_g33524_i0	PRJNA835051	33820	242	2.38191	5.7642222	Caudoviricetes sp.	2832643	Viruses	Viruses	52.8	0.022	NTclustered	gi\|2052189786\|tpg\|BK055894.1\|	2832643	g33524	i0	100	0.115702479338843	28	0	12	0	64	91	69624	69651	MAG TPA_asm: Caudoviricetes sp. isolate ctubV7, partial genome	blastn	28	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
27559985	27559985	PRJNA835051_S_NODE_37424_length_236_cov_1.233161_g37128_i0	PRJNA835051	37424	236	1.233161	2.91025996	Caudoviricetes sp.	2832643	Viruses	Viruses	78.2	1.98e-16	NR	XOS05622.1	2832643	g37128	i0	54.2	1.89406779661017	72	30	87.7	1	28	234	2	73	XOS05622.1 MAG: gp71 protein [Caudoviricetes sp.]	diamond	447	78.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
28223039	28223039	PRJNA835051_S_NODE_5146_length_386_cov_3.338192_g4851_i0	PRJNA835051	5146	386	3.338192	12.88542112	Caudoviricetes sp.	2832643	Viruses	Viruses	72	2.9e-12	NR	XOR80200.1	2832643	g4851	i0	40.8	0.800518134715026	103	59	78.5	2	4	306	132	234	XOR80200.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	309	72	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
29044306	29044306	PRJNA835051_S_NODE_81528_length_183_cov_2.357143_g81232_i0	PRJNA835051	81528	183	2.357143	4.31357169	Caudoviricetes sp.	2832643	Viruses	Viruses	47.8	1.43e-5	NR	DAM60462.1	2832643	g81232	i0	65.6	0.524590163934426	32	11	52.5	0	110	15	1	32	DAM60462.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	96	47.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
29643672	29643672	PRJNA835051_S_NODE_52770_length_213_cov_1.717647_g52474_i0	PRJNA835051	52770	213	1.717647	3.65858811	Caudoviricetes sp.	2832643	Viruses	Viruses	60.5	1.42e-8	NR	DAZ11227.1	2832643	g52474	i0	51.1	0.661971830985915	47	23	66.2	0	34	174	248	294	DAZ11227.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	141	60.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
30907886	30907886	PRJNA835051_S_NODE_24094_length_264_cov_2.257919_g23798_i0	PRJNA835051	24094	264	2.257919	5.96090616	Gordonia phage Ghobes	1887647	Viruses	Viruses	43.1	0.019	NR	YP_009281156.1	1887647	g23798	i0	39	0.670454545454545	59	36	67	0	84	260	10	68	YP_009281156.1 deoxyuridine triphosphatase [Gordonia phage Ghobes]	diamond	177	43.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Ghobesvirus	Ghobesvirus ghobes
31318516	31318516	PRJNA835051_S_NODE_70795_length_193_cov_1.586667_g70499_i0	PRJNA835051	70795	193	1.586667	3.06226731	Podoviridae sp. ctLUJ1	2656710	Viruses	Viruses	43.1	0.00505	NR	QGH72803.1	2656710	g70499	i0	44.4	0.839378238341969	54	27	83.9	2	27	188	1	51	QGH72803.1 MAG: protein of unknown function DUF4326 [Podoviridae sp. ctLUJ1]	diamond	162	43.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Schitoviridae		Podoviridae sp. ctLUJ1
32339617	32339617	PRJNA835051_S_NODE_88459_length_178_cov_1.059259_g88163_i0	PRJNA835051	88459	178	1.059259	1.88548102	Viruses	10239	Viruses	Viruses	59.3	7.1e-9	NR	WPJ72093.1	3079598	g88163	i0	47.4	1.93820224719101	57	30	96.1	0	173	3	53	109	WPJ72093.1 hypothetical protein DEEACLCL_00076 [Salmonella phage CRW-SP2]	diamond	345	59.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Ackermannviridae		Salmonella phage CRW-SP2

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