metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJEB82358" and tax

11 rows where analysis = "blastn", bioproject = "PRJEB82358" 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
140777	140777	PRJEB82358_P_NODE_13401_length_276_cov_1.517241_g13390_i0	PRJEB82358	13401	276	1.517241	4.18758516	Flavihumibacter rivuli	2838156	Bacteria	Bacteria	220	6.57e-53	NTclustered	gi\|2198890466\|gb\|CP092334.1\|	2838156	g13390	i0	81.992	0.945652173913043	261	45	94	2	1	260	1144246	1144505	Flavihumibacter rivuli strain IMCC34838 chromosome, complete genome	blastn	261	220	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavihumibacter	Flavihumibacter rivuli
140907	140907	PRJEB82358_P_NODE_5221_length_411_cov_4.402367_g5210_i0	PRJEB82358	5221	411	4.402367	18.09372837	Flavobacterium dauae	1563479	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2557430891\|gb\|CP130821.1\|	1563479	g5210	i0	100	0.072992700729927	30	0	7	0	122	151	1161438	1161409	Flavobacterium dauae strain TCH3-2 chromosome, complete genome	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium dauae
2272603	2272603	PRJEB82358_P_NODE_17282_length_248_cov_1.560000_g17271_i0	PRJEB82358	17282	248	1.56	3.8688	Weeksellaceae	2762318	Bacteria	Bacteria	398	2.5e-106	NTclustered	gi\|1919297446\|gb\|CP063145.1\|	1118202	g17271	i0	99.541	34.2822580645161	218	1	88	0	1	218	305491	305274	Cruoricaptor ignavus strain M1214 chromosome, complete genome	blastn	8502	398	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cruoricaptor	Cruoricaptor ignavus
2690850	2690850	PRJEB82358_P_NODE_14063_length_270_cov_3.629442_g14052_i0	PRJEB82358	14063	270	3.629442	9.7994934	Lacibacter sp. MH-610	3020883	Bacteria	Bacteria	239	1.7700000000000002e-58	NTclustered	gi\|2865359271\|gb\|CP116002.1\|	3020883	g14052	i0	93.789	0.596296296296296	161	7	59	3	67	225	1613880	1614039	Lacibacter sp. MH-610 chromosome	blastn	161	239	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter sp. MH-610
9068078	9068078	PRJEB82358_P_NODE_12008_length_289_cov_1.592593_g11997_i0	PRJEB82358	12008	289	1.592593	4.60259377	Pedobacter sp. UC225_65	3350173	Bacteria	Bacteria	420	6.359999999999998e-113	NTclustered	gi\|2814008831\|gb\|CP170550.1\|	3350173	g11997	i0	93.031	22.083044982699	287	20	99	0	3	289	1268481	1268767	Pedobacter sp. UC225_65 chromosome, complete genome	blastn	6382	420	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. UC225_65
12894365	12894365	PRJEB82358_P_NODE_20851_length_227_cov_4.467532_g20840_i0	PRJEB82358	20851	227	4.467532	10.14129764	Flavihumibacter rivuli	2838156	Bacteria	Bacteria	154	5.39e-33	NTclustered	gi\|2198890466\|gb\|CP092334.1\|	2838156	g20840	i0	83.333	6.18061674008811	168	26	74	2	59	225	4222954	4222788	Flavihumibacter rivuli strain IMCC34838 chromosome, complete genome	blastn	1403	154	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavihumibacter	Flavihumibacter rivuli
12894380	12894380	PRJEB82358_P_NODE_23431_length_201_cov_5.125000_g23420_i0	PRJEB82358	23431	201	5.125	10.30125	Mucilaginibacter sp. Mucisp86	3243060	Bacteria	Bacteria	171	4.6299999999999996e-38	NTclustered	gi\|2897220482\|gb\|CP168503.1\|	3243060	g23420	i0	82.564	0.970149253731343	195	33	97	1	4	198	3651064	3650871	Mucilaginibacter sp. Mucisp86 strain CT11-86 chromosome, complete genome	blastn	195	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter sp. Mucisp86
15025328	15025328	PRJEB82358_P_NODE_15312_length_260_cov_7.245989_g15301_i0	PRJEB82358	15312	260	7.245989	18.8395714	Flavobacterium	237	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2447257787\|gb\|CP092822.1\|	1454066	g15301	i0	100	0.215384615384615	28	0	11	0	200	227	1435096	1435069	Flavobacterium sp. WW92 chromosome, complete genome	blastn	56	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WW92
17575340	17575340	PRJEB82358_P_NODE_12934_length_280_cov_3.101449_g12923_i0	PRJEB82358	12934	280	3.101449	8.6840572	Pedobacter	84567	Bacteria	Bacteria	294	3.88e-75	NTclustered	gi\|2844688158\|gb\|CP162529.1\|	2739058	g12923	i0	88.259	15.9035714285714	247	27	88	2	34	280	3258921	3259165	Pedobacter foliorum strain LMG 31463 chromosome, complete genome	blastn	4453	294	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter foliorum
19266244	19266244	PRJEB82358_P_NODE_11476_length_294_cov_4.719457_g11465_i0	PRJEB82358	11476	294	4.719457	13.87520358	Niastella koreensis	354356	Bacteria	Bacteria	150	9.399999999999999e-32	NTclustered	gi\|361057412\|gb\|CP003178.1\|	700598	g11465	i0	86.861	3.40136054421769	137	15	46	3	60	194	7218966	7219101	Niastella koreensis GR20-10, complete genome	blastn	1000	150	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niastella	Niastella koreensis
19266289	19266289	PRJEB82358_P_NODE_17996_length_245_cov_0.895349_g17985_i0	PRJEB82358	17996	245	0.895349	2.19360505	Pedobacter sp. SL55	2995161	Bacteria	Bacteria	243	1.22e-59	NTclustered	gi\|2381133349\|gb\|CP113059.1\|	2995161	g17985	i0	85.408	8.51836734693878	233	34	95	0	12	244	279697	279465	Pedobacter sp. SL55 chromosome	blastn	2087	243	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. SL55

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