metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA904835" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA904835" and tax_kingdom = "Bacillati"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1247526	1247526	PRJNA904835_P_NODE_51001_length_251_cov_0.865169_g50745_i0	PRJNA904835	51001	251	0.865169	2.17157419	Amycolatopsis	1813	Bacteria	Bacteria	147	1.01e-30	NTclustered	gi\|2326010688\|gb\|CP100416.1\|	33910	g50745	i0	77.959	84.1354581673307	245	47	97	7	2	244	7700068	7700307	Amycolatopsis mediterranei strain ISP5501 chromosome	blastn	21118	147	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis mediterranei
1247557	1247557	PRJNA904835_P_NODE_55821_length_245_cov_0.895349_g55565_i0	PRJNA904835	55821	245	0.895349	2.19360505	Rhodococcus	1827	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2258906618\|dbj\|AP018733.1\|	1833	g55565	i0	100	412.379591836735	245	0	100	0	1	245	4075433	4075189	Rhodococcus erythropolis JCM 2895 DNA, complete genome	blastn	101033	453	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus erythropolis
8535653	8535653	PRJNA904835_P_NODE_24887_length_399_cov_1.702454_g24632_i0	PRJNA904835	24887	399	1.702454	6.79279146	Mycoplasmopsis maculosa	114885	Bacteria	Bacteria	78.7	6.31e-10	NTclustered	gi\|1563804680\|emb\|LR215037.1\|	114885	g24632	i0	74.731	0.466165413533835	186	41	46	6	203	384	310396	310579	Mycoplasma maculosum strain NCTC10168 genome assembly, chromosome: 1	blastn	186	78.7	1	Bacteria		Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis maculosa
11087352	11087352	PRJNA904835_P_NODE_58149_length_242_cov_0.911243_g57893_i0	PRJNA904835	58149	242	0.911243	2.20520806	Aerococcus urinaeequi	51665	Bacteria	Bacteria	431	2.4e-116	NTclustered	gi\|2437762991\|gb\|CP116590.1\|	51665	g57893	i0	98.76	5	242	3	100	0	1	242	1256001	1255760	Aerococcus urinaeequi strain K79-1 chromosome, complete genome	blastn	1210	431	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Aerococcus	Aerococcus urinaeequi
13636506	13636506	PRJNA904835_P_NODE_26591_length_384_cov_1.401929_g26335_i0	PRJNA904835	26591	384	1.401929	5.38340736	Mycoplasmopsis maculosa	114885	Bacteria	Bacteria	67.6	1.31e-6	NTclustered	gi\|1563804680\|emb\|LR215037.1\|	114885	g26335	i0	93.333	0.1171875	45	3	12	0	69	113	310496	310452	Mycoplasma maculosum strain NCTC10168 genome assembly, chromosome: 1	blastn	45	67.6	1	Bacteria		Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis maculosa
14001385	14001385	PRJNA904835_P_NODE_41211_length_293_cov_1.750000_g40955_i0	PRJNA904835	41211	293	1.75	5.1275	Thermosynechococcus	146785	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|47118315\|dbj\|BA000039.2\|	197221	g40955	i0	100	0.197952218430034	29	0	10	0	147	175	1622764	1622792	Thermosynechococcus elongatus BP-1 DNA, complete genome	blastn	58	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Thermosynechococcaceae	Thermosynechococcus	Thermosynechococcus vestitus
16186178	16186178	PRJNA904835_P_NODE_43813_length_282_cov_0.904306_g43557_i0	PRJNA904835	43813	282	0.904306	2.55014292	Streptococcus thermophilus	1308	Bacteria	Bacteria	416	8.009999999999998e-112	NTclustered	gi\|1239731491\|gb\|CP017064.1\|	1308	g43557	i0	93.286	574.503546099291	283	17	100	2	1	282	21938	21657	Streptococcus thermophilus strain ST3 chromosome, complete genome	blastn	162010	416	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
16549946	16549946	PRJNA904835_P_NODE_44993_length_276_cov_1.246305_g44737_i0	PRJNA904835	44993	276	1.246305	3.4398018	Cutibacterium	1912216	Bacteria	Bacteria	494	3.51e-135	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g44737	i0	98.913	50.9492753623188	276	3	100	0	1	276	1067285	1067010	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	14062	494	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
17460464	17460464	PRJNA904835_P_NODE_10134_length_670_cov_1.425461_g9898_i0	PRJNA904835	10134	670	1.425461	9.5505887	Mycoplasmopsis maculosa	114885	Bacteria	Bacteria	75	1.42e-8	NTclustered	gi\|1563804680\|emb\|LR215037.1\|	114885	g9898	i0	78.761	0.16865671641791	113	22	17	2	296	407	310385	310496	Mycoplasma maculosum strain NCTC10168 genome assembly, chromosome: 1	blastn	113	75	1	Bacteria		Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis maculosa
23835703	23835703	PRJNA904835_P_NODE_51059_length_251_cov_0.865169_g50803_i0	PRJNA904835	51059	251	0.865169	2.17157419	Corynebacterium afermentans	38286	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|2531253808\|gb\|CP046530.1\|	144184	g50803	i0	99.203	386.745019920319	251	2	100	0	1	251	640353	640103	Corynebacterium afermentans subsp. lipophilum strain DSM 44282 chromosome, complete genome	blastn	97073	453	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium afermentans
24198794	24198794	PRJNA904835_P_NODE_17759_length_486_cov_1.077482_g17504_i0	PRJNA904835	17759	486	1.077482	5.23656252	Lachnospiraceae	186803	Bacteria	Bacteria	52.8	0.047	NTclustered	gi\|2299353445\|gb\|CP102274.1\|	154046	g17504	i0	100	0.121399176954733	28	0	6	0	399	426	3222005	3222032	Hungatella hathewayi strain DSM 13479 chromosome, complete genome	blastn	59	52.8	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Hungatella	Hungatella hathewayi
25109689	25109689	PRJNA904835_P_NODE_56020_length_245_cov_0.895349_g55764_i0	PRJNA904835	56020	245	0.895349	2.19360505	Metamycoplasma alkalescens	45363	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|1450418660\|emb\|LS991949.1\|	45363	g55764	i0	99.592	1	245	1	100	0	1	245	458379	458135	Mycoplasma alkalescens strain NCTC10135 genome assembly, chromosome: 1	blastn	245	448	1	Bacteria		Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma alkalescens
25474137	25474137	PRJNA904835_P_NODE_55040_length_246_cov_0.890173_g54784_i0	PRJNA904835	55040	246	0.890173	2.18982558	Enterococcus	1350	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2437787960\|gb\|CP116571.1\|	1351	g54784	i0	100	100	246	0	100	0	1	246	2245633	2245388	Enterococcus faecalis strain K190-1 chromosome, complete genome	blastn	24600	455	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis

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