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

28 rows where analysis = "blastn", bioproject = "PRJNA1061474" 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
178858	178858	PRJNA1061474_P_NODE_45701_length_251_cov_0.865169_g45455_i0	PRJNA1061474	45701	251	0.865169	2.17157419	Marinoscillum sp.	2024838	Bacteria	Bacteria	139	1.7000000000000003e-28	NTclustered	gi\|2836248207\|gb\|CP121337.1\|	2024838	g45455	i0	100	29.5378486055777	75	0	30	0	81	155	4849859	4849785	MAG: Marinoscillum sp. isolate NCC532_bact_3502 chromosome, complete genome	blastn	7414	139	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Reichenbachiellaceae	Marinoscillum	Marinoscillum sp.
1011699	1011699	PRJNA1061474_P_NODE_44441_length_255_cov_1.692308_g44195_i0	PRJNA1061474	44441	255	1.692308	4.3153854	Porphyromonas	836	Bacteria	Bacteria	448	2.53e-121	NTclustered	gi\|1274919567\|gb\|CP024601.1\|	837	g44195	i0	99.592	448.070588235294	245	1	96	0	1	245	1546781	1547025	Porphyromonas gingivalis strain KCOM 2799 chromosome, complete genome	blastn	114258	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas gingivalis
2729464	2729464	PRJNA1061474_P_NODE_52143_length_246_cov_0.867052_g51897_i0	PRJNA1061474	52143	246	0.867052	2.13294792	Candidatus Latescibacterota bacterium	2053570	Bacteria	Bacteria	235	2.06e-57	NTclustered	gi\|2108033339\|gb\|CP070763.1\|	2053570	g51897	i0	84.583	1.92682926829268	240	33	97	3	6	243	1701259	1701022	MAG: Candidatus Latescibacterota bacterium isolate bin260 chromosome	blastn	474	235	1	Bacteria	FCB group	Pseudomonadati	Candidatus Latescibacterota					Candidatus Latescibacterota bacterium
4005443	4005443	PRJNA1061474_P_NODE_53284_length_245_cov_0.895349_g53038_i0	PRJNA1061474	53284	245	0.895349	2.19360505	Niabella yanshanensis	577386	Bacteria	Bacteria	213	9.59e-51	NTclustered	gi\|2636479872\|gb\|CP139960.1\|	577386	g53038	i0	83.19	88.0530612244898	232	39	95	0	12	243	2395512	2395743	Niabella yanshanensis strain HAMBI_3031 chromosome, complete genome	blastn	21573	213	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella yanshanensis
5281673	5281673	PRJNA1061474_P_NODE_50545_length_247_cov_0.885057_g50299_i0	PRJNA1061474	50545	247	0.885057	2.18609079	Mucilaginibacter sp. SJ	3029053	Bacteria	Bacteria	200	7.529999999999999e-47	NTclustered	gi\|2451268147\|gb\|CP118631.1\|	3029053	g50299	i0	81.452	2.00404858299595	248	42	99	3	1	246	4850585	4850340	Mucilaginibacter sp. SJ chromosome, complete genome	blastn	495	200	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter sp. SJ
5281728	5281728	PRJNA1061474_P_NODE_52765_length_245_cov_0.895349_g52519_i0	PRJNA1061474	52765	245	0.895349	2.19360505	Pseudobacter ginsenosidimutans	661488	Bacteria	Bacteria	172	1.63e-38	NTclustered	gi\|1721651342\|gb\|CP042431.1\|	661488	g52519	i0	82.412	1.10612244897959	199	34	81	1	30	228	6567245	6567048	Pseudobacter ginsenosidimutans strain Gsoil 221 chromosome, complete genome	blastn	271	172	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Pseudobacter	Pseudobacter ginsenosidimutans
6556435	6556435	PRJNA1061474_P_NODE_3526_length_1161_cov_3.550551_g3390_i0	PRJNA1061474	3526	1161	3.550551	41.22189711	Prevotella melaninogenica	28132	Bacteria	Bacteria	1978	0	NTclustered	gi\|1239340444\|dbj\|AP018049.1\|	28132	g3390	i0	99.005	229.320413436693	1105	9	95	2	1	1104	369141	368038	Prevotella melaninogenica DNA, complete genome, strain: GAI 07411	blastn	266241	1978	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
6556842	6556842	PRJNA1061474_P_NODE_49726_length_248_cov_0.880000_g49480_i0	PRJNA1061474	49726	248	0.88	2.1824	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	276	1.22e-69	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g49480	i0	86.747	59.5040322580645	249	31	100	2	1	248	1828330	1828083	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	14757	276	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
7389374	7389374	PRJNA1061474_P_NODE_30686_length_335_cov_1.103053_g30440_i0	PRJNA1061474	30686	335	1.103053	3.69522755	Porphyromonas	836	Bacteria	Bacteria	470	7.36e-128	NTclustered	gi\|2437755982\|gb\|CP116614.1\|	837	g30440	i0	91.988	284.579104477612	337	24	100	3	1	335	1241164	1241499	Porphyromonas gingivalis strain ATCC 49417 chromosome, complete genome	blastn	95334	470	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas gingivalis
7831402	7831402	PRJNA1061474_P_NODE_46127_length_251_cov_0.865169_g45881_i0	PRJNA1061474	46127	251	0.865169	2.17157419	Hymenobacter sp. PAMC 26628	1484118	Bacteria	Bacteria	403	5.45e-108	NTclustered	gi\|996006667\|gb\|CP014304.1\|	1484118	g45881	i0	95.618	48.4820717131474	251	11	100	0	1	251	1213575	1213325	Hymenobacter sp. PAMC 26628 chromosome, complete genome	blastn	12169	403	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. PAMC 26628
9105966	9105966	PRJNA1061474_P_NODE_32888_length_320_cov_1.315789_g32642_i0	PRJNA1061474	32888	320	1.315789	4.2105248	Spirosoma sp. SC4-14	3128900	Bacteria	Bacteria	424	5.52e-114	NTclustered	gi\|2699382250\|gb\|CP147518.1\|	3128900	g32642	i0	97.581	203.896875	248	5	77	1	26	272	24104	23857	Spirosoma sp. SC4-14 chromosome, complete genome	blastn	65247	424	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma sp. SC4-14
9106613	9106613	PRJNA1061474_P_NODE_55448_length_243_cov_0.905882_g55202_i0	PRJNA1061474	55448	243	0.905882	2.20129326	Candidatus Latescibacterota bacterium	2053570	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2893358399\|emb\|OZ220690.1\|	2053570	g55202	i0	100	0.584362139917695	29	0	12	0	165	193	2167396	2167424	MAG: Candidatus Latescibacterota bacterium isolate 4544edd8-ea3d-4877-aa30-594cc490bc13 genome assembly, chromosome: 1	blastn	142	54.7	1	Bacteria	FCB group	Pseudomonadati	Candidatus Latescibacterota					Candidatus Latescibacterota bacterium
10382090	10382090	PRJNA1061474_P_NODE_46589_length_250_cov_0.870056_g46343_i0	PRJNA1061474	46589	250	0.870056	2.17514	uncultured Bacteroidota bacterium	152509	Bacteria	Bacteria	281	2.65e-71	NTclustered	gi\|2874253829\|emb\|OY969813.1\|	152509	g46343	i0	87.603	0.968	242	30	97	0	4	245	1941501	1941260	MAG: uncultured Bacteroidetes bacterium isolate MFD09671.bin.1.97 genome assembly, chromosome: 1	blastn	242	281	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					uncultured Bacteroidota bacterium
10382091	10382091	PRJNA1061474_P_NODE_46609_length_250_cov_0.870056_g46363_i0	PRJNA1061474	46609	250	0.870056	2.17514	Spirosoma foliorum	2710596	Bacteria	Bacteria	431	2.489999999999999e-116	NTclustered	gi\|1886902300\|gb\|CP059732.1\|	2710596	g46363	i0	98.367	0.98	245	4	98	0	6	250	4841658	4841902	Spirosoma foliorum strain KCTC 72228 chromosome, complete genome	blastn	245	431	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma foliorum
10382220	10382220	PRJNA1061474_P_NODE_51869_length_246_cov_0.890173_g51623_i0	PRJNA1061474	51869	246	0.890173	2.18982558	Mucilaginibacter rubeus	2027860	Bacteria	Bacteria	222	1.5999999999999996e-53	NTclustered	gi\|1735100761\|gb\|CP043450.1\|	2027860	g51623	i0	87.831	13.0528455284553	189	23	77	0	7	195	7187968	7187780	Mucilaginibacter rubeus strain P1 chromosome, complete genome	blastn	3211	222	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter rubeus
10382227	10382227	PRJNA1061474_P_NODE_52029_length_246_cov_0.890173_g51783_i0	PRJNA1061474	52029	246	0.890173	2.18982558	Flavihumibacter rivuli	2838156	Bacteria	Bacteria	86.1	2.19e-12	NTclustered	gi\|2198890466\|gb\|CP092334.1\|	2838156	g51783	i0	90.625	0.260162601626016	64	6	26	0	183	246	1886766	1886829	Flavihumibacter rivuli strain IMCC34838 chromosome, complete genome	blastn	64	86.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavihumibacter	Flavihumibacter rivuli
11657457	11657457	PRJNA1061474_P_NODE_50370_length_247_cov_0.885057_g50124_i0	PRJNA1061474	50370	247	0.885057	2.18609079	Flavobacterium acetivorans	2893883	Bacteria	Bacteria	80.5	1.02e-10	NTclustered	gi\|2153896436\|gb\|CP087132.1\|	2893883	g50124	i0	94.231	0.210526315789474	52	3	21	0	67	118	43168	43219	Flavobacterium acetivorans strain F-29 chromosome, complete genome	blastn	52	80.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium acetivorans
12932473	12932473	PRJNA1061474_P_NODE_44991_length_252_cov_1.497207_g44745_i0	PRJNA1061474	44991	252	1.497207	3.77296164	Flavobacterium sp. KACC 22758	3025667	Bacteria	Bacteria	444	3.2299999999999996e-120	NTclustered	gi\|2446139215\|gb\|CP117878.1\|	3025667	g44745	i0	98.413	4.82142857142857	252	4	100	0	1	252	4163847	4164098	Flavobacterium sp. KACC 22758 chromosome, complete genome	blastn	1215	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. KACC 22758
13765046	13765046	PRJNA1061474_P_NODE_39831_length_281_cov_1.009615_g39585_i0	PRJNA1061474	39831	281	1.009615	2.83701815	Prevotella	838	Bacteria	Bacteria	477	3.6099999999999986e-130	NTclustered	gi\|265678843\|ref\|NR_029148.1\|	28137	g39585	i0	100	91.8149466192171	258	0	92	0	1	258	659	916	Prevotella veroralis strain ATCC 33779 16S ribosomal RNA, partial sequence	blastn	25800	477	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella veroralis
14207787	14207787	PRJNA1061474_P_NODE_57732_length_241_cov_0.916667_g57486_i0	PRJNA1061474	57732	241	0.916667	2.20916747	Mucilaginibacter jinjuensis	1176721	Bacteria	Bacteria	300	7.02e-77	NTclustered	gi\|2442599841\|gb\|CP117167.1\|	1176721	g57486	i0	89.212	1	241	24	99	2	1	240	2450550	2450789	Mucilaginibacter jinjuensis strain KACC 16571 chromosome, complete genome	blastn	241	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter jinjuensis
15039343	15039343	PRJNA1061474_P_NODE_38752_length_286_cov_1.948357_g38506_i0	PRJNA1061474	38752	286	1.948357	5.57230102	Weeksellaceae	2762318	Bacteria	Bacteria	496	1.02e-135	NTclustered	gi\|1519569220\|gb\|CP033933.1\|	421525	g38506	i0	100	430.181818181818	268	0	94	0	1	268	35804	36071	Kaistella haifensis strain G0079 chromosome, complete genome	blastn	123032	496	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis
15039359	15039359	PRJNA1061474_P_NODE_47272_length_250_cov_0.870056_g47026_i0	PRJNA1061474	47272	250	0.870056	2.17514	Hoylesella	2974257	Bacteria	Bacteria	416	6.969999999999998e-112	NTclustered	gi\|2127571982\|gb\|CP085926.1\|	28127	g47026	i0	98.718	240.936	234	3	94	0	1	234	210722	210955	Hoylesella buccalis strain FDAARGOS_1588 chromosome, complete genome	blastn	60234	416	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Hoylesella	Hoylesella buccalis
18030747	18030747	PRJNA1061474_P_NODE_55715_length_243_cov_0.905882_g55469_i0	PRJNA1061474	55715	243	0.905882	2.20129326	Candidatus Chryseobacterium colombiense	3121364	Bacteria	Bacteria	366	6.89e-97	NTclustered	gi\|2457556413\|gb\|CP119310.1\|	3121364	g55469	i0	93.827	95.7942386831276	243	15	100	0	1	243	813434	813192	MAG: Candidatus Chryseobacterium colombiense isolate MAG_1654 chromosome, complete genome	blastn	23278	366	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Candidatus Chryseobacterium colombiense
20138097	20138097	PRJNA1061474_P_NODE_39536_length_282_cov_1.473684_g39290_i0	PRJNA1061474	39536	282	1.473684	4.15578888	Pseudomonadati	3379134	Bacteria	Bacteria	484	2.1599999999999996e-132	NTclustered	gi\|1139290057\|emb\|LT676654.1\|	28132	g39290	i0	100	98.4716312056738	262	0	93	0	1	262	47	308	Prevotella melaninogenica partial 16S rRNA gene, isolate 398N_2068	blastn	27769	484	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
20579642	20579642	PRJNA1061474_P_NODE_39317_length_283_cov_1.680952_g39071_i0	PRJNA1061474	39317	283	1.680952	4.75709416	Prevotella melaninogenica	28132	Bacteria	Bacteria	394	3.77e-105	NTclustered	gi\|1239340444\|dbj\|AP018049.1\|	28132	g39071	i0	99.087	174.233215547703	219	2	77	0	65	283	369316	369098	Prevotella melaninogenica DNA, complete genome, strain: GAI 07411	blastn	49308	394	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
21855855	21855855	PRJNA1061474_P_NODE_53618_length_244_cov_0.900585_g53372_i0	PRJNA1061474	53618	244	0.900585	2.1974274	Hymenobacter yonginensis	748197	Bacteria	Bacteria	171	5.82e-38	NTclustered	gi\|2423912131\|gb\|CP115396.1\|	748197	g53372	i0	82.212	4.35245901639344	208	28	83	6	38	240	4410270	4410067	Hymenobacter yonginensis strain KCTC 22745 chromosome, complete genome	blastn	1062	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter yonginensis
21855967	21855967	PRJNA1061474_P_NODE_58398_length_201_cov_9.351562_g58152_i0	PRJNA1061474	58398	201	9.351562	18.79663962	Prevotella melaninogenica	28132	Bacteria	Bacteria	237	4.4999999999999996e-58	NTclustered	gi\|1239340444\|dbj\|AP018049.1\|	28132	g58152	i0	98.507	141.542288557214	134	2	67	0	1	134	369183	369316	Prevotella melaninogenica DNA, complete genome, strain: GAI 07411	blastn	28450	237	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
25237899	25237899	PRJNA1061474_P_NODE_17700_length_473_cov_2.917500_g17454_i0	PRJNA1061474	17700	473	2.9175	13.799775	Prevotella	838	Bacteria	Bacteria	760	0	NTclustered	gi\|2028855114\|gb\|CP072349.1\|	28132	g17454	i0	99.059	235.718816067653	425	1	89	3	41	463	1633848	1634271	Prevotella melaninogenica strain F0301 chromosome 1, complete sequence	blastn	111495	760	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica

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