metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA631119" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA631119" 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
603273	603273	PRJNA631119_P_NODE_4581_length_524_cov_2.323725_g4463_i0	PRJNA631119	4581	524	2.323725	12.176319	Spirosoma oryzicola	2898794	Bacteria	Bacteria	606	8.739999999999998e-169	NTclustered	gi\|2168315906\|gb\|CP089538.1\|	2898794	g4463	i0	87.879	337.603053435115	528	49	100	15	1	524	24637	25153	Spirosoma oryzicola strain RHs26 chromosome, complete genome	blastn	176904	606	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma oryzicola
1879404	1879404	PRJNA631119_P_NODE_28622_length_259_cov_0.827957_g28504_i0	PRJNA631119	28622	259	0.827957	2.14440863	Chryseobacterium cucumeris	1813611	Bacteria	Bacteria	479	9.13e-131	NTclustered	gi\|2866376460\|gb\|PQ722363.1\|	1813611	g28504	i0	100	210.23166023166	259	0	100	0	1	259	4	262	Chryseobacterium cucumeris strain Chr_cuc1 16S ribosomal RNA gene, partial sequence	blastn	54450	479	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium cucumeris
1879420	1879420	PRJNA631119_P_NODE_30982_length_251_cov_0.865169_g30864_i0	PRJNA631119	30982	251	0.865169	2.17157419	Elizabethkingia ursingii	1756150	Bacteria	Bacteria	409	1.17e-109	NTclustered	gi\|1153153613\|gb\|CP016377.1\|	1756150	g30864	i0	96.016	49.8764940239044	251	10	100	0	1	251	2770511	2770761	Elizabethkingia ursingii strain G4123 chromosome, complete genome	blastn	12519	409	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia ursingii
1879475	1879475	PRJNA631119_P_NODE_5722_length_478_cov_3.856790_g5604_i0	PRJNA631119	5722	478	3.85679	18.4354562	Hymenobacter sp. PAMC 26628	1484118	Bacteria	Bacteria	56.5	0.004	NTclustered	gi\|996006667\|gb\|CP014304.1\|	1484118	g5604	i0	100	0.0627615062761506	30	0	6	0	248	277	4586063	4586092	Hymenobacter sp. PAMC 26628 chromosome, complete genome	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. PAMC 26628
3703459	3703459	PRJNA631119_P_NODE_14863_length_331_cov_1.321705_g14745_i0	PRJNA631119	14863	331	1.321705	4.37484355	Flavobacterium	237	Bacteria	Bacteria	584	2.4899999999999985e-162	NTclustered	gi\|2206042033\|gb\|CP092832.1\|	1160795	g14745	i0	98.489	107.078549848943	331	5	100	0	1	331	1449172	1448842	Flavobacterium sp. HJ-32-4 chromosome, complete genome	blastn	35443	584	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. HJ-32-4
4430925	4430925	PRJNA631119_P_NODE_24184_length_277_cov_1.450980_g24066_i0	PRJNA631119	24184	277	1.45098	4.0192146	uncultured Saccharicrinis sp.	1618115	Bacteria	Bacteria	171	6.74e-38	NTclustered	gi\|2621785463\|emb\|OY781921.1\|	1618115	g24066	i0	80	83.9097472924188	240	40	86	5	26	264	1428403	1428171	MAG: uncultured Saccharicrinis sp. isolate 044d8e91-df83-4d29-87ff-5f2b71dcf37c genome assembly, chromosome: 1	blastn	23243	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Marinilabiliaceae	Saccharicrinis	uncultured Saccharicrinis sp.
6981772	6981772	PRJNA631119_P_NODE_466_length_1305_cov_9.312500_g427_i0	PRJNA631119	466	1305	9.3125	121.528125	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	1445	0	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g427	i0	86.732	316.485823754789	1319	151	99	19	1	1304	216174	217483	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	413014	1445	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
6981799	6981799	PRJNA631119_P_NODE_8626_length_405_cov_2.072289_g8508_i0	PRJNA631119	8626	405	2.072289	8.39277045	Chitinophagaceae bacterium LGM1	2837399	Bacteria	Bacteria	571	2.4099999999999995e-158	NTclustered	gi\|2046997110\|gb\|CP075895.1\|	2837399	g8508	i0	94.823	239.883950617284	367	18	91	1	1	367	1076285	1076650	Chitinophagaceae bacterium LGM1 chromosome, complete genome	blastn	97153	571	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium LGM1
9531684	9531684	PRJNA631119_P_NODE_1828_length_784_cov_1.706048_g1725_i0	PRJNA631119	1828	784	1.706048	13.37541632	Bacteroidetes bacterium UKL13-3	1690483	Bacteria	Bacteria	1068	0	NTclustered	gi\|1012307226\|gb\|CP012155.1\|	1690483	g1725	i0	91.443	449.864795918367	783	59	99	5	1	781	955355	954579	Bacteroidetes bacterium UKL13-3 chromosome, complete genome	blastn	352694	1068	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium UKL13-3
9531685	9531685	PRJNA631119_P_NODE_18368_length_306_cov_1.721030_g18250_i0	PRJNA631119	18368	306	1.72103	5.2663518	Prosthecochloris sp. GSB1	281093	Bacteria	Bacteria	211	4.45e-50	NTclustered	gi\|1227310175\|gb\|CP022571.1\|	281093	g18250	i0	80.882	76.0228758169935	272	48	88	4	24	293	1544783	1545052	Prosthecochloris sp. GSB1 strain TY Vent = GSB1 = Ty-1 chromosome, complete genome	blastn	23263	211	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Prosthecochloris	Prosthecochloris sp. GSB1
9531772	9531772	PRJNA631119_P_NODE_34748_length_246_cov_1.468208_g34630_i0	PRJNA631119	34748	246	1.468208	3.61179168	Bacteroidales bacterium	2030927	Bacteria	Bacteria	193	1.25e-44	NTclustered	gi\|2621717562\|emb\|OY775914.1\|	2030927	g34630	i0	81.743	100.886178861789	241	35	95	8	2	234	2181607	2181846	MAG: Bacteroidales bacterium isolate 7de1171c-092d-4693-a70e-3c34f944b135 genome assembly, chromosome: 1	blastn	24818	193	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
12082622	12082622	PRJNA631119_P_NODE_19410_length_300_cov_1.828194_g19292_i0	PRJNA631119	19410	300	1.828194	5.484582	Flavobacterium squillarum	1119057	Bacteria	Bacteria	544	3.78e-150	NTclustered	gi\|2116728070\|gb\|OK513252.1\|	1119057	g19292	i0	99.333	99.5233333333333	300	2	100	0	1	300	2	301	Flavobacterium squillarum strain WG6 16S ribosomal RNA gene, partial sequence	blastn	29857	544	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium squillarum
13357520	13357520	PRJNA631119_P_NODE_6571_length_452_cov_1.659631_g6453_i0	PRJNA631119	6571	452	1.659631	7.50153212	Cyclobacteriaceae bacterium	2099675	Bacteria	Bacteria	592	2.0899999999999992e-164	NTclustered	gi\|1869340971\|gb\|CP058703.1\|	2099675	g6453	i0	90.308	276.247787610619	454	40	100	4	1	452	2012942	2013393	MAG: Cyclobacteriaceae bacterium isolate SSA6 chromosome	blastn	124864	592	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae		Cyclobacteriaceae bacterium
15906144	15906144	PRJNA631119_P_NODE_5073_length_502_cov_4.109557_g4955_i0	PRJNA631119	5073	502	4.109557	20.62997614	Cyclobacteriaceae bacterium	2099675	Bacteria	Bacteria	558	2.3699999999999995e-154	NTclustered	gi\|1869340971\|gb\|CP058703.1\|	2099675	g4955	i0	86.957	270.988047808765	506	54	99	12	2	500	1696987	1696487	MAG: Cyclobacteriaceae bacterium isolate SSA6 chromosome	blastn	136036	558	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae		Cyclobacteriaceae bacterium
18455376	18455376	PRJNA631119_P_NODE_41275_length_197_cov_5.314516_g41157_i0	PRJNA631119	41275	197	5.314516	10.46959652	Spirosoma rhododendri	2728024	Bacteria	Bacteria	309	9.17e-80	NTclustered	gi\|1835007590\|gb\|CP051677.1\|	2728024	g41157	i0	94.924	340.573604060914	197	10	100	0	1	197	1400402	1400206	Spirosoma sp. CJU-R4 chromosome, complete genome	blastn	67093	309	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma rhododendri
18455411	18455411	PRJNA631119_P_NODE_8615_length_405_cov_2.873494_g8497_i0	PRJNA631119	8615	405	2.873494	11.6376507	Runella sp. SP2	2268026	Bacteria	Bacteria	665	0	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g8497	i0	96.305	290.750617283951	406	13	100	2	1	405	5733997	5733593	Runella sp. SP2 chromosome, complete genome	blastn	117754	665	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
19729887	19729887	PRJNA631119_P_NODE_376_length_1415_cov_11.956781_g340_i0	PRJNA631119	376	1415	11.956781	169.18845115	Aurantibacillus circumpalustris	3036359	Bacteria	Bacteria	1849	0	NTclustered	gi\|2482055248\|gb\|CP121197.1\|	3036359	g340	i0	90.232	377.433215547703	1423	129	100	10	1	1415	2013790	2012370	Aurantibacillus circumpalustris strain Swamp196 chromosome, complete genome	blastn	534068	1849	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Aurantibacillaceae	Aurantibacillus	Aurantibacillus circumpalustris
19729898	19729898	PRJNA631119_P_NODE_40236_length_233_cov_3.131250_g40118_i0	PRJNA631119	40236	233	3.13125	7.2958125	uncultured Gemmatimonadota bacterium	203437	Bacteria	Bacteria	82.4	2.66e-11	NTclustered	gi\|2518551241\|emb\|OX638340.1\|	203437	g40118	i0	84.337	2.1931330472103	83	13	36	0	101	183	2245027	2244945	MAG: uncultured Gemmatimonadota bacterium isolate 6ed59a95-0d5b-4630-9937-108f2708d2fb genome assembly, chromosome: 1	blastn	511	82.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					uncultured Gemmatimonadota bacterium
21005611	21005611	PRJNA631119_P_NODE_22657_length_283_cov_3.271429_g22539_i0	PRJNA631119	22657	283	3.271429	9.25814407	uncultured Flexibacteraceae bacterium	239735	Bacteria	Bacteria	518	2.14e-142	NTclustered	gi\|111607564\|gb\|DQ847443.1\|	239735	g22539	i0	99.647	117.798586572438	283	1	100	0	1	283	1087	1369	Uncultured Flexibacteraceae bacterium clone GL2-106 16S ribosomal RNA gene, partial sequence	blastn	33337	518	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae		uncultured Flexibacteraceae bacterium
21005693	21005693	PRJNA631119_P_NODE_38437_length_242_cov_0.911243_g38319_i0	PRJNA631119	38437	242	0.911243	2.20520806	Dyadobacter sp. 676	3088362	Bacteria	Bacteria	331	2.5e-86	NTclustered	gi\|2752922223\|gb\|CP159289.1\|	3088362	g38319	i0	91.632	34.5123966942149	239	20	99	0	1	239	1399631	1399393	Dyadobacter sp. 676 chromosome, complete genome	blastn	8352	331	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter sp. 676
21553773	21553773	PRJNA631119_P_NODE_19577_length_299_cov_1.796460_g19459_i0	PRJNA631119	19577	299	1.79646	5.3714154	Weeksellaceae	2762318	Bacteria	Bacteria	514	2.95e-141	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g19459	i0	97.659	482.374581939799	299	7	100	0	1	299	1758117	1758415	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	144230	514	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
22280371	22280371	PRJNA631119_P_NODE_36138_length_245_cov_0.895349_g36020_i0	PRJNA631119	36138	245	0.895349	2.19360505	Dyadobacter fermentans	94254	Bacteria	Bacteria	259	1.21e-64	NTclustered	gi\|254946573\|gb\|CP001619.1\|	471854	g36020	i0	85.772	1.00408163265306	246	33	100	2	1	245	6442941	6443185	Dyadobacter fermentans DSM 18053, complete genome	blastn	246	259	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter fermentans
23555770	23555770	PRJNA631119_P_NODE_19699_length_298_cov_2.764444_g19581_i0	PRJNA631119	19699	298	2.764444	8.23804312	Runella rosea	2259595	Bacteria	Bacteria	374	5.2e-99	NTclustered	gi\|1430388288\|gb\|CP030850.1\|	2259595	g19581	i0	90.21	454.973154362416	286	28	96	0	13	298	4137460	4137745	Runella rosea strain HYN0085 chromosome, complete genome	blastn	135582	374	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella rosea
23555809	23555809	PRJNA631119_P_NODE_28519_length_259_cov_1.580645_g28401_i0	PRJNA631119	28519	259	1.580645	4.09387055	Segatella copri	165179	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2619012172\|gb\|CP137557.1\|	165179	g28401	i0	100	0.22007722007722	29	0	11	0	1	29	486019	485991	Segatella copri strain HDE06 chromosome, complete genome	blastn	57	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
23555812	23555812	PRJNA631119_P_NODE_28739_length_258_cov_1.659459_g28621_i0	PRJNA631119	28739	258	1.659459	4.28140422	Pedobacter sp. SL55	2995161	Bacteria	Bacteria	366	7.38e-97	NTclustered	gi\|2381133349\|gb\|CP113059.1\|	2995161	g28621	i0	92.248	266.837209302326	258	20	100	0	1	258	2780	3037	Pedobacter sp. SL55 chromosome	blastn	68844	366	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. SL55
23555815	23555815	PRJNA631119_P_NODE_29159_length_256_cov_3.202186_g29041_i0	PRJNA631119	29159	256	3.202186	8.19759616	Dyadobacter sp. 676	3088362	Bacteria	Bacteria	451	1.96e-122	NTclustered	gi\|2752922223\|gb\|CP159289.1\|	3088362	g29041	i0	98.438	286.86328125	256	4	100	0	1	256	3091600	3091855	Dyadobacter sp. 676 chromosome, complete genome	blastn	73437	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter sp. 676
23555861	23555861	PRJNA631119_P_NODE_38019_length_242_cov_1.798817_g37901_i0	PRJNA631119	38019	242	1.798817	4.35313714	Bacteroidales bacterium	2030927	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2621786424\|emb\|OY782882.1\|	2030927	g37901	i0	100	0.115702479338843	28	0	12	0	66	93	2950611	2950638	MAG: Bacteroidales bacterium isolate 57984f20-7b8f-4c7b-84b7-4034ea6f78da genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
24829568	24829568	PRJNA631119_P_NODE_39900_length_237_cov_2.719512_g39782_i0	PRJNA631119	39900	237	2.719512	6.44524344	Cyclobacteriaceae bacterium	2099675	Bacteria	Bacteria	250	7.0299999999999995e-62	NTclustered	gi\|2320768945\|gb\|CP075525.1\|	2099675	g39782	i0	85.774	21.7510548523207	239	31	100	3	1	237	691512	691275	MAG: Cyclobacteriaceae bacterium isolate TGS_BAC11 chromosome	blastn	5155	250	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae		Cyclobacteriaceae 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);;