metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA789095" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA789095" 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
5874747	5874747	PRJNA789095_P_NODE_61525_length_260_cov_1.465241_g60191_i0	PRJNA789095	61525	260	1.465241	3.8096266	Caudoviricetes sp.	2832643	Viruses	Viruses	448	2.5899999999999996e-121	NTclustered	gi\|2057128742\|tpg\|BK058097.1\|	2832643	g60191	i0	97.692	4.44615384615385	260	6	100	0	1	260	127042	127301	MAG TPA_asm: Caudoviricetes sp. isolate ct7Al7, partial genome	blastn	1156	448	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
5874879	5874879	PRJNA789095_P_NODE_65705_length_251_cov_1.662921_g64371_i0	PRJNA789095	65705	251	1.662921	4.17393171	Chemalvirus PseuGes254	3427870	Viruses	Viruses	291	4.43e-74	NTclustered	gi\|2618969016\|gb\|OR575930.1\|	3092638	g64371	i0	87.6	0.99601593625498	250	31	99	0	1	250	31581	31332	Pseudomonas phage vB_PseuGesM_254, complete genome	blastn	250	291	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Vandenendeviridae	Chemalvirus	Chemalvirus PseuGes254
12250866	12250866	PRJNA789095_P_NODE_64550_length_253_cov_3.061111_g63216_i0	PRJNA789095	64550	253	3.061111	7.74461083	Caudoviricetes sp.	2832643	Viruses	Viruses	448	2.5099999999999998e-121	NTclustered	gi\|2915012446\|gb\|OR222476.1\|	2832643	g63216	i0	98.805	104.438735177866	251	3	99	0	3	253	9028	8778	MAG: Caudoviricetes sp. isolate MSP0915 genomic sequence	blastn	26423	448	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
12694153	12694153	PRJNA789095_P_NODE_54090_length_276_cov_2.950739_g52756_i0	PRJNA789095	54090	276	2.950739	8.14403964	Gualtarvirus	2948732	Viruses	Viruses	91.6	5.38e-14	NTclustered	gi\|1936180902\|gb\|MW082584.1\|	2787015	g52756	i0	86.747	25.0507246376812	83	9	30	2	95	177	147219	147299	Serratia phage 4S, complete genome	blastn	6914	91.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae		Serratia phage 4S
13525275	13525275	PRJNA789095_P_NODE_71331_length_245_cov_2.866279_g69997_i0	PRJNA789095	71331	245	2.866279	7.02238355	Caudoviricetes sp.	2832643	Viruses	Viruses	52.8	0.022	NTclustered	gi\|2054759203\|tpg\|BK043588.1\|	2832643	g69997	i0	100	0.114285714285714	28	0	11	0	5	32	2655	2628	MAG TPA_asm: Caudoviricetes sp. isolate ctBlH5, partial genome	blastn	28	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
16074010	16074010	PRJNA789095_P_NODE_69113_length_248_cov_0.880000_g67779_i0	PRJNA789095	69113	248	0.88	2.1824	Caudoviricetes sp.	2832643	Viruses	Viruses	424	4.13e-114	NTclustered	gi\|2057112422\|tpg\|BK038543.1\|	2832643	g67779	i0	97.581	9.73387096774194	248	5	100	1	1	248	56783	56537	MAG TPA_asm: Caudoviricetes sp. isolate ct8461, partial genome	blastn	2414	424	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
17349836	17349836	PRJNA789095_P_NODE_71914_length_245_cov_0.895349_g70580_i0	PRJNA789095	71914	245	0.895349	2.19360505	Caudoviricetes sp.	2832643	Viruses	Viruses	442	1.1199999999999994e-119	NTclustered	gi\|2052998103\|tpg\|BK030969.1\|	2832643	g70580	i0	99.184	456.89387755102	245	2	100	0	1	245	283	39	MAG TPA_asm: Caudoviricetes sp. isolate ctdoP9, partial genome	blastn	111939	442	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
19066238	19066238	PRJNA789095_P_NODE_66455_length_250_cov_3.598870_g65121_i0	PRJNA789095	66455	250	3.59887	8.997175	Pahexavirus	1982251	Viruses	Viruses	374	4.2499999999999986e-99	NTclustered	gi\|543171355\|ref\|NC_022336.1\|	1235645	g65121	i0	93.927	93.476	247	15	99	0	1	247	10287	10041	Propionibacterium phage PHL010M04, complete genome	blastn	23369	374	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Pahexavirus	Pahexavirus PHL151N00
19896937	19896937	PRJNA789095_P_NODE_23156_length_478_cov_2.407407_g21826_i0	PRJNA789095	23156	478	2.407407	11.50740546	Caudoviricetes sp.	2832643	Viruses	Viruses	721	0	NTclustered	gi\|2054434277\|tpg\|BK035998.1\|	2832643	g21826	i0	95.565	353.941422594142	451	18	94	2	29	478	17758	18207	MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome	blastn	169184	721	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
24998145	24998145	PRJNA789095_P_NODE_76760_length_237_cov_3.579268_g75426_i0	PRJNA789095	76760	237	3.579268	8.48286516	Caudoviricetes sp.	2832643	Viruses	Viruses	433	6.5e-117	NTclustered	gi\|2915051030\|gb\|OR222847.1\|	2832643	g75426	i0	99.578	12.7299578059072	237	1	100	0	1	237	72672	72436	MAG: Caudoviricetes sp. isolate MSP0502 genomic sequence	blastn	3017	433	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);;