metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA390533" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA390533" 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_genus	tax_species
11888751	11888751	PRJNA390533_P_NODE_8370_length_679_cov_4.070312_g7580_i0	PRJNA390533	8370	679	4.070312	27.63741848	Psychrobacter phage D'Alembert	2891959	Viruses	Viruses	150	4.72e-40	NR	CAH1193240.1	2891959	g7580	i0	49.3	3.27835051546392	150	73	66.3	1	655	206	1	147	CAH1193240.1 XkdK-like protein [Psychrobacter phage D'Alembert]	diamond	2226	150	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Psychrobacter phage D'Alembert
27739021	27739021	PRJNA390533_P_NODE_36344_length_199_cov_2.543750_g35317_i0	PRJNA390533	36344	199	2.54375	5.0620625	Microbacterium phage Count	2182352	Viruses	Viruses	47.8	3.34e-4	NR	AWN03372.1	2182352	g35317	i0	51.3	0.587939698492462	39	19	58.8	0	197	81	148	186	AWN03372.1 hypothetical protein PBI_COUNT_49 [Microbacterium phage Count]	diamond	117	47.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Microbacterium phage Count
29727525	29727525	PRJNA390533_P_NODE_12510_length_544_cov_5.182178_g11568_i0	PRJNA390533	12510	544	5.182178	28.19104832	Caudoviricetes sp.	2832643	Viruses	Viruses	136	2.5e-37	NR	AXF51898.1	2832643	g11568	i0	56.7	0.661764705882353	120	51	66.2	1	173	532	4	122	AXF51898.1 MAG: NADH dehydrogenase subunit C [Caudoviricetes sp.]	diamond	360	136	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Caudoviricetes sp.
30865072	30865072	PRJNA390533_P_NODE_2194_length_1186_cov_9.176112_g1855_i0	PRJNA390533	2194	1186	9.176112	108.82868832	Acinetobacter phage MD-2	2865959	Viruses	Viruses	236	7.55e-72	NR	CAH1066774.1	2899278	g1855	i0	62.4	0.430016863406408	170	64	43	0	1174	665	93	262	CAH1066774.1 Uncharacterised protein [Acinetobacter phage MD-2021a]	diamond	510	236	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Acinetobacter phage MD-2021a
31718799	31718799	PRJNA390533_P_NODE_25537_length_315_cov_1.478261_g24510_i0	PRJNA390533	25537	315	1.478261	4.65652215	Caudoviricetes sp.	2832643	Viruses	Viruses	63.2	9.58e-11	NR	XOS41782.1	2832643	g24510	i0	45.6	0.542857142857143	57	31	54.3	0	16	186	1	57	XOS41782.1 MAG: hypothetical protein MSP0993_51 [Caudoviricetes sp.]	diamond	171	63.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Caudoviricetes sp.
32146965	32146965	PRJNA390533_P_NODE_40118_length_180_cov_1.638298_g39091_i0	PRJNA390533	40118	180	1.638298	2.9489364	root	1	Root_unresolved	Root_unresolved	73.2	7.49e-14	NR	YP_009603591.1	1175654	g39091	i0	58.9	2.85	56	21	93.3	1	169	2	155	208	YP_009603591.1 QueE-like radical SAM domain [Pseudomonas phage PaMx25]	diamond	513	73.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Nipunavirus	Nipunavirus PaMx25
32193412	32193412	PRJNA390533_P_NODE_28858_length_266_cov_1.136564_g27831_i0	PRJNA390533	28858	266	1.136564	3.02326024	Caudoviricetes sp.	2832643	Viruses	Viruses	151	3.3599999999999992e-43	NR	XOQ93795.1	2832643	g27831	i0	83	0.992481203007519	88	15	99.2	0	3	266	22	109	XOQ93795.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	264	151	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Caudoviricetes sp.
32414965	32414965	PRJNA390533_P_NODE_31299_length_238_cov_3.542714_g30272_i0	PRJNA390533	31299	238	3.542714	8.43165932	Caudoviricetes sp.	2832643	Viruses	Viruses	47	8.91e-5	NR	DAR72918.1	2832643	g30272	i0	57.8	0.567226890756303	45	18	55.5	1	84	215	14	58	DAR72918.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	135	47	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Caudoviricetes sp.
32414975	32414975	PRJNA390533_P_NODE_46219_length_160_cov_1.000000_g45192_i0	PRJNA390533	46219	160	1	1.6	Pseudanabaena phage Pan4	2981587	Viruses	Viruses	95.5	8.14e-22	NR	UXO94023.1	2981587	g45192	i0	81.5	3.0375	54	9	99.4	1	160	2	153	206	UXO94023.1 DNA methylase [Pseudanabaena phage Pan4]	diamond	486	95.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Pseudanabaena phage Pan4
32510031	32510031	PRJNA390533_P_NODE_1959_length_1236_cov_7.183793_g1653_i0	PRJNA390533	1959	1236	7.183793	88.79168148	Caudoviricetes sp.	2832643	Viruses	Viruses	130	7.23e-33	NR	XOR18952.1	2832643	g1653	i0	64.5	0.533980582524272	110	36	26.2	2	568	245	1	109	XOR18952.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	660	130	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Caudoviricetes sp.
32541651	32541651	PRJNA390533_P_NODE_12199_length_554_cov_1.933981_g11261_i0	PRJNA390533	12199	554	1.933981	10.71425474	Caudoviricetes sp.	2832643	Viruses	Viruses	94	1.34e-18	NR	XOQ91086.1	2832643	g11261	i0	41.4	0.693140794223827	128	73	68.8	2	21	401	445	571	XOQ91086.1 MAG: pre-neck appendage [Caudoviricetes sp.]	diamond	384	94	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);;