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

13 rows where analysis = "blastn", bioproject = "PRJNA870096" and tax_phylum = "Bacillota"

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
1237362	1237362	PRJNA870096_S_NODE_81861_length_194_cov_1.423841_g80197_i0	PRJNA870096	81861	194	1.423841	2.76225154	Mediterraneibacter	2316020	Bacteria	Bacteria	187	4.4e-43	NTclustered	gi\|2813041535\|emb\|OZ186737.1\|	33038	g80197	i0	84.422	499.324742268041	199	21	100	10	1	194	20870	20677	Mediterraneibacter gnavus isolate LUMC_Rgna_QRD044 genome assembly, chromosome: 1	blastn	96869	187	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Mediterraneibacter	Mediterraneibacter gnavus
5065390	5065390	PRJNA870096_S_NODE_51904_length_244_cov_2.104478_g50240_i0	PRJNA870096	51904	244	2.104478	5.13492632	Bacillus	1386	Bacteria	Bacteria	75	4.7e-9	NTclustered	gi\|2235673318\|gb\|CP026143.1\|	1471	g50240	i0	97.674	0.655737704918033	43	1	18	0	168	210	2499654	2499696	Bacillus methanolicus strain DFS2 chromosome, complete genome	blastn	160	75	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus methanolicus
5065471	5065471	PRJNA870096_S_NODE_95284_length_181_cov_0.920290_g93620_i0	PRJNA870096	95284	181	0.92029	1.6657249	root	1	Root_unresolved	Root_unresolved	318	1.37e-82	NTclustered	gi\|2414155\|emb\|Y09787.1\|	1428	g93620	i0	100	14.2265193370166	172	0	95	0	1	172	599	428	B.thuringiensis cryIA(c) gene	blastn	2575	318	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
6341156	6341156	PRJNA870096_S_NODE_128365_length_157_cov_1.807018_g126701_i0	PRJNA870096	128365	157	1.807018	2.83701826	root	1	Root_unresolved	Root_unresolved	274	2.54e-69	NTclustered	gi\|2414155\|emb\|Y09787.1\|	1428	g126701	i0	100	15.0764331210191	148	0	94	0	10	157	1095	1242	B.thuringiensis cryIA(c) gene	blastn	2367	274	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
6341367	6341367	PRJNA870096_S_NODE_965_length_1840_cov_5.100723_g599_i0	PRJNA870096	965	1840	5.100723	93.8533032	root	1	Root_unresolved	Root_unresolved	3367	0	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g599	i0	100	55.279347826087	1823	0	99	0	10	1832	2428460	2426638	Staphylococcus aureus strain WH9628 chromosome	blastn	101714	3384	0.994976359338062	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
8503070	8503070	PRJNA870096_S_NODE_43927_length_267_cov_1.700893_g42263_i0	PRJNA870096	43927	267	1.700893	4.54138431	Saccharibacillus brassicae	2583377	Bacteria	Bacteria	110	1.43e-19	NTclustered	gi\|1696750961\|gb\|CP041217.1\|	2583377	g42263	i0	75.093	7.35955056179775	269	49	96	14	11	267	976326	976064	Saccharibacillus brassicae strain ATSA2 chromosome, complete genome	blastn	1965	110	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Saccharibacillus	Saccharibacillus brassicae
13991275	13991275	PRJNA870096_S_NODE_90371_length_185_cov_1.492958_g88707_i0	PRJNA870096	90371	185	1.492958	2.7619723	Paenibacillus	44249	Bacteria	Bacteria	337	3.89e-88	NTclustered	gi\|2700521045\|gb\|CP147845.1\|	59843	g88707	i0	99.459	7.91891891891892	185	1	100	0	1	185	759872	759688	Paenibacillus glucanolyticus strain GlSt238 chromosome, complete genome	blastn	1465	337	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus glucanolyticus
14878260	14878260	PRJNA870096_S_NODE_56652_length_233_cov_2.015789_g54988_i0	PRJNA870096	56652	233	2.015789	4.69678837	Roseburia rectibacter	2763062	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2206258461\|gb\|CP092473.1\|	2763062	g54988	i0	96.97	0.141630901287554	33	1	14	0	65	97	2892630	2892662	Roseburia rectibacter strain NSJ-69 chromosome, complete genome	blastn	33	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Roseburia	Roseburia rectibacter
17428648	17428648	PRJNA870096_S_NODE_70134_length_209_cov_1.596386_g68470_i0	PRJNA870096	70134	209	1.596386	3.33644674	[Eubacterium] hominis	2764325	Bacteria	Bacteria	315	2.12e-81	NTclustered	gi\|1897739665\|gb\|CP060636.1\|	2764325	g68470	i0	93.78	458.071770334928	209	13	100	0	1	209	385455	385247	[Eubacterium] hominis strain New-5 chromosome, complete genome	blastn	95737	315	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Amedibacillus	[Eubacterium] hominis
20363672	20363672	PRJNA870096_S_NODE_41556_length_275_cov_1.982759_g39892_i0	PRJNA870096	41556	275	1.982759	5.45258725	Bacteria	2	Bacteria	Bacteria	422	1.67e-113	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g39892	i0	100	102.738181818182	228	0	83	0	26	253	386	613	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	28253	422	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
20363698	20363698	PRJNA870096_S_NODE_52556_length_243_cov_1.035000_g50892_i0	PRJNA870096	52556	243	1.035	2.51505	root	1	Root_unresolved	Root_unresolved	436	5.18e-118	NTclustered	gi\|2414155\|emb\|Y09787.1\|	1428	g50892	i0	99.177	16.6831275720165	243	1	100	1	1	243	965	724	B.thuringiensis cryIA(c) gene	blastn	4054	436	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
25076119	25076119	PRJNA870096_S_NODE_35120_length_301_cov_2.135659_g33456_i0	PRJNA870096	35120	301	2.135659	6.42833359	Lactococcus petauri	1940789	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2257541798\|gb\|CP086595.1\|	1940789	g33456	i0	100	0.0963455149501661	29	0	10	0	105	133	794808	794780	Lactococcus petauri strain LG26 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus petauri
25464071	25464071	PRJNA870096_S_NODE_90000_length_185_cov_3.795775_g88336_i0	PRJNA870096	90000	185	3.795775	7.02218375	root	1	Root_unresolved	Root_unresolved	342	8.369999999999999e-90	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g88336	i0	100	106.264864864865	185	0	100	0	1	185	1398	1214	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	19659	342	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis

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