metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA798905" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA798905" and tax_phylum = "Actinomycetota"

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
12697816	12697816	PRJNA798905_S_NODE_34470_length_256_cov_1.426230_g34021_i0	PRJNA798905	34470	256	1.42623	3.6511488	Mycobacteriales	85007	Bacteria	Bacteria	83.2	1.57e-17	NR	WP_358199943.1	37330	g34021	i0	69.4	2.28515625	49	15	57.4	0	256	110	147	195	WP_358199943.1 hypothetical protein [Nocardia nova]	diamond	585	83.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Nocardia	Nocardia nova
27211814	27211814	PRJNA798905_S_NODE_1302_length_1227_cov_281.519931_g118_i3	PRJNA798905	1302	1227	281.519931	3454.24955337	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	48.9	0.0154	NR	WP_389241032.1	3364690	g118	i3	32.1	0.198044009779951	81	51	19.6	2	247	8	3	80	WP_389241032.1 phosphotransferase [Streptomyces sp. NPDC004111]	diamond	243	48.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC004111
27243593	27243593	PRJNA798905_S_NODE_27943_length_286_cov_2.084507_g27494_i0	PRJNA798905	27943	286	2.084507	5.96169002	Actinomycetota bacterium	2900548	Bacteria	Bacteria	88.6	4.94e-18	NR	MBM3688387.1	2900548	g27494	i0	55.2	8.2027972027972	87	33	88.1	2	31	282	101	184	MBM3688387.1 DNA topoisomerase 4 subunit A [Actinomycetota bacterium]	diamond	2346	88.6	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
27433447	27433447	PRJNA798905_S_NODE_9783_length_440_cov_2.653951_g9334_i0	PRJNA798905	9783	440	2.653951	11.6773844	Tsukamurella tyrosinosolvens	57704	Bacteria	Bacteria	124	2.3999999999999999e-32	NR	WP_367582384.1	57704	g9334	i0	50.4	0.865909090909091	127	59	83.9	2	377	9	48	174	WP_367582384.1 HNH endonuclease signature motif containing protein [Tsukamurella tyrosinosolvens]	diamond	381	124	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Tsukamurellaceae	Tsukamurella	Tsukamurella tyrosinosolvens
27568427	27568427	PRJNA798905_S_NODE_17404_length_352_cov_5.136201_g16955_i0	PRJNA798905	17404	352	5.136201	18.07942752	Bacteria	2	Bacteria	Bacteria	110	2.22e-28	NR	HET9773339.1	2080302	g16955	i0	54.9	1.78125	102	43	86.9	2	333	28	27	125	HET9773339.1 NADAR family protein [Acidimicrobiia bacterium]	diamond	627	110	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
28727789	28727789	PRJNA798905_S_NODE_567_length_1848_cov_230.835493_g118_i1	PRJNA798905	567	1848	230.835493	4265.83991064	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	48.9	0.0268	NR	WP_389241032.1	3364690	g118	i1	31.9	0.152597402597403	94	59	14.9	3	719	994	3	93	WP_389241032.1 phosphotransferase [Streptomyces sp. NPDC004111]	diamond	282	48.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC004111
29169932	29169932	PRJNA798905_S_NODE_36009_length_250_cov_3.338983_g35560_i0	PRJNA798905	36009	250	3.338983	8.3474575	Cellulomonas composti	266130	Bacteria	Bacteria	43.5	0.0215	NR	WP_146842518.1	266130	g35560	i0	36.4	1.812	77	34	82.8	4	212	6	771	840	WP_146842518.1 sulfide/dihydroorotate dehydrogenase-like FAD/NAD-binding protein [Cellulomonas composti]	diamond	453	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Cellulomonadaceae	Cellulomonas	Cellulomonas composti
29201499	29201499	PRJNA798905_S_NODE_249_length_2756_cov_242.388744_g118_i0	PRJNA798905	249	2756	242.388744	6680.23378464	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	48.9	0.0436	NR	WP_389241032.1	3364690	g118	i0	31.9	0.102322206095791	94	59	10	3	2038	1763	3	93	WP_389241032.1 phosphotransferase [Streptomyces sp. NPDC004111]	diamond	282	48.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC004111
30527849	30527849	PRJNA798905_S_NODE_24293_length_305_cov_6.431034_g23844_i0	PRJNA798905	24293	305	6.431034	19.6146537	Curtobacterium ammoniigenes	395387	Bacteria	Bacteria	48.9	1.94e-4	NR	WP_066514309.1	395387	g23844	i0	45.5	0.649180327868852	66	34	63	1	274	83	35	100	WP_066514309.1 hypothetical protein [Curtobacterium ammoniigenes]	diamond	198	48.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Curtobacterium	Curtobacterium ammoniigenes
30749070	30749070	PRJNA798905_S_NODE_1774_length_1032_cov_22.628780_g1415_i0	PRJNA798905	1774	1032	22.62878	233.5290096	Streptomyces sp. BRB	1931	Bacteria	Bacteria	409	2.04e-139	NR	WP_196191622.1	2769544	g1415	i0	83.4	0.73546511627907	253	42	73.5	0	774	16	98	350	WP_196191622.1 hypothetical protein [Streptomyces sp. BRB081]	diamond	759	409	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. BRB081
31222818	31222818	PRJNA798905_S_NODE_7895_length_480_cov_5.068796_g7446_i0	PRJNA798905	7895	480	5.068796	24.3302208	Streptomyces sp. CHB9.2	2841670	Bacteria	Bacteria	220	1.5600000000000001e-63	NR	WP_252940890.1	2841670	g7446	i0	67.7	0.9875	158	51	98.8	0	7	480	8	165	WP_252940890.1 hypothetical protein [Streptomyces sp. CHB9.2]	diamond	474	220	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. CHB9.2
31823846	31823846	PRJNA798905_S_NODE_27277_length_289_cov_6.703704_g26828_i0	PRJNA798905	27277	289	6.703704	19.37370456	Coriobacteriaceae bacterium	2011094	Bacteria	Bacteria	43.1	0.0451	NR	MDO4436993.1	2011094	g26828	i0	35.7	0.726643598615917	70	38	66.4	3	3	194	164	232	MDO4436993.1 DNA repair protein [Coriobacteriaceae bacterium]	diamond	210	43.1	1	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Coriobacteriales	Coriobacteriaceae		Coriobacteriaceae bacterium
31887212	31887212	PRJNA798905_S_NODE_37197_length_247_cov_3.971264_g36748_i0	PRJNA798905	37197	247	3.971264	9.80902208	Haloechinothrix halophila	1069073	Bacteria	Bacteria	42.7	0.0377	NR	WP_034268929.1	1069073	g36748	i0	42.9	0.595141700404858	49	24	54.7	1	221	87	103	151	WP_034268929.1 amidohydrolase [Haloechinothrix halophila]	diamond	147	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Haloechinothrix	Haloechinothrix halophila

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