metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA594101" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA594101" 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
566919	566919	PRJNA594101_S_NODE_12361_length_469_cov_2.229798_g12059_i0	PRJNA594101	12361	469	2.229798	10.45775262	uncultured Ignavibacteriales bacterium	1191687	Bacteria	Bacteria	52.8	0.046	NTclustered	gi\|2874253946\|emb\|OY970271.1\|	1191687	g12059	i0	100	0.0597014925373134	28	0	6	0	191	218	1115747	1115720	MAG: uncultured Ignavibacteriales bacterium isolate MFD02416.bin.c.14 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			uncultured Ignavibacteriales bacterium
566923	566923	PRJNA594101_S_NODE_12781_length_461_cov_3.626289_g12479_i0	PRJNA594101	12781	461	3.626289	16.71719229	Bacteroidales bacterium	2030927	Bacteria	Bacteria	60.2	2.67e-4	NTclustered	gi\|2621784647\|emb\|OY781105.1\|	2030927	g12479	i0	100	0.06941431670282	32	0	7	0	240	271	2057659	2057628	MAG: Bacteroidales bacterium isolate 0f0db77d-63af-43ca-a293-a1227edc7b73 genome assembly, chromosome: 1	blastn	32	60.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
566987	566987	PRJNA594101_S_NODE_21521_length_362_cov_1.792388_g21219_i0	PRJNA594101	21521	362	1.792388	6.48844456	Chryseobacterium sp. KCF3-3	3231511	Bacteria	Bacteria	58.4	7.38e-4	NTclustered	gi\|2802707432\|dbj\|AP035792.1\|	3231511	g21219	i0	100	0.0856353591160221	31	0	9	0	317	347	3484953	3484983	Chryseobacterium sp. KCF3-3 DNA, complete genome	blastn	31	58.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. KCF3-3
567288	567288	PRJNA594101_S_NODE_921_length_1451_cov_10.440493_g810_i0	PRJNA594101	921	1451	10.440493	151.49155343	Flagellimonas oceani	2698672	Bacteria	Bacteria	54.7	0.041	NTclustered	gi\|1819720604\|gb\|CP049616.1\|	2698672	g810	i0	96.875	0.0220537560303239	32	1	2	0	1144	1175	2936779	2936748	Flagellimonas oceani strain 501str8 chromosome, complete genome	blastn	32	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flagellimonas	Flagellimonas oceani
3118187	3118187	PRJNA594101_S_NODE_50743_length_249_cov_0.875000_g50441_i0	PRJNA594101	50743	249	0.875	2.17875	Flavobacterium indicum	312277	Bacteria	Bacteria	182	2.75e-41	NTclustered	gi\|380500974\|emb\|HE774682.1\|	1094466	g50441	i0	80.579	0.971887550200803	242	41	96	5	3	241	451338	451576	Flavobacterium indicum GPTSA100-9 complete genome	blastn	242	182	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium indicum
3118275	3118275	PRJNA594101_S_NODE_8143_length_573_cov_1.988000_g7843_i0	PRJNA594101	8143	573	1.988	11.39124	uncultured Ignavibacteriales bacterium	1191687	Bacteria	Bacteria	62.1	9.39e-5	NTclustered	gi\|2874253946\|emb\|OY970271.1\|	1191687	g7843	i0	97.222	0.136125654450262	36	1	6	0	158	193	3540838	3540803	MAG: uncultured Ignavibacteriales bacterium isolate MFD02416.bin.c.14 genome assembly, chromosome: 1	blastn	78	62.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			uncultured Ignavibacteriales bacterium
3118280	3118280	PRJNA594101_S_NODE_8443_length_563_cov_1.630612_g8143_i0	PRJNA594101	8443	563	1.630612	9.18034556	Panacibacter ginsenosidivorans	1813871	Bacteria	Bacteria	60.2	3.32e-4	NTclustered	gi\|1721657344\|gb\|CP042435.1\|	1813871	g8143	i0	94.737	0.0674955595026643	38	2	7	0	526	563	2481769	2481806	Panacibacter ginsenosidivorans strain Gsoil1550 chromosome, complete genome	blastn	38	60.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Panacibacter	Panacibacter ginsenosidivorans
4394777	4394777	PRJNA594101_S_NODE_52544_length_247_cov_0.862069_g52242_i0	PRJNA594101	52544	247	0.862069	2.12931043	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	407	4.14e-109	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g52242	i0	96.721	0.987854251012146	244	8	99	0	4	247	1732437	1732194	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	244	407	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3
6243032	6243032	PRJNA594101_S_NODE_18605_length_387_cov_1.003185_g18303_i0	PRJNA594101	18605	387	1.003185	3.88232595	Chryseobacterium	59732	Bacteria	Bacteria	52.8	0.037	NTclustered	gi\|2463166018\|gb\|CP119767.1\|	651561	g18303	i0	100	0.289405684754522	28	0	7	0	353	380	2069878	2069851	Chryseobacterium arthrosphaerae strain FS91703 chromosome, complete genome	blastn	112	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium arthrosphaerae
6243049	6243049	PRJNA594101_S_NODE_43805_length_264_cov_1.130890_g43503_i0	PRJNA594101	43805	264	1.13089	2.9855496	Flavobacterium	237	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1421732866\|gb\|CP030261.1\|	2249356	g43503	i0	100	0.329545454545455	29	0	11	0	85	113	375673	375645	Flavobacterium fluviale strain HYN0086 chromosome, complete genome	blastn	87	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium fluviale
6945122	6945122	PRJNA594101_S_NODE_1366_length_1260_cov_4.732940_g1223_i0	PRJNA594101	1366	1260	4.73294	59.635044	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	54.7	0.036	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g1223	i0	100	0.023015873015873	29	0	2	0	1101	1129	155193	155165	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
9495499	9495499	PRJNA594101_S_NODE_38288_length_281_cov_0.951923_g37986_i0	PRJNA594101	38288	281	0.951923	2.67490363	Flavobacterium indicum	312277	Bacteria	Bacteria	508	1.28e-139	NTclustered	gi\|380500974\|emb\|HE774682.1\|	1094466	g37986	i0	99.288	1.7864768683274	281	2	100	0	1	281	1438464	1438184	Flavobacterium indicum GPTSA100-9 complete genome	blastn	502	508	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium indicum
10771359	10771359	PRJNA594101_S_NODE_36189_length_288_cov_1.279070_g35887_i0	PRJNA594101	36189	288	1.27907	3.6837216	Bacteroidaceae bacterium	2212467	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2621780210\|emb\|OY776497.1\|	2212467	g35887	i0	100	0.100694444444444	29	0	10	0	37	65	2249235	2249207	MAG: Bacteroidaceae bacterium isolate 33854f8d-f901-4bce-8b2d-65fb297ee460 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae		Bacteroidaceae bacterium
11342795	11342795	PRJNA594101_S_NODE_54629_length_244_cov_1.187135_g54327_i0	PRJNA594101	54629	244	1.187135	2.8966094	Chryseobacterium	59732	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|1158824264\|gb\|CP018786.1\|	253	g54327	i0	99.18	77.2991803278689	244	2	100	0	1	244	989027	989270	Chryseobacterium indologenes strain AA5 chromosome, complete genome	blastn	18861	440	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
13321010	13321010	PRJNA594101_S_NODE_28251_length_320_cov_3.052632_g27949_i0	PRJNA594101	28251	320	3.052632	9.7684224	Rhodothermales bacterium	2306054	Bacteria	Bacteria	60.2	1.79e-4	NTclustered	gi\|2518550857\|emb\|OX638318.1\|	2306054	g27949	i0	94.737	0.11875	38	2	12	0	264	301	1853920	1853883	MAG: Rhodothermales bacterium isolate 55cba9af-49f2-4dbc-822e-66a085d3a702 genome assembly, chromosome: 1	blastn	38	60.2	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
13321112	13321112	PRJNA594101_S_NODE_41331_length_271_cov_1.186869_g41029_i0	PRJNA594101	41331	271	1.186869	3.21641499	Flavobacterium indicum	312277	Bacteria	Bacteria	390	4.639999999999999e-104	NTclustered	gi\|380500974\|emb\|HE774682.1\|	1094466	g41029	i0	92.62	1	271	20	100	0	1	271	1437623	1437893	Flavobacterium indicum GPTSA100-9 complete genome	blastn	271	390	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium indicum
14595998	14595998	PRJNA594101_S_NODE_37232_length_284_cov_1.777251_g36930_i0	PRJNA594101	37232	284	1.777251	5.04739284	Rhodothermus marinus	29549	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|1778177540\|dbj\|AP019797.1\|	29549	g36930	i0	100	0.0985915492957746	28	0	10	0	247	274	2898913	2898886	Rhodothermus marinus AA3-38 DNA, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
15869615	15869615	PRJNA594101_S_NODE_11993_length_476_cov_1.414392_g11691_i0	PRJNA594101	11993	476	1.414392	6.73250592	Thermoflexibacter ruber	1003	Bacteria	Bacteria	459	2.3399999999999998e-124	NTclustered	gi\|174550\|gb\|M58788.1\|FBCRR16SI	1003	g11691	i0	87.595	81.7563025210084	395	45	83	4	81	473	5	397	Flexibacter ruber 16S ribosomal RNA	blastn	38916	459	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Thermoflexibacteraceae	Thermoflexibacter	Thermoflexibacter ruber
19693529	19693529	PRJNA594101_S_NODE_39676_length_276_cov_1.517241_g39374_i0	PRJNA594101	39676	276	1.517241	4.18758516	Cytophagales bacterium Alg240-R148	2305985	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|1805798709\|emb\|LS999826.1\|	2305985	g39374	i0	100	0.101449275362319	28	0	10	0	190	217	1129726	1129753	Cytophagales bacterium Alg240-R148 genome assembly, chromosome: I	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales			Cytophagales bacterium Alg240-R148
20969225	20969225	PRJNA594101_S_NODE_25157_length_337_cov_2.325758_g24855_i0	PRJNA594101	25157	337	2.325758	7.83780446	Aestuariibaculum lutulentum	2920935	Bacteria	Bacteria	63.9	1.47e-5	NTclustered	gi\|2595818653\|gb\|CP136709.1\|	2920935	g24855	i0	78.351	0.382789317507418	97	21	29	0	3	99	1315166	1315070	Aestuariibaculum lutulentum strain L182 chromosome, complete genome	blastn	129	63.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aestuariibaculum	Aestuariibaculum lutulentum
20969453	20969453	PRJNA594101_S_NODE_54937_length_244_cov_0.900585_g54635_i0	PRJNA594101	54937	244	0.900585	2.1974274	Fluviicola taffensis	191579	Bacteria	Bacteria	263	9.34e-66	NTclustered	gi\|327317519\|gb\|CP002542.1\|	755732	g54635	i0	86.364	0.991803278688525	242	32	99	1	1	241	1241681	1241922	Fluviicola taffensis DSM 16823 chromosome, complete genome	blastn	242	263	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
22244125	22244125	PRJNA594101_S_NODE_16458_length_410_cov_1.370920_g16156_i0	PRJNA594101	16458	410	1.37092	5.620772	Echinicola sp. 20G	2781961	Bacteria	Bacteria	52.8	0.039	NTclustered	gi\|1929905271\|dbj\|AP024154.1\|	2781961	g16156	i0	100	0.0682926829268293	28	0	7	0	274	301	415665	415638	Echinicola sp. 20G DNA, nearly complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Echinicola	Echinicola sp. 20G
23519308	23519308	PRJNA594101_S_NODE_13759_length_446_cov_1.477212_g13457_i0	PRJNA594101	13759	446	1.477212	6.58836552	Chryseobacterium fluminis	2983606	Bacteria	Bacteria	52.8	0.043	NTclustered	gi\|2340756546\|gb\|CP111121.1\|	2983606	g13457	i0	94.118	0.0762331838565022	34	2	8	0	250	283	1958481	1958514	Chryseobacterium fluminis strain MMS21-Ot14 chromosome, complete genome	blastn	34	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium fluminis
25365735	25365735	PRJNA594101_S_NODE_49380_length_250_cov_1.706215_g49078_i0	PRJNA594101	49380	250	1.706215	4.2655375	Flavobacterium	237	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|1205046755\|gb\|MF289266.1\|	239	g49078	i0	100	100.352	244	0	98	0	7	250	273	30	Flavobacterium sp. strain MMS16-Y17 16S ribosomal RNA gene, partial sequence	blastn	25088	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.

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