metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA407886" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA407886" 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
1082611	1082611	PRJNA407886_P_NODE_77321_length_244_cov_3.514620_g75627_i0	PRJNA407886	77321	244	3.51462	8.5756728	Lentilactobacillus	2767893	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2438966276\|gb\|CP110846.1\|	1581	g75627	i0	100	0.688524590163934	28	0	11	0	129	156	2114477	2114504	Lentilactobacillus buchneri strain Egmn17 chromosome	blastn	168	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lentilactobacillus	Lentilactobacillus buchneri
2968897	2968897	PRJNA407886_P_NODE_79463_length_243_cov_0.905882_g77769_i0	PRJNA407886	79463	243	0.905882	2.20129326	[Ruminococcus] torques	33039	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|291548560\|emb\|FP929055.1\|	657313	g77769	i0	99.588	2	243	1	100	0	1	243	796390	796632	Ruminococcus torques L2-14 draft genome	blastn	486	444	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Mediterraneibacter	[Ruminococcus] torques
3633461	3633461	PRJNA407886_P_NODE_74763_length_247_cov_0.885057_g73069_i0	PRJNA407886	74763	247	0.885057	2.18609079	Streptococcus	1301	Bacteria	Bacteria	448	2.4399999999999993e-121	NTclustered	gi\|2179901676\|gb\|CP046524.1\|	1303	g73069	i0	100	97.9797570850202	242	0	98	0	6	247	1378005	1378246	Streptococcus oralis strain SOT chromosome, complete genome	blastn	24201	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
8071402	8071402	PRJNA407886_P_NODE_77247_length_245_cov_0.895349_g75553_i0	PRJNA407886	77247	245	0.895349	2.19360505	Lactobacillus crispatus	47770	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1543693276\|gb\|CP026503.1\|	47770	g75553	i0	100	413.020408163265	245	0	100	0	1	245	77433	77189	Lactobacillus crispatus strain AB70 chromosome, complete genome	blastn	101190	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
8734831	8734831	PRJNA407886_P_NODE_27127_length_449_cov_2.244681_g25434_i0	PRJNA407886	27127	449	2.244681	10.07861769	Gemella	1378	Bacteria	Bacteria	819	0	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g25434	i0	99.555	833.69710467706	449	2	100	0	1	449	10536	10088	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	374330	819	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
8735361	8735361	PRJNA407886_P_NODE_70247_length_251_cov_0.865169_g68553_i0	PRJNA407886	70247	251	0.865169	2.17157419	Staphylococcus	1279	Bacteria	Bacteria	60.2	1.36e-4	NTclustered	gi\|1844054309\|gb\|CP053477.1\|	1292	g68553	i0	100	0.382470119521912	32	0	13	0	70	101	1300853	1300822	Staphylococcus warneri strain WB224 chromosome, complete genome	blastn	96	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
9346166	9346166	PRJNA407886_P_NODE_74588_length_247_cov_0.885057_g72894_i0	PRJNA407886	74588	247	0.885057	2.18609079	Staphylococcus hominis	1290	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|2669659999\|gb\|CP090011.1\|	1290	g72894	i0	99.595	25.9676113360324	247	1	100	0	1	247	976597	976351	Staphylococcus hominis strain acrlg chromosome, complete genome	blastn	6414	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
10010541	10010541	PRJNA407886_P_NODE_64128_length_263_cov_3.926316_g62434_i0	PRJNA407886	64128	263	3.926316	10.32621108	Staphylococcus	1279	Bacteria	Bacteria	481	2.58e-131	NTclustered	gi\|2521904872\|gb\|CP127705.1\|	1280	g62434	i0	99.62	551.368821292776	263	1	100	0	1	263	2019987	2019725	Staphylococcus aureus strain C351 chromosome, complete genome	blastn	145010	481	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
11285805	11285805	PRJNA407886_P_NODE_66129_length_259_cov_1.387097_g64435_i0	PRJNA407886	66129	259	1.387097	3.59258123	Peptostreptococcales	3082720	Bacteria	Bacteria	241	4.690000000000001e-59	NTclustered	gi\|2513816600\|gb\|CP126462.1\|	166485	g64435	i0	85.02	441.737451737452	247	26	96	10	12	253	484759	484999	Caminicella sporogenes strain HV-G chromosome, complete genome	blastn	114410	241	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Caminicellaceae	Caminicella	Caminicella sporogenes
11896800	11896800	PRJNA407886_P_NODE_67970_length_255_cov_1.142857_g66276_i0	PRJNA407886	67970	255	1.142857	2.91428535	Leuconostoc carnosum	1252	Bacteria	Bacteria	134	8.040000000000001e-27	NTclustered	gi\|1721181998\|gb\|CP042376.1\|	1252	g66276	i0	77.007	19.6274509803922	274	37	100	12	1	255	6135	5869	Leuconostoc carnosum strain CBA3620 plasmid unnamed2, complete sequence	blastn	5005	134	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc carnosum
13171647	13171647	PRJNA407886_P_NODE_66771_length_257_cov_2.282609_g65077_i0	PRJNA407886	66771	257	2.282609	5.86630513	Staphylococcus epidermidis	1282	Bacteria	Bacteria	470	5.45e-128	NTclustered	gi\|2489625674\|gb\|CP121231.1\|	1282	g65077	i0	99.611	100	257	1	100	0	1	257	1710427	1710683	Staphylococcus epidermidis strain 9 chromosome	blastn	25700	470	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
13835721	13835721	PRJNA407886_P_NODE_46051_length_319_cov_1.650407_g44357_i0	PRJNA407886	46051	319	1.650407	5.26479833	Companilactobacillus	2767879	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|2781060683\|gb\|CP162899.1\|	1612	g44357	i0	100	0.526645768025078	28	0	9	0	94	121	2060484	2060457	Companilactobacillus farciminis strain YLR-1 chromosome, complete genome	blastn	168	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Companilactobacillus	Companilactobacillus farciminis
14446878	14446878	PRJNA407886_P_NODE_69972_length_251_cov_0.865169_g68278_i0	PRJNA407886	69972	251	0.865169	2.17157419	Staphylococcus hominis	1290	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2669659999\|gb\|CP090011.1\|	1290	g68278	i0	100	26.1195219123506	251	0	100	0	1	251	985327	985077	Staphylococcus hominis strain acrlg chromosome, complete genome	blastn	6556	464	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
15720732	15720732	PRJNA407886_P_NODE_73593_length_248_cov_0.880000_g71899_i0	PRJNA407886	73593	248	0.88	2.1824	Lactobacillus crispatus	47770	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g71899	i0	99.597	68.4556451612903	248	1	100	0	1	248	477043	477290	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	16977	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
16995118	16995118	PRJNA407886_P_NODE_52514_length_296_cov_1.197309_g50820_i0	PRJNA407886	52514	296	1.197309	3.54403464	Peptostreptococcaceae bacterium oral taxon E45	713027	Bacteria	Bacteria	536	6.2199999999999986e-148	NTclustered	gi\|285205304\|gb\|GU431233.1\|	713027	g50820	i0	99.324	107.993243243243	296	2	100	0	1	296	298	3	Peptostreptococcaceae bacterium oral taxon E45 clone JS010 16S ribosomal RNA gene, partial sequence	blastn	31966	536	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae		Peptostreptococcaceae bacterium oral taxon E45
17659614	17659614	PRJNA407886_P_NODE_30554_length_413_cov_1.267647_g28860_i0	PRJNA407886	30554	413	1.267647	5.23538211	Clostridium	1485	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|1095307724\|gb\|CP013019.1\|	1501	g28860	i0	96.875	0.387409200968523	32	1	8	0	23	54	2219981	2219950	Clostridium pasteurianum strain M150B chromosome, complete genome	blastn	160	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium pasteurianum
19543974	19543974	PRJNA407886_P_NODE_81436_length_241_cov_0.916667_g79742_i0	PRJNA407886	81436	241	0.916667	2.20916747	Streptococcus parasuis	1501662	Bacteria	Bacteria	228	3.3599999999999994e-55	NTclustered	gi\|2830875037\|gb\|CP170760.1\|	1501662	g79742	i0	99.213	52.356846473029	127	0	99	1	1	127	169658	169533	Streptococcus parasuis strain FZ2 chromosome, complete genome	blastn	12618	228	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus parasuis
19543982	19543982	PRJNA407886_P_NODE_81856_length_241_cov_0.916667_g80162_i0	PRJNA407886	81856	241	0.916667	2.20916747	Staphylococcus capitis	29388	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|2770657928\|gb\|CP145242.1\|	72758	g80162	i0	100	1.67219917012448	241	0	100	0	1	241	2238	1998	Staphylococcus capitis subsp. capitis strain Sc1365673 plasmid pSc1365673_1, complete sequence	blastn	403	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
20819823	20819823	PRJNA407886_P_NODE_78977_length_243_cov_0.905882_g77283_i0	PRJNA407886	78977	243	0.905882	2.20129326	Brevibacillus choshinensis	54911	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1976386733\|gb\|CP069127.1\|	54911	g77283	i0	100	0.11522633744856	28	0	12	0	216	243	4575907	4575880	Brevibacillus choshinensis strain HPD31-SP3 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus choshinensis
24644255	24644255	PRJNA407886_P_NODE_66180_length_259_cov_1.241935_g64486_i0	PRJNA407886	66180	259	1.241935	3.21661165	Chakrabartyella piscis	2918914	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2509460602\|gb\|CP092441.1\|	2918914	g64486	i0	100	0.108108108108108	28	0	11	0	232	259	610963	610936	Chakrabartyella piscis strain BP5G chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Chakrabartyella	Chakrabartyella piscis
24644332	24644332	PRJNA407886_P_NODE_70260_length_251_cov_0.865169_g68566_i0	PRJNA407886	70260	251	0.865169	2.17157419	Staphylococcus hominis	1290	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2663184963\|gb\|CP142855.1\|	1290	g68566	i0	100	31.6693227091633	251	0	100	0	1	251	671034	670784	Staphylococcus hominis strain Sh8213 chromosome, complete genome	blastn	7949	464	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis

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