metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA781196" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA781196" 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
759621	759621	PRJNA781196_P_NODE_61481_length_245_cov_1.813953_g61104_i0	PRJNA781196	61481	245	1.813953	4.44418485	Psychroserpens ponticola	2932268	Bacteria	Bacteria	71.3	6.11e-8	NTclustered	gi\|2441525218\|gb\|CP116221.1\|	2932268	g61104	i0	92	2.11428571428571	50	4	20	0	196	245	2554763	2554714	Psychroserpens ponticola strain MSW6 chromosome, complete genome	blastn	518	71.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Psychroserpens	Psychroserpens ponticola
1211135	1211135	PRJNA781196_P_NODE_17881_length_395_cov_2.136646_g17504_i0	PRJNA781196	17881	395	2.136646	8.4397517	Hymenobacter	89966	Bacteria	Bacteria	603	8.319999999999999e-168	NTclustered	gi\|731476172\|gb\|CP010054.1\|	1385664	g17504	i0	94.416	239.113924050633	394	19	99	3	4	395	971175	970783	Hymenobacter sp. DG25B, complete genome	blastn	94450	608	0.991776315789474	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. DG25B
3310441	3310441	PRJNA781196_P_NODE_32563_length_309_cov_1.322034_g32186_i0	PRJNA781196	32563	309	1.322034	4.08508506	Bacteroidetes bacterium UKL13-3	1690483	Bacteria	Bacteria	449	8.76e-122	NTclustered	gi\|1012307226\|gb\|CP012155.1\|	1690483	g32186	i0	95.088	410.300970873786	285	14	92	0	1	285	954853	955137	Bacteroidetes bacterium UKL13-3 chromosome, complete genome	blastn	126783	449	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium UKL13-3
3762895	3762895	PRJNA781196_P_NODE_26003_length_339_cov_1.466165_g25626_i0	PRJNA781196	26003	339	1.466165	4.97029935	Bacteroidota	976	Bacteria	Bacteria	207	6.46e-49	NTclustered	gi\|1721675146\|gb\|CP042437.1\|	862126	g25626	i0	82.231	234.722713864307	242	42	71	1	74	315	1842315	1842075	Mucilaginibacter ginsenosidivorax strain KHI28 chromosome, complete genome	blastn	79571	209	0.990430622009569	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter ginsenosidivorax
5862378	5862378	PRJNA781196_P_NODE_11905_length_470_cov_1.730479_g11529_i0	PRJNA781196	11905	470	1.730479	8.1332513	Aureispira anguillae	2864201	Bacteria	Bacteria	383	1.43e-101	NTclustered	gi\|2314744358\|dbj\|AP026867.1\|	2864201	g11529	i0	81.838	238.525531914894	468	73	99	12	7	470	4695986	4695527	Aureispira anguillae EL160426 DNA, complete genome	blastn	112107	383	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae	Aureispira	Aureispira anguillae
5862759	5862759	PRJNA781196_P_NODE_39065_length_286_cov_1.098592_g38688_i0	PRJNA781196	39065	286	1.098592	3.14197312	Hymenobacter cellulosilyticus	2932248	Bacteria	Bacteria	490	4.729999999999998e-134	NTclustered	gi\|2221923801\|gb\|CP095046.1\|	2932248	g38688	i0	97.561	277.43006993007	287	6	100	1	1	286	977142	977428	Hymenobacter cellulosilyticus strain 5116 S-3 chromosome, complete genome	blastn	79345	490	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter cellulosilyticus
5862961	5862961	PRJNA781196_P_NODE_53145_length_251_cov_0.876404_g52768_i0	PRJNA781196	53145	251	0.876404	2.19977404	Candidatus Kaistella beijingensis	2820270	Bacteria	Bacteria	202	2.13e-47	NTclustered	gi\|2097156165\|gb\|CP071953.1\|	2820270	g52768	i0	81.633	6.24302788844621	245	44	97	1	4	247	2747022	2746778	Candidatus Kaistella beijingensis strain PM-38 chromosome, complete genome	blastn	1567	202	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Candidatus Kaistella beijingensis
7138184	7138184	PRJNA781196_P_NODE_53146_length_251_cov_0.876404_g52769_i0	PRJNA781196	53146	251	0.876404	2.19977404	Chitinophaga sp. HK235	2952571	Bacteria	Bacteria	161	3.62e-35	NTclustered	gi\|2032009615\|gb\|CP073766.1\|	2952571	g52769	i0	81.395	267.422310756972	215	25	82	14	45	251	4430012	4430219	Chitinophaga sp. HK235 chromosome, complete genome	blastn	67123	161	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga sp. HK235
8864476	8864476	PRJNA781196_P_NODE_53007_length_251_cov_0.876404_g52630_i0	PRJNA781196	53007	251	0.876404	2.19977404	Prevotella	838	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|965692493\|dbj\|AP014597.1\|	28131	g52630	i0	99.203	277.003984063745	251	2	100	0	1	251	1258478	1258228	Prevotella intermedia DNA, complete genome, strain: OMA14, chromosome: I	blastn	69528	453	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella intermedia
9687792	9687792	PRJNA781196_P_NODE_38448_length_288_cov_1.088372_g38071_i0	PRJNA781196	38448	288	1.088372	3.13451136	Runella sp. SP2	2268026	Bacteria	Bacteria	457	4.8299999999999984e-124	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g38071	i0	95.47	448.15625	287	11	99	2	1	285	7121649	7121935	Runella sp. SP2 chromosome, complete genome	blastn	129069	457	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
12239216	12239216	PRJNA781196_P_NODE_55130_length_250_cov_0.881356_g54753_i0	PRJNA781196	55130	250	0.881356	2.20339	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	425	1.16e-114	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g54753	i0	97.959	229.128	245	5	98	0	3	247	2978806	2979050	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	57282	425	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
12239342	12239342	PRJNA781196_P_NODE_62270_length_245_cov_0.906977_g61893_i0	PRJNA781196	62270	245	0.906977	2.22209365	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	291	4.3000000000000005e-74	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g61893	i0	88.936	4.84897959183674	235	26	96	0	3	237	4555924	4556158	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	1188	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128
13513057	13513057	PRJNA781196_P_NODE_34591_length_301_cov_1.368421_g34214_i0	PRJNA781196	34591	301	1.368421	4.11894721	Candidatus Fluviicola riflensis	1798018	Bacteria	Bacteria	525	1.3699999999999995e-144	NTclustered	gi\|1229046090\|gb\|CP022585.1\|	1798018	g34214	i0	98.333	403.013289036545	300	3	99	2	4	301	787155	786856	Candidatus Fluviicola riflensis chromosome, complete genome	blastn	121307	525	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Candidatus Fluviicola riflensis
13965304	13965304	PRJNA781196_P_NODE_60891_length_246_cov_0.901734_g60514_i0	PRJNA781196	60891	246	0.901734	2.21826564	Chitinophaga	79328	Bacteria	Bacteria	289	1.56e-73	NTclustered	gi\|2656636291\|gb\|CP140771.1\|	3108349	g60514	i0	88.608	200.682926829268	237	27	96	0	9	245	6703111	6703347	Chitinophaga sp. 212800008-4 chromosome, complete genome	blastn	49368	289	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga sp. 212800008-4
14787811	14787811	PRJNA781196_P_NODE_31012_length_315_cov_2.181818_g30635_i0	PRJNA781196	31012	315	2.181818	6.8727267	Hymenobacter sp. BT18	2835648	Bacteria	Bacteria	544	3.99e-150	NTclustered	gi\|1829874072\|gb\|CP050954.1\|	2835648	g30635	i0	97.778	306.730158730159	315	7	100	0	1	315	1252715	1253029	Hymenobacter sp. BT18 chromosome, complete genome	blastn	96620	544	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BT18
15239789	15239789	PRJNA781196_P_NODE_55752_length_249_cov_1.073864_g55375_i0	PRJNA781196	55752	249	1.073864	2.67392136	Fluviicola	332102	Bacteria	Bacteria	329	9.3e-86	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g55375	i0	91.597	325.096385542169	238	20	96	0	12	249	1593	1830	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	80949	329	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
16061831	16061831	PRJNA781196_P_NODE_40313_length_282_cov_1.349282_g39936_i0	PRJNA781196	40313	282	1.349282	3.80497524	Aquiflexum balticum	280473	Bacteria	Bacteria	62.1	4.32e-5	NTclustered	gi\|1175431232\|emb\|LT838813.1\|	758820	g39936	i0	89.583	0.170212765957447	48	5	17	0	134	181	3296335	3296382	Aquiflexum balticum DSM 16537 genome assembly, chromosome: I	blastn	48	62.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Aquiflexum	Aquiflexum balticum
16062258	16062258	PRJNA781196_P_NODE_67773_length_234_cov_2.422360_g67396_i0	PRJNA781196	67773	234	2.42236	5.6683224	Dyadobacter sandarakinus	2747268	Bacteria	Bacteria	241	4.17e-59	NTclustered	gi\|1986777041\|gb\|CP056775.1\|	2747268	g67396	i0	85.593	238.679487179487	236	27	99	6	1	233	869792	869561	Dyadobacter sandarakinus strain Q3-56 chromosome, complete genome	blastn	55851	241	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter sandarakinus
16514097	16514097	PRJNA781196_P_NODE_13253_length_448_cov_4.069333_g12876_i0	PRJNA781196	13253	448	4.069333	18.23061184	Flavobacterium	237	Bacteria	Bacteria	817	0	NTclustered	gi\|2892685955\|gb\|CP174374.1\|	3379707	g12876	i0	99.554	530.013392857143	448	2	100	0	1	448	1250744	1250297	Flavobacterium sp. TBRC 19031 chromosome, complete genome	blastn	237446	817	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium mekongense
18611194	18611194	PRJNA781196_P_NODE_58075_length_248_cov_0.891429_g57698_i0	PRJNA781196	58075	248	0.891429	2.21074392	Flavobacterium mekongense	3379707	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|2892685955\|gb\|CP174374.1\|	3379707	g57698	i0	99.194	2	248	2	100	0	1	248	2710014	2709767	Flavobacterium sp. TBRC 19031 chromosome, complete genome	blastn	496	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium mekongense
19063056	19063056	PRJNA781196_P_NODE_53735_length_251_cov_0.876404_g53358_i0	PRJNA781196	53735	251	0.876404	2.19977404	Cloacibacterium	501783	Bacteria	Bacteria	425	1.16e-114	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g53358	i0	97.211	50.406374501992	251	7	100	0	1	251	2252995	2253245	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	12652	425	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
20337725	20337725	PRJNA781196_P_NODE_53436_length_251_cov_0.876404_g53059_i0	PRJNA781196	53436	251	0.876404	2.19977404	Sphingobacterium	28453	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2306435172\|gb\|CP094931.1\|	34087	g53059	i0	100	6.58565737051793	251	0	100	0	1	251	3032988	3032738	Sphingobacterium faecium strain WB1 chromosome, complete genome	blastn	1653	464	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium faecium
21162396	21162396	PRJNA781196_P_NODE_8937_length_530_cov_1.884026_g8562_i0	PRJNA781196	8937	530	1.884026	9.9853378	Runella sp. SP2	2268026	Bacteria	Bacteria	963	0	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g8562	i0	99.434	247.707547169811	530	3	100	0	1	530	5734411	5734940	Runella sp. SP2 chromosome, complete genome	blastn	131285	963	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
21613406	21613406	PRJNA781196_P_NODE_37457_length_291_cov_1.224771_g37080_i0	PRJNA781196	37457	291	1.224771	3.56408361	Fluviicola	332102	Bacteria	Bacteria	472	1.75e-128	NTclustered	gi\|2308952759\|emb\|OX044359.1\|	213322	g37080	i0	95.876	261.563573883161	291	12	100	0	1	291	216643	216353	MAG: uncultured Flavobacteriales bacterium isolate C_MB391 genome assembly, chromosome: C_MB391_contig-1	blastn	76115	472	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			uncultured Flavobacteriales bacterium
22436833	22436833	PRJNA781196_P_NODE_51998_length_252_cov_0.871508_g51621_i0	PRJNA781196	51998	252	0.871508	2.19620016	Cloacibacterium caeni	2004710	Bacteria	Bacteria	460	3.2e-125	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g51621	i0	99.603	99.2777777777778	252	1	100	0	1	252	2157017	2156766	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	25018	460	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
22437084	22437084	PRJNA781196_P_NODE_67878_length_232_cov_2.220126_g67501_i0	PRJNA781196	67878	232	2.220126	5.15069232	Hymenobacter sp. BT18	2835648	Bacteria	Bacteria	422	1.37e-113	NTclustered	gi\|1829874072\|gb\|CP050954.1\|	2835648	g67501	i0	99.567	379.754310344828	231	1	99	0	2	232	1253632	1253862	Hymenobacter sp. BT18 chromosome, complete genome	blastn	88103	422	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BT18
24985654	24985654	PRJNA781196_P_NODE_29760_length_321_cov_1.580645_g29383_i0	PRJNA781196	29760	321	1.580645	5.07387045	uncultured Saprospiraceae bacterium	261514	Bacteria	Bacteria	523	5.309999999999998e-144	NTclustered	gi\|1743647159\|gb\|MN477070.1\|	261514	g29383	i0	98.013	93.6947040498442	302	5	94	1	20	321	254	554	Uncultured Saprospiraceae bacterium clone em.517 16S ribosomal RNA gene, partial sequence	blastn	30076	523	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		uncultured Saprospiraceae 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);;