metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA608660" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA608660" 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
3698486	3698486	PRJNA608660_P_NODE_2963_length_793_cov_8.826613_g2731_i0	PRJNA608660	2963	793	8.826613	69.99504109	Caudoviricetes sp.	2832643	Viruses	Viruses	247	7.850000000000001e-71	NR	XOS26097.1	2832643	g2731	i0	64.5	0.873896595208071	231	55	83.6	4	9	671	1038	1251	XOS26097.1 MAG: hypothetical protein MSP0002_14 [Caudoviricetes sp.]	diamond	693	247	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
27932936	27932936	PRJNA608660_P_NODE_17225_length_348_cov_1.739130_g16870_i0	PRJNA608660	17225	348	1.73913	6.0521724	uncultured Caudovirales phage	2100421	Viruses	Viruses	80.9	2.49e-16	NR	CAB4138382.1	2100421	g16870	i0	73.3	0.767241379310345	45	12	38.8	0	137	3	16	60	CAB4138382.1 hypothetical protein UFOVP331_14 [uncultured Caudovirales phage]	diamond	267	80.9	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
28374922	28374922	PRJNA608660_P_NODE_25726_length_264_cov_1.665116_g25370_i0	PRJNA608660	25726	264	1.665116	4.39590624	Caudoviricetes sp.	2832643	Viruses	Viruses	52.8	1.24e-6	NR	DAU45685.1	2832643	g25370	i0	42	0.568181818181818	50	27	54.5	1	7	150	36	85	DAU45685.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	150	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
29353912	29353912	PRJNA608660_P_NODE_43929_length_174_cov_1.664000_g43572_i0	PRJNA608660	43929	174	1.664	2.89536	uncultured Caudovirales phage	2100421	Viruses	Viruses	62.8	1.19e-9	NR	CAB4143035.1	2100421	g43572	i0	53.7	0.931034482758621	54	25	93.1	0	3	164	322	375	CAB4143035.1 Concanavalin A-like lectin/glucanases superfamily [uncultured Caudovirales phage]	diamond	162	62.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
30901671	30901671	PRJNA608660_P_NODE_37474_length_198_cov_1.812081_g37118_i0	PRJNA608660	37474	198	1.812081	3.58792038	uncultured Caudovirales phage	2100421	Viruses	Viruses	68.6	1.43e-11	NR	CAB4143134.1	2100421	g37118	i0	44.4	0.954545454545455	63	32	90.9	1	3	182	271	333	CAB4143134.1 putative RNA ligase [uncultured Caudovirales phage]	diamond	189	68.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
31153964	31153964	PRJNA608660_P_NODE_50455_length_157_cov_3.370370_g50098_i0	PRJNA608660	50455	157	3.37037	5.2914809	Sinorhizobium phage phiN3	1647405	Viruses	Viruses	68.9	6.62e-12	NR	YP_009212423.1	1647405	g50098	i0	69.6	0.878980891719745	46	14	87.9	0	2	139	236	281	YP_009212423.1 RNA-binding protein [Sinorhizobium phage phiN3]	diamond	138	68.9	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Emdodecavirus	Emdodecavirus N3
31755199	31755199	PRJNA608660_P_NODE_44157_length_173_cov_2.435484_g43800_i0	PRJNA608660	44157	173	2.435484	4.21338732	Aeromonas phage avDM6	3101602	Viruses	Viruses	39.3	0.0344	NR	UYD59232.1	3101602	g43800	i0	38.1	0.728323699421965	42	25	72.8	1	135	10	7	47	UYD59232.1 hypothetical protein HPMBJEAJ_00117 [Aeromonas phage avDM6]	diamond	126	39.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae	Ishigurovirus	Aeromonas phage avDM6
31913417	31913417	PRJNA608660_P_NODE_28057_length_247_cov_3.237374_g27701_i0	PRJNA608660	28057	247	3.237374	7.99631378	Microbacterium phage SBlackberry	2810527	Viruses	Viruses	43.1	0.00467	NR	UAW08782.1	2810527	g27701	i0	40.4	0.631578947368421	52	30	61.9	1	226	74	7	58	UAW08782.1 membrane protein [Microbacterium phage SBlackberry]	diamond	156	43.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Goodmanvirus	Microbacterium phage SBlackberry
32230052	32230052	PRJNA608660_P_NODE_48538_length_164_cov_0.904348_g48181_i0	PRJNA608660	48538	164	0.904348	1.48313072	Microbacterium phage SBlackberry	2810527	Viruses	Viruses	43.1	0.00168	NR	UAW08782.1	2810527	g48181	i0	43.5	0.841463414634146	46	25	82.3	1	150	16	7	52	UAW08782.1 membrane protein [Microbacterium phage SBlackberry]	diamond	138	43.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Goodmanvirus	Microbacterium phage SBlackberry
32577965	32577965	PRJNA608660_P_NODE_26719_length_256_cov_2.879227_g26363_i0	PRJNA608660	26719	256	2.879227	7.37082112	Caudoviricetes sp.	2832643	Viruses	Viruses	74.3	5.65e-15	NR	XOR16700.1	2832643	g26363	i0	65.4	0.609375	52	18	60.9	0	199	44	11	62	XOR16700.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	156	74.3	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);;