metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA1057075" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA1057075" 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
4839334	4839334	PRJNA1057075_S_NODE_2464_length_265_cov_52881.166667_g2365_i0	PRJNA1057075	2464	265	52881.166667	140135.09166755	Bacteria	2	Bacteria	Bacteria	398	2.7e-106	NTclustered	gi\|1042399388\|gb\|KU555885.1\|	1292	g2365	i0	98.238	431.267924528302	227	4	86	0	1	227	443	669	Staphylococcus warneri strain SWA15219-3 16S-23S ribosomal RNA intergenic spacer gene, region	blastn	114286	398	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
6554550	6554550	PRJNA1057075_S_NODE_9986_length_157_cov_2.185185_g9887_i0	PRJNA1057075	9986	157	2.185185	3.43074045	Emergencia timonensis	1776384	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2613044976\|gb\|CP136188.1\|	1776384	g9887	i0	100	0.713375796178344	28	0	18	0	75	102	1824571	1824544	Emergencia timonensis strain NTUH-41-K21 chromosome, complete genome	blastn	112	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae	Emergencia	Emergencia timonensis
7829201	7829201	PRJNA1057075_S_NODE_4947_length_204_cov_0.948387_g4848_i0	PRJNA1057075	4947	204	0.948387	1.93470948	Clostridium septicum	1504	Bacteria	Bacteria	220	4.61e-53	NTclustered	gi\|2260370548\|gb\|CP099799.1\|	1504	g4848	i0	89.326	744.647058823529	178	15	86	3	25	200	231885	231710	Clostridium septicum strain RMA 8861 chromosome, complete genome	blastn	151908	220	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium septicum
13764679	13764679	PRJNA1057075_S_NODE_7091_length_177_cov_1.593750_g6992_i0	PRJNA1057075	7091	177	1.59375	2.8209375	Lactobacillus	1578	Bacteria	Bacteria	324	2.87e-84	NTclustered	gi\|2913177562\|gb\|CP180627.1\|	47770	g6992	i0	100	377.35593220339	175	0	99	0	1	175	1145979	1146153	Lactobacillus crispatus strain T31e chromosome, complete genome	blastn	66792	324	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
19302304	19302304	PRJNA1057075_S_NODE_2376_length_268_cov_52638.155251_g2277_i0	PRJNA1057075	2376	268	52638.155251	141070.25607268	Staphylococcus hominis	1290	Bacteria	Bacteria	412	9.77e-111	NTclustered	gi\|1780389983\|gb\|CP046301.1\|	1290	g2277	i0	99.558	410.981343283582	226	1	84	0	43	268	1064642	1064867	Staphylococcus hominis strain FDAARGOS_747 chromosome, complete genome	blastn	110143	412	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
21853470	21853470	PRJNA1057075_S_NODE_7058_length_177_cov_2.875000_g6959_i0	PRJNA1057075	7058	177	2.875	5.08875	Clostridium perfringens	1502	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2702800439\|gb\|CP148701.1\|	1502	g6959	i0	100	0.169491525423729	30	0	17	0	119	148	502640	502669	Clostridium perfringens strain Z1322PCP0092 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
23128899	23128899	PRJNA1057075_S_NODE_4179_length_219_cov_4.282353_g4080_i0	PRJNA1057075	4179	219	4.282353	9.37835307	Weissella paramesenteroides	1249	Bacteria	Bacteria	374	3.64e-99	NTclustered	gi\|1937010051\|gb\|CP065046.1\|	1249	g4080	i0	98.131	547.922374429224	214	4	98	0	1	214	363558	363345	Weissella paramesenteroides strain STCH-BD1 chromosome	blastn	119995	374	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella paramesenteroides

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