metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA1175041" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA1175041" 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
1041123	1041123	PRJNA1175041_P_NODE_66661_length_342_cov_1.182156_g63793_i0	PRJNA1175041	66661	342	1.182156	4.04297352	Mesomycoplasma	2923352	Bacteria	Bacteria	625	1.5199999999999998e-174	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g63793	i0	99.707	16.3099415204678	341	1	99	0	2	342	671212	670872	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	5578	625	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
1591112	1591112	PRJNA1175041_P_NODE_103802_length_243_cov_0.894118_g100934_i0	PRJNA1175041	103802	243	0.894118	2.17270674	Streptococcus pasteurianus	197614	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2605139866\|gb\|CP136943.1\|	197614	g100934	i0	100	22	243	0	100	0	1	243	831437	831195	Streptococcus pasteurianus strain WUSP082 chromosome, complete genome	blastn	5346	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pasteurianus
2316390	2316390	PRJNA1175041_P_NODE_39102_length_553_cov_1.456250_g36248_i0	PRJNA1175041	39102	553	1.45625	8.0530625	Bacillus	1386	Bacteria	Bacteria	1016	0	NTclustered	gi\|2798377728\|gb\|CP168764.1\|	1392	g36248	i0	99.819	100	553	1	100	0	1	553	3916615	3917167	Bacillus anthracis strain Z03-J001 chromosome, complete genome	blastn	55300	1016	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
4869162	4869162	PRJNA1175041_P_NODE_107384_length_239_cov_1.783133_g104516_i0	PRJNA1175041	107384	239	1.783133	4.26168787	Mesomycoplasma	2923352	Bacteria	Bacteria	431	2.3599999999999996e-116	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g104516	i0	99.167	15.0627615062761	240	1	100	1	1	239	423457	423696	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	3600	431	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
5420677	5420677	PRJNA1175041_P_NODE_98305_length_248_cov_0.868571_g95437_i0	PRJNA1175041	98305	248	0.868571	2.15405608	Corynebacterium hadale	2026255	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2537331151\|gb\|CP047655.1\|	2026255	g95437	i0	100	385.064516129032	248	0	100	0	1	248	1273267	1273514	Corynebacterium hadale strain DSM 105365 chromosome, complete genome	blastn	95496	459	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium hadale
6143960	6143960	PRJNA1175041_P_NODE_27345_length_781_cov_1.593220_g24659_i0	PRJNA1175041	27345	781	1.59322	12.4430482	Bacillus	1386	Bacteria	Bacteria	1432	0	NTclustered	gi\|2257786247\|gb\|CP085402.1\|	1392	g24659	i0	99.744	100.166453265045	781	2	100	0	1	781	3356875	3357655	Bacillus anthracis strain CMF9 chromosome, complete genome	blastn	78230	1432	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
8694045	8694045	PRJNA1175041_P_NODE_46807_length_467_cov_1.446701_g43941_i0	PRJNA1175041	46807	467	1.446701	6.75609367	Corynebacterium	1716	Bacteria	Bacteria	841	0	NTclustered	gi\|2547420364\|gb\|CP073093.1\|	38304	g43941	i0	99.355	366.758029978587	465	1	99	1	1	465	293904	294366	Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome	blastn	171276	841	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
8694047	8694047	PRJNA1175041_P_NODE_50007_length_440_cov_1.408719_g47140_i0	PRJNA1175041	50007	440	1.408719	6.1983636	Bacillus	1386	Bacteria	Bacteria	813	0	NTclustered	gi\|984728683\|gb\|CP014179.1\|	1392	g47140	i0	100	100	440	0	100	0	1	440	3948299	3947860	Bacillus anthracis strain Stendal chromosome, complete genome	blastn	44000	813	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
9244378	9244378	PRJNA1175041_P_NODE_104108_length_242_cov_1.408284_g101240_i0	PRJNA1175041	104108	242	1.408284	3.40804728	Lachnospiraceae bacterium JLR.KK009	3114295	Bacteria	Bacteria	398	2.4299999999999994e-106	NTclustered	gi\|2692820420\|gb\|CP143549.1\|	3114295	g101240	i0	96.281	1.61157024793388	242	9	100	0	1	242	390155	389914	Lachnospiraceae bacterium JLR.KK009 strain JLR.KK002 chromosome	blastn	390	398	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium JLR.KK009
9245502	9245502	PRJNA1175041_P_NODE_99028_length_247_cov_0.873563_g96160_i0	PRJNA1175041	99028	247	0.873563	2.15770061	Schaalia odontolytica	1660	Bacteria	Bacteria	124	4.66e-24	NTclustered	gi\|1663040979\|gb\|CP040006.1\|	1660	g96160	i0	98.571	0.283400809716599	70	1	28	0	1	70	1127189	1127258	Schaalia odontolytica strain XH001 chromosome, complete genome	blastn	70	124	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Schaalia	Schaalia odontolytica
9969225	9969225	PRJNA1175041_P_NODE_54328_length_409_cov_1.523810_g51460_i0	PRJNA1175041	54328	409	1.52381	6.2323829	Mollicutes	31969	Bacteria	Bacteria	750	0	NTclustered	gi\|281186773\|gb\|GU227378.1\|	2100	g51460	i0	99.756	100.987775061125	409	1	100	0	1	409	1346	938	Mycoplasma hyorhinis strain USP36P 16S ribosomal RNA gene, partial sequence	blastn	41304	750	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
9969239	9969239	PRJNA1175041_P_NODE_70868_length_325_cov_1.448413_g68000_i0	PRJNA1175041	70868	325	1.448413	4.70734225	Bacillus	1386	Bacteria	Bacteria	590	5.2299999999999986e-164	NTclustered	gi\|2257786247\|gb\|CP085402.1\|	1392	g68000	i0	99.385	100	325	2	100	0	1	325	3971078	3971402	Bacillus anthracis strain CMF9 chromosome, complete genome	blastn	32500	590	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
9969264	9969264	PRJNA1175041_P_NODE_99408_length_247_cov_0.862069_g96540_i0	PRJNA1175041	99408	247	0.862069	2.12931043	Bifidobacterium	1678	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|2450724931\|gb\|CP118598.1\|	1679	g96540	i0	99.595	8	247	1	100	0	1	247	1222869	1223115	Bifidobacterium longum subsp. longum strain F2 chromosome, complete genome	blastn	1976	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium longum
12519810	12519810	PRJNA1175041_P_NODE_96810_length_249_cov_0.863636_g93942_i0	PRJNA1175041	96810	249	0.863636	2.15045364	root	1	Root_unresolved	Root_unresolved	399	6.989999999999999e-107	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g93942	i0	95.582	99.566265060241	249	11	100	0	1	249	2463444	2463692	Staphylococcus aureus strain WH9628 chromosome	blastn	24792	399	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
13794446	13794446	PRJNA1175041_P_NODE_96051_length_250_cov_1.000000_g93183_i0	PRJNA1175041	96051	250	1	2.5	Geodermatophilaceae	85030	Bacteria	Bacteria	302	2.04e-77	NTclustered	gi\|507148190\|ref\|NR_102997.1\|	138336	g93183	i0	88.538	241.064	253	24	100	5	1	250	1652	1402	Blastococcus saxobsidens strain DD2 23S ribosomal RNA gene, complete sequence	blastn	60266	303	0.996699669966997	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus saxobsidens
14346520	14346520	PRJNA1175041_P_NODE_90452_length_265_cov_0.973958_g87584_i0	PRJNA1175041	90452	265	0.973958	2.5809887	Corynebacterium gottingense	2041036	Bacteria	Bacteria	484	2.0199999999999998e-132	NTclustered	gi\|2869851930\|gb\|CP175790.1\|	2041036	g87584	i0	99.623	362.581132075472	265	1	100	0	1	265	244019	244283	Corynebacterium gottingense strain YSMAA1_1_F6 chromosome, complete genome	blastn	96084	484	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium gottingense
15619271	15619271	PRJNA1175041_P_NODE_106713_length_240_cov_0.910180_g103845_i0	PRJNA1175041	106713	240	0.91018	2.184432	Streptococcus mitis	28037	Bacteria	Bacteria	377	3.14e-100	NTclustered	gi\|2886508907\|emb\|OZ217344.1\|	28037	g103845	i0	95	100	240	12	100	0	1	240	785652	785891	Streptococcus mitis isolate S. mitis E22 genome assembly, chromosome: 1	blastn	24000	377	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
16343619	16343619	PRJNA1175041_P_NODE_108173_length_239_cov_0.915663_g105305_i0	PRJNA1175041	108173	239	0.915663	2.18843457	Streptococcus	1301	Bacteria	Bacteria	442	1.0899999999999994e-119	NTclustered	gi\|335369081\|gb\|CP002843.1\|	760570	g105305	i0	100	12.7531380753138	239	0	100	0	1	239	1698443	1698681	Streptococcus parasanguinis ATCC 15912, complete genome	blastn	3048	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus parasanguinis
16893568	16893568	PRJNA1175041_P_NODE_105694_length_241_cov_0.904762_g102826_i0	PRJNA1175041	105694	241	0.904762	2.18047642	Streptomyces sp. 11x1	3038642	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2591930018\|gb\|CP122458.1\|	3038642	g102826	i0	96.875	0.132780082987552	32	0	13	1	91	122	5456664	5456634	Streptomyces sp. 11x1 chromosome, complete genome	blastn	32	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. 11x1
17618900	17618900	PRJNA1175041_P_NODE_40814_length_531_cov_1.296943_g37952_i0	PRJNA1175041	40814	531	1.296943	6.88676733	Bacillus	1386	Bacteria	Bacteria	754	0	NTclustered	gi\|2257786247\|gb\|CP085402.1\|	1392	g37952	i0	100	100.566854990584	408	0	100	0	124	531	3356178	3356585	Bacillus anthracis strain CMF9 chromosome, complete genome	blastn	53401	754	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
22718005	22718005	PRJNA1175041_P_NODE_103818_length_243_cov_0.894118_g100950_i0	PRJNA1175041	103818	243	0.894118	2.17270674	Clostridia	186801	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|2777750333\|dbj\|AP031452.1\|	39491	g100950	i0	99.177	20.7325102880658	243	2	100	0	1	243	2575854	2575612	Agathobacter rectalis k41-0107-C12 DNA, complete genome	blastn	5038	438	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Agathobacter	Agathobacter rectalis
22718040	22718040	PRJNA1175041_P_NODE_79638_length_295_cov_1.063063_g76770_i0	PRJNA1175041	79638	295	1.063063	3.13603585	Corynebacterium	1716	Bacteria	Bacteria	512	1.04e-140	NTclustered	gi\|2537331151\|gb\|CP047655.1\|	2026255	g76770	i0	97.966	433.840677966102	295	6	100	0	1	295	735100	735394	Corynebacterium hadale strain DSM 105365 chromosome, complete genome	blastn	127983	512	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium hadale
22718041	22718041	PRJNA1175041_P_NODE_79918_length_294_cov_1.262443_g77050_i0	PRJNA1175041	79918	294	1.262443	3.71158242	Corynebacterium	1716	Bacteria	Bacteria	514	2.8899999999999997e-141	NTclustered	gi\|2869815348\|gb\|CP175785.1\|	1979527	g77050	i0	98.299	370.585034013605	294	3	100	2	1	294	545944	546235	Corynebacterium kefirresidentii strain YSMAA1_2_B7 chromosome, complete genome	blastn	108952	514	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
22718057	22718057	PRJNA1175041_P_NODE_99958_length_246_cov_0.878613_g97090_i0	PRJNA1175041	99958	246	0.878613	2.16138798	Corynebacterium	1716	Bacteria	Bacteria	416	6.839999999999999e-112	NTclustered	gi\|2537331151\|gb\|CP047655.1\|	2026255	g97090	i0	97.154	4.00813008130081	246	7	100	0	1	246	17556	17311	Corynebacterium hadale strain DSM 105365 chromosome, complete genome	blastn	986	416	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium hadale

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