metadata: contig_metadata: 13 rows where bioproject = "PRJNA1192965", tax_kingdom = "Bacillati" and tax

13 rows where bioproject = "PRJNA1192965", tax_kingdom = "Bacillati" 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
1042364	1042364	PRJNA1192965_P_NODE_1_length_3180_cov_34.790795_g0_i0	PRJNA1192965	1	3180	34.790795	1106.347281	Ruminococcus sp. XPD3	41978	Bacteria	Bacteria	1895	0	NR	WP_075424065.1	1452269	g0	i0	100	0.911320754716981	966	0	91.1	0	2997	100	2	967	WP_075424065.1 type VI-D CRISPR-associated RNA-guided ribonuclease Cas13d [Ruminococcus sp. XPD3002]	diamond	2898	1895	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp. XPD3002
4870465	4870465	PRJNA1192965_P_NODE_4424_length_245_cov_0.895349_g4405_i0	PRJNA1192965	4424	245	0.895349	2.19360505	Lactobacillus	1578	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g4405	i0	100	426.040816326531	245	0	100	0	1	245	90557	90801	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	104380	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
6145220	6145220	PRJNA1192965_P_NODE_3345_length_251_cov_0.865169_g3326_i0	PRJNA1192965	3345	251	0.865169	2.17157419	Staphylococcus	1279	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2482395019\|gb\|CP094927.1\|	1280	g3326	i0	100	100	251	0	100	0	1	251	307609	307359	Staphylococcus aureus strain 13 chromosome, complete genome	blastn	25100	464	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
8695387	8695387	PRJNA1192965_P_NODE_1087_length_377_cov_1.523026_g1068_i0	PRJNA1192965	1087	377	1.523026	5.74180802	Staphylococcus	1279	Bacteria	Bacteria	680	0	NTclustered	gi\|2451579829\|gb\|CP118060.1\|	1283	g1068	i0	99.204	466.262599469496	377	3	100	0	1	377	855976	855600	Staphylococcus haemolyticus strain VSI35 chromosome, complete genome	blastn	175781	680	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
18172127	18172127	PRJNA1192965_P_NODE_4415_length_245_cov_0.895349_g4396_i0	PRJNA1192965	4415	245	0.895349	2.19360505	Finegoldia magna	1260	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g4396	i0	100	648.955102040816	245	0	100	0	1	245	162671	162427	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	158994	453	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
19446537	19446537	PRJNA1192965_P_NODE_2716_length_269_cov_1.719388_g2697_i0	PRJNA1192965	2716	269	1.719388	4.62515372	Staphylococcus warneri	1292	Bacteria	Bacteria	488	1.5799999999999998e-133	NTclustered	gi\|1714036495\|gb\|CP031269.1\|	1292	g2697	i0	99.625	474.323420074349	267	1	99	0	1	267	2316137	2315871	Staphylococcus warneri strain 16A chromosome, complete genome	blastn	127593	488	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
22719223	22719223	PRJNA1192965_P_NODE_1898_length_306_cov_2.244635_g1879_i0	PRJNA1192965	1898	306	2.244635	6.8685831	Bacillales	1385	Bacteria	Bacteria	566	8.239999999999998e-157	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g1879	i0	100	533.915032679739	306	0	100	0	1	306	750199	749894	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	163378	566	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
30546296	30546296	PRJNA1192965_P_NODE_3793_length_248_cov_1.468571_g3774_i0	PRJNA1192965	3793	248	1.468571	3.64205608	Clostridia bacterium	2044939	Bacteria	Bacteria	72.4	1.25e-12	NR	MBR0463171.1	2044939	g3774	i0	52.6	4.65725806451613	76	30	85.9	3	36	248	222	296	MBR0463171.1 glycoside hydrolase family 125 protein [Clostridia bacterium]	diamond	1155	72.4	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
31620919	31620919	PRJNA1192965_P_NODE_2916_length_262_cov_1.629630_g2897_i0	PRJNA1192965	2916	262	1.62963	4.2696306	unclassified Oceanobacillus	2630292	Bacteria	Bacteria	42.7	0.0453	NR	WP_156858045.1	2630292	g2897	i0	30.6	0.709923664122137	62	43	71	0	234	49	149	210	WP_156858045.1 MULTISPECIES: ribosome biogenesis GTPase YqeH [unclassified Oceanobacillus]	diamond	186	42.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Oceanobacillus
31652423	31652423	PRJNA1192965_P_NODE_4057_length_247_cov_0.885057_g4038_i0	PRJNA1192965	4057	247	0.885057	2.18609079	Bacilli bacterium	1903720	Bacteria	Bacteria	42	0.0235	NR	GHU29446.1	1903720	g4038	i0	37.5	0.777327935222672	64	32	71.7	4	198	22	4	64	GHU29446.1 hypothetical protein FACS1894152_7770 [Bacilli bacterium]	diamond	192	42	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
31779030	31779030	PRJNA1192965_P_NODE_1157_length_369_cov_4.905405_g1138_i0	PRJNA1192965	1157	369	4.905405	18.10094445	Brevibacillus fulvus	1125967	Bacteria	Bacteria	137	3.71e-39	NR	WP_204516782.1	1125967	g1138	i0	61.7	0.869918699186992	107	41	87	0	41	361	2	108	WP_204516782.1 group I truncated hemoglobin [Brevibacillus fulvus]	diamond	321	137	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus fulvus
31873985	31873985	PRJNA1192965_P_NODE_2997_length_259_cov_1.956989_g2978_i0	PRJNA1192965	2997	259	1.956989	5.06860151	Bacilli bacterium	1903720	Bacteria	Bacteria	120	7.2e-30	NR	MBP3799570.1	1903720	g2978	i0	66.3	1.93436293436293	83	28	96.1	0	6	254	102	184	MBP3799570.1 dynamin family protein [Bacilli bacterium]	diamond	501	120	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
32063787	32063787	PRJNA1192965_P_NODE_1278_length_356_cov_1.088339_g1259_i0	PRJNA1192965	1278	356	1.088339	3.87448684	Symbiobacteriaceae bacterium	2602712	Bacteria	Bacteria	109	4.07e-26	NR	MDF2629472.1	2602712	g1259	i0	44.4	0.985955056179775	117	62	98.6	2	352	2	38	151	MDF2629472.1 zinc-binding dehydrogenase [Symbiobacteriaceae bacterium]	diamond	351	109	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Symbiobacteriaceae		Symbiobacteriaceae bacterium

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