metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1264536" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1264536" 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
9982128	9982128	PRJNA1264536_P_NODE_5268_length_244_cov_0.912281_g5194_i0	PRJNA1264536	5268	244	0.912281	2.22596564	Actinomycetota bacterium	2900548	Bacteria	Bacteria	149	9.36e-45	NR	MFM7526076.1	2900548	g5194	i0	98.7	2.87704918032787	78	1	95.9	0	237	4	1	78	MFM7526076.1 NAD(P)-dependent oxidoreductase [Actinomycetota bacterium]	diamond	702	149	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
28431970	28431970	PRJNA1264536_P_NODE_4586_length_251_cov_0.876404_g4512_i0	PRJNA1264536	4586	251	0.876404	2.19977404	Actinomycetes bacterium	1883427	Bacteria	Bacteria	157	2.32e-46	NR	GDX19034.1	1883427	g4512	i0	96.4	0.99203187250996006	83	3	99.2	0	249	1	149	231	GDX19034.1 hypothetical protein LBMAG06_11630 [Actinomycetes bacterium]	diamond	249	157	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes				Actinomycetes bacterium
29032057	29032057	PRJNA1264536_P_NODE_4348_length_253_cov_0.866667_g4274_i0	PRJNA1264536	4348	253	0.866667	2.19266751	Actinomycetota bacterium	2900548	Bacteria	Bacteria	92.8	1.19e-20	NR	MCA1681223.1	2900548	g4274	i0	82.4	0.604743083003953	51	9	60.5	0	155	3	1	51	MCA1681223.1 IS5 family transposase [Actinomycetota bacterium]	diamond	153	92.8	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
30091532	30091532	PRJNA1264536_P_NODE_4852_length_248_cov_0.891429_g4778_i0	PRJNA1264536	4852	248	0.891429	2.21074392	Trebonia	2767073	Bacteria	Bacteria	133	1.66e-34	NR	MCW2891044.1	1883427	g4778	i0	73.2	1.98387096774194	82	22	99.2	0	1	246	409	490	MCW2891044.1 hypothetical protein [Actinomycetes bacterium]	diamond	492	133	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes				Actinomycetes bacterium
30516208	30516208	PRJNA1264536_P_NODE_5333_length_244_cov_0.912281_g5259_i0	PRJNA1264536	5333	244	0.912281	2.22596564	Acidimicrobiia bacterium	2080302	Bacteria	Bacteria	126	7.589999999999999e-32	NR	MFM8265162.1	2080302	g5259	i0	87.3	0.971311475409836	79	9	97.1	1	242	6	161	238	MFM8265162.1 trypsin-like serine protease [Acidimicrobiia bacterium]	diamond	237	126	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
31306154	31306154	PRJNA1264536_P_NODE_5395_length_243_cov_0.917647_g5321_i0	PRJNA1264536	5395	243	0.917647	2.22988221	Solirubrobacteraceae bacterium	2586742	Bacteria	Bacteria	98.6	5.72e-23	NR	HEY7890830.1	2586742	g5321	i0	86	0.703703703703704	57	6	70.4	1	242	72	57	111	HEY7890830.1 SigB/SigF/SigG family RNA polymerase sigma factor [Solirubrobacteraceae bacterium]	diamond	171	98.6	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Solirubrobacteraceae		Solirubrobacteraceae bacterium
31482503	31482503	PRJNA1264536_P_NODE_5396_length_243_cov_0.917647_g5322_i0	PRJNA1264536	5396	243	0.917647	2.22988221	Actinomycetes	1760	Bacteria	Bacteria	87	7.85e-18	NR	HET7668478.1	1785	g5322	i0	80.9	2.34567901234568	47	9	58	0	242	102	409	455	HET7668478.1 menaquinone biosynthesis decarboxylase [Mycobacterium sp.]	diamond	570	87	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp.
32558139	32558139	PRJNA1264536_P_NODE_2039_length_398_cov_0.960000_g1965_i0	PRJNA1264536	2039	398	0.96	3.8208	root	1	Root_unresolved	Root_unresolved	70.1	5.37e-11	NR	MCW2763450.1	1909296	g1965	i0	44.4	1.50753768844221	72	38	54.3	1	397	182	258	327	MCW2763450.1 hypothetical protein [Marmoricola sp.]	diamond	600	70.5	0.994326241134752	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Marmoricola	Marmoricola 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);;