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

15 rows where analysis = "diamond", bioproject = "PRJNA982106" and tax_phylum = "Uroviricota"

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_genus	tax_species
22948935	22948935	PRJNA982106_P_NODE_3958_length_449_cov_1.194149_g3719_i0	PRJNA982106	3958	449	1.194149	5.36172901	Streptomyces phage RosaAsantewaa	2562347	Viruses	Viruses	114	4.88e-26	NR	QBZ73603.1	2562347	g3719	i0	58.3	0.641425389755011	96	36	62.8	2	449	168	1182	1275	QBZ73603.1 DNA primase/polymerase [Streptomyces phage RosaAsantewaa]	diamond	288	114	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Scapunavirus	Streptomyces phage RosaAsantewaa
26836600	26836600	PRJNA982106_P_NODE_28041_length_245_cov_0.895349_g27801_i0	PRJNA982106	28041	245	0.895349	2.19360505	Caudoviricetes sp.	2832643	Viruses	Viruses	44.3	0.00167	NR	DAT63459.1	2832643	g27801	i0	49.1	1.23673469387755	55	21	67.3	2	23	187	37	84	DAT63459.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	303	44.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Caudoviricetes sp.
26962843	26962843	PRJNA982106_P_NODE_2762_length_524_cov_1.177384_g2524_i0	PRJNA982106	2762	524	1.177384	6.16949216	Streptomyces phage Scap1	2041354	Viruses	Viruses	115	2.15e-29	NR	YP_009615371.1	2041354	g2524	i0	52.6	1.32824427480916	116	55	66.4	0	356	9	1	116	YP_009615371.1 holin [Streptomyces phage Scap1]	diamond	696	115	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Scapunavirus	Scapunavirus scap1
27279277	27279277	PRJNA982106_P_NODE_3583_length_468_cov_0.845570_g3344_i0	PRJNA982106	3583	468	0.84557	3.9572676	Streptomyces phage Bing	2079427	Viruses	Viruses	197	3.239999999999999e-55	NR	YP_009622884.1	2079427	g3344	i0	68.2	1.98717948717949	154	49	98.7	0	468	7	692	845	YP_009622884.1 RNA-dependent RNA polymerase [Streptomyces phage Bing]	diamond	930	197	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Bingvirus	Bingvirus bing
27437405	27437405	PRJNA982106_P_NODE_1723_length_673_cov_1.421667_g1491_i0	PRJNA982106	1723	673	1.421667	9.56781891	Streptomyces phage LibertyBell	2301574	Viruses	Viruses	147	1.34e-41	NR	AXQ61246.1	2301574	g1491	i0	58.5	1.06537890044577	123	50	54.4	1	377	12	2	124	AXQ61246.1 hypothetical protein SEA_LIBERTYBELL_5 [Streptomyces phage LibertyBell]	diamond	717	147	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Streptomyces phage LibertyBell
27759230	27759230	PRJNA982106_P_NODE_6324_length_379_cov_1.006536_g6084_i0	PRJNA982106	6324	379	1.006536	3.81477144	Scapunavirus	2560225	Viruses	Viruses	132	3.18e-35	NR	YP_009615366.1	2041354	g6084	i0	53.2	2.95250659630607	126	59	99.7	0	378	1	37	162	YP_009615366.1 minor tail protein [Streptomyces phage Scap1]	diamond	1119	132	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Scapunavirus	Scapunavirus scap1
29521004	29521004	PRJNA982106_P_NODE_17770_length_267_cov_1.067010_g17530_i0	PRJNA982106	17770	267	1.06701	2.8489167	Streptomyces phage Scap1	2041354	Viruses	Viruses	128	3.5e-32	NR	YP_009615401.1	2041354	g17530	i0	73	1	89	22	100	1	267	1	568	654	YP_009615401.1 RNA-dependent RNA polymerase [Streptomyces phage Scap1]	diamond	267	128	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Scapunavirus	Scapunavirus scap1
30063824	30063824	PRJNA982106_P_NODE_13151_length_298_cov_0.857778_g12911_i0	PRJNA982106	13151	298	0.857778	2.55617844	Scapunavirus	2560225	Viruses	Viruses	108	2.29e-26	NR	QBZ73600.1	2562347	g12911	i0	57.3	1.95302013422819	96	41	96.6	0	10	297	87	182	QBZ73600.1 membrane protein [Streptomyces phage RosaAsantewaa]	diamond	582	108	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Scapunavirus	Streptomyces phage RosaAsantewaa
30279466	30279466	PRJNA982106_P_NODE_8052_length_350_cov_1.093863_g7812_i0	PRJNA982106	8052	350	1.093863	3.8285205	Caudoviricetes sp.	2832643	Viruses	Viruses	131	2.49e-36	NR	DAG32307.1	2832643	g7812	i0	92.3	2.78571428571429	65	5	55.7	0	350	156	91	155	DAG32307.1 MAG TPA: IS66 Orf2 like protein [Caudoviricetes sp.]	diamond	975	131	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Caudoviricetes sp.
30658220	30658220	PRJNA982106_P_NODE_10693_length_320_cov_0.935223_g10453_i0	PRJNA982106	10693	320	0.935223	2.9927136	Streptomyces phage Bing	2079427	Viruses	Viruses	176	1.67e-51	NR	YP_009622880.1	2079427	g10453	i0	80.2	3.9375	106	20	99.4	1	318	1	1	105	YP_009622880.1 DNA helicase [Streptomyces phage Bing]	diamond	1260	176	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Bingvirus	Bingvirus bing
30689726	30689726	PRJNA982106_P_NODE_25693_length_247_cov_0.885057_g25453_i0	PRJNA982106	25693	247	0.885057	2.18609079	Caudoviricetes sp.	2832643	Viruses	Viruses	47.8	2.59e-4	NR	DAI33279.1	2832643	g25453	i0	91.3	0.279352226720648	23	2	27.9	0	130	62	12	34	DAI33279.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	69	47.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Caudoviricetes sp.
30980394	30980394	PRJNA982106_P_NODE_19874_length_254_cov_1.276243_g19634_i0	PRJNA982106	19874	254	1.276243	3.24165722	Bingvirus	2560103	Viruses	Viruses	114	3.8500000000000006e-27	NR	YP_009622884.1	2079427	g19634	i0	69.9	5.87007874015748	83	25	98	0	4	252	381	463	YP_009622884.1 RNA-dependent RNA polymerase [Streptomyces phage Bing]	diamond	1491	114	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Bingvirus	Bingvirus bing
31100415	31100415	PRJNA982106_P_NODE_13155_length_298_cov_0.808889_g12915_i0	PRJNA982106	13155	298	0.808889	2.41048922	Streptomyces phage Kardashian	2601691	Viruses	Viruses	132	1.31e-36	NR	QEQ93881.1	2601691	g12915	i0	67.3	0.986577181208054	98	32	98.7	0	2	295	65	162	QEQ93881.1 hypothetical protein SEA_KARDASHIAN_16 [Streptomyces phage Kardashian]	diamond	294	132	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Bingvirus	Streptomyces phage Kardashian
32901917	32901917	PRJNA982106_P_NODE_11900_length_308_cov_1.234043_g11660_i0	PRJNA982106	11900	308	1.234043	3.80085244	Caudoviricetes sp.	2832643	Viruses	Viruses	130	1.68e-32	NR	DAF69193.1	2832643	g11660	i0	61.2	1.00324675324675	103	39	99.4	1	307	2	195	297	DAF69193.1 MAG TPA: Preneck appendage protein helix, VIRAL PROTEIN.05A [Caudoviricetes sp.]	diamond	309	130	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Caudoviricetes sp.
32907956	32907956	PRJNA982106_P_NODE_4060_length_445_cov_1.099462_g3821_i0	PRJNA982106	4060	445	1.099462	4.8926059	Viruses	10239	Viruses	Viruses	150	4.249999999999999e-43	NR	YP_009615398.1	2041354	g3821	i0	49.3	2.89213483146067	142	71	95.7	1	434	9	49	189	YP_009615398.1 HNH endonuclease [Streptomyces phage Scap1]	diamond	1287	151	0.993377483443709	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Scapunavirus	Scapunavirus scap1

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