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

15 rows where bioproject = "PRJNA690592" 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
671204	671204	PRJNA690592_S_NODE_174141_length_259_cov_1.220430_g173127_i0	PRJNA690592	174141	259	1.22043	3.1609137	Caudoviricetes sp.	2832643	Viruses	Viruses	54.7	0.007	NTclustered	gi\|2054779292\|tpg\|BK049701.1\|	2832643	g173127	i0	100	0.111969111969112	29	0	11	0	143	171	2196	2168	MAG TPA_asm: Caudoviricetes sp. isolate cthCc3, partial genome	blastn	29	54.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
5774422	5774422	PRJNA690592_S_NODE_123725_length_300_cov_2.365639_g122711_i0	PRJNA690592	123725	300	2.365639	7.096917	Caudoviricetes sp.	2832643	Viruses	Viruses	56.5	0.002	NTclustered	gi\|2058048439\|tpg\|BK042485.1\|	2832643	g122711	i0	100	0.39	30	0	10	0	25	54	31161	31190	MAG TPA_asm: Caudoviricetes sp. isolate ctCEr7, partial genome	blastn	117	56.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
9599619	9599619	PRJNA690592_S_NODE_16068_length_737_cov_21.843373_g15162_i0	PRJNA690592	16068	737	21.843373	160.98565901	Caudoviricetes sp.	2832643	Viruses	Viruses	56.5	0.006	NTclustered	gi\|2059595612\|tpg\|BK036979.1\|	2832643	g15162	i0	96.97	0.0447761194029851	33	1	4	0	244	276	18043	18075	MAG TPA_asm: Caudoviricetes sp. isolate ctoq918, partial genome	blastn	33	56.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
9600399	9600399	PRJNA690592_S_NODE_71488_length_377_cov_1.144737_g70474_i0	PRJNA690592	71488	377	1.144737	4.31565849	Microbacterium phage YuuY	2652417	Viruses	Viruses	56.5	0.003	NTclustered	gi\|1764710673\|gb\|MN284901.1\|	2652417	g70474	i0	88	0.440318302387268	50	3	12	2	11	57	24523	24474	Microbacterium phage YuuY, complete genome	blastn	166	56.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Elerivirus	Microbacterium phage YuuY
12151152	12151152	PRJNA690592_S_NODE_67010_length_387_cov_1.716561_g65996_i0	PRJNA690592	67010	387	1.716561	6.64309107	Caudoviricetes sp.	2832643	Viruses	Viruses	58.4	7.94e-4	NTclustered	gi\|2059611993\|tpg\|BK037319.1\|	2832643	g65996	i0	97.059	0.816537467700258	34	1	10	0	184	217	46782	46815	MAG TPA_asm: Caudoviricetes sp. isolate ctt3g2, partial genome	blastn	316	58.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
13424930	13424930	PRJNA690592_S_NODE_16231_length_734_cov_18.065053_g15322_i0	PRJNA690592	16231	734	18.065053	132.59748902	Caudoviricetes sp.	2832643	Viruses	Viruses	56.5	0.006	NTclustered	gi\|2059595612\|tpg\|BK036979.1\|	2832643	g15322	i0	96.97	0.0449591280653951	33	1	4	0	244	276	18043	18075	MAG TPA_asm: Caudoviricetes sp. isolate ctoq918, partial genome	blastn	33	56.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
15973728	15973728	PRJNA690592_S_NODE_143673_length_282_cov_1.473684_g142659_i0	PRJNA690592	143673	282	1.473684	4.15578888	Caudoviricetes sp.	2832643	Viruses	Viruses	54.7	0.007	NTclustered	gi\|2054629845\|tpg\|BK022290.1\|	2832643	g142659	i0	100	0.102836879432624	29	0	10	0	99	127	5132	5104	MAG TPA_asm: Caudoviricetes sp. isolate ct1P710, partial genome	blastn	29	54.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
18523071	18523071	PRJNA690592_S_NODE_153875_length_274_cov_1.149254_g152861_i0	PRJNA690592	153875	274	1.149254	3.14895596	Caudoviricetes sp.	2832643	Viruses	Viruses	507	4.47e-139	NTclustered	gi\|2915016823\|gb\|OR222530.1\|	2832643	g152861	i0	100	52.6021897810219	274	0	100	0	1	274	21774	22047	MAG: Caudoviricetes sp. isolate MSP0407 genomic sequence	blastn	14413	507	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
24898022	24898022	PRJNA690592_S_NODE_43660_length_466_cov_1.936387_g42646_i0	PRJNA690592	43660	466	1.936387	9.02356342	Caudoviricetes sp.	2832643	Viruses	Viruses	52.8	0.045	NTclustered	gi\|2059778054\|tpg\|BK039281.1\|	2832643	g42646	i0	100	0.133047210300429	28	0	6	0	238	265	27942	27969	MAG TPA_asm: Caudoviricetes sp. isolate ctwJd6, partial genome	blastn	62	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
28156551	28156551	PRJNA690592_S_NODE_207105_length_244_cov_0.900585_g206091_i0	PRJNA690592	207105	244	0.900585	2.1974274	Streptomyces phage Yaboi	2301621	Viruses	Viruses	76.6	5.41e-15	NR	YP_009841238.1	2301621	g206091	i0	58.8	0.836065573770492	68	28	83.6	0	234	31	102	169	YP_009841238.1 hypothetical protein HWB86_gp180 [Streptomyces phage Yaboi]	diamond	204	76.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Stanwilliamsviridae	Karimacvirus	Karimacvirus yaboi
29513915	29513915	PRJNA690592_S_NODE_99110_length_329_cov_1.042969_g98096_i0	PRJNA690592	99110	329	1.042969	3.43136801	Roseobacter phage RDJL Phi 1	562742	Viruses	Viruses	53.1	2.07e-6	NR	YP_004421789.1	562742	g98096	i0	47.1	3.95744680851064	51	27	46.5	0	176	328	8	58	YP_004421789.1 hypothetical protein RDJLphi1_gp21 [Roseobacter phage RDJL Phi 1]	diamond	1302	53.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Xiamenvirus	Xiamenvirus RDJL1
29608318	29608318	PRJNA690592_S_NODE_145150_length_281_cov_1.110577_g144136_i0	PRJNA690592	145150	281	1.110577	3.12072137	uncultured Mediterranean phage uvMED	1407671	Viruses	Viruses	44.7	0.00749	NR	BAQ88411.1	1407671	g144136	i0	44.2	0.555160142348754	52	27	55.5	1	281	126	110	159	BAQ88411.1 phage morphogenesis protein [uncultured Mediterranean phage uvMED]	diamond	156	44.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				uncultured Mediterranean phage uvMED
30367207	30367207	PRJNA690592_S_NODE_116572_length_308_cov_1.310638_g115558_i0	PRJNA690592	116572	308	1.310638	4.03676504	Klebsiella phage Kp_Pokalde_	3431989	Viruses	Viruses	54.3	1.06e-6	NR	QKE60375.1	2736260	g115558	i0	34.4	0.876623376623377	90	46	75	2	266	36	4	93	QKE60375.1 putative DNA endonuclease VII [Klebsiella phage Kp_Pokalde_002]	diamond	270	54.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Autographivirales	Autotranscriptaviridae	Przondovirus	Przondovirus pokalde002
30619538	30619538	PRJNA690592_S_NODE_26853_length_581_cov_2.328740_g25859_i0	PRJNA690592	26853	581	2.32874	13.5299794	Caudoviricetes sp.	2832643	Viruses	Viruses	62.4	5.14e-8	NR	DAG67903.1	2832643	g25859	i0	53.5	0.222030981067126	43	20	22.2	0	326	454	28	70	DAG67903.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	129	62.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
31124699	31124699	PRJNA690592_S_NODE_150335_length_277_cov_1.019608_g149321_i0	PRJNA690592	150335	277	1.019608	2.82431416	Caudoviricetes sp.	2832643	Viruses	Viruses	43.5	0.0147	NR	DAM69420.1	2832643	g149321	i0	31.4	0.931407942238267	86	58	92.1	1	264	10	10	95	DAM69420.1 MAG TPA: DNA-packaging protein [Caudoviricetes sp.]	diamond	258	43.5	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);;