metadata: contig_metadata: 17 rows where bioproject = "PRJNA322517" and tax

17 rows where bioproject = "PRJNA322517" 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
3619814	3619814	PRJNA322517_P_NODE_5263_length_169_cov_1.291667_g5241_i0	PRJNA322517	5263	169	1.291667	2.18291723	root	1	Root_unresolved	Root_unresolved	307	2.73e-79	NTclustered	gi\|2800799246\|gb\|CP093959.1\|	1358	g5241	i0	99.408	414	169	1	100	0	1	169	162156	162324	Lactococcus lactis strain FAM 17919 chromosome, complete genome	blastn	69966	307	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
4897013	4897013	PRJNA322517_P_NODE_6084_length_162_cov_4.690265_g6062_i0	PRJNA322517	6084	162	4.690265	7.5982293	Staphylococcus	1279	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|1214725545\|gb\|CP022247.1\|	1282	g6062	i0	100	99.8271604938272	162	0	100	0	1	162	1656775	1656614	Staphylococcus epidermidis strain AMT chromosome, complete genome	blastn	16172	300	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
7447033	7447033	PRJNA322517_P_NODE_4726_length_179_cov_7.500000_g4704_i0	PRJNA322517	4726	179	7.5	13.425	Bacillaceae	186817	Bacteria	Bacteria	315	1.75e-81	NTclustered	gi\|1387294402\|gb\|CP023704.1\|	35841	g4704	i0	99.422	3.60335195530726	173	1	97	0	7	179	3615112	3615284	Caldibacillus thermoamylovorans strain SSBM chromosome, complete genome	blastn	645	315	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Caldibacillus	Caldibacillus thermoamylovorans
8721707	8721707	PRJNA322517_P_NODE_4347_length_188_cov_1.136691_g4325_i0	PRJNA322517	4347	188	1.136691	2.13697908	Lactococcus	1357	Bacteria	Bacteria	339	1.1e-88	NTclustered	gi\|2844354962\|gb\|CP126575.1\|	1359	g4325	i0	100	2.87765957446809	183	0	97	0	1	183	128	310	Lactococcus cremoris strain UL007 plasmid pUL007F, complete sequence	blastn	541	339	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus cremoris
12547680	12547680	PRJNA322517_P_NODE_3710_length_209_cov_5.412500_g3688_i0	PRJNA322517	3710	209	5.4125	11.312125	Bacillus	1386	Bacteria	Bacteria	318	1.64e-82	NTclustered	gi\|2033736802\|gb\|CP072774.1\|	1396	g3688	i0	94.924	94.2583732057416	197	7	94	1	13	209	4176059	4175866	Bacillus cereus strain BC33 chromosome, complete genome	blastn	19700	318	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
12547684	12547684	PRJNA322517_P_NODE_4930_length_175_cov_1.626984_g4908_i0	PRJNA322517	4930	175	1.626984	2.847222	Lactococcus	1357	Bacteria	Bacteria	318	1.32e-82	NTclustered	gi\|2844548646\|gb\|CP158368.1\|	1359	g4908	i0	99.429	45	175	1	100	0	1	175	404620	404794	Lactococcus cremoris strain UC023 chromosome, complete genome	blastn	7875	318	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus cremoris
12547689	12547689	PRJNA322517_P_NODE_6370_length_160_cov_2.747748_g6348_i0	PRJNA322517	6370	160	2.747748	4.3963968	root	1	Root_unresolved	Root_unresolved	279	5.59e-71	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g6348	i0	98.125	95.6875	160	3	100	0	1	160	1171	1330	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	15310	279	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
13822587	13822587	PRJNA322517_P_NODE_6471_length_151_cov_2.450980_g6449_i0	PRJNA322517	6471	151	2.45098	3.7009798	Lactobacillales	186826	Bacteria	Bacteria	279	5.19e-71	NTclustered	gi\|1044892037\|gb\|KX138409.1\|	1358	g6449	i0	100	276.430463576159	151	0	100	0	1	151	49625	49775	Lactococcus lactis strain NCDO712 plasmid pNZ712, complete sequence	blastn	41741	279	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
16966655	16966655	PRJNA322517_P_NODE_4574_length_183_cov_1.171642_g4552_i0	PRJNA322517	4574	183	1.171642	2.14410486	Lactococcus cremoris	1359	Bacteria	Bacteria	339	1.07e-88	NTclustered	gi\|2529167004\|gb\|CP069179.2\|	1359	g4552	i0	100	100	183	0	100	0	1	183	351354	351536	Lactococcus cremoris strain NCDO700 chromosome, complete genome	blastn	18300	339	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus cremoris
17646735	17646735	PRJNA322517_P_NODE_5214_length_170_cov_1.396694_g5192_i0	PRJNA322517	5214	170	1.396694	2.3743798	Lactococcus	1357	Bacteria	Bacteria	309	7.64e-80	NTclustered	gi\|1044892037\|gb\|KX138409.1\|	1358	g5192	i0	99.412	15	170	1	100	0	1	170	43773	43942	Lactococcus lactis strain NCDO712 plasmid pNZ712, complete sequence	blastn	2550	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
17646740	17646740	PRJNA322517_P_NODE_6294_length_161_cov_0.910714_g6272_i0	PRJNA322517	6294	161	0.910714	1.46624954	Lactococcus	1357	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|2529167004\|gb\|CP069179.2\|	1359	g6272	i0	100	45	161	0	100	0	1	161	371971	372131	Lactococcus cremoris strain NCDO700 chromosome, complete genome	blastn	7245	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus cremoris
18920615	18920615	PRJNA322517_P_NODE_5355_length_167_cov_1.915254_g5333_i0	PRJNA322517	5355	167	1.915254	3.19847418	Streptococcus	1301	Bacteria	Bacteria	287	3.53e-73	NTclustered	gi\|2578556603\|gb\|CP133988.1\|	1318	g5333	i0	97.605	14.6347305389222	167	4	100	0	1	167	1975654	1975488	Streptococcus parasanguinis strain B-1756 chromosome, complete genome	blastn	2444	287	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus parasanguinis
21470876	21470876	PRJNA322517_P_NODE_5417_length_167_cov_0.864407_g5395_i0	PRJNA322517	5417	167	0.864407	1.44355969	Lactococcus	1357	Bacteria	Bacteria	298	1.63e-76	NTclustered	gi\|2844548646\|gb\|CP158368.1\|	1359	g5395	i0	98.802	1498.5628742515	167	2	100	0	1	167	2054638	2054472	Lactococcus cremoris strain UC023 chromosome, complete genome	blastn	250260	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus cremoris
21470877	21470877	PRJNA322517_P_NODE_6197_length_162_cov_0.902655_g6175_i0	PRJNA322517	6197	162	0.902655	1.4623011	Lactococcus	1357	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2529167004\|gb\|CP069179.2\|	1359	g6175	i0	100	13.9876543209877	162	0	100	0	1	162	1388920	1389081	Lactococcus cremoris strain NCDO700 chromosome, complete genome	blastn	2266	300	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus cremoris
24020940	24020940	PRJNA322517_P_NODE_3679_length_210_cov_2.583851_g3657_i0	PRJNA322517	3679	210	2.583851	5.4260871	Lactococcus	1357	Bacteria	Bacteria	322	1.27e-83	NTclustered	gi\|1551912485\|gb\|MH678626.1\|	1358	g3657	i0	92.558	101.214285714286	215	11	100	1	1	210	3749	3535	Lactococcus lactis strain Lll4 Eps gene cluster, complete sequence	blastn	21255	322	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
24020942	24020942	PRJNA322517_P_NODE_4499_length_184_cov_2.703704_g4477_i0	PRJNA322517	4499	184	2.703704	4.97481536	root	1	Root_unresolved	Root_unresolved	281	1.84e-71	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g4477	i0	100	161.407608695652	152	0	83	0	33	184	1047	896	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	29699	281	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
25295375	25295375	PRJNA322517_P_NODE_4300_length_189_cov_1.192857_g4278_i0	PRJNA322517	4300	189	1.192857	2.25449973	Lactococcus	1357	Bacteria	Bacteria	344	2.39e-90	NTclustered	gi\|2529167004\|gb\|CP069179.2\|	1359	g4278	i0	99.471	45	189	1	100	0	1	189	93987	94175	Lactococcus cremoris strain NCDO700 chromosome, complete genome	blastn	8505	344	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus cremoris

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