metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA800090" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA800090" 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
1220598	1220598	PRJNA800090_P_NODE_178081_length_234_cov_0.806061_g175896_i0	PRJNA800090	178081	234	0.806061	1.88618274	Trichococcus	82802	Bacteria	Bacteria	416	6.449999999999999e-112	NTclustered	gi\|2621701196\|emb\|OY759718.1\|	82803	g175896	i0	98.718	416.529914529915	234	3	100	0	1	234	61113	61346	MAG: Trichococcus flocculiformis isolate 659e37ff-3402-4023-a990-0c9469b16b9d genome assembly, chromosome: 1	blastn	97468	416	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Trichococcus	Trichococcus flocculiformis
3351622	3351622	PRJNA800090_S_NODE_27163_length_245_cov_1.636364_g27051_i0	PRJNA800090	27163	245	1.636364	4.0090918	Paenibacillus amylolyticus	1451	Bacteria	Bacteria	62.1	3.67e-5	NTclustered	gi\|2484051427\|gb\|CP121451.1\|	1451	g27051	i0	91.304	10.3918367346939	46	2	18	2	181	225	934493	934537	Paenibacillus amylolyticus strain Sample9_7 chromosome, complete genome	blastn	2546	62.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus amylolyticus
4626578	4626578	PRJNA800090_P_NODE_181764_length_232_cov_1.184049_g179579_i0	PRJNA800090	181764	232	1.184049	2.74699368	Weissella sagaensis	2559928	Bacteria	Bacteria	424	3.82e-114	NTclustered	gi\|2786736315\|gb\|CP166295.1\|	2559928	g179579	i0	99.569	598.98275862069	232	1	100	0	1	232	311730	311499	Weissella sagaensis strain ZD-66 chromosome, complete genome	blastn	138964	424	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella sagaensis
6325273	6325273	PRJNA800090_P_NODE_78105_length_380_cov_1.327974_g75920_i0	PRJNA800090	78105	380	1.327974	5.0463012	Clostridium	1485	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2425298477\|gb\|CP114763.1\|	1492	g75920	i0	94.444	1.8	36	2	9	0	345	380	2739288	2739323	Clostridium butyricum strain LV1 chromosome 1, complete sequence	blastn	684	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium butyricum
7598569	7598569	PRJNA800090_P_NODE_157566_length_249_cov_1.416667_g155381_i0	PRJNA800090	157566	249	1.416667	3.52750083	Staphylococcus	1279	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2669659999\|gb\|CP090011.1\|	1290	g155381	i0	99.598	475.345381526104	249	1	100	0	1	249	762188	762436	Staphylococcus hominis strain acrlg chromosome, complete genome	blastn	118361	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
9726635	9726635	PRJNA800090_P_NODE_198728_length_214_cov_2.979310_g196543_i0	PRJNA800090	198728	214	2.97931	6.3757234	Paenibacillus sp. FSL K6-3182	2921495	Bacteria	Bacteria	396	7.559999999999996e-106	NTclustered	gi\|2709965757\|gb\|CP150265.1\|	2921495	g196543	i0	100	1101.18691588785	214	0	100	0	1	214	96604	96817	Paenibacillus sp. FSL K6-3182 chromosome, complete genome	blastn	235654	396	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL K6-3182
10149015	10149015	PRJNA800090_P_NODE_172268_length_236_cov_1.520958_g170083_i0	PRJNA800090	172268	236	1.520958	3.58946088	Streptococcus	1301	Bacteria	Bacteria	436	4.999999999999999e-118	NTclustered	gi\|1403314054\|emb\|LS483348.1\|	150055	g170083	i0	100	47	236	0	100	0	1	236	337321	337556	Streptococcus lutetiensis strain NCTC8738 genome assembly, chromosome: 1	blastn	11092	436	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus lutetiensis
11000194	11000194	PRJNA800090_P_NODE_10049_length_1277_cov_1.918874_g8886_i0	PRJNA800090	10049	1277	1.918874	24.50402098	Streptococcus mitis	28037	Bacteria	Bacteria	67.6	4.66e-6	NTclustered	gi\|927035354\|gb\|CP012646.1\|	28037	g8886	i0	85.294	0.0532498042286609	68	7	5	3	643	707	1106772	1106839	Streptococcus mitis strain KCOM 1350 (= ChDC B183), complete genome	blastn	68	67.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
11002556	11002556	PRJNA800090_P_NODE_2609_length_2119_cov_2.624390_g2247_i0	PRJNA800090	2609	2119	2.62439	55.6108241	Cohnella abietis	2507935	Bacteria	Bacteria	237	5.629999999999999e-57	NTclustered	gi\|1563814197\|dbj\|AP019400.1\|	2507935	g2247	i0	75.352	46.9919773478056	568	100	35	33	954	1504	2432368	2431824	Cohnella sp. HS21 DNA, complete genome	blastn	99576	237	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Cohnella	Cohnella abietis
11004057	11004057	PRJNA800090_P_NODE_93109_length_340_cov_2.605166_g90924_i0	PRJNA800090	93109	340	2.605166	8.8575644	Virgibacillus sp. 6R	1911587	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1112930461\|gb\|CP017762.1\|	1911587	g90924	i0	100	0.0882352941176471	30	0	9	0	83	112	1111359	1111388	Virgibacillus sp. 6R chromosome, complete sequence	blastn	30	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Virgibacillus	Virgibacillus sp. 6R
12277489	12277489	PRJNA800090_P_NODE_175490_length_234_cov_4.048485_g173305_i0	PRJNA800090	175490	234	4.048485	9.4734549	Staphylococcus lugdunensis	28035	Bacteria	Bacteria	427	2.9799999999999993e-115	NTclustered	gi\|1239643078\|gb\|CP017069.2\|	28035	g173305	i0	99.573	472.008547008547	234	1	100	0	1	234	2381936	2382169	Staphylococcus lugdunensis strain K93G chromosome, complete genome	blastn	110450	427	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus lugdunensis
12277518	12277518	PRJNA800090_P_NODE_176770_length_234_cov_0.884848_g174585_i0	PRJNA800090	176770	234	0.884848	2.07054432	Staphylococcus epidermidis	1282	Bacteria	Bacteria	427	2.9799999999999993e-115	NTclustered	gi\|2536852070\|gb\|CP129374.1\|	1282	g174585	i0	99.573	100	234	1	100	0	1	234	975732	975499	Staphylococcus epidermidis strain CSMH-411EB chromosome, complete genome	blastn	23400	427	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
13975181	13975181	PRJNA800090_P_NODE_78731_length_378_cov_1.514563_g76546_i0	PRJNA800090	78731	378	1.514563	5.72504814	root	1	Root_unresolved	Root_unresolved	601	2.8499999999999996e-167	NTclustered	gi\|719642273\|gb\|CP009746.1\|	1405	g76546	i0	100	99.1243386243386	325	0	86	0	54	378	5592418	5592094	Bacillus weihenstephanensis strain WSBC 10204, complete genome	blastn	37469	601	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
21200549	21200549	PRJNA800090_P_NODE_179857_length_233_cov_0.878049_g177672_i0	PRJNA800090	179857	233	0.878049	2.04585417	Paenibacillus sp. FSL K6-3182	2921495	Bacteria	Bacteria	431	2.2899999999999996e-116	NTclustered	gi\|2709965757\|gb\|CP150265.1\|	2921495	g177672	i0	100	57.6609442060086	233	0	100	0	1	233	84422	84190	Paenibacillus sp. FSL K6-3182 chromosome, complete genome	blastn	13435	431	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL K6-3182
24172687	24172687	PRJNA800090_P_NODE_58259_length_458_cov_3.742931_g56075_i0	PRJNA800090	58259	458	3.742931	17.14262398	Bacteria	2	Bacteria	Bacteria	846	0	NTclustered	gi\|1147724948\|gb\|KY622910.1\|	1290	g56075	i0	100	105	458	0	100	0	1	458	74	531	Staphylococcus hominis strain OA313 16S ribosomal RNA gene, partial sequence	blastn	48090	846	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis

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