metadata: contig_metadata: 20 rows where bioproject = "PRJNA575566", tax_kingdom = "Bacillati" and tax

20 rows where bioproject = "PRJNA575566", tax_kingdom = "Bacillati" 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
3111189	3111189	PRJNA575566_P_NODE_9963_length_331_cov_1.862963_g9766_i0	PRJNA575566	9963	331	1.862963	6.16640753	Hathewaya histolytica	1498	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g9766	i0	100	0.0845921450151057	28	0	8	0	43	70	1995814	1995841	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
7514629	7514629	PRJNA575566_P_NODE_30026_length_201_cov_0.914286_g29829_i0	PRJNA575566	30026	201	0.914286	1.83771486	root	1	Root_unresolved	Root_unresolved	372	1.18e-98	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g29829	i0	100	103	201	0	100	0	1	201	1572842	1572642	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	20703	372	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
8212996	8212996	PRJNA575566_P_NODE_13067_length_291_cov_0.995652_g12870_i0	PRJNA575566	13067	291	0.995652	2.89734732	Rossellomorea sedimentorum	3115294	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2872182794\|gb\|CP143546.1\|	3115294	g12870	i0	100	0.0962199312714777	28	0	10	0	229	256	3908371	3908398	Bacillus sp. SCS-153A chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Rossellomorea	Rossellomorea sedimentorum
8213275	8213275	PRJNA575566_P_NODE_30467_length_188_cov_2.015748_g30270_i0	PRJNA575566	30467	188	2.015748	3.78960624	Firmicutes bacterium ADurb.Bin356	1852890	Bacteria	Bacteria	102	3.02e-24	NR	OQA16478.1	1852890	g30270	i0	82.3	0.98936170212766	62	11	98.9	0	186	1	244	305	OQA16478.1 MAG: Glyceraldehyde-3-phosphate dehydrogenase A [Firmicutes bacterium ADurb.Bin356]	diamond	186	102	1	Bacteria	Bacillati	Bacillota					Firmicutes bacterium ADurb.Bin356
8789519	8789519	PRJNA575566_P_NODE_15407_length_268_cov_2.671498_g15210_i0	PRJNA575566	15407	268	2.671498	7.15961464	Streptococcus	1301	Bacteria	Bacteria	494	3.39e-135	NTclustered	gi\|1943211519\|gb\|CP065707.1\|	1303	g15210	i0	100	341.041044776119	267	0	99	0	2	268	424001	424267	Streptococcus oralis strain FDAARGOS_885 chromosome, complete genome	blastn	91399	496	0.995967741935484	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
9488307	9488307	PRJNA575566_P_NODE_15008_length_272_cov_1.213270_g14811_i0	PRJNA575566	15008	272	1.21327	3.3000944	Romboutsia sp. CE17	2724150	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|1831577921\|gb\|CP051144.1\|	2724150	g14811	i0	100	0.102941176470588	28	0	10	0	63	90	1915318	1915345	Romboutsia sp. CE17 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Romboutsia	Romboutsia sp. CE17
9488431	9488431	PRJNA575566_P_NODE_22748_length_217_cov_1.230769_g22551_i0	PRJNA575566	22748	217	1.230769	2.67076873	uncultured Clostridia bacterium	244328	Bacteria	Bacteria	126	1.11e-24	NTclustered	gi\|2729058716\|emb\|OZ007016.1\|	244328	g22551	i0	81.29	32.0967741935484	155	29	71	0	42	196	641205	641051	MAG: uncultured Clostridia bacterium isolate 6737_HOM_CTRL_s71.ctg000086c_hifiasm_circ MAG genome assembly, chromosome: 1	blastn	6965	126	1	Bacteria	Bacillati	Bacillota	Clostridia				uncultured Clostridia bacterium
10764251	10764251	PRJNA575566_P_NODE_17569_length_251_cov_1.347368_g17372_i0	PRJNA575566	17569	251	1.347368	3.38189368	Ligilactobacillus salivarius	1624	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2276881336\|gb\|CP101530.1\|	1624	g17372	i0	100	0.111553784860558	28	0	11	0	91	118	525665	525638	Ligilactobacillus salivarius strain SNK-6 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus salivarius
12039222	12039222	PRJNA575566_P_NODE_26370_length_206_cov_0.882759_g26173_i0	PRJNA575566	26370	206	0.882759	1.81848354	Streptococcus sp. FSL K6-1323	2954513	Bacteria	Bacteria	381	2.0199999999999994e-101	NTclustered	gi\|2723658837\|gb\|CP152039.1\|	2954513	g26173	i0	100	99.868932038835	206	0	100	0	1	206	2009385	2009180	Streptococcus sp. FSL K6-1323 chromosome, complete genome	blastn	20573	381	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. FSL K6-1323
14588988	14588988	PRJNA575566_P_NODE_27992_length_204_cov_0.895105_g27795_i0	PRJNA575566	27992	204	0.895105	1.8260142	Streptococcus sp. FDAARGOS_192	1839799	Bacteria	Bacteria	326	9.5e-85	NTclustered	gi\|1352481846\|gb\|CP020429.2\|	1839799	g27795	i0	96.447	13.828431372549	197	7	99	0	8	204	19199	19003	Streptococcus sp. FDAARGOS_192 plasmid unnamed1, complete sequence	blastn	2821	326	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. FDAARGOS_192
16439433	16439433	PRJNA575566_P_NODE_4273_length_505_cov_2.981982_g4076_i0	PRJNA575566	4273	505	2.981982	15.0590091	root	1	Root_unresolved	Root_unresolved	771	0	NTclustered	gi\|407866\|emb\|Z26888.1\|	29378	g4076	i0	94.314	124.205940594059	510	18	100	8	1	505	9	512	S.arlettae gene for 16S ribosomal RNA	blastn	62724	771	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus arlettae
17714650	17714650	PRJNA575566_P_NODE_21474_length_225_cov_1.676829_g21277_i0	PRJNA575566	21474	225	1.676829	3.77286525	Bacillaceae	186817	Bacteria	Bacteria	385	1.74e-102	NTclustered	gi\|2511289955\|gb\|CP126088.1\|	86664	g21277	i0	97.768	799.622222222222	224	4	99	1	1	224	11308	11530	Priestia flexa strain CCW CN82 chromosome, complete genome	blastn	179915	385	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia flexa
20962306	20962306	PRJNA575566_P_NODE_25517_length_207_cov_0.876712_g25320_i0	PRJNA575566	25517	207	0.876712	1.81479384	Limosilactobacillus mucosae	97478	Bacteria	Bacteria	350	5.74e-92	NTclustered	gi\|1874469609\|gb\|CP058954.1\|	97478	g25320	i0	97.101	6.14975845410628	207	6	100	0	1	207	1459042	1459248	Limosilactobacillus mucosae strain A1 chromosome, complete genome	blastn	1273	350	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Limosilactobacillus	Limosilactobacillus mucosae
24088718	24088718	PRJNA575566_P_NODE_25219_length_208_cov_0.870748_g25022_i0	PRJNA575566	25219	208	0.870748	1.81115584	Exiguobacterium	33986	Bacteria	Bacteria	381	2.0499999999999995e-101	NTclustered	gi\|2844360308\|gb\|CP172296.1\|	340146	g25022	i0	100	724.322115384615	206	0	99	0	1	206	39785	39580	Exiguobacterium mexicanum strain MM chromosome, complete genome	blastn	150659	381	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium mexicanum
25362979	25362979	PRJNA575566_P_NODE_11820_length_305_cov_1.184426_g11623_i0	PRJNA575566	11820	305	1.184426	3.6124993	Exiguobacterium	33986	Bacteria	Bacteria	542	1.38e-149	NTclustered	gi\|2274429004\|gb\|CP101462.1\|	33987	g11623	i0	98.689	743.039344262295	305	4	100	0	1	305	12924	13228	Exiguobacterium aurantiacum strain CX2 chromosome, complete genome	blastn	226627	542	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium aurantiacum
26921340	26921340	PRJNA575566_P_NODE_28522_length_203_cov_0.901408_g28325_i0	PRJNA575566	28522	203	0.901408	1.82985824	Clostridium lundense	319475	Bacteria	Bacteria	72.8	5.57e-13	NR	WP_027623033.1	319475	g28325	i0	48.5	2.89655172413793	66	34	97.5	0	203	6	378	443	WP_027623033.1 pyridoxal phosphate-dependent decarboxylase family protein [Clostridium lundense]	diamond	588	72.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium lundense
28311363	28311363	PRJNA575566_P_NODE_28186_length_203_cov_1.352113_g27989_i0	PRJNA575566	28186	203	1.352113	2.74478939	Lachnospira sp.	2049031	Bacteria	Bacteria	46.2	0.00132	NR	MCI8426399.1	2049031	g27989	i0	34.4	3.59113300492611	64	35	94.6	1	12	203	550	606	MCI8426399.1 DNA internalization-related competence protein ComEC/Rec2 [Lachnospira sp.]	diamond	729	46.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lachnospira	Lachnospira sp.
29858307	29858307	PRJNA575566_P_NODE_21471_length_225_cov_1.853659_g21274_i0	PRJNA575566	21471	225	1.853659	4.17073275	Clostridia bacterium	2044939	Bacteria	Bacteria	47.4	7.14e-4	NR	MBQ7391938.1	2044939	g21274	i0	43.1	0.68	51	27	65.3	1	7	153	388	438	MBQ7391938.1 InlB B-repeat-containing protein [Clostridia bacterium]	diamond	153	47.4	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
31090590	31090590	PRJNA575566_P_NODE_23735_length_211_cov_1.280000_g23538_i0	PRJNA575566	23735	211	1.28	2.7008	Bacillus kwashiorkori	1522318	Bacteria	Bacteria	95.1	4.41e-21	NR	WP_062350715.1	1522318	g23538	i0	62.3	1.97630331753555	69	26	98.1	0	207	1	91	159	WP_062350715.1 FAD/NAD(P)-binding oxidoreductase [Bacillus kwashiorkori]	diamond	417	95.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus kwashiorkori
31578567	31578567	PRJNA575566_P_NODE_13836_length_283_cov_1.153153_g13639_i0	PRJNA575566	13836	283	1.153153	3.26342299	Bacilli	91061	Bacteria	Bacteria	77	3.24e-14	NR	MCA9766345.1	48221	g13639	i0	44.8	11.1519434628975	96	47	99.6	3	282	1	92	183	MCA9766345.1 inositol 2-dehydrogenase [Carnobacterium sp.]	diamond	3156	77.4	0.994832041343669	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium sp.

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