metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA1008624" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA1008624" 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
154432	154432	PRJNA1008624_P_NODE_30321_length_167_cov_0.881356_g30133_i0	PRJNA1008624	30321	167	0.881356	1.47186452	Christensenella sp. MSJ-20	2841518	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2054240447\|gb\|CP076563.1\|	2841518	g30133	i0	100	0.167664670658683	28	0	17	0	72	99	619915	619942	Christensenella sp. MSJ-20 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Christensenellales	Christensenellaceae	Christensenella	Christensenella sp. MSJ-20
1429175	1429175	PRJNA1008624_P_NODE_29622_length_167_cov_0.881356_g29434_i0	PRJNA1008624	29622	167	0.881356	1.47186452	Lysinibacillus sp. GJ-1	2896845	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2164218338\|gb\|CP088912.1\|	2896845	g29434	i0	100	0.167664670658683	28	0	17	0	12	39	1411399	1411372	Lysinibacillus sp. GJ-1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus sp. GJ-1
3980965	3980965	PRJNA1008624_P_NODE_36964_length_162_cov_0.920354_g36776_i0	PRJNA1008624	36964	162	0.920354	1.49097348	Bacillus mycoides	1405	Bacteria	Bacteria	285	1.2199999999999998e-72	NTclustered	gi\|2559808127\|gb\|CP131924.1\|	1405	g36776	i0	98.75	11.0679012345679	160	2	99	0	3	162	1209653	1209812	Bacillus mycoides strain PAMC 29627 chromosome, complete genome	blastn	1793	285	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
5257222	5257222	PRJNA1008624_P_NODE_25545_length_173_cov_1.653226_g25357_i0	PRJNA1008624	25545	173	1.653226	2.86008098	Bacillus mycoides	1405	Bacteria	Bacteria	259	7.98e-65	NTclustered	gi\|2070281380\|gb\|CP067053.1\|	1405	g25357	i0	94.118	60.4971098265896	170	10	98	0	1	170	4980606	4980775	Bacillus mycoides strain JAS 83/3 chromosome, complete genome	blastn	10466	259	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
7378881	7378881	PRJNA1008624_P_NODE_14506_length_221_cov_1.790698_g14318_i0	PRJNA1008624	14506	221	1.790698	3.95744258	Lactobacillus	1578	Bacteria	Bacteria	398	2.1799999999999995e-106	NTclustered	gi\|2913177562\|gb\|CP180627.1\|	47770	g14318	i0	99.543	378.14479638009	219	0	99	1	4	221	1146162	1145944	Lactobacillus crispatus strain T31e chromosome, complete genome	blastn	83570	398	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
8654506	8654506	PRJNA1008624_P_NODE_6287_length_335_cov_3.202797_g6099_i0	PRJNA1008624	6287	335	3.202797	10.72936995	Streptococcus	1301	Bacteria	Bacteria	608	1.489999999999999e-169	NTclustered	gi\|1686100215\|gb\|MK330563.1\|	45634	g6099	i0	99.699	323.465671641791	332	1	99	0	1	332	2125	1794	Streptococcus cristatus strain 3965_07 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	108361	614	0.990228013029316	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus cristatus
11204639	11204639	PRJNA1008624_P_NODE_23509_length_180_cov_1.190840_g23321_i0	PRJNA1008624	23509	180	1.19084	2.143512	Lactobacillus	1578	Bacteria	Bacteria	320	3.79e-83	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g23321	i0	99.435	419.883333333333	177	0	98	1	4	180	90619	90794	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	75579	320	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
11633090	11633090	PRJNA1008624_P_NODE_3450_length_463_cov_9.202899_g3264_i0	PRJNA1008624	3450	463	9.202899	42.60942237	Bulleidia sp. 10714-15	3241172	Bacteria	Bacteria	69.4	4.46e-7	NTclustered	gi\|2793725965\|dbj\|AP036017.1\|	3241172	g3264	i0	81.818	2.99352051835853	88	11	18	5	245	329	140452	140367	Bulleidia sp. 10714-15 DNA, complete genome	blastn	1386	69.4	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Bulleidia	Bulleidia sp. 10714-15
15029073	15029073	PRJNA1008624_P_NODE_13072_length_232_cov_1.284153_g12884_i0	PRJNA1008624	13072	232	1.284153	2.97923496	Veillonella	29465	Bacteria	Bacteria	305	1.44e-78	NTclustered	gi\|1540028531\|emb\|LR134375.1\|	39778	g12884	i0	93.301	581.913793103448	209	10	90	4	25	232	500332	500127	Veillonella dispar strain NCTC11831 genome assembly, chromosome: 1	blastn	135004	305	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella dispar
15029095	15029095	PRJNA1008624_P_NODE_22432_length_183_cov_2.805970_g22244_i0	PRJNA1008624	22432	183	2.80597	5.1349251	Enterococcus	1350	Bacteria	Bacteria	331	1.79e-86	NTclustered	gi\|1700446164\|emb\|LR607359.1\|	1351	g22244	i0	100	550.366120218579	179	0	98	0	1	179	2808964	2808786	Enterococcus faecalis strain 4928STDY7071765 genome assembly, chromosome: 1	blastn	100717	333	0.993993993993994	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
15029117	15029117	PRJNA1008624_P_NODE_36452_length_162_cov_0.920354_g36264_i0	PRJNA1008624	36452	162	0.920354	1.49097348	Geobacillus	129337	Bacteria	Bacteria	268	1.23e-67	NTclustered	gi\|2529062746\|gb\|CP128458.1\|	1422	g36264	i0	97.452	12.5987654320988	157	4	97	0	5	161	3625471	3625315	Geobacillus stearothermophilus strain EF60133 chromosome, complete genome	blastn	2041	268	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	Geobacillus stearothermophilus
15029119	15029119	PRJNA1008624_P_NODE_3792_length_440_cov_3.373402_g3606_i0	PRJNA1008624	3792	440	3.373402	14.8429688	Streptococcus	1301	Bacteria	Bacteria	797	0	NTclustered	gi\|2246565702\|gb\|CP097843.1\|	1303	g3606	i0	99.542	329.845454545455	437	2	99	0	1	437	18044	17608	Streptococcus oralis strain HP01 chromosome, complete genome	blastn	145132	802	0.993765586034913	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
15029143	15029143	PRJNA1008624_P_NODE_8532_length_286_cov_1.725738_g8344_i0	PRJNA1008624	8532	286	1.725738	4.93561068	root	1	Root_unresolved	Root_unresolved	56.5	0.002	NTclustered	gi\|2633045940\|gb\|CP132148.1\|	1496	g8344	i0	92.5	1.36713286713287	40	2	14	1	225	264	117134	117172	Clostridioides difficile strain SC084-01-01 plasmid p840101_2, complete sequence	blastn	391	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
18853033	18853033	PRJNA1008624_P_NODE_28995_length_168_cov_0.873950_g28807_i0	PRJNA1008624	28995	168	0.87395	1.468236	Ruminococcus	1263	Bacteria	Bacteria	298	1.64e-76	NTclustered	gi\|2259770547\|gb\|CP074197.1\|	2831966	g28807	i0	99.39	48.2380952380952	164	1	98	0	4	167	1660466	1660303	Ruminococcus sp. FMBCY1 chromosome, complete genome	blastn	8104	298	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp. FMBCY1
20127835	20127835	PRJNA1008624_P_NODE_9696_length_268_cov_2.977169_g9508_i0	PRJNA1008624	9696	268	2.977169	7.97881292	Anoxybacillus	150247	Bacteria	Bacteria	490	4.39e-134	NTclustered	gi\|1207877705\|gb\|CP021838.1\|	33934	g9508	i0	100	811.847014925373	265	0	99	0	1	265	2187340	2187076	Anoxybacillus flavithermus strain 52-1A chromosome, complete genome	blastn	217575	490	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus flavithermus
21403451	21403451	PRJNA1008624_P_NODE_9957_length_265_cov_1.050926_g9769_i0	PRJNA1008624	9957	265	1.050926	2.7849539	Enterococcus	1350	Bacteria	Bacteria	418	2.0699999999999994e-112	NTclustered	gi\|1913493076\|gb\|CP050490.1\|	37734	g9769	i0	95.753	438.433962264151	259	11	100	0	1	259	671449	671707	Enterococcus casseliflavus strain EGM182 chromosome, complete genome	blastn	116185	418	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
24380289	24380289	PRJNA1008624_P_NODE_24040_length_178_cov_1.496124_g23852_i0	PRJNA1008624	24040	178	1.496124	2.66310072	Streptococcus thermophilus	1308	Bacteria	Bacteria	316	4.8399999999999983e-82	NTclustered	gi\|1868745036\|emb\|LR822026.1\|	1308	g23852	i0	99.425	97.7696629213483	174	1	98	0	4	177	630411	630238	Streptococcus thermophilus isolate STH_CIRM_967 genome assembly, chromosome: STHERMO	blastn	17403	316	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus

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