metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA998413" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA998413" 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
979193	979193	PRJNA998413_S_NODE_5021_length_274_cov_1.270142_g4990_i0	PRJNA998413	5021	274	1.270142	3.48018908	Paenibacillus sp. Cedars	1980674	Bacteria	Bacteria	507	4.47e-139	NTclustered	gi\|1394605008\|gb\|CP020866.1\|	1980674	g4990	i0	100	16.3503649635037	274	0	100	0	1	274	5427441	5427714	Paenibacillus sp. Cedars chromosome, complete genome	blastn	4480	507	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. Cedars
1273994	1273994	PRJNA998413_S_NODE_9841_length_223_cov_1.675000_g9810_i0	PRJNA998413	9841	223	1.675	3.73525	Staphylococcus	1279	Bacteria	Bacteria	412	7.88e-111	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g9810	i0	100	84.7399103139013	223	0	100	0	1	223	1586199	1585977	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	18897	412	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
3825926	3825926	PRJNA998413_S_NODE_5203_length_271_cov_1.865385_g5172_i0	PRJNA998413	5203	271	1.865385	5.05519335	root	1	Root_unresolved	Root_unresolved	501	2.05e-137	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g5172	i0	100	101.80442804428	271	0	100	0	1	271	2411010	2410740	Staphylococcus aureus strain WH9628 chromosome	blastn	27589	501	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
4807171	4807171	PRJNA998413_S_NODE_7824_length_240_cov_1.497175_g7793_i0	PRJNA998413	7824	240	1.497175	3.59322	Granulicatella elegans	137732	Bacteria	Bacteria	333	6.88e-87	NTclustered	gi\|2127543886\|gb\|CP085953.1\|	137732	g7793	i0	91.667	1	240	20	100	0	1	240	1840855	1841094	Granulicatella elegans strain FDAARGOS_1559 chromosome, complete genome	blastn	240	333	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella elegans
7356909	7356909	PRJNA998413_S_NODE_9326_length_227_cov_2.158537_g9295_i0	PRJNA998413	9326	227	2.158537	4.89987899	Anaerococcus mediterraneensis	1870984	Bacteria	Bacteria	396	8.109999999999997e-106	NTclustered	gi\|1105524756\|emb\|LT635772.1\|	1870984	g9295	i0	98.655	316.823788546256	223	3	98	0	1	223	437233	437455	Anaerococcus sp. Marseille-P2765 strain Marseille-P2765T genome assembly, chromosome: contig00001	blastn	71919	396	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus mediterraneensis
7652015	7652015	PRJNA998413_S_NODE_13226_length_209_cov_1.376712_g13195_i0	PRJNA998413	13226	209	1.376712	2.87732808	Streptococcus	1301	Bacteria	Bacteria	307	3.54e-79	NTclustered	gi\|1943211519\|gb\|CP065707.1\|	1303	g13195	i0	93.269	34.7751196172249	208	14	99	0	1	208	1512426	1512219	Streptococcus oralis strain FDAARGOS_885 chromosome, complete genome	blastn	7268	307	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
11477756	11477756	PRJNA998413_S_NODE_6109_length_258_cov_1.676923_g6078_i0	PRJNA998413	6109	258	1.676923	4.32646134	Anaerococcus	165779	Bacteria	Bacteria	405	1.56e-108	NTclustered	gi\|1374529452\|ref\|NR_076129.2\|	33034	g6078	i0	94.981	161.589147286822	259	11	100	2	1	258	782	525	Anaerococcus prevotii strain DSM 20548 23S ribosomal RNA, complete sequence	blastn	41690	405	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus prevotii
18830901	18830901	PRJNA998413_S_NODE_14115_length_198_cov_2.481481_g14084_i0	PRJNA998413	14115	198	2.481481	4.91333238	Roseburia rectibacter	2763062	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2206258461\|gb\|CP092473.1\|	2763062	g14084	i0	96.97	0.166666666666667	33	1	17	0	143	175	2892662	2892630	Roseburia rectibacter strain NSJ-69 chromosome, complete genome	blastn	33	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Roseburia	Roseburia rectibacter
20400350	20400350	PRJNA998413_S_NODE_3316_length_311_cov_2.463710_g3285_i0	PRJNA998413	3316	311	2.46371	7.6621381	Staphylococcus	1279	Bacteria	Bacteria	575	1.3899999999999995e-159	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g3285	i0	100	100	311	0	100	0	1	311	1695894	1695584	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	31100	575	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
20400364	20400364	PRJNA998413_S_NODE_9856_length_223_cov_1.462500_g9825_i0	PRJNA998413	9856	223	1.4625	3.261375	Streptococcus	1301	Bacteria	Bacteria	398	2.21e-106	NTclustered	gi\|2179901676\|gb\|CP046524.1\|	1303	g9825	i0	99.541	320.645739910314	218	1	98	0	1	218	18381	18598	Streptococcus oralis strain SOT chromosome, complete genome	blastn	71504	398	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
23931652	23931652	PRJNA998413_S_NODE_9319_length_227_cov_2.451220_g9288_i0	PRJNA998413	9319	227	2.45122	5.5642694	Staphylococcus epidermidis	1282	Bacteria	Bacteria	420	4.81e-113	NTclustered	gi\|1214725545\|gb\|CP022247.1\|	1282	g9288	i0	100	100.63436123348	227	0	100	0	1	227	1909417	1909643	Staphylococcus epidermidis strain AMT chromosome, complete genome	blastn	22844	420	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
25205350	25205350	PRJNA998413_S_NODE_7700_length_241_cov_2.084270_g7669_i0	PRJNA998413	7700	241	2.08427	5.0230907	Streptococcus pneumoniae	1313	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|404276812\|emb\|HE983624.1\|	869309	g7669	i0	100	316	241	0	100	0	1	241	18459	18699	Streptococcus pneumoniae SPNA45, complete genome	blastn	76156	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae

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