metadata: contig_metadata: 15 rows where bioproject = "PRJNA396510" and tax

15 rows where bioproject = "PRJNA396510" 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
411888	411888	PRJNA396510_P_NODE_15361_length_163_cov_0.894737_g15292_i0	PRJNA396510	15361	163	0.894737	1.45842131	Streptococcus thermophilus	1308	Bacteria	Bacteria	112	5.08e-27	NR	TKW62483.1	1308	g15292	i0	100	1.98773006134969	54	0	99.4	0	1	162	550	603	TKW62483.1 MAG: hypothetical protein DI612_08705, partial [Streptococcus thermophilus]	diamond	324	112	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
8731939	8731939	PRJNA396510_P_NODE_7907_length_211_cov_1.574074_g7838_i0	PRJNA396510	7907	211	1.574074	3.32129614	Streptococcus	1301	Bacteria	Bacteria	390	3.459999999999999e-104	NTclustered	gi\|1403375826\|emb\|LS483375.1\|	1302	g7838	i0	100	336	211	0	100	0	1	211	625278	625488	Streptococcus gordonii strain NCTC3165 genome assembly, chromosome: 1	blastn	70896	390	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus gordonii
10615821	10615821	PRJNA396510_P_NODE_15769_length_162_cov_0.902655_g15700_i0	PRJNA396510	15769	162	0.902655	1.4623011	Staphylococcus hominis	1290	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g15700	i0	100	27.3827160493827	162	0	100	0	1	162	99897	99736	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	4436	300	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
11282373	11282373	PRJNA396510_P_NODE_5749_length_242_cov_1.595855_g5680_i0	PRJNA396510	5749	242	1.595855	3.8619691	Streptococcus	1301	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1578096036\|emb\|LR216035.1\|	1313	g5680	i0	100	336.892561983471	242	0	100	0	1	242	1835236	1834995	Streptococcus pneumoniae isolate SA_GPS_SP505-sc-1895675 genome assembly, chromosome: 1	blastn	81528	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
11890736	11890736	PRJNA396510_P_NODE_16310_length_161_cov_0.910714_g16241_i0	PRJNA396510	16310	161	0.910714	1.46624954	Streptococcus oralis	1303	Bacteria	Bacteria	254	3.42e-63	NTclustered	gi\|326682110\|emb\|FR720602.1\|	927666	g16241	i0	95.57	24.3850931677019	158	7	98	0	4	161	1040699	1040542	Streptococcus oralis Uo5 complete genome sequence	blastn	3926	254	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
15106883	15106883	PRJNA396510_P_NODE_2152_length_368_cov_1.479624_g2083_i0	PRJNA396510	2152	368	1.479624	5.44501632	Staphylococcus	1279	Bacteria	Bacteria	658	0	NTclustered	gi\|93463980\|gb\|DQ472009.1\|	1288	g2083	i0	98.913	485.013586956522	368	4	100	0	1	368	479	846	Staphylococcus xylosus strain DSM20267 23S ribosomal RNA gene, partial sequence	blastn	178485	664	0.990963855421687	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus xylosus
16989354	16989354	PRJNA396510_P_NODE_13854_length_166_cov_0.871795_g13785_i0	PRJNA396510	13854	166	0.871795	1.4471797	Staphylococcus cohnii	29382	Bacteria	Bacteria	298	1.62e-76	NTclustered	gi\|2624852950\|gb\|CP119997.1\|	29382	g13785	i0	100	7.59036144578313	161	0	97	0	6	166	290118	289958	Staphylococcus cohnii strain Dog166 chromosome, complete genome	blastn	1260	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
20813540	20813540	PRJNA396510_P_NODE_15877_length_162_cov_0.902655_g15808_i0	PRJNA396510	15877	162	0.902655	1.4623011	Bacillus paralicheniformis	1648923	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|2006893320\|dbj\|AP023090.1\|	1648923	g15808	i0	99.383	99.6481481481482	162	1	100	0	1	162	3044268	3044429	Bacillus paralicheniformis RSC-3 DNA, complete genome	blastn	16143	294	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus paralicheniformis
22756115	22756115	PRJNA396510_P_NODE_16078_length_162_cov_0.902655_g16009_i0	PRJNA396510	16078	162	0.902655	1.4623011	Lactobacillus	1578	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g16009	i0	100	584.759259259259	162	0	100	0	1	162	59085	59246	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	94731	300	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
26726804	26726804	PRJNA396510_P_NODE_14301_length_165_cov_0.879310_g14232_i0	PRJNA396510	14301	165	0.87931	1.4508615	Levyella massiliensis	938289	Bacteria	Bacteria	112	2.9e-28	NR	WP_019190309.1	938289	g14232	i0	96.3	0.981818181818182	54	2	98.2	0	3	164	116	169	WP_019190309.1 MaoC/PaaZ C-terminal domain-containing protein [Levyella massiliensis]	diamond	162	112	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales		Levyella	Levyella massiliensis
28797221	28797221	PRJNA396510_P_NODE_15507_length_163_cov_0.894737_g15438_i0	PRJNA396510	15507	163	0.894737	1.45842131	Bacteria	2	Bacteria	Bacteria	106	7.45e-28	NR	MBN9993869.1	1639	g15438	i0	100	3.97546012269939	54	0	99.4	0	163	2	28	81	MBN9993869.1 hypothetical protein [Listeria monocytogenes]	diamond	648	106	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
30486162	30486162	PRJNA396510_P_NODE_9953_length_191_cov_0.838028_g9884_i0	PRJNA396510	9953	191	0.838028	1.60063348	Paenibacillus gyeongsangnamensis	3388067	Bacteria	Bacteria	41.6	0.0479	NR	WP_269884168.1	3388067	g9884	i0	31	0.910994764397906	58	38	91.1	2	184	11	65	120	WP_269884168.1 uracil/xanthine transporter [Paenibacillus gyeongsangnamensis]	diamond	174	41.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus gyeongsangnamensis
31577575	31577575	PRJNA396510_P_NODE_5156_length_254_cov_1.087805_g5087_i0	PRJNA396510	5156	254	1.087805	2.7630247	Paenibacillus	44249	Bacteria	Bacteria	42.7	0.0402	NR	WP_238655226.1	1089681	g5087	i0	36.2	1.37007874015748	58	37	68.5	0	33	206	143	200	WP_238655226.1 alpha/beta hydrolase [Paenibacillus piscarius]	diamond	348	42.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus piscarius
32130356	32130356	PRJNA396510_P_NODE_15258_length_163_cov_0.894737_g15189_i0	PRJNA396510	15258	163	0.894737	1.45842131	Mediannikoviicoccus vaginalis	2899727	Bacteria	Bacteria	92.4	3.82e-20	NR	WP_237036350.1	2899727	g15189	i0	92.5	0.975460122699387	53	4	97.5	0	3	161	801	853	WP_237036350.1 DNA mismatch repair protein MutS [Mediannikoviicoccus vaginalis]	diamond	159	92.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Mediannikoviicoccus	Mediannikoviicoccus vaginalis
32351877	32351877	PRJNA396510_P_NODE_13979_length_166_cov_0.863248_g13910_i0	PRJNA396510	13979	166	0.863248	1.43299168	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	47.4	3.1e-4	NR	MBE6951160.1	2485925	g13910	i0	45	0.72289156626506	40	22	72.3	0	40	159	49	88	MBE6951160.1 hypothetical protein [Oscillospiraceae bacterium]	diamond	120	47.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae 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);;