metadata: contig_metadata: 6 rows where bioproject = "PRJNA505837" and tax

6 rows where bioproject = "PRJNA505837" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2386013	2386013	PRJNA505837_S_NODE_22_length_806_cov_8.145431_g18_i0	PRJNA505837	22	806	8.145431	65.65217386	Corynebacterium	1716	Bacteria	Bacteria	1417	0	NTclustered	gi\|2550468567\|gb\|CP100375.1\|	38284	g18	i0	98.278	365.275434243176	813	6	100	7	1	806	2492473	2491662	Corynebacterium accolens strain CA8 chromosome	blastn	294412	1428	0.992296918767507	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
4310625	4310625	PRJNA505837_S_NODE_724_length_173_cov_1.979167_g709_i0	PRJNA505837	724	173	1.979167	3.42395891	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	255	1.03e-63	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g709	i0	93.143	252.439306358382	175	10	100	1	1	173	552300	552474	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	43672	255	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
7488576	7488576	PRJNA505837_S_NODE_506_length_203_cov_1.862069_g491_i0	PRJNA505837	506	203	1.862069	3.78000007	Cutibacterium	1912216	Bacteria	Bacteria	368	1.55e-97	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g491	i0	99.507	251.35960591133	203	0	100	1	1	203	56296	56497	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	51026	368	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
12589448	12589448	PRJNA505837_S_NODE_650_length_181_cov_2.138158_g635_i0	PRJNA505837	650	181	2.138158	3.87006598	Staphylococcus	1279	Bacteria	Bacteria	335	1.36e-87	NTclustered	gi\|2521719496\|gb\|CP127601.1\|	1280	g635	i0	100	488	181	0	100	0	1	181	1949469	1949649	Staphylococcus aureus strain C322 chromosome, complete genome	blastn	88328	335	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
15786386	15786386	PRJNA505837_S_NODE_153_length_354_cov_4.470769_g138_i0	PRJNA505837	153	354	4.470769	15.82652226	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	649	0	NTclustered	gi\|2869826682\|gb\|CP175779.1\|	38304	g138	i0	99.718	377.387005649718	354	1	100	0	1	354	4093	4446	Corynebacterium tuberculostearicum strain YSMAA3_1_A4 chromosome, complete genome	blastn	133595	649	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
24062431	24062431	PRJNA505837_S_NODE_959_length_153_cov_2.677419_g944_i0	PRJNA505837	959	153	2.677419	4.09645107	Bacillales	1385	Bacteria	Bacteria	283	4.0799999999999995e-72	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g944	i0	100	463.150326797386	153	0	100	0	1	153	2277979	2278131	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	70862	283	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);;