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

24 rows where analysis = "blastn", bioproject = "PRJNA280983" 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
371636	371636	PRJNA280983_P_NODE_10841_length_163_cov_0.894737_g10726_i0	PRJNA280983	10841	163	0.894737	1.45842131	Staphylococcus massiliensis	555791	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|2831308571\|gb\|CP171119.1\|	555791	g10726	i0	100	101.122699386503	163	0	100	0	1	163	335424	335586	Staphylococcus massiliensis strain WGS1515 chromosome, complete genome	blastn	16483	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus massiliensis
2334206	2334206	PRJNA280983_P_NODE_8062_length_197_cov_1.202703_g7947_i0	PRJNA280983	8062	197	1.202703	2.36932491	Streptococcus	1301	Bacteria	Bacteria	353	4.18e-93	NTclustered	gi\|2179903814\|gb\|CP046525.1\|	68892	g7947	i0	98.985	327.832487309645	197	2	100	0	1	197	141199	141003	Streptococcus infantis strain SO chromosome, complete genome	blastn	64583	353	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus infantis
4198761	4198761	PRJNA280983_P_NODE_304_length_1254_cov_4.695436_g250_i0	PRJNA280983	304	1254	4.695436	58.88076744	Clostridium sporogenes	1509	Bacteria	Bacteria	483	3.83e-131	NTclustered	gi\|1321416001\|gb\|CP013700.1\|	1509	g250	i0	76.195	5.71371610845295	983	194	77	36	2	961	59026	59991	Clostridium sporogenes strain AM1195 plasmid pRSJ11_1, complete sequence	blastn	7165	483	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sporogenes
4198780	4198780	PRJNA280983_P_NODE_7164_length_217_cov_1.517857_g7049_i0	PRJNA280983	7164	217	1.517857	3.29374969	Dolosigranulum pigrum	29394	Bacteria	Bacteria	302	1.72e-77	NTclustered	gi\|2020681836\|gb\|CP040413.1\|	29394	g7049	i0	91.705	479.428571428571	217	18	100	0	1	217	426804	427020	Dolosigranulum pigrum strain KPL3246 chromosome, complete genome	blastn	104036	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum
6161786	6161786	PRJNA280983_P_NODE_10605_length_164_cov_0.886957_g10490_i0	PRJNA280983	10605	164	0.886957	1.45460948	Staphylococcus	1279	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g10490	i0	100	42	164	0	100	0	1	164	667601	667764	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	6888	303	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
6749325	6749325	PRJNA280983_P_NODE_10586_length_164_cov_0.886957_g10471_i0	PRJNA280983	10586	164	0.886957	1.45460948	Agathobacter rectalis	39491	Bacteria	Bacteria	298	1.59e-76	NTclustered	gi\|2669501798\|gb\|CP143947.1\|	39491	g10471	i0	99.39	7	164	1	100	0	1	164	914753	914916	Agathobacter rectalis strain DFI.5.28 chromosome, complete genome	blastn	1148	298	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Agathobacter	Agathobacter rectalis
7436885	7436885	PRJNA280983_P_NODE_10046_length_166_cov_0.871795_g9931_i0	PRJNA280983	10046	166	0.871795	1.4471797	Exiguobacterium	33986	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|2274429004\|gb\|CP101462.1\|	33987	g9931	i0	100	800.39156626506	166	0	100	0	1	166	13363	13528	Exiguobacterium aurantiacum strain CX2 chromosome, complete genome	blastn	132865	307	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium aurantiacum
7436888	7436888	PRJNA280983_P_NODE_11406_length_161_cov_0.910714_g11291_i0	PRJNA280983	11406	161	0.910714	1.46624954	Bacillus	1386	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|2582827010\|gb\|CP135060.1\|	1396	g11291	i0	100	100	161	0	100	0	1	161	4674297	4674137	Bacillus cereus strain B126_1 chromosome, complete genome	blastn	16100	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
8024921	8024921	PRJNA280983_P_NODE_10587_length_164_cov_0.886957_g10472_i0	PRJNA280983	10587	164	0.886957	1.45460948	Amygdalobacter indicium	3029272	Bacteria	Bacteria	300	4.43e-77	NTclustered	gi\|2452648414\|gb\|CP118866.1\|	3029272	g10472	i0	100	1.97560975609756	162	0	99	0	1	162	508831	508670	Amygdalobacter indicium strain UPII 610-J, complete sequence	blastn	324	300	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Amygdalobacter	Amygdalobacter indicium
8711626	8711626	PRJNA280983_P_NODE_387_length_1153_cov_4.404891_g326_i0	PRJNA280983	387	1153	4.404891	50.78839323	Bacillus	1386	Bacteria	Bacteria	296	4.92e-75	NTclustered	gi\|2216093746\|gb\|CP015257.1\|	1890302	g326	i0	73.168	80.0147441457069	928	207	79	37	30	936	4597724	4598630	Bacillus wiedmannii strain Bt18679 chromosome, complete genome	blastn	92257	296	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus wiedmannii
8711632	8711632	PRJNA280983_P_NODE_5107_length_281_cov_4.418103_g4992_i0	PRJNA280983	5107	281	4.418103	12.41486943	Streptococcus	1301	Bacteria	Bacteria	520	5.909999999999999e-143	NTclustered	gi\|1943211519\|gb\|CP065707.1\|	1303	g4992	i0	100	316	281	0	100	0	1	281	424267	423987	Streptococcus oralis strain FDAARGOS_885 chromosome, complete genome	blastn	88796	520	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
9987082	9987082	PRJNA280983_P_NODE_2808_length_416_cov_2.713896_g2693_i0	PRJNA280983	2808	416	2.713896	11.28980736	Turicibacter	191303	Bacteria	Bacteria	279	1.6900000000000002e-70	NTclustered	gi\|984737891\|gb\|CP013476.1\|	1712675	g2693	i0	80.902	605.353365384615	377	53	89	13	22	390	954868	955233	Turicibacter sp. H121 chromosome, complete genome	blastn	251827	279	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Turicibacteraceae	Turicibacter	Turicibacter sp. H121
9987094	9987094	PRJNA280983_P_NODE_5828_length_255_cov_1.237864_g5713_i0	PRJNA280983	5828	255	1.237864	3.1565532	Bacteria	2	Bacteria	Bacteria	80.5	1.06e-10	NTclustered	gi\|1710409573\|gb\|CP036259.1\|	2377	g5713	i0	88.06	1.69411764705882	67	8	26	0	1	67	1239068	1239002	Sporomusa termitida strain DSM 4440 chromosome, complete genome	blastn	432	80.5	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Sporomusaceae	Sporomusa	Sporomusa termitida
10575623	10575623	PRJNA280983_P_NODE_7529_length_208_cov_1.679245_g7414_i0	PRJNA280983	7529	208	1.679245	3.4928296	Gemella sanguinis	84135	Bacteria	Bacteria	359	9.59e-95	NTclustered	gi\|1780450472\|gb\|CP046313.1\|	84135	g7414	i0	98.058	455.043269230769	206	4	99	0	1	206	518026	517821	Gemella sanguinis strain FDAARGOS_742 chromosome, complete genome	blastn	94649	359	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella sanguinis
12537480	12537480	PRJNA280983_P_NODE_11350_length_161_cov_0.910714_g11235_i0	PRJNA280983	11350	161	0.910714	1.46624954	Streptococcus	1301	Bacteria	Bacteria	285	1.2099999999999998e-72	NTclustered	gi\|2197967995\|gb\|CP031970.1\|	1307	g11235	i0	98.75	394.534161490683	160	2	99	0	2	161	18865	19024	Streptococcus suis strain SFJ44 chromosome, complete genome	blastn	63520	285	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus suis
13812359	13812359	PRJNA280983_P_NODE_7411_length_211_cov_1.259259_g7296_i0	PRJNA280983	7411	211	1.259259	2.65703649	Clostridium	1485	Bacteria	Bacteria	159	1.0599999999999999e-34	NTclustered	gi\|1370553329\|gb\|CP027777.1\|	1491	g7296	i0	80.383	49.7772511848341	209	41	99	0	3	211	317728	317936	Clostridium botulinum strain Mfbjulcb8 chromosome, complete genome	blastn	10503	159	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
16949057	16949057	PRJNA280983_P_NODE_9934_length_167_cov_0.864407_g9819_i0	PRJNA280983	9934	167	0.864407	1.44355969	Lachnoanaerobaculum gingivalis	2490855	Bacteria	Bacteria	220	3.63e-53	NTclustered	gi\|2504688929\|gb\|CP124777.1\|	2490855	g9819	i0	90.419	1	167	16	100	0	1	167	1093704	1093870	Lachnoanaerobaculum gingivalis strain SHL-20230108WGSARO1-L360107582 chromosome, complete genome	blastn	167	220	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lachnoanaerobaculum	Lachnoanaerobaculum gingivalis
17636594	17636594	PRJNA280983_P_NODE_11194_length_162_cov_0.902655_g11079_i0	PRJNA280983	11194	162	0.902655	1.4623011	Streptococcus	1301	Bacteria	Bacteria	206	9.78e-49	NTclustered	gi\|2179901676\|gb\|CP046524.1\|	1303	g11079	i0	89.506	6.85185185185185	162	17	100	0	1	162	1708645	1708806	Streptococcus oralis strain SOT chromosome, complete genome	blastn	1110	206	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
17636595	17636595	PRJNA280983_P_NODE_11554_length_153_cov_3.019231_g11439_i0	PRJNA280983	11554	153	3.019231	4.61942343	Aerococcus	1375	Bacteria	Bacteria	248	1.49e-61	NTclustered	gi\|984726517\|gb\|CP014164.1\|	1377	g11439	i0	96.078	561.150326797386	153	5	100	1	1	153	19014	18863	Aerococcus viridans strain CCUG4311, complete genome	blastn	85856	248	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Aerococcus	Aerococcus viridans
18910389	18910389	PRJNA280983_P_NODE_10675_length_164_cov_0.886957_g10560_i0	PRJNA280983	10675	164	0.886957	1.45460948	Clostridium	1485	Bacteria	Bacteria	298	1.59e-76	NTclustered	gi\|2860212306\|gb\|CP174103.1\|	1538	g10560	i0	100	8.83536585365854	161	0	98	0	3	163	1282710	1282550	Mutant Clostridium ljungdahlii isolate delaor1, complete genome	blastn	1449	298	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium ljungdahlii
18910409	18910409	PRJNA280983_P_NODE_8695_length_185_cov_2.044118_g8580_i0	PRJNA280983	8695	185	2.044118	3.7816183	Staphylococcus	1279	Bacteria	Bacteria	342	8.369999999999999e-90	NTclustered	gi\|2831308571\|gb\|CP171119.1\|	555791	g8580	i0	100	468.945945945946	185	0	100	0	1	185	279759	279575	Staphylococcus massiliensis strain WGS1515 chromosome, complete genome	blastn	86755	342	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus massiliensis
19497597	19497597	PRJNA280983_P_NODE_7156_length_217_cov_2.315476_g7041_i0	PRJNA280983	7156	217	2.315476	5.02458292	Paenibacillus konkukensis	2020716	Bacteria	Bacteria	119	1.86e-22	NTclustered	gi\|2242672127\|gb\|CP027059.1\|	2020716	g7041	i0	82.979	65.1013824884793	141	14	63	9	1	137	5149608	5149742	Paenibacillus konkukensis strain SK3146 chromosome	blastn	14127	119	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus konkukensis
21460713	21460713	PRJNA280983_P_NODE_9737_length_167_cov_1.855932_g9622_i0	PRJNA280983	9737	167	1.855932	3.09940644	Streptococcus	1301	Bacteria	Bacteria	307	2.71e-79	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g9622	i0	100	326.035928143713	166	0	99	0	2	167	1569873	1570038	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	54448	307	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
23323710	23323710	PRJNA280983_P_NODE_6619_length_232_cov_0.912568_g6504_i0	PRJNA280983	6619	232	0.912568	2.11715776	Bacillus cereus	1396	Bacteria	Bacteria	383	6.48e-102	NTclustered	gi\|1782786424\|gb\|CP046511.1\|	1396	g6504	i0	96.537	1224.93534482759	231	8	100	0	1	231	401513	401743	Bacillus cereus strain JHU chromosome, complete genome	blastn	284185	383	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus

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