metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA380416" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA380416" 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
4229186	4229186	PRJNA380416_P_NODE_13764_length_161_cov_0.910714_g13617_i0	PRJNA380416	13764	161	0.910714	1.46624954	Cloacibacterium normanense	237258	Bacteria	Bacteria	287	3.37e-73	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g13617	i0	98.758	3.83229813664596	161	2	100	0	1	161	2247510	2247350	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	617	287	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
4229188	4229188	PRJNA380416_P_NODE_13904_length_161_cov_0.910714_g13757_i0	PRJNA380416	13904	161	0.910714	1.46624954	Cloacibacterium caeni	2004710	Bacteria	Bacteria	276	7.29e-70	NTclustered	gi\|2040340746\|emb\|OU015319.1\|	2004710	g13757	i0	97.516	5	161	4	100	0	1	161	2106208	2106368	Cloacibacterium caeni isolate Isolate1 genome assembly, chromosome: 000000F_arrow	blastn	805	276	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
4229195	4229195	PRJNA380416_P_NODE_584_length_822_cov_2.090556_g481_i0	PRJNA380416	584	822	2.090556	17.18437032	Sphingobacteriales bacterium JAD_PAG50586_3	2982687	Bacteria	Bacteria	881	0	NTclustered	gi\|2233014210\|gb\|CP096135.1\|	2982687	g481	i0	86.199	360.986618004866	826	100	99	12	3	822	2138477	2139294	MAG: Sphingobacteriales bacterium JAD_PAG50586_3 chromosome, complete genome	blastn	296731	881	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales			Sphingobacteriales bacterium JAD_PAG50586_3
6779743	6779743	PRJNA380416_P_NODE_12286_length_165_cov_0.879310_g12139_i0	PRJNA380416	12286	165	0.87931	1.4508615	Cloacibacterium caeni	2004710	Bacteria	Bacteria	289	9.66e-74	NTclustered	gi\|2040340746\|emb\|OU015319.1\|	2004710	g12139	i0	98.182	4	165	3	100	0	1	165	2395470	2395306	Cloacibacterium caeni isolate Isolate1 genome assembly, chromosome: 000000F_arrow	blastn	660	289	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
8726817	8726817	PRJNA380416_P_NODE_13127_length_163_cov_0.894737_g12980_i0	PRJNA380416	13127	163	0.894737	1.45842131	Mucilaginibacter	423349	Bacteria	Bacteria	189	9.92e-44	NTclustered	gi\|2016456650\|gb\|CP071881.1\|	2027860	g12980	i0	100	11.8220858895706	102	0	63	0	1	102	3595480	3595581	Mucilaginibacter rubeus strain P2-0.1 chromosome, complete genome	blastn	1927	189	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter rubeus
10605759	10605759	PRJNA380416_P_NODE_1109_length_587_cov_2.604089_g971_i0	PRJNA380416	1109	587	2.604089	15.28600243	Schleiferiaceae bacterium	2562116	Bacteria	Bacteria	649	0	NTclustered	gi\|2874253937\|emb\|OY970262.1\|	2562116	g971	i0	87.368	490.139693356048	570	66	97	6	7	575	3149242	3149806	MAG: Schleiferiaceae bacterium isolate MFD03250.bin.1.24 genome assembly, chromosome: 1	blastn	287712	649	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Schleiferiaceae		Schleiferiaceae bacterium
10605781	10605781	PRJNA380416_P_NODE_7909_length_203_cov_1.896104_g7762_i0	PRJNA380416	7909	203	1.896104	3.84909112	Candidatus Fluviicola riflensis	1798018	Bacteria	Bacteria	281	2.07e-71	NTclustered	gi\|1229046090\|gb\|CP022585.1\|	1798018	g7762	i0	91.626	226.093596059113	203	17	100	0	1	203	789083	788881	Candidatus Fluviicola riflensis chromosome, complete genome	blastn	45897	281	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Candidatus Fluviicola riflensis
12552662	12552662	PRJNA380416_P_NODE_13790_length_161_cov_0.910714_g13643_i0	PRJNA380416	13790	161	0.910714	1.46624954	Weeksellaceae	2762318	Bacteria	Bacteria	292	7.24e-75	NTclustered	gi\|1919297446\|gb\|CP063145.1\|	1118202	g13643	i0	99.379	35	161	1	100	0	1	161	852860	853020	Cruoricaptor ignavus strain M1214 chromosome, complete genome	blastn	5635	292	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cruoricaptor	Cruoricaptor ignavus
13155764	13155764	PRJNA380416_P_NODE_9091_length_189_cov_1.421429_g8944_i0	PRJNA380416	9091	189	1.421429	2.68650081	Flectobacillus sp. HMD2002	665460	Bacteria	Bacteria	350	5.14e-92	NTclustered	gi\|255763064\|gb\|GQ374919.1\|	665460	g8944	i0	100	99.978835978836	189	0	100	0	1	189	227	39	Flectobacillus sp. HMD2002 16S ribosomal RNA gene, partial sequence	blastn	18896	350	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp. HMD2002
15101933	15101933	PRJNA380416_P_NODE_11012_length_169_cov_1.275000_g10865_i0	PRJNA380416	11012	169	1.275	2.15475	Chryseobacterium	59732	Bacteria	Bacteria	285	1.28e-72	NTclustered	gi\|1519580736\|gb\|CP033930.1\|	253	g10865	i0	97.041	450.408284023669	169	5	100	0	1	169	2944264	2944096	Chryseobacterium indologenes strain H5559 chromosome, complete genome	blastn	76119	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
16979369	16979369	PRJNA380416_P_NODE_2714_length_365_cov_3.655063_g2567_i0	PRJNA380416	2714	365	3.655063	13.34097995	Bacteroidales bacterium	2030927	Bacteria	Bacteria	361	5.0699999999999986e-95	NTclustered	gi\|2621701195\|emb\|OY759717.1\|	2030927	g2567	i0	84.89	326.805479452055	364	48	98	6	4	362	3010459	3010820	MAG: Bacteroidales bacterium isolate 1994922c-57ad-4284-af65-a097e7e7ad8c genome assembly, chromosome: 1	blastn	119284	361	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
20803491	20803491	PRJNA380416_P_NODE_11717_length_166_cov_0.871795_g11570_i0	PRJNA380416	11717	166	0.871795	1.4471797	Empedobacter stercoris	1628248	Bacteria	Bacteria	178	2.2e-40	NTclustered	gi\|1905412003\|gb\|CP053698.1\|	1628248	g11570	i0	98.99	10.2168674698795	99	1	60	0	1	99	640690	640592	Empedobacter stercoris strain ES183 chromosome, complete genome	blastn	1696	178	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter stercoris
20803508	20803508	PRJNA380416_P_NODE_5217_length_254_cov_2.302439_g5070_i0	PRJNA380416	5217	254	2.302439	5.84819506	Chryseobacterium indologenes	253	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1566847344\|gb\|CP035532.1\|	253	g5070	i0	100	0.220472440944882	28	0	11	0	84	111	765838	765811	Chryseobacterium indologenes strain StR 01 chromosome, complete genome	blastn	56	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
21475818	21475818	PRJNA380416_P_NODE_13137_length_163_cov_0.894737_g12990_i0	PRJNA380416	13137	163	0.894737	1.45842131	Cloacibacterium	501783	Bacteria	Bacteria	261	2.07e-65	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g12990	i0	95.679	5.20245398773006	162	7	99	0	1	162	2366592	2366753	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	848	261	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
23354053	23354053	PRJNA380416_P_NODE_10059_length_179_cov_1.453846_g9912_i0	PRJNA380416	10059	179	1.453846	2.60238434	Polaribacter sp. Hel1_33_78	1336804	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|1086039533\|emb\|LT629794.1\|	1336804	g9912	i0	100	0.525139664804469	30	0	17	0	52	81	2167765	2167736	Polaribacter sp. Hel1_33_78 genome assembly, chromosome: I	blastn	94	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Polaribacter	Polaribacter sp. Hel1_33_78
23354066	23354066	PRJNA380416_P_NODE_13339_length_162_cov_0.902655_g13192_i0	PRJNA380416	13339	162	0.902655	1.4623011	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	156	9.99e-34	NTclustered	gi\|1958116195\|gb\|CP065012.1\|	1869212	g13192	i0	85.333	0.925925925925926	150	22	93	0	13	162	1356360	1356509	MAG: Chitinophagaceae bacterium isolate Rand_18-Q3-R56-63_BAT3C.147_cln chromosome, complete genome	blastn	150	156	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium

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