metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA688736" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA688736" 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
3218581	3218581	PRJNA688736_P_NODE_27743_length_303_cov_1.147826_g27458_i0	PRJNA688736	27743	303	1.147826	3.47791278	Companilactobacillus allii	1847728	Bacteria	Bacteria	542	1.37e-149	NTclustered	gi\|1134955820\|gb\|CP019323.1\|	1847728	g27458	i0	99.007	471.590759075908	302	3	99	0	2	303	647993	647692	Companilactobacillus allii strain WiKim39, complete sequence.	blastn	142892	542	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Companilactobacillus	Companilactobacillus allii
5006024	5006024	PRJNA688736_P_NODE_38424_length_257_cov_3.190217_g38139_i0	PRJNA688736	38424	257	3.190217	8.19885769	Limosilactobacillus	2742598	Bacteria	Bacteria	475	1.1699999999999999e-129	NTclustered	gi\|2316373968\|gb\|CP106884.1\|	1633	g38139	i0	100	486.241245136187	257	0	100	0	1	257	501524	501268	Limosilactobacillus vaginalis strain GSH01 chromosome, complete genome	blastn	124964	475	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Limosilactobacillus	Limosilactobacillus vaginalis
5771592	5771592	PRJNA688736_P_NODE_40185_length_253_cov_0.866667_g39900_i0	PRJNA688736	40185	253	0.866667	2.19266751	Staphylococcus shinii	2912228	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|1969348917\|gb\|CP068712.1\|	2912228	g39900	i0	100	55.8300395256917	253	0	100	0	1	253	1512374	1512122	Staphylococcus shinii strain 14AME19 chromosome, complete genome	blastn	14125	468	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus shinii
7046391	7046391	PRJNA688736_P_NODE_32366_length_282_cov_1.416268_g32081_i0	PRJNA688736	32366	282	1.416268	3.99387576	Lapidilactobacillus dextrinicus	51664	Bacteria	Bacteria	420	6.19e-113	NTclustered	gi\|1757085258\|gb\|CP044499.1\|	51664	g32081	i0	93.38	447.822695035461	287	14	100	3	1	282	191060	191346	Lapidilactobacillus dextrinicus strain LH506 chromosome, complete genome	blastn	126286	420	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lapidilactobacillus	Lapidilactobacillus dextrinicus
7555986	7555986	PRJNA688736_P_NODE_9926_length_474_cov_3.633416_g9642_i0	PRJNA688736	9926	474	3.633416	17.22239184	Lactiplantibacillus	2767842	Bacteria	Bacteria	869	0	NTclustered	gi\|2739944818\|emb\|OZ061355.1\|	1589	g9642	i0	99.789	478.042194092827	473	1	99	0	1	473	568105	568577	Lactiplantibacillus pentosus isolate Lactiplantibacillus pentosus CNRZ1547 genome assembly, chromosome: 1	blastn	226592	869	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus pentosus
8830599	8830599	PRJNA688736_P_NODE_38027_length_259_cov_1.446237_g37742_i0	PRJNA688736	38027	259	1.446237	3.74575383	Bacilli	91061	Bacteria	Bacteria	462	9.2e-126	NTclustered	gi\|1114444147\|gb\|KX057511.1\|	1428	g37742	i0	98.842	110	259	3	100	0	1	259	749	491	Bacillus thuringiensis strain a33 16S ribosomal RNA gene, partial sequence	blastn	28490	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
11380950	11380950	PRJNA688736_P_NODE_30989_length_288_cov_1.134884_g30704_i0	PRJNA688736	30989	288	1.134884	3.26846592	Geobacillus	129337	Bacteria	Bacteria	516	7.86e-142	NTclustered	gi\|1317793375\|gb\|CP025074.1\|	1394	g30704	i0	98.958	35	288	3	100	0	1	288	251489	251776	[Bacillus] caldolyticus strain NEB414 chromosome, complete genome	blastn	10080	521	0.990403071017274	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	[Bacillus] caldolyticus
12656654	12656654	PRJNA688736_P_NODE_20350_length_346_cov_1.315018_g20065_i0	PRJNA688736	20350	346	1.315018	4.54996228	Staphylococcus	1279	Bacteria	Bacteria	634	2.5599999999999996e-177	NTclustered	gi\|93463980\|gb\|DQ472009.1\|	1288	g20065	i0	99.711	517.028901734104	346	1	100	0	1	346	1125	1470	Staphylococcus xylosus strain DSM20267 23S ribosomal RNA gene, partial sequence	blastn	178892	634	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus xylosus
13931038	13931038	PRJNA688736_P_NODE_13671_length_411_cov_2.952663_g13386_i0	PRJNA688736	13671	411	2.952663	12.13544493	Lactiplantibacillus	2767842	Bacteria	Bacteria	745	0	NTclustered	gi\|1482711233\|gb\|CP032460.1\|	1590	g13386	i0	99.511	472.729927007299	409	2	99	0	1	409	1181972	1182380	Lactiplantibacillus plantarum strain ATG-K2 chromosome, complete genome	blastn	194292	745	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
14696804	14696804	PRJNA688736_P_NODE_36992_length_263_cov_1.257895_g36707_i0	PRJNA688736	36992	263	1.257895	3.30826385	Lysinibacillus sp. PLM2	2929796	Bacteria	Bacteria	383	7.499999999999999e-102	NTclustered	gi\|2215597311\|dbj\|AP025689.1\|	2929796	g36707	i0	92.83	1.00760456273764	265	17	100	1	1	263	3812472	3812736	Lysinibacillus sp. PLM2 DNA, complete genome	blastn	265	383	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus sp. PLM2
15205872	15205872	PRJNA688736_P_NODE_19792_length_350_cov_1.440433_g19507_i0	PRJNA688736	19792	350	1.440433	5.0415155	Lactiplantibacillus	2767842	Bacteria	Bacteria	641	1.5399999999999996e-179	NTclustered	gi\|2739944818\|emb\|OZ061355.1\|	1589	g19507	i0	99.714	471.048571428571	350	1	100	0	1	350	567258	567607	Lactiplantibacillus pentosus isolate Lactiplantibacillus pentosus CNRZ1547 genome assembly, chromosome: 1	blastn	164867	641	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus pentosus
15971003	15971003	PRJNA688736_P_NODE_6913_length_558_cov_3.746392_g6631_i0	PRJNA688736	6913	558	3.746392	20.90486736	Lapidilactobacillus dextrinicus	51664	Bacteria	Bacteria	928	0	NTclustered	gi\|1757085258\|gb\|CP044499.1\|	51664	g6631	i0	96.926	571.965949820789	553	17	99	0	1	553	191971	192523	Lapidilactobacillus dextrinicus strain LH506 chromosome, complete genome	blastn	319157	928	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lapidilactobacillus	Lapidilactobacillus dextrinicus
16480551	16480551	PRJNA688736_P_NODE_39653_length_253_cov_1.577778_g39368_i0	PRJNA688736	39653	253	1.577778	3.99177834	Companilactobacillus	2767879	Bacteria	Bacteria	431	2.52e-116	NTclustered	gi\|1678291493\|gb\|CP040736.1\|	938155	g39368	i0	97.61	537.529644268775	251	6	99	0	1	251	34481	34231	Companilactobacillus futsaii strain Y97 chromosome, complete genome	blastn	135995	431	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Companilactobacillus	Companilactobacillus futsaii
20304015	20304015	PRJNA688736_P_NODE_37416_length_261_cov_2.234043_g37131_i0	PRJNA688736	37416	261	2.234043	5.83085223	Companilactobacillus	2767879	Bacteria	Bacteria	449	7.22e-122	NTclustered	gi\|2781060683\|gb\|CP162899.1\|	1612	g37131	i0	97.701	521.195402298851	261	6	100	0	1	261	1879594	1879334	Companilactobacillus farciminis strain YLR-1 chromosome, complete genome	blastn	136032	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Companilactobacillus	Companilactobacillus farciminis
21579645	21579645	PRJNA688736_P_NODE_27857_length_302_cov_1.388646_g27572_i0	PRJNA688736	27857	302	1.388646	4.19371092	Lactobacillaceae	33958	Bacteria	Bacteria	558	1.36e-154	NTclustered	gi\|310941352\|dbj\|AB596991.1\|	1633	g27572	i0	100	112	302	0	100	0	1	302	115	416	Lactobacillus vaginalis gene for 16S rRNA, partial sequence, strain: HE3	blastn	33824	558	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Limosilactobacillus	Limosilactobacillus vaginalis
23620764	23620764	PRJNA688736_P_NODE_37139_length_262_cov_2.132275_g36854_i0	PRJNA688736	37139	262	2.132275	5.5865605	Lapidilactobacillus dextrinicus	51664	Bacteria	Bacteria	424	4.4e-114	NTclustered	gi\|1757085258\|gb\|CP044499.1\|	51664	g36854	i0	95.802	486.74427480916	262	11	100	0	1	262	191868	191607	Lapidilactobacillus dextrinicus strain LH506 chromosome, complete genome	blastn	127527	424	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lapidilactobacillus	Lapidilactobacillus dextrinicus

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