metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA784979" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA784979" 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
1213356	1213356	PRJNA784979_S_NODE_5121_length_213_cov_1.481707_g5079_i0	PRJNA784979	5121	213	1.481707	3.15603591	Hymenobacter	89966	Bacteria	Bacteria	357	3.55e-94	NTclustered	gi\|1847976054\|gb\|CP053904.1\|	2675877	g5079	i0	97.608	250.136150234742	209	3	98	2	1	208	433735	433528	Hymenobacter sp. BRD67 chromosome, complete genome	blastn	53279	357	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD67
1213383	1213383	PRJNA784979_S_NODE_8301_length_180_cov_0.770992_g8259_i0	PRJNA784979	8301	180	0.770992	1.3877856	Chryseobacterium	59732	Bacteria	Bacteria	202	1.4299999999999999e-47	NTclustered	gi\|1586140306\|gb\|CP031676.1\|	250	g8259	i0	98.261	337.433333333333	115	2	64	0	6	120	2656715	2656829	Chryseobacterium gleum strain 110146 chromosome	blastn	60738	202	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gleum
2041429	2041429	PRJNA784979_S_NODE_12482_length_163_cov_0.894737_g12440_i0	PRJNA784979	12482	163	0.894737	1.45842131	Hymenobacter yonginensis	748197	Bacteria	Bacteria	89.8	1.04e-13	NTclustered	gi\|2423912131\|gb\|CP115396.1\|	748197	g12440	i0	85.057	0.957055214723926	87	13	53	0	1	87	777706	777620	Hymenobacter yonginensis strain KCTC 22745 chromosome, complete genome	blastn	156	89.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter yonginensis
2041453	2041453	PRJNA784979_S_NODE_3362_length_252_cov_3.236453_g3320_i0	PRJNA784979	3362	252	3.236453	8.15586156	Flavobacterium ammonificans	1751056	Bacteria	Bacteria	444	3.2299999999999996e-120	NTclustered	gi\|2119748049\|dbj\|AP025183.1\|	1751056	g3320	i0	100	502.238095238095	240	0	95	0	6	245	1065629	1065390	Flavobacterium ammonificans GENT11 DNA, complete genome	blastn	126564	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammonificans
2488925	2488925	PRJNA784979_S_NODE_9102_length_174_cov_0.784000_g9060_i0	PRJNA784979	9102	174	0.784	1.36416	Panacibacter	1874621	Bacteria	Bacteria	287	3.69e-73	NTclustered	gi\|2874254166\|emb\|OY970398.1\|	866510	g9060	i0	98.171	100.655172413793	164	3	94	0	8	171	3591739	3591902	MAG: uncultured Chitinophagaceae bacterium isolate MFD02832.bin.c.2 genome assembly, chromosome: 1	blastn	17514	287	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		uncultured Chitinophagaceae bacterium
3316840	3316840	PRJNA784979_S_NODE_7203_length_189_cov_1.128571_g7161_i0	PRJNA784979	7203	189	1.128571	2.13299919	Roseivirga spongicola	333140	Bacteria	Bacteria	202	1.5199999999999998e-47	NTclustered	gi\|2634447873\|gb\|CP139724.1\|	333140	g7161	i0	86.957	309.640211640212	184	19	96	4	2	182	2111704	2111885	Roseivirga spongicola strain OXR-11 chromosome, complete genome	blastn	58522	202	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Roseivirgaceae	Roseivirga	Roseivirga spongicola
3316855	3316855	PRJNA784979_S_NODE_9483_length_171_cov_1.614754_g9441_i0	PRJNA784979	9483	171	1.614754	2.76122934	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	302	1.29e-77	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g9441	i0	99.401	111.380116959064	167	0	98	1	1	167	339080	338915	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	19046	302	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128
4593787	4593787	PRJNA784979_S_NODE_11224_length_165_cov_0.879310_g11182_i0	PRJNA784979	11224	165	0.87931	1.4508615	Sphingobacterium multivorum	28454	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1958258319\|gb\|CP068086.1\|	28454	g11182	i0	100	15.9878787878788	165	0	100	0	1	165	885367	885531	Sphingobacterium multivorum strain FDAARGOS_1143 chromosome, complete genome	blastn	2638	305	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium multivorum
5041678	5041678	PRJNA784979_S_NODE_14084_length_152_cov_2.864078_g14042_i0	PRJNA784979	14084	152	2.864078	4.35339856	Bacteroidota	976	Bacteria	Bacteria	91.6	2.63e-14	NTclustered	gi\|1494853531\|emb\|LR027382.1\|	2364787	g14042	i0	84.946	97.5065789473684	93	10	60	4	57	147	1466786	1466696	Alistipes sp. Marseille-P5997 genome assembly, chromosome: contig00001	blastn	14821	91.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Alistipes	Alistipes megaguti
8418640	8418640	PRJNA784979_S_NODE_11807_length_164_cov_0.886957_g11765_i0	PRJNA784979	11807	164	0.886957	1.45460948	Dyadobacter chenhuakuii	2909339	Bacteria	Bacteria	298	1.59e-76	NTclustered	gi\|2257600705\|gb\|CP098805.1\|	2909339	g11765	i0	99.39	2.99390243902439	164	1	100	0	1	164	5842310	5842473	Dyadobacter chenhuakuii strain CY22 chromosome, complete genome	blastn	491	298	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter chenhuakuii
8866496	8866496	PRJNA784979_S_NODE_1627_length_375_cov_2.239264_g1585_i0	PRJNA784979	1627	375	2.239264	8.39724	Cloacibacterium	501783	Bacteria	Bacteria	676	0	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g1585	i0	99.462	456.736	372	2	99	0	1	372	130191	129820	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	171276	676	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
10969648	10969648	PRJNA784979_S_NODE_12689_length_162_cov_1.345133_g12647_i0	PRJNA784979	12689	162	1.345133	2.17911546	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	206	9.78e-49	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g12647	i0	90.446	0.969135802469136	157	14	97	1	2	158	3087372	3087527	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	157	206	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128
10969686	10969686	PRJNA784979_S_NODE_7649_length_185_cov_1.029412_g7607_i0	PRJNA784979	7649	185	1.029412	1.9044122	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	243	8.73e-60	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g7607	i0	91.16	263.735135135135	181	12	97	4	7	185	338248	338070	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	48791	243	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128
12693083	12693083	PRJNA784979_S_NODE_4530_length_223_cov_1.477011_g4488_i0	PRJNA784979	4530	223	1.477011	3.29373453	Aquirufa	2676247	Bacteria	Bacteria	364	2.2399999999999993e-96	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g4488	i0	97.642	517.14798206278	212	5	95	0	2	213	359592	359803	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	115324	364	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
12693105	12693105	PRJNA784979_S_NODE_7810_length_183_cov_1.925373_g7768_i0	PRJNA784979	7810	183	1.925373	3.52343259	Flavobacterium	237	Bacteria	Bacteria	305	1.08e-78	NTclustered	gi\|1834819635\|gb\|CP051546.1\|	239	g7768	i0	98.276	478.726775956284	174	3	95	0	8	181	55582	55755	MAG: Flavobacterium sp. isolate NK2020 chromosome	blastn	87607	305	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
13519354	13519354	PRJNA784979_S_NODE_6631_length_194_cov_2.186207_g6589_i0	PRJNA784979	6631	194	2.186207	4.24124158	Cloacibacterium caeni	2004710	Bacteria	Bacteria	339	1.15e-88	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g6589	i0	99.465	362.603092783505	187	0	96	1	7	193	1872428	1872243	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	70345	339	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
15241770	15241770	PRJNA784979_S_NODE_12052_length_163_cov_2.649123_g12010_i0	PRJNA784979	12052	163	2.649123	4.31807049	Flavobacterium	237	Bacteria	Bacteria	283	4.43e-72	NTclustered	gi\|2446065538\|dbj\|LC747093.1\|	239	g12010	i0	100	93.9079754601227	153	0	94	0	6	158	213	61	Flavobacterium sp. PF-16 gene for 16S ribosomal RNA, partial sequence	blastn	15307	283	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
16516291	16516291	PRJNA784979_S_NODE_1793_length_353_cov_3.500000_g1751_i0	PRJNA784979	1793	353	3.5	12.355	Flavobacterium	237	Bacteria	Bacteria	612	1.2199999999999996e-170	NTclustered	gi\|2922046464\|gb\|CP182943.1\|	1355330	g1751	i0	99.118	539.549575070822	340	3	96	0	6	345	573755	574094	Flavobacterium faecale strain WV33 chromosome, complete genome	blastn	190461	612	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium faecale
16516356	16516356	PRJNA784979_S_NODE_9413_length_172_cov_0.723577_g9371_i0	PRJNA784979	9413	172	0.723577	1.24455244	Emticicia	312278	Bacteria	Bacteria	207	2.91e-49	NTclustered	gi\|470489174\|ref\|NR_076911.1\|	312279	g9371	i0	93.525	162.674418604651	139	9	81	0	18	156	1557	1695	Emticicia oligotrophica strain GPTSA100-15 23S ribosomal RNA gene, complete sequence	blastn	27980	207	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
17343803	17343803	PRJNA784979_S_NODE_7354_length_187_cov_2.079710_g7312_i0	PRJNA784979	7354	187	2.07971	3.8890577	Candidatus Parvibacillus calidus	2982025	Bacteria	Bacteria	213	6.94e-51	NTclustered	gi\|1869334961\|gb\|CP058702.1\|	2982025	g7312	i0	91.503	142.572192513369	153	13	82	0	35	187	2574702	2574550	MAG: Candidatus Parvibacillus calidus isolate SSA7 chromosome	blastn	26661	213	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae	Candidatus Parvibacillus	Candidatus Parvibacillus calidus
18617100	18617100	PRJNA784979_S_NODE_3495_length_248_cov_1.125628_g3453_i0	PRJNA784979	3495	248	1.125628	2.79155744	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	283	7.309999999999999e-72	NTclustered	gi\|2021938309\|gb\|CP051243.1\|	2021391	g3453	i0	88.608	254.838709677419	237	22	95	5	10	244	1916531	1916298	Flavobacteriales bacterium isolate ih4 chromosome	blastn	63200	283	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
20339762	20339762	PRJNA784979_S_NODE_12536_length_163_cov_0.736842_g12494_i0	PRJNA784979	12536	163	0.736842	1.20105246	Cytophagales	768507	Bacteria	Bacteria	219	1.2699999999999999e-52	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g12494	i0	92.763	328.963190184049	152	10	93	1	8	159	360468	360318	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	53621	220	0.995454545454545	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
21615583	21615583	PRJNA784979_S_NODE_3077_length_263_cov_4.079439_g3035_i0	PRJNA784979	3077	263	4.079439	10.72892457	Cloacibacterium	501783	Bacteria	Bacteria	459	1.21e-124	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g3035	i0	98.833	484.866920152091	257	3	98	0	1	257	130297	130553	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	127520	459	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
22442848	22442848	PRJNA784979_S_NODE_12698_length_162_cov_1.327434_g12656_i0	PRJNA784979	12698	162	1.327434	2.15044308	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	268	1.23e-67	NTclustered	gi\|1527187866\|gb\|CP034161.1\|	2487072	g12656	i0	96.875	1.97530864197531	160	5	99	0	3	162	1722535	1722694	Epilithonimonas vandammei strain F5649 chromosome, complete genome	blastn	320	268	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
23718353	23718353	PRJNA784979_S_NODE_11879_length_164_cov_0.886957_g11837_i0	PRJNA784979	11879	164	0.886957	1.45460948	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	209	7.68e-50	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g11837	i0	89.634	1	164	17	100	0	1	164	2370363	2370200	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	164	209	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
23718402	23718402	PRJNA784979_S_NODE_7099_length_190_cov_1.085106_g7057_i0	PRJNA784979	7099	190	1.085106	2.0617014	Runella slithyformis	106	Bacteria	Bacteria	187	4.29e-43	NTclustered	gi\|336303358\|gb\|CP002859.1\|	761193	g7057	i0	91.852	1.42105263157895	135	9	70	2	58	190	5871942	5872076	Runella slithyformis DSM 19594 chromosome, complete genome	blastn	270	187	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella slithyformis

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