metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA608894" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA608894" 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
585764	585764	PRJNA608894_P_NODE_55761_length_245_cov_0.895349_g55262_i0	PRJNA608894	55761	245	0.895349	2.19360505	Staphylococcus epidermidis	1282	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1214725545\|gb\|CP022247.1\|	1282	g55262	i0	100	99.9755102040816	245	0	100	0	1	245	629910	629666	Staphylococcus epidermidis strain AMT chromosome, complete genome	blastn	24494	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
585787	585787	PRJNA608894_P_NODE_57201_length_244_cov_0.900585_g56702_i0	PRJNA608894	57201	244	0.900585	2.1974274	Gemella haemolysans	1379	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g56702	i0	99.59	509.639344262295	244	1	100	0	1	244	11060	10817	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	124352	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
2422343	2422343	PRJNA608894_P_NODE_38122_length_290_cov_1.488479_g37623_i0	PRJNA608894	38122	290	1.488479	4.3165891	Anaerococcus	165779	Bacteria	Bacteria	508	1.33e-139	NTclustered	gi\|1948596785\|gb\|CP066014.1\|	33037	g37623	i0	98.276	493.88275862069	290	5	100	0	1	290	181559	181270	Anaerococcus vaginalis strain FDAARGOS_988 chromosome, complete genome	blastn	143226	508	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus vaginalis
3698697	3698697	PRJNA608894_P_NODE_46103_length_262_cov_1.613757_g45604_i0	PRJNA608894	46103	262	1.613757	4.22804334	Clostridium	1485	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1406179818\|gb\|CP030018.1\|	1488	g45604	i0	100	0.442748091603053	29	0	11	0	205	233	369885	369913	Clostridium acetobutylicum strain LJ4 chromosome	blastn	116	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium acetobutylicum
3698755	3698755	PRJNA608894_P_NODE_60163_length_241_cov_0.916667_g59664_i0	PRJNA608894	60163	241	0.916667	2.20916747	Staphylococcus	1279	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|2669659999\|gb\|CP090011.1\|	1290	g59664	i0	100	97.4730290456432	241	0	100	0	1	241	1346473	1346713	Staphylococcus hominis strain acrlg chromosome, complete genome	blastn	23491	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
4412993	4412993	PRJNA608894_P_NODE_35004_length_305_cov_5.245690_g34505_i0	PRJNA608894	35004	305	5.24569	15.9993545	Clostridiales bacterium	1898207	Bacteria	Bacteria	65.8	3.65e-6	NTclustered	gi\|2189482846\|gb\|CP091729.1\|	1898207	g34505	i0	93.333	16.1311475409836	45	2	15	1	179	223	1586362	1586319	MAG: Clostridiales bacterium isolate nC33_bin.2.fa chromosome, complete genome	blastn	4920	65.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
4413406	4413406	PRJNA608894_P_NODE_58144_length_243_cov_0.905882_g57645_i0	PRJNA608894	58144	243	0.905882	2.20129326	Limnochorda pilosa	1555112	Bacteria	Bacteria	163	9.7e-36	NTclustered	gi\|921142775\|dbj\|AP014924.1\|	1555112	g57645	i0	79.2	143.609053497942	250	40	99	10	1	241	2641857	2641611	Limnochorda pilosa DNA, complete genome, strain: HC45	blastn	34897	163	1	Bacteria	Bacillati	Bacillota	Limnochordia	Limnochordales	Limnochordaceae	Limnochorda	Limnochorda pilosa
6250799	6250799	PRJNA608894_P_NODE_39225_length_286_cov_1.427230_g38726_i0	PRJNA608894	39225	286	1.42723	4.0818778	Bacillus	1386	Bacteria	Bacteria	518	2.17e-142	NTclustered	gi\|1475349526\|gb\|CP024771.1\|	1417985	g38726	i0	99.303	99.6328671328671	287	1	100	1	1	286	3089389	3089103	Bacillus thuringiensis LM1212 chromosome, complete genome	blastn	28495	518	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
6250843	6250843	PRJNA608894_P_NODE_51325_length_250_cov_0.870056_g50826_i0	PRJNA608894	51325	250	0.870056	2.17514	Bacillus	1386	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|2263617782\|gb\|CP099801.1\|	2026186	g50826	i0	99.2	99.964	250	2	100	0	1	250	1378208	1378457	Bacillus paranthracis strain SSBC101 chromosome, complete genome	blastn	24991	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus paranthracis
8799894	8799894	PRJNA608894_P_NODE_14187_length_598_cov_2.260952_g13704_i0	PRJNA608894	14187	598	2.260952	13.52049296	Lysinibacillus	400634	Bacteria	Bacteria	989	0	NTclustered	gi\|2007734766\|gb\|CP071738.1\|	1421	g13704	i0	97.586	944.834448160535	580	9	97	5	21	598	13493	14069	Lysinibacillus sphaericus strain BS-pTAND672-2 chromosome	blastn	565011	989	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus sphaericus
13339738	13339738	PRJNA608894_P_NODE_47511_length_257_cov_10.934783_g47012_i0	PRJNA608894	47511	257	10.934783	28.10239231	Hathewaya histolytica	1498	Bacteria	Bacteria	475	1.1699999999999999e-129	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g47012	i0	100	813.420233463035	257	0	100	0	1	257	10909	10653	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	209049	475	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
13901082	13901082	PRJNA608894_P_NODE_43071_length_272_cov_1.653266_g42572_i0	PRJNA608894	43071	272	1.653266	4.49688352	Lactobacillus	1578	Bacteria	Bacteria	490	4.459999999999998e-134	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g42572	i0	99.262	95	271	2	99	0	2	272	1247792	1247522	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	25840	490	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
14614503	14614503	PRJNA608894_P_NODE_41612_length_277_cov_3.740196_g41113_i0	PRJNA608894	41612	277	3.740196	10.36034292	Lysinibacillus sp. RS11	3242682	Bacteria	Bacteria	475	1.2799999999999997e-129	NTclustered	gi\|2805666388\|gb\|CP168124.1\|	3242682	g41113	i0	97.818	1059.89891696751	275	6	99	0	3	277	4273994	4274268	Bacillus sp. RS11 chromosome, complete genome	blastn	293592	475	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus sp. RS11
15175325	15175325	PRJNA608894_P_NODE_19092_length_473_cov_2.665000_g18596_i0	PRJNA608894	19092	473	2.665	12.60545	Staphylococcus	1279	Bacteria	Bacteria	863	0	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g18596	i0	99.577	473.154334038055	473	2	100	0	1	473	708589	708117	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	223802	863	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
15175367	15175367	PRJNA608894_P_NODE_34632_length_307_cov_3.047009_g34133_i0	PRJNA608894	34632	307	3.047009	9.35431763	Lysinibacillus	400634	Bacteria	Bacteria	568	2.3e-157	NTclustered	gi\|2007734766\|gb\|CP071738.1\|	1421	g34133	i0	100	1001.85342019544	307	0	100	0	1	307	12597	12291	Lysinibacillus sphaericus strain BS-pTAND672-2 chromosome	blastn	307569	568	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus sphaericus
15888241	15888241	PRJNA608894_P_NODE_30513_length_331_cov_3.604651_g30014_i0	PRJNA608894	30513	331	3.604651	11.93139481	Hathewaya histolytica	1498	Bacteria	Bacteria	612	1.14e-170	NTclustered	gi\|3080568\|dbj\|AB013091.1\|	1498	g30014	i0	100	874.800604229607	331	0	100	0	1	331	1600	1930	Clostridium histolyticum rrlC gene for 23S rRNA, partial sequence	blastn	289559	612	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
16449755	16449755	PRJNA608894_P_NODE_25833_length_373_cov_2.693333_g25336_i0	PRJNA608894	25833	373	2.693333	10.04613209	Staphylococcus	1279	Bacteria	Bacteria	684	0	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g25336	i0	99.732	474.44235924933	373	1	100	0	1	373	750819	750447	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	176967	684	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
16449845	16449845	PRJNA608894_P_NODE_57073_length_244_cov_0.900585_g56574_i0	PRJNA608894	57073	244	0.900585	2.1974274	Staphylococcus	1279	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g56574	i0	100	42.9426229508197	244	0	100	0	1	244	833310	833067	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	10478	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
17725006	17725006	PRJNA608894_P_NODE_30774_length_329_cov_2.976562_g30275_i0	PRJNA608894	30774	329	2.976562	9.79288898	Exiguobacterium	33986	Bacteria	Bacteria	608	1.4599999999999995e-169	NTclustered	gi\|2274429004\|gb\|CP101462.1\|	33987	g30275	i0	100	711.960486322188	329	0	100	0	1	329	2340806	2340478	Exiguobacterium aurantiacum strain CX2 chromosome, complete genome	blastn	234235	608	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium aurantiacum
18998458	18998458	PRJNA608894_P_NODE_21575_length_429_cov_2.654494_g21079_i0	PRJNA608894	21575	429	2.654494	11.38777926	Finegoldia	150022	Bacteria	Bacteria	793	0	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g21079	i0	100	384.578088578089	429	0	100	0	1	429	164182	163754	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	164984	793	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
18998497	18998497	PRJNA608894_P_NODE_37395_length_293_cov_2.681818_g36896_i0	PRJNA608894	37395	293	2.681818	7.85772674	Finegoldia	150022	Bacteria	Bacteria	542	1.32e-149	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g36896	i0	100	571.150170648464	293	0	100	0	1	293	162229	161937	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	167347	542	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
20273495	20273495	PRJNA608894_P_NODE_12816_length_649_cov_3.815972_g12343_i0	PRJNA608894	12816	649	3.815972	24.76565828	Finegoldia	150022	Bacteria	Bacteria	1197	0	NTclustered	gi\|2127562652\|gb\|CP085955.1\|	1260	g12343	i0	100	350.750385208012	648	0	99	0	2	649	459177	459824	Finegoldia magna strain FDAARGOS_1557 chromosome, complete genome	blastn	227637	1197	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
20988260	20988260	PRJNA608894_P_NODE_6617_length_1116_cov_4.773730_g6242_i0	PRJNA608894	6617	1116	4.77373	53.2748268	Hathewaya histolytica	1498	Bacteria	Bacteria	2061	0	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g6242	i0	100	833.310035842294	1116	0	100	0	1	1116	11374	12489	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	929974	2061	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
21549044	21549044	PRJNA608894_P_NODE_61977_length_226_cov_2.503268_g61478_i0	PRJNA608894	61977	226	2.503268	5.65738568	Finegoldia	150022	Bacteria	Bacteria	418	1.7199999999999998e-112	NTclustered	gi\|2127562652\|gb\|CP085955.1\|	1260	g61478	i0	100	39.641592920354	226	0	100	0	1	226	461147	460922	Finegoldia magna strain FDAARGOS_1557 chromosome, complete genome	blastn	8959	418	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
22262634	22262634	PRJNA608894_P_NODE_39738_length_284_cov_1.800948_g39239_i0	PRJNA608894	39738	284	1.800948	5.11469232	Anaerococcus nagyae	1755241	Bacteria	Bacteria	525	1.2899999999999994e-144	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g39239	i0	100	1	284	0	100	0	1	284	1052947	1053230	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	284	525	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
23538231	23538231	PRJNA608894_P_NODE_54859_length_246_cov_0.890173_g54360_i0	PRJNA608894	54859	246	0.890173	2.18982558	Peptoniphilus genitalis	3036303	Bacteria	Bacteria	248	2.6399999999999997e-61	NTclustered	gi\|2246887130\|gb\|CP097885.1\|	3036303	g54360	i0	84.959	4.01219512195122	246	35	99	2	2	246	782021	781777	Peptoniphilus genitalis strain SAHP1 chromosome, complete genome	blastn	987	248	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus genitalis
24812096	24812096	PRJNA608894_P_NODE_56080_length_245_cov_0.895349_g55581_i0	PRJNA608894	56080	245	0.895349	2.19360505	Staphylococcus cohnii	29382	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1373834432\|emb\|LT963440.1\|	29382	g55581	i0	100	99.3224489795918	245	0	100	0	1	245	538045	538289	Staphylococcus cohnii isolate Staphylococcus cohnii ATCC 29974 genome assembly, chromosome: I	blastn	24334	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
24812140	24812140	PRJNA608894_P_NODE_58320_length_243_cov_0.905882_g57821_i0	PRJNA608894	58320	243	0.905882	2.20129326	Staphylococcus epidermidis	1282	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2866787960\|gb\|CP064471.1\|	1282	g57821	i0	100	38	243	0	100	0	1	243	327333	327091	Staphylococcus epidermidis strain UMCG387 chromosome, complete genome	blastn	9234	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
25373400	25373400	PRJNA608894_P_NODE_35180_length_304_cov_4.064935_g34681_i0	PRJNA608894	35180	304	4.064935	12.3574024	Finegoldia	150022	Bacteria	Bacteria	562	1.06e-155	NTclustered	gi\|2127562652\|gb\|CP085955.1\|	1260	g34681	i0	100	417.546052631579	304	0	100	0	1	304	459083	458780	Finegoldia magna strain FDAARGOS_1557 chromosome, complete genome	blastn	126934	562	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna

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