metadata: contig_metadata: 14 rows where bioproject = "PRJNA1204310" and tax

14 rows where bioproject = "PRJNA1204310" 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
5432925	5432925	PRJNA1204310_P_NODE_59985_length_244_cov_2.818713_g59688_i0	PRJNA1204310	59985	244	2.818713	6.87765972	Rhadinovirus saimiriinegamma2	3050350	Viruses	Viruses	97.1	1e-15	NTclustered	gi\|30348412\|emb\|AJ410478.1\|	10381	g59688	i0	84.158	16.6967213114754	101	14	41	2	11	110	262	163	Saimiriine herpesvirus 2 stpC and tip genes, strain C5952	blastn	4074	97.1	1	Viruses	Heunggongvirae	Peploviricota	Herviviricetes	Herpesvirales	Orthoherpesviridae	Rhadinovirus	Rhadinovirus saimiriinegamma2
6707230	6707230	PRJNA1204310_P_NODE_46106_length_271_cov_1.545455_g45809_i0	PRJNA1204310	46106	271	1.545455	4.18818305	Synechococcus phage S-CRES3	3038222	Viruses	Viruses	296	1.04e-75	NTclustered	gi\|2496382469\|gb\|OQ587941.1\|	3038222	g45809	i0	88	0.922509225092251	250	30	92	0	22	271	52012	52261	Synechococcus phage S-CRES3, complete genome	blastn	250	296	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Synechococcus phage S-CRES3
6707552	6707552	PRJNA1204310_P_NODE_60746_length_244_cov_0.912281_g60449_i0	PRJNA1204310	60746	244	0.912281	2.22596564	Cyanophage S-RIM4	2530169	Viruses	Viruses	231	2.63e-56	NTclustered	gi\|1603723705\|gb\|MK493321.1\|	2530169	g60449	i0	86.385	57.3032786885246	213	27	87	2	10	221	142679	142468	Cyanophage S-RIM4 isolate RW_11_0999, complete genome	blastn	13982	231	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Kyanoviridae	Shandvirus	Cyanophage S-RIM4
9257631	9257631	PRJNA1204310_P_NODE_57328_length_247_cov_0.896552_g57031_i0	PRJNA1204310	57328	247	0.896552	2.21448344	Prochlorococcus phage P-TIM68	1542477	Viruses	Viruses	69.7	1.17e-11	NR	YP_009213605.1	1542477	g57031	i0	57	0.959514170040486	79	31	92.3	2	3	230	225	303	YP_009213605.1 head closure Hc2 [Prochlorococcus phage P-TIM68]	diamond	237	69.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Kyanoviridae	Haifavirus	Haifavirus tim68
16347573	16347573	PRJNA1204310_P_NODE_58873_length_246_cov_0.901734_g58576_i0	PRJNA1204310	58873	246	0.901734	2.21826564	Aurunvirus	2733093	Viruses	Viruses	196	9.7e-46	NTclustered	gi\|2275413904\|ref\|NC_019516.2\|	1137745	g58576	i0	81.275	3.0609756097561	251	40	100	5	1	246	153209	152961	Cyanophage S-TIM5, complete genome	blastn	753	196	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Aurunvirus	Aurunvirus STIM5
18180905	18180905	PRJNA1204310_P_NODE_40675_length_290_cov_2.023041_g40378_i0	PRJNA1204310	40675	290	2.023041	5.8668189	Drulisvirus K72PH164C2	3428371	Viruses	Viruses	60.2	1.6e-4	NTclustered	gi\|2617470222\|emb\|OY757088.1\|	3071646	g40378	i0	100	0.110344827586207	32	0	11	0	242	273	3968	3999	Klebsiella phage vB_Kpl_K72PH164C2 genome assembly, chromosome: K72PH164C2_assembly	blastn	32	60.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Autographivirales	Autoscriptoviridae	Drulisvirus	Drulisvirus K72PH164C2
26851342	26851342	PRJNA1204310_P_NODE_53981_length_250_cov_0.881356_g53684_i0	PRJNA1204310	53981	250	0.881356	2.20339	Synechococcus phage S-CRES1	3038220	Viruses	Viruses	132	1.28e-36	NR	WGL30445.1	3038220	g53684	i0	79.5	0.996	83	17	99.6	0	250	2	64	146	WGL30445.1 FAD-dependent thymidylate synthase [Synechococcus phage S-CRES1]	diamond	249	132	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Synechococcus phage S-CRES1
27660295	27660295	PRJNA1204310_P_NODE_51164_length_253_cov_0.866667_g50867_i0	PRJNA1204310	51164	253	0.866667	2.19266751	Kyanoviridae	2946160	Viruses	Viruses	153	1.5e-44	NR	YP_004322420.1	444860	g50867	i0	86.9	1.94466403162055	84	11	99.6	0	2	253	16	99	YP_004322420.1 thymidylate synthase [Synechococcus phage S-SM2]	diamond	492	153	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Kyanoviridae	Nilusvirus	Nilusvirus ssm2
28272575	28272575	PRJNA1204310_P_NODE_61626_length_243_cov_0.917647_g61329_i0	PRJNA1204310	61626	243	0.917647	2.22988221	uncultured phage_MedDCM-OCT-S45-C4	2740801	Viruses	Viruses	79	5.04e-15	NR	YP_009778022.1	2740801	g61329	i0	56.8	1	81	33	97.5	2	5	241	25	105	YP_009778022.1 tail fiber protein [uncultured phage_MedDCM-OCT-S45-C4]	diamond	243	79	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Autographivirales		Ashivirus	Ashivirus S45C4
29459529	29459529	PRJNA1204310_P_NODE_36290_length_310_cov_0.877637_g35993_i0	PRJNA1204310	36290	310	0.877637	2.7206747	root	1	Root_unresolved	Root_unresolved	64.3	3.42e-10	NR	YP_007673165.1	754040	g35993	i0	55.1	1.52903225806452	69	29	66.8	2	207	1	30	96	YP_007673165.1 hypothetical protein SWQG_00019 [Synechococcus phage S-RIP2]	diamond	474	64.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Autographivirales		Sednavirus	Sednavirus SRIP2
31589783	31589783	PRJNA1204310_P_NODE_55056_length_249_cov_0.886364_g54759_i0	PRJNA1204310	55056	249	0.886364	2.20704636	uncultured Mediterranean phage MEDS5 group	1262075	Viruses	Viruses	106	1.2999999999999998e-24	NR	AFX83901.1	1262075	g54759	i0	76.1	1.62650602409639	67	16	80.7	0	3	203	316	382	AFX83901.1 phage major capsid protein [uncultured Mediterranean phage MEDS5 group]	diamond	405	106	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				uncultured Mediterranean phage MEDS5 group
31747656	31747656	PRJNA1204310_P_NODE_36897_length_307_cov_1.000000_g36600_i0	PRJNA1204310	36897	307	1	3.07	Synechococcus phage S-CBWM1	2053653	Viruses	Viruses	82	1.13e-15	NR	YP_009816528.1	2053653	g36600	i0	54.9	0.801302931596091	82	29	76.2	3	3	236	395	472	YP_009816528.1 head maturation protease [Synechococcus phage S-CBWM1]	diamond	246	82	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Aokuangvirus	Aokuangvirus SCBWM1
31811048	31811048	PRJNA1204310_P_NODE_61957_length_242_cov_1.786982_g61660_i0	PRJNA1204310	61957	242	1.786982	4.32449644	Synechococcus phage S-SM2	444860	Viruses	Viruses	113	6.160000000000001e-27	NR	YP_004322186.1	444860	g61660	i0	62.8	0.966942148760331	78	29	96.7	0	240	7	1584	1661	YP_004322186.1 tail fiber protein [Synechococcus phage S-SM2]	diamond	234	113	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Kyanoviridae	Nilusvirus	Nilusvirus ssm2
31969124	31969124	PRJNA1204310_P_NODE_56218_length_248_cov_0.891429_g55921_i0	PRJNA1204310	56218	248	0.891429	2.21074392	Synechococcus phage S-CRES3	3038222	Viruses	Viruses	112	4.16e-30	NR	WGL30760.1	3038222	g55921	i0	71.3	0.967741935483871	80	23	96.8	0	240	1	1	80	WGL30760.1 hypothetical protein SCRES3_gp103 [Synechococcus phage S-CRES3]	diamond	240	112	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Synechococcus phage S-CRES3

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