metadata: contig_metadata: 16 rows where bioproject = "PRJNA937226" and tax

16 rows where bioproject = "PRJNA937226" and tax_phylum = "Bacteroidota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1255740	1255740	PRJNA937226_S_NODE_17301_length_197_cov_1.756757_g17174_i0	PRJNA937226	17301	197	1.756757	3.46081129	Hymenobacteraceae	1853232	Bacteria	Bacteria	315	1.9699999999999998e-81	NTclustered	gi\|887498678\|gb\|CP010777.1\|	1379910	g17174	i0	95.431	279.162436548223	197	9	100	0	1	197	2692430	2692234	Rufibacter sp. DG31D, complete genome	blastn	54995	315	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Rufibacter	Rufibacter radiotolerans
8564940	8564940	PRJNA937226_S_NODE_7207_length_272_cov_1.170404_g7080_i0	PRJNA937226	7207	272	1.170404	3.18349888	Bacteroidales bacterium	2030927	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2621786220\|emb\|OY782678.1\|	2030927	g7080	i0	100	0.102941176470588	28	0	10	0	239	266	2364385	2364412	MAG: Bacteroidales bacterium isolate 1f9300ae-d6db-4a26-8fb7-1be2ee45184d genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
8908567	8908567	PRJNA937226_S_NODE_14687_length_210_cov_1.366460_g14560_i0	PRJNA937226	14687	210	1.36646	2.869566	Chryseobacterium	59732	Bacteria	Bacteria	385	1.5999999999999995e-102	NTclustered	gi\|1519580736\|gb\|CP033930.1\|	253	g14560	i0	100	521.933333333333	208	0	99	0	3	210	2943601	2943808	Chryseobacterium indologenes strain H5559 chromosome, complete genome	blastn	109606	388	0.992268041237113	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
13665462	13665462	PRJNA937226_S_NODE_14591_length_210_cov_5.291925_g14464_i0	PRJNA937226	14591	210	5.291925	11.1130425	uncultured Bacteroidales bacterium	194843	Bacteria	Bacteria	139	1.38e-28	NTclustered	gi\|2729058746\|emb\|OZ007033.1\|	194843	g14464	i0	79.904	7.60952380952381	209	27	95	11	3	201	1232584	1232787	MAG: uncultured Bacteroidales bacterium isolate metabat2_pooled_hifiasm.1162 MAG genome assembly, chromosome: 1	blastn	1598	139	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			uncultured Bacteroidales bacterium
15283701	15283701	PRJNA937226_S_NODE_28012_length_163_cov_0.912281_g27885_i0	PRJNA937226	28012	163	0.912281	1.48701803	Dysgonomonas	156973	Bacteria	Bacteria	296	5.68e-76	NTclustered	gi\|1821115267\|gb\|CP049857.1\|	2714926	g27885	i0	99.387	275.601226993865	163	1	100	0	1	163	348145	348307	Dysgonomonas sp. HDW5A chromosome, complete genome	blastn	44923	296	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Dysgonomonas	Dysgonomonas sp. HDW5A
17490252	17490252	PRJNA937226_S_NODE_8894_length_253_cov_2.725490_g8767_i0	PRJNA937226	8894	253	2.72549	6.8954897	Flavisolibacter tropicus	1492898	Bacteria	Bacteria	462	8.95e-126	NTclustered	gi\|1028466201\|gb\|CP011390.1\|	1492898	g8767	i0	99.605	259.292490118577	253	1	100	0	1	253	1744148	1743896	Flavisolibacter tropicus strain LCS9 chromosome, complete genome	blastn	65601	462	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter tropicus
18763561	18763561	PRJNA937226_S_NODE_13495_length_217_cov_1.547619_g13368_i0	PRJNA937226	13495	217	1.547619	3.35833323	Prevotella sp.	59823	Bacteria	Bacteria	152	6e-41	NR	MBD9230008.1	59823	g13368	i0	94.4	0.981566820276498	71	4	98.2	0	215	3	23	93	MBD9230008.1 DUF4982 domain-containing protein [Prevotella sp.]	diamond	213	152	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
22588890	22588890	PRJNA937226_S_NODE_14478_length_211_cov_2.296296_g14351_i0	PRJNA937226	14478	211	2.296296	4.84518456	Flavobacterium rivulicola	2732161	Bacteria	Bacteria	294	2.79e-75	NTclustered	gi\|2557550594\|gb\|CP121446.1\|	2732161	g14351	i0	92.271	618.113744075829	207	16	98	0	1	207	1110046	1109840	Flavobacterium rivulicola strain IMCC34852 chromosome, complete genome	blastn	130422	294	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium rivulicola
26961525	26961525	PRJNA937226_S_NODE_10962_length_235_cov_2.763441_g10835_i0	PRJNA937226	10962	235	2.763441	6.49408635	Prevotella sp.	59823	Bacteria	Bacteria	113	1.17e-30	NR	MBR2035444.1	59823	g10835	i0	98.4	0.778723404255319	61	1	77.9	0	53	235	1	61	MBR2035444.1 membrane protein insertase YidC [Prevotella sp.]	diamond	183	113	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
27625409	27625409	PRJNA937226_S_NODE_12584_length_223_cov_1.195402_g12457_i0	PRJNA937226	12584	223	1.195402	2.66574646	Bacteroidales bacterium	2030927	Bacteria	Bacteria	133	6.289999999999998e-35	NR	MEE1081819.1	2030927	g12457	i0	94.5	0.982062780269058	73	4	98.2	0	3	221	6	78	MEE1081819.1 hypothetical protein [Bacteroidales bacterium]	diamond	219	133	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
28484820	28484820	PRJNA937226_S_NODE_16626_length_200_cov_2.754967_g16499_i0	PRJNA937226	16626	200	2.754967	5.509934	Bacteroides	816	Bacteria	Bacteria	113	4.33e-31	NR	MBO5795928.1	29523	g16499	i0	91.4	3.48	58	5	87	0	26	199	1	58	MBO5795928.1 type II toxin-antitoxin system prevent-host-death family antitoxin [Bacteroides sp.]	diamond	696	114	0.991228070175439	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides sp.
29930405	29930405	PRJNA937226_S_NODE_3491_length_347_cov_2.268456_g3364_i0	PRJNA937226	3491	347	2.268456	7.87154232	Alistipes sp.	1872444	Bacteria	Bacteria	164	2.64e-49	NR	MBO5044251.1	1872444	g3364	i0	100	0.726224783861671	84	0	72.6	0	95	346	1	84	MBO5044251.1 nucleoside deaminase [Alistipes sp.]	diamond	252	164	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Alistipes	Alistipes sp.
29961810	29961810	PRJNA937226_S_NODE_19811_length_186_cov_2.992701_g19684_i0	PRJNA937226	19811	186	2.992701	5.56642386	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	42	0.0327	NR	MBC7875087.1	1869212	g19684	i0	41.4	0.935483870967742	58	32	93.5	2	12	185	176	231	MBC7875087.1 PspC domain-containing protein [Chitinophagaceae bacterium]	diamond	174	42	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
30663898	30663898	PRJNA937226_S_NODE_28173_length_162_cov_5.327434_g28046_i0	PRJNA937226	28173	162	5.327434	8.63044308	Bacteroidota	976	Bacteria	Bacteria	101	2.87e-26	NR	HLO81779.1	1869212	g28046	i0	86.8	1.96296296296296	53	7	98.1	0	160	2	6	58	HLO81779.1 type II toxin-antitoxin system PemK/MazF family toxin [Chitinophagaceae bacterium]	diamond	318	101	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
31605261	31605261	PRJNA937226_S_NODE_13476_length_217_cov_1.857143_g13349_i0	PRJNA937226	13476	217	1.857143	4.03000031	Bacteroidales bacterium	2030927	Bacteria	Bacteria	109	1.24e-26	NR	MBR4978503.1	2030927	g13349	i0	94.7	0.788018433179724	57	3	78.8	0	1	171	291	347	MBR4978503.1 type I asparaginase [Bacteroidales bacterium]	diamond	171	109	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
31700099	31700099	PRJNA937226_S_NODE_8917_length_253_cov_1.274510_g8790_i0	PRJNA937226	8917	253	1.27451	3.2245103	Segatella copri	165179	Bacteria	Bacteria	169	5.73e-50	NR	MEE1460156.1	165179	g8790	i0	100	0.99604743083004	84	0	99.6	0	253	2	158	241	MEE1460156.1 hypothetical protein [Segatella copri]	diamond	252	169	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri

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