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

7 rows where analysis = "blastn", bioproject = "PRJNA733995" 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
2472100	2472100	PRJNA733995_P_NODE_8602_length_292_cov_2.707763_g8555_i0	PRJNA733995	8602	292	2.707763	7.90666796	Bacillati	1783272	Bacteria	Bacteria	540	4.74e-149	NTclustered	gi\|77416130\|emb\|AM110940.1\|	1423	g8555	i0	100	103	292	0	100	0	1	292	546	837	Bacillus subtilis partial 16S rRNA gene, isolate B-2032	blastn	30076	540	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus subtilis
5024992	5024992	PRJNA733995_P_NODE_10924_length_262_cov_2.343915_g10877_i0	PRJNA733995	10924	262	2.343915	6.1410573	Staphylococcus	1279	Bacteria	Bacteria	484	1.99e-132	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g10877	i0	100	93.3625954198473	262	0	100	0	1	262	592123	592384	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	24461	484	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
10125315	10125315	PRJNA733995_P_NODE_12948_length_246_cov_0.890173_g12901_i0	PRJNA733995	12948	246	0.890173	2.18982558	Clostridioides	1870884	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2125191241\|gb\|CP067345.1\|	2770776	g12901	i0	100	0.227642276422764	28	0	11	0	183	210	3437318	3437345	Clostridioides sp. ES-S-0010-02 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides sp. ES-S-0010-02
10125339	10125339	PRJNA733995_P_NODE_9788_length_276_cov_2.211823_g9741_i0	PRJNA733995	9788	276	2.211823	6.10463148	Staphylococcus	1279	Bacteria	Bacteria	510	3.48e-140	NTclustered	gi\|2889733023\|gb\|CP123119.1\|	1280	g9741	i0	100	100	276	0	100	0	1	276	821130	821405	Staphylococcus aureus strain GE-MSSA41 chromosome, complete genome	blastn	27600	510	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
14745596	14745596	PRJNA733995_P_NODE_6232_length_344_cov_0.974170_g6185_i0	PRJNA733995	6232	344	0.97417	3.3511448	Shouchella clausii	79880	Bacteria	Bacteria	283	1.06e-71	NTclustered	gi\|2913863705\|gb\|CP181250.1\|	79880	g6185	i0	84.407	590.677325581395	295	39	85	7	5	296	3276742	3277032	MAG: Shouchella clausii isolate UW_FK_BACI1_1 chromosome	blastn	203193	283	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Shouchella	Shouchella clausii
15225297	15225297	PRJNA733995_P_NODE_10372_length_269_cov_1.505102_g10325_i0	PRJNA733995	10372	269	1.505102	4.04872438	Staphylococcus	1279	Bacteria	Bacteria	497	2.63e-136	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g10325	i0	100	45.996282527881	269	0	100	0	1	269	409384	409116	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	12373	497	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
21119176	21119176	PRJNA733995_P_NODE_10857_length_263_cov_2.115789_g10810_i0	PRJNA733995	10857	263	2.115789	5.56452507	Staphylococcus haemolyticus	1283	Bacteria	Bacteria	486	5.5499999999999986e-133	NTclustered	gi\|2536850969\|gb\|CP129362.1\|	1283	g10810	i0	100	225.083650190114	263	0	100	0	1	263	2200948	2200686	Staphylococcus haemolyticus strain CCSH-121 chromosome, complete genome	blastn	59197	486	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus

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