metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1005695" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1005695" 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
10356713	10356713	PRJNA1005695_P_NODE_33329_length_258_cov_1.610811_g32477_i0	PRJNA1005695	33329	258	1.610811	4.15589238	Aeromonas phage PS1	2591406	Viruses	Viruses	93.2	4.04e-20	NR	YP_010674769.1	2591406	g32477	i0	61.2	0.988372093023256	85	32	98.8	1	2	256	267	350	YP_010674769.1 internal head protein [Aeromonas phage PS1]	diamond	255	93.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Chimalliviridae	Ferozepurvirus	Ferozepurvirus PS1
22678009	22678009	PRJNA1005695_P_NODE_37418_length_247_cov_1.477011_g36566_i0	PRJNA1005695	37418	247	1.477011	3.64821717	Aeromonas phage PVN	3431627	Viruses	Viruses	168	3.389999999999999e-47	NR	YP_010845329.1	2822864	g36566	i0	91.5	0.995951417004049	82	7	99.6	0	247	2	533	614	YP_010845329.1 anaerobic NTP reductase large subunit [Aeromonas phage PVN03]	diamond	246	168	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Chaseviridae	Phayathaivirus	Phayathaivirus PVN03
27128855	27128855	PRJNA1005695_P_NODE_36662_length_249_cov_0.886364_g35810_i0	PRJNA1005695	36662	249	0.886364	2.20704636	Pantoea phage Phynn	2589666	Viruses	Viruses	65.9	2.77e-10	NR	QDH49241.1	2589666	g35810	i0	46.2	1.95180722891566	78	40	94	1	247	14	400	475	QDH49241.1 nicotinamide phosphoribosyltransferase [Pantoea phage Phynn]	diamond	486	65.9	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae		Pantoea phage Phynn
27950558	27950558	PRJNA1005695_P_NODE_29105_length_277_cov_1.524510_g28253_i0	PRJNA1005695	29105	277	1.52451	4.2228927	Caudoviricetes sp.	2832643	Viruses	Viruses	106	2.6899999999999994e-24	NR	XOS26520.1	2832643	g28253	i0	65.4	2.53429602888087	78	27	84.5	0	235	2	1	78	XOS26520.1 MAG: ribonucleotide reductase A subunit [Caudoviricetes sp.]	diamond	702	106	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
28140192	28140192	PRJNA1005695_P_NODE_38485_length_245_cov_0.906977_g37633_i0	PRJNA1005695	38485	245	0.906977	2.22209365	Pseudotevenvirus RB43	115991	Viruses	Viruses	47	9.13e-4	NR	CCK74042.1	115991	g37633	i0	41	0.955102040816327	78	43	95.5	3	243	10	9	83	CCK74042.1 protein of unknown function [Pseudotevenvirus RB43]	diamond	234	47	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae	Pseudotevenvirus	Pseudotevenvirus RB43
28171482	28171482	PRJNA1005695_P_NODE_28626_length_279_cov_2.898058_g27774_i0	PRJNA1005695	28626	279	2.898058	8.08558182	Aeromonas phage ZPAH14	2924887	Viruses	Viruses	72.8	1.46e-12	NR	YP_010656714.1	2924887	g27774	i0	53.5	1.76344086021505	86	31	87.1	4	243	1	322	403	YP_010656714.1 hypothetical protein PP651_gp13 [Aeromonas phage ZPAH14]	diamond	492	72.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Chaseviridae	Shantouvirus	Shantouvirus ZPAH14
28321890	28321890	PRJNA1005695_P_NODE_39166_length_244_cov_0.912281_g38314_i0	PRJNA1005695	39166	244	0.912281	2.22596564	Viruses	10239	Viruses	Viruses	137	2.79e-39	NR	YP_009196470.1	1327935	g38314	i0	75.3	2.98770491803279	81	20	99.6	0	243	1	64	144	YP_009196470.1 tail tube protein [Cronobacter phage S13]	diamond	729	137	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae		Cronobacter phage S13
28985283	28985283	PRJNA1005695_P_NODE_18548_length_351_cov_1.061151_g17696_i0	PRJNA1005695	18548	351	1.061151	3.72464001	Chaseviridae	2731689	Viruses	Viruses	136	1.9e-37	NR	YP_009008859.1	1445859	g17696	i0	75.9	3.04273504273504	87	21	74.4	0	349	89	145	231	YP_009008859.1 hypothetical protein Spp001_39 [Shewanella phage Spp001]	diamond	1068	137	0.992700729927007	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Chaseviridae	Yushanvirus	Yushanvirus Spp001
31796833	31796833	PRJNA1005695_P_NODE_38577_length_245_cov_0.906977_g37725_i0	PRJNA1005695	38577	245	0.906977	2.22209365	Machinavirus	2169624	Viruses	Viruses	117	8.71e-29	NR	YP_009293182.1	1883373	g37725	i0	63.3	1.93469387755102	79	29	96.7	0	240	4	84	162	YP_009293182.1 virion structural protein [Erwinia phage vB_EamM_Huxley]	diamond	474	117	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Chimalliviridae	Machinavirus	Machinavirus machina

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