metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA699078" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA699078" and tax_clade = "FCB group"

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
681921	681921	PRJNA699078_S_NODE_18341_length_386_cov_2.824926_g17394_i0	PRJNA699078	18341	386	2.824926	10.90421436	Parabacteroides distasonis	823	Bacteria	Bacteria	651	0	NTclustered	gi\|2463807697\|gb\|CP120353.1\|	823	g17394	i0	99.169	472.70725388601	361	3	94	0	26	386	169328	169688	Parabacteroides distasonis strain F1-28 isolate human Intestinal chromosome, complete genome	blastn	182465	651	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides distasonis
682869	682869	PRJNA699078_S_NODE_80741_length_187_cov_1.130435_g79792_i0	PRJNA699078	80741	187	1.130435	2.11391345	Parabacteroides distasonis	823	Bacteria	Bacteria	346	6.56e-91	NTclustered	gi\|2290784043\|gb\|CP103242.1\|	823	g79792	i0	100	50.6256684491979	187	0	100	0	1	187	3172875	3172689	Parabacteroides distasonis strain BFG-275 chromosome, complete genome	blastn	9467	346	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides distasonis
1184127	1184127	PRJNA699078_S_NODE_57841_length_223_cov_2.022989_g56892_i0	PRJNA699078	57841	223	2.022989	4.51126547	Parabacteroides	375288	Bacteria	Bacteria	407	3.67e-109	NTclustered	gi\|2290514682\|gb\|CP103099.1\|	823	g56892	i0	99.552	97.4529147982063	223	1	100	0	1	223	663341	663563	Parabacteroides distasonis strain BFG-549 chromosome, complete genome	blastn	21732	407	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides distasonis
5012403	5012403	PRJNA699078_S_NODE_60684_length_217_cov_3.416667_g59735_i0	PRJNA699078	60684	217	3.416667	7.41416739	root	1	Root_unresolved	Root_unresolved	401	1.6499999999999994e-107	NTclustered	gi\|1848637015\|gb\|CP054012.1\|	823	g59735	i0	100	142.018433179724	217	0	100	0	1	217	2654748	2654532	Parabacteroides distasonis strain FDAARGOS_759 chromosome, complete genome	blastn	30818	401	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides distasonis
8837026	8837026	PRJNA699078_S_NODE_8187_length_515_cov_2.478541_g7298_i0	PRJNA699078	8187	515	2.478541	12.76448615	Spirosoma	107	Bacteria	Bacteria	841	0	NTclustered	gi\|1702113944\|gb\|CP041360.1\|	2520506	g7298	i0	96.117	306.256310679612	515	20	100	0	1	515	678038	677524	Spirosoma sp. KCTC 42546 chromosome, complete genome	blastn	157722	841	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma sp. KCTC 42546
9610781	9610781	PRJNA699078_S_NODE_48868_length_245_cov_1.591837_g47919_i0	PRJNA699078	48868	245	1.591837	3.90000065	Spirosoma pollinicola	2057025	Bacteria	Bacteria	412	8.81e-111	NTclustered	gi\|1304138264\|gb\|CP025096.1\|	2057025	g47919	i0	97.154	254.70612244898	246	3	100	3	1	245	8390585	8390827	Spirosoma pollinicola strain Ha7 chromosome, complete genome	blastn	62403	412	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma pollinicola
10885882	10885882	PRJNA699078_S_NODE_12709_length_441_cov_3.125000_g11782_i0	PRJNA699078	12709	441	3.125	13.78125	Phocaeicola dorei	357276	Bacteria	Bacteria	573	7.359999999999999e-159	NTclustered	gi\|1721134202\|emb\|LR699004.1\|	357276	g11782	i0	93.734	422.834467120181	383	22	87	2	60	441	695872	695491	Bacteroides dorei isolate MGYG-HGUT-02478 genome assembly, chromosome: 1	blastn	186470	573	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola dorei
10886645	10886645	PRJNA699078_S_NODE_64929_length_210_cov_0.813665_g63980_i0	PRJNA699078	64929	210	0.813665	1.7086965	Arachidicoccus terrestris	2875539	Bacteria	Bacteria	270	4.6699999999999986e-68	NTclustered	gi\|2096314771\|gb\|CP083387.1\|	2875539	g63980	i0	91.089	423.666666666667	202	15	96	3	1	201	1664870	1665069	Arachidicoccus terrestris strain 5GH13-10 chromosome, complete genome	blastn	88970	270	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Arachidicoccus	Arachidicoccus terrestris
10886848	10886848	PRJNA699078_S_NODE_78089_length_190_cov_1.602837_g77140_i0	PRJNA699078	78089	190	1.602837	3.0453903	Spirosoma radiotolerans	1379870	Bacteria	Bacteria	291	3.18e-74	NTclustered	gi\|808692684\|gb\|CP010429.1\|	1379870	g77140	i0	94.211	417.489473684211	190	11	100	0	1	190	4385380	4385191	Spirosoma radiotolerans strain DG5A, complete genome	blastn	79323	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma radiotolerans
12162005	12162005	PRJNA699078_S_NODE_84090_length_183_cov_1.164179_g83141_i0	PRJNA699078	84090	183	1.164179	2.13044757	Parabacteroides distasonis	823	Bacteria	Bacteria	339	1.07e-88	NTclustered	gi\|2290784043\|gb\|CP103242.1\|	823	g83141	i0	100	419.765027322404	183	0	100	0	1	183	2277104	2276922	Parabacteroides distasonis strain BFG-275 chromosome, complete genome	blastn	76817	339	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides distasonis
14711304	14711304	PRJNA699078_S_NODE_4952_length_619_cov_3.233333_g4163_i0	PRJNA699078	4952	619	3.233333	20.01433127	Parabacteroides distasonis	823	Bacteria	Bacteria	1133	0	NTclustered	gi\|2463807697\|gb\|CP120353.1\|	823	g4163	i0	99.677	552.478190630049	619	2	100	0	1	619	2312873	2313491	Parabacteroides distasonis strain F1-28 isolate human Intestinal chromosome, complete genome	blastn	341984	1133	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides distasonis
16487056	16487056	PRJNA699078_S_NODE_47733_length_248_cov_2.115578_g46784_i0	PRJNA699078	47733	248	2.115578	5.24663344	Bacteroides	816	Bacteria	Bacteria	414	2.48e-111	NTclustered	gi\|2290604469\|gb\|CP103098.1\|	371601	g46784	i0	96.774	429.552419354839	248	8	100	0	1	248	5594485	5594732	Bacteroides xylanisolvens strain BFG-319 chromosome, complete genome	blastn	106529	414	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides xylanisolvens
17259547	17259547	PRJNA699078_S_NODE_103514_length_165_cov_0.896552_g102565_i0	PRJNA699078	103514	165	0.896552	1.4793108	Blattabacterium cuenoti	1653831	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1893900755\|gb\|CP059221.1\|	1653831	g102565	i0	100	0.175757575757576	29	0	18	0	78	106	557127	557155	Blattabacterium cuenoti strain ALLACbim chromosome, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Blattabacteriaceae	Blattabacterium	Blattabacterium cuenoti
19809545	19809545	PRJNA699078_S_NODE_69176_length_203_cov_1.077922_g68227_i0	PRJNA699078	69176	203	1.077922	2.18818166	Phocaeicola dorei	357276	Bacteria	Bacteria	370	4.3e-98	NTclustered	gi\|671709398\|gb\|CP007619.1\|	357276	g68227	i0	99.507	311.354679802956	203	1	100	0	1	203	665694	665492	Bacteroides dorei isolate HS1_L_1_B_010, complete genome	blastn	63205	370	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola dorei
23634994	23634994	PRJNA699078_S_NODE_30239_length_313_cov_3.200758_g29290_i0	PRJNA699078	30239	313	3.200758	10.01837254	Spirosoma radiotolerans	1379870	Bacteria	Bacteria	457	5.309999999999999e-124	NTclustered	gi\|808692684\|gb\|CP010429.1\|	1379870	g29290	i0	92.971	211.690095846645	313	22	100	0	1	313	5778787	5779099	Spirosoma radiotolerans strain DG5A, complete genome	blastn	66259	457	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma radiotolerans

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