metadata: contig_metadata: 12 rows where bioproject = "PRJNA1264536" and tax

12 rows where 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
6156785	6156785	PRJNA1264536_P_NODE_2625_length_347_cov_1.138686_g2551_i0	PRJNA1264536	2625	347	1.138686	3.95124042	Cutibacterium	1912216	Bacteria	Bacteria	641	1.5299999999999996e-179	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2551	i0	100	271.881844380403	347	0	100	0	1	347	57055	56709	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	94343	641	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
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
16941184	16941184	PRJNA1264536_P_NODE_4974_length_247_cov_0.896552_g4900_i0	PRJNA1264536	4974	247	0.896552	2.21448344	Kitasatospora aureofaciens	1894	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|1175678048\|gb\|CP020567.1\|	1894	g4900	i0	99.19	27.6842105263158	247	2	100	0	1	247	1300372	1300126	Kitasatospora aureofaciens strain DM-1, complete genome	blastn	6838	446	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Kitasatospora	Kitasatospora aureofaciens
20180107	20180107	PRJNA1264536_P_NODE_4876_length_248_cov_0.891429_g4802_i0	PRJNA1264536	4876	248	0.891429	2.21074392	Brevibacterium	1696	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|1013855561\|gb\|CP014869.1\|	1703	g4802	i0	99.597	371.758064516129	248	1	100	0	1	248	831242	831489	Brevibacterium linens strain BS258 chromosome, complete genome	blastn	92196	453	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium linens
24590195	24590195	PRJNA1264536_P_NODE_4340_length_253_cov_0.866667_g4266_i0	PRJNA1264536	4340	253	0.866667	2.19266751	Actinocatenispora sera	390989	Bacteria	Bacteria	300	7.43e-77	NTclustered	gi\|2020954569\|dbj\|AP023354.1\|	390989	g4266	i0	88.664	1.97233201581028	247	26	97	2	4	249	2534309	2534064	Actinocatenispora sera NBRC 101916 DNA, complete genome	blastn	499	300	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Actinocatenispora	Actinocatenispora sera
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);;