metadata: contig_metadata: 20 rows where bioproject = "PRJNA415636" and tax

20 rows where bioproject = "PRJNA415636" and tax_kingdom = "Bacillati"

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
1693939	1693939	PRJNA415636_S_NODE_3962_length_250_cov_1.201970_g3915_i0	PRJNA415636	3962	250	1.20197	3.004925	Streptococcus mitis	28037	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2886510793\|emb\|OZ217345.1\|	28037	g3915	i0	100	99.98	250	0	100	0	1	250	1742079	1742328	Streptococcus mitis isolate S. mitis F22 genome assembly, chromosome: 1	blastn	24995	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
2969826	2969826	PRJNA415636_S_NODE_5843_length_214_cov_0.916168_g5796_i0	PRJNA415636	5843	214	0.916168	1.96059952	Mycoplasma wenyonii	65123	Bacteria	Bacteria	357	3.5699999999999996e-94	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g5796	i0	96.729	1	214	7	100	0	1	214	187906	188119	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	214	357	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
4246174	4246174	PRJNA415636_S_NODE_6104_length_210_cov_2.815951_g6057_i0	PRJNA415636	6104	210	2.815951	5.9134971	Mycoplasma wenyonii	65123	Bacteria	Bacteria	383	5.75e-102	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g6057	i0	99.524	1	210	1	100	0	1	210	609661	609452	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	210	383	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
5522883	5522883	PRJNA415636_S_NODE_2945_length_280_cov_1.510730_g2898_i0	PRJNA415636	2945	280	1.51073	4.230044	Mycoplasma wenyonii	65123	Bacteria	Bacteria	468	2.16e-127	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g2898	i0	96.786	1	280	9	100	0	1	280	537161	537440	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	280	468	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
13172877	13172877	PRJNA415636_S_NODE_1071_length_400_cov_3.660057_g1024_i0	PRJNA415636	1071	400	3.660057	14.640228	Paenarthrobacter sp. S56	3138179	Bacteria	Bacteria	67.6	1.37e-6	NTclustered	gi\|2734993624\|gb\|CP152470.1\|	3138179	g1024	i0	97.436	0.2975	39	1	10	0	204	242	3312890	3312928	Paenarthrobacter sp. S56 chromosome, complete genome	blastn	119	67.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Paenarthrobacter	Paenarthrobacter sp. S56
15721779	15721779	PRJNA415636_S_NODE_3953_length_250_cov_2.078818_g3906_i0	PRJNA415636	3953	250	2.078818	5.197045	Mycoplasma wenyonii	65123	Bacteria	Bacteria	440	4.1399999999999976e-119	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g3906	i0	98.406	1.004	251	3	100	1	1	250	560981	561231	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	251	440	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
16385690	16385690	PRJNA415636_S_NODE_4113_length_246_cov_2.306533_g4066_i0	PRJNA415636	4113	246	2.306533	5.67407118	Streptococcus	1301	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|2246565702\|gb\|CP097843.1\|	1303	g4066	i0	99.187	100	246	2	100	0	1	246	1772641	1772396	Streptococcus oralis strain HP01 chromosome, complete genome	blastn	24600	444	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
17660801	17660801	PRJNA415636_S_NODE_1314_length_375_cov_7.704268_g1267_i0	PRJNA415636	1314	375	7.704268	28.891005	Paenibacillus	44249	Bacteria	Bacteria	52.8	0.036	NTclustered	gi\|1125819267\|gb\|CP011420.1\|	1406	g1267	i0	100	0.456	28	0	7	0	328	355	3149485	3149458	Paenibacillus polymyxa strain ATCC 15970 chromosome, complete genome	blastn	171	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus polymyxa
18270736	18270736	PRJNA415636_S_NODE_5335_length_222_cov_1.497143_g5288_i0	PRJNA415636	5335	222	1.497143	3.32365746	Mycoplasma wenyonii	65123	Bacteria	Bacteria	361	2.8799999999999994e-95	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g5288	i0	95.946	1	222	9	100	0	1	222	137419	137640	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	222	361	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
19544940	19544940	PRJNA415636_S_NODE_4956_length_229_cov_1.197802_g4909_i0	PRJNA415636	4956	229	1.197802	2.74296658	Mycoplasma wenyonii	65123	Bacteria	Bacteria	350	6.47e-92	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g4909	i0	94.298	0.995633187772926	228	13	99	0	2	229	188922	188695	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	228	350	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
20820832	20820832	PRJNA415636_S_NODE_3957_length_250_cov_1.502463_g3910_i0	PRJNA415636	3957	250	1.502463	3.7561575	Mycoplasma wenyonii	65123	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g3910	i0	99.6	1	250	1	100	0	1	250	37219	37468	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	250	457	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
20820834	20820834	PRJNA415636_S_NODE_4197_length_244_cov_1.258883_g4150_i0	PRJNA415636	4197	244	1.258883	3.07167452	Corynebacterium sp. 102791.4	3104612	Bacteria	Bacteria	385	1.91e-102	NTclustered	gi\|2627812303\|gb\|OR912476.1\|	3104612	g4150	i0	95.082	335.463114754098	244	12	100	0	1	244	1164	921	Corynebacterium sp. 102791.4 23S ribosomal RNA gene, partial sequence	blastn	81853	385	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. 102791.4
20820836	20820836	PRJNA415636_S_NODE_5537_length_219_cov_1.186047_g5490_i0	PRJNA415636	5537	219	1.186047	2.59744293	Mycoplasma wenyonii	65123	Bacteria	Bacteria	366	6.09e-97	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g5490	i0	97.235	0.990867579908676	217	4	99	2	4	219	556495	556280	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	217	366	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
23371220	23371220	PRJNA415636_S_NODE_2419_length_301_cov_3.610236_g2372_i0	PRJNA415636	2419	301	3.610236	10.86681036	Mycoplasma wenyonii	65123	Bacteria	Bacteria	518	2.3e-142	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g2372	i0	97.674	1	301	7	100	0	1	301	254865	254565	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	301	518	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
27612797	27612797	PRJNA415636_S_NODE_5384_length_221_cov_2.086207_g5337_i0	PRJNA415636	5384	221	2.086207	4.61051747	Actinomycetota bacterium	2900548	Bacteria	Bacteria	53.5	1.91e-6	NR	MEY2477645.1	2900548	g5337	i0	42.3	1.91402714932127	71	41	96.4	0	214	2	78	148	MEY2477645.1 hypothetical protein [Actinomycetota bacterium]	diamond	423	53.5	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
27770744	27770744	PRJNA415636_S_NODE_2104_length_318_cov_2.719557_g2057_i0	PRJNA415636	2104	318	2.719557	8.64819126	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	93.6	4.22e-21	NR	HEX2906967.1	3069543	g2057	i0	43.6	0.952830188679245	101	56	95.3	1	303	1	95	194	HEX2906967.1 isoprenylcysteine carboxylmethyltransferase family protein [Phototrophicaceae bacterium]	diamond	303	93.6	1	Bacteria	Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
29854485	29854485	PRJNA415636_S_NODE_4031_length_248_cov_2.273632_g3984_i0	PRJNA415636	4031	248	2.273632	5.63860736	Mycoplasma wenyonii	65123	Bacteria	Bacteria	94	1.84e-20	NR	WP_112665897.1	65123	g3984	i0	56.4	0.943548387096774	78	34	94.4	0	234	1	262	339	WP_112665897.1 restriction endonuclease subunit S [Mycoplasma wenyonii]	diamond	234	94	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
30265440	30265440	PRJNA415636_S_NODE_3832_length_253_cov_1.800971_g3785_i0	PRJNA415636	3832	253	1.800971	4.55645663	Neobacillus cucumis	1740721	Bacteria	Bacteria	111	1.81e-26	NR	WP_180960453.1	1740721	g3785	i0	59.5	1.99209486166008	84	34	99.6	0	2	253	103	186	WP_180960453.1 C39 family peptidase [Neobacillus cucumis]	diamond	504	111	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Neobacillus	Neobacillus cucumis
30517906	30517906	PRJNA415636_S_NODE_3613_length_259_cov_0.995283_g3566_i0	PRJNA415636	3613	259	0.995283	2.57778297	Mycoplasma wenyonii	65123	Bacteria	Bacteria	139	3.1500000000000004e-36	NR	WP_112664927.1	65123	g3566	i0	81.4	0.996138996138996	86	16	99.6	0	259	2	133	218	WP_112664927.1 DNA gyrase/topoisomerase IV subunit B [Mycoplasma wenyonii]	diamond	258	139	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
31055321	31055321	PRJNA415636_S_NODE_2755_length_287_cov_1.525000_g2708_i0	PRJNA415636	2755	287	1.525	4.37675	Mycoplasma wenyonii	65123	Bacteria	Bacteria	73.2	5.52e-13	NR	RAO95294.1	65123	g2708	i0	97.1	0.710801393728223	34	1	35.5	0	95	196	203	236	RAO95294.1 modification methylase HemK [Mycoplasma wenyonii]	diamond	204	73.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii

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