metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJEB12982" and tax

32 rows where analysis = "blastn", bioproject = "PRJEB12982" 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
985710	985710	PRJEB12982_P_NODE_6721_length_281_cov_2.762931_g6558_i0	PRJEB12982	6721	281	2.762931	7.76383611	Spirosoma	107	Bacteria	Bacteria	272	1.83e-68	NTclustered	gi\|1823150813\|gb\|CP050063.1\|	2692134	g6558	i0	84.589	146.597864768683	292	26	100	15	1	281	445027	444744	Spirosoma aureum strain BT328 chromosome, complete genome	blastn	41194	274	0.992700729927007	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma aureum
1295173	1295173	PRJEB12982_P_NODE_19362_length_163_cov_2.359649_g19199_i0	PRJEB12982	19362	163	2.359649	3.84622787	Cyclobacterium xiamenense	1297121	Bacteria	Bacteria	154	3.62e-33	NTclustered	gi\|2808418640\|gb\|CP159481.1\|	1297121	g19199	i0	83.951	289.80981595092	162	25	99	1	3	163	782055	781894	Cyclobacterium xiamenense strain ac3 chromosome, complete genome	blastn	47239	154	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Cyclobacterium	Cyclobacterium xiamenense
2260959	2260959	PRJEB12982_P_NODE_15782_length_173_cov_1.709677_g15619_i0	PRJEB12982	15782	173	1.709677	2.95774121	Chryseobacterium	59732	Bacteria	Bacteria	303	3.63e-78	NTclustered	gi\|1519537162\|gb\|CP033926.1\|	112234	g15619	i0	98.266	504.42774566474	173	3	100	0	1	173	2804103	2803931	Chryseobacterium joostei strain DSM 16927 chromosome, complete genome	blastn	87266	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium joostei
2570746	2570746	PRJEB12982_P_NODE_13143_length_193_cov_1.368056_g12980_i0	PRJEB12982	13143	193	1.368056	2.64034808	Spirosoma montaniterrae	1178516	Bacteria	Bacteria	291	3.2399999999999994e-74	NTclustered	gi\|1142450876\|gb\|CP014263.1\|	1178516	g12980	i0	94.764	616.020725388601	191	2	99	3	3	193	3065389	3065207	Spirosoma montaniterrae strain DY10 chromosome, complete genome	blastn	118892	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma montaniterrae
2570784	2570784	PRJEB12982_P_NODE_15423_length_176_cov_1.204724_g15260_i0	PRJEB12982	15423	176	1.204724	2.12031424	Runella sp. SP2	2268026	Bacteria	Bacteria	222	1.0699999999999999e-53	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g15260	i0	89.714	286.426136363636	175	16	99	2	1	174	5733327	5733154	Runella sp. SP2 chromosome, complete genome	blastn	50411	222	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
3536299	3536299	PRJEB12982_P_NODE_2663_length_473_cov_1.759434_g2502_i0	PRJEB12982	2663	473	1.759434	8.32212282	Chryseobacterium	59732	Bacteria	Bacteria	669	0	NTclustered	gi\|2429067237\|gb\|CP115859.1\|	1265445	g2502	i0	92.194	501.678646934461	474	36	100	1	1	473	1728174	1728647	Chryseobacterium camelliae strain VAN22-5A chromosome, complete genome	blastn	237294	669	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium camelliae
4813517	4813517	PRJEB12982_P_NODE_10844_length_214_cov_1.236364_g10681_i0	PRJEB12982	10844	214	1.236364	2.64581896	Fluviicola	332102	Bacteria	Bacteria	374	3.539999999999999e-99	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g10681	i0	98.131	413.242990654206	214	4	100	0	1	214	1623	1836	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	88434	374	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
5123240	5123240	PRJEB12982_P_NODE_11845_length_204_cov_1.316129_g11682_i0	PRJEB12982	11845	204	1.316129	2.68490316	Chryseobacterium gambrini	373672	Bacteria	Bacteria	377	2.59e-100	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g11682	i0	100	35.1078431372549	204	0	100	0	1	204	476894	477097	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	7162	377	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
5123454	5123454	PRJEB12982_P_NODE_8125_length_252_cov_1.758621_g7962_i0	PRJEB12982	8125	252	1.758621	4.43172492	Bacteroides faecium	2715212	Bacteria	Bacteria	329	9.43e-86	NTclustered	gi\|1828977791\|gb\|CP050831.1\|	2715212	g7962	i0	91.057	421.865079365079	246	18	99	4	9	252	2421527	2421284	Bacteroides faecium strain CBA7301 chromosome, complete genome	blastn	106310	329	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides faecium
6088786	6088786	PRJEB12982_P_NODE_13225_length_192_cov_1.923077_g13062_i0	PRJEB12982	13225	192	1.923077	3.69230784	Flavobacterium	237	Bacteria	Bacteria	158	3.41e-34	NTclustered	gi\|1057916935\|gb\|CP012388.1\|	96345	g13062	i0	81.865	564.03125	193	30	98	5	2	190	2972906	2973097	Flavobacterium psychrophilum strain Z1, complete genome	blastn	108294	158	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium psychrophilum
6088806	6088806	PRJEB12982_P_NODE_21085_length_161_cov_0.910714_g20922_i0	PRJEB12982	21085	161	0.910714	1.46624954	Fluviicola	332102	Bacteria	Bacteria	241	2.66e-59	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g20922	i0	93.789	15.944099378882	161	8	99	2	1	160	1477	1636	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	2567	241	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
7673135	7673135	PRJEB12982_P_NODE_17087_length_167_cov_0.864407_g16924_i0	PRJEB12982	17087	167	0.864407	1.44355969	Alistipes onderdonkii	328813	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1681981355\|dbj\|AP019737.1\|	2585117	g16924	i0	100	0.335329341317365	28	0	17	0	49	76	1259825	1259798	Alistipes onderdonkii subsp. vulgaris 5CPYCFAH4 DNA, complete genome	blastn	56	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Alistipes	Alistipes onderdonkii
8638792	8638792	PRJEB12982_P_NODE_8227_length_250_cov_1.940299_g8064_i0	PRJEB12982	8227	250	1.940299	4.8507475	Chryseobacterium	59732	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|2429074367\|gb\|CP115858.1\|	192389	g8064	i0	99.6	509.372	250	1	100	0	1	250	2626831	2627080	Chryseobacterium daecheongense strain PL22-22A chromosome, complete genome	blastn	127343	457	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium daecheongense
8947992	8947992	PRJEB12982_P_NODE_2528_length_486_cov_1.411899_g2367_i0	PRJEB12982	2528	486	1.411899	6.86182914	Spirosoma sp. KNUC1025	2894082	Bacteria	Bacteria	614	4.819999999999998e-171	NTclustered	gi\|2153997481\|gb\|CP087139.1\|	2894082	g2367	i0	89.571	431.20987654321	489	43	99	7	2	486	2541	2057	Spirosoma sp. KNUC1025 chromosome, complete genome	blastn	209568	614	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma sp. KNUC1025
10223768	10223768	PRJEB12982_P_NODE_3389_length_417_cov_1.817935_g3227_i0	PRJEB12982	3389	417	1.817935	7.58078895	Spirosoma rhododendri	2728024	Bacteria	Bacteria	477	5.589999999999999e-130	NTclustered	gi\|1835007590\|gb\|CP051677.1\|	2728024	g3227	i0	87.351	98.3525179856115	419	49	100	4	1	417	1401851	1401435	Spirosoma sp. CJU-R4 chromosome, complete genome	blastn	41013	477	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma rhododendri
11189044	11189044	PRJEB12982_P_NODE_9709_length_227_cov_1.146067_g9546_i0	PRJEB12982	9709	227	1.146067	2.60157209	Spirosoma	107	Bacteria	Bacteria	359	1.06e-94	NTclustered	gi\|1163018612\|gb\|CP020105.1\|	564064	g9546	i0	95.175	415.422907488987	228	9	100	2	1	227	1095269	1095043	Spirosoma rigui strain KCTC 12531 chromosome, complete genome	blastn	94301	359	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma rigui
11498874	11498874	PRJEB12982_P_NODE_11990_length_203_cov_1.045455_g11827_i0	PRJEB12982	11990	203	1.045455	2.12227365	uncultured Parabacteroides sp.	512312	Bacteria	Bacteria	235	1.6399999999999998e-57	NTclustered	gi\|453201738\|gb\|JQ999646.1\|	512312	g11827	i0	87.685	393.093596059113	203	23	99	2	1	202	263	464	Uncultured Parabacteroides sp. clone GKJWQY101AZHWU 23S ribosomal RNA gene, partial sequence	blastn	79798	235	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	uncultured Parabacteroides sp.
12464832	12464832	PRJEB12982_P_NODE_2830_length_458_cov_0.875306_g2669_i0	PRJEB12982	2830	458	0.875306	4.00890148	Bacteroidaceae	815	Bacteria	Bacteria	538	2.8e-148	NTclustered	gi\|2290744999\|gb\|CP103225.1\|	817	g2669	i0	88.017	523.355895196507	459	50	100	4	1	458	147914	147460	Bacteroides fragilis strain BFG-604 chromosome, complete genome	blastn	239697	540	0.996296296296296	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides fragilis
14048989	14048989	PRJEB12982_P_NODE_13192_length_193_cov_0.965278_g13029_i0	PRJEB12982	13192	193	0.965278	1.86298654	Spirosoma taeanense	2735870	Bacteria	Bacteria	270	4.22e-68	NTclustered	gi\|1843765704\|gb\|CP053435.1\|	2735870	g13029	i0	92.228	350.367875647668	193	11	100	3	1	193	3381034	3380846	Spirosoma taeanense strain TS118 chromosome, complete genome	blastn	67621	270	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma taeanense
14049132	14049132	PRJEB12982_P_NODE_2172_length_526_cov_4.553459_g132_i3	PRJEB12982	2172	526	4.553459	23.95119434	Tellurirhabdus bombi	2907205	Bacteria	Bacteria	544	6.98e-150	NTclustered	gi\|2179090906\|gb\|CP090557.1\|	2907205	g132	i3	85.606	295.568441064639	528	65	99	11	5	526	418651	418129	Tellurirhabdus bombi strain IE-0392 chromosome, complete genome	blastn	155469	544	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Tellurirhabdus	Tellurirhabdus bombi
15323246	15323246	PRJEB12982_P_NODE_8693_length_243_cov_1.164948_g8530_i0	PRJEB12982	8693	243	1.164948	2.83082364	Parabacteroides absconsus	2951805	Bacteria	Bacteria	233	7.289999999999999e-57	NTclustered	gi\|2695680047\|gb\|CP146284.1\|	2951805	g8530	i0	84.746	259	236	32	96	4	1	233	3663937	3664171	Parabacteroides absconsus strain AD58 chromosome, complete genome	blastn	62937	233	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides absconsus
16288392	16288392	PRJEB12982_P_NODE_21433_length_159_cov_2.318182_g21270_i0	PRJEB12982	21433	159	2.318182	3.68590938	Persicobacter	59740	Bacteria	Bacteria	111	2.14e-20	NTclustered	gi\|2581926559\|dbj\|AP025304.1\|	387638	g21270	i0	85.981	110.503144654088	107	11	66	4	55	159	9678	9782	Persicobacter psychrovividus NBRC 101262 plasmid pPPrrn DNA, complete genome	blastn	17570	111	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Persicobacteraceae	Persicobacter	Persicobacter psychrovividus
16597755	16597755	PRJEB12982_P_NODE_17634_length_166_cov_0.871795_g17471_i0	PRJEB12982	17634	166	0.871795	1.4471797	Chryseobacterium sp. ZHDP1	2838877	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|2046786976\|gb\|CP075682.1\|	2838877	g17471	i0	100	81.2228915662651	166	0	100	0	1	166	3241223	3241058	Chryseobacterium sp. ZHDP1 chromosome, complete genome	blastn	13483	307	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. ZHDP1
17563545	17563545	PRJEB12982_P_NODE_274_length_1454_cov_20.594306_g20_i2	PRJEB12982	274	1454	20.594306	299.44120924	Aquirufa	2676247	Bacteria	Bacteria	1727	0	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g20	i2	88.396	305.753782668501	1465	131	99	34	2	1445	360268	358822	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	444566	1727	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
18837479	18837479	PRJEB12982_P_NODE_1475_length_640_cov_4.228426_g132_i2	PRJEB12982	1475	640	4.228426	27.0619264	Cytophagales	768507	Bacteria	Bacteria	507	1.13e-138	NTclustered	gi\|38374131\|gb\|M62806.2\|FBCRRL	927664	g132	i2	81.034	424.2515625	638	110	99	11	10	640	503	1136	Flexibacter flexilis large subunit ribosomal RNA gene, partial sequence	blastn	271521	507	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flexibacteraceae	Flexibacter	Flexibacter flexilis
20112253	20112253	PRJEB12982_P_NODE_15916_length_172_cov_2.073171_g15753_i0	PRJEB12982	15916	172	2.073171	3.56585412	Chryseobacterium	59732	Bacteria	Bacteria	318	1.2899999999999999e-82	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g15753	i0	100	514.348837209302	172	0	100	0	1	172	1783660	1783831	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	88468	318	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
20421656	20421656	PRJEB12982_P_NODE_20537_length_162_cov_0.902655_g20374_i0	PRJEB12982	20537	162	0.902655	1.4623011	Flavobacterium sp. TR2	2977321	Bacteria	Bacteria	272	9.51e-69	NTclustered	gi\|2304704138\|gb\|CP104307.1\|	2977321	g20374	i0	96.914	9	162	5	100	0	1	162	2206025	2206186	Flavobacterium sp. TR2 chromosome, complete genome	blastn	1458	272	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. TR2
21387828	21387828	PRJEB12982_P_NODE_20637_length_162_cov_0.902655_g20474_i0	PRJEB12982	20637	162	0.902655	1.4623011	Fluviicola	332102	Bacteria	Bacteria	270	3.4199999999999993e-68	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g20474	i0	96.894	4.96913580246914	161	5	99	0	1	161	399	239	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	805	270	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
21697674	21697674	PRJEB12982_P_NODE_18878_length_164_cov_0.886957_g18715_i0	PRJEB12982	18878	164	0.886957	1.45460948	Hymenobacter aerilatus	2932251	Bacteria	Bacteria	254	3.5e-63	NTclustered	gi\|2221943441\|gb\|CP095053.1\|	2932251	g18715	i0	94.512	187.335365853659	164	9	100	0	1	164	662331	662494	Hymenobacter aerilatus strain 5413 J-13 chromosome, complete genome	blastn	30723	254	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter aerilatus
21697765	21697765	PRJEB12982_P_NODE_6978_length_276_cov_0.898678_g6815_i0	PRJEB12982	6978	276	0.898678	2.48035128	Chryseobacterium gambrini	373672	Bacteria	Bacteria	510	3.48e-140	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g6815	i0	100	80.036231884058	276	0	100	0	1	276	2223564	2223839	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	22090	510	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
22972909	22972909	PRJEB12982_P_NODE_17539_length_166_cov_0.871795_g17376_i0	PRJEB12982	17539	166	0.871795	1.4471797	uncultured Polaribacter sp.	174711	Bacteria	Bacteria	132	1.74e-26	NTclustered	gi\|2308952735\|emb\|OX044355.1\|	174711	g17376	i0	81.935	16.4939759036145	155	28	93	0	3	157	372255	372101	MAG: uncultured Polaribacter sp. isolate AJ_MB356 genome assembly, chromosome: AJ_MB356_contig-1	blastn	2738	132	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Polaribacter	uncultured Polaribacter sp.
22972926	22972926	PRJEB12982_P_NODE_18579_length_165_cov_0.879310_g18416_i0	PRJEB12982	18579	165	0.87931	1.4508615	Chryseobacterium gambrini	373672	Bacteria	Bacteria	300	4.46e-77	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g18416	i0	99.394	6.34545454545455	165	1	100	0	1	165	31168	31004	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	1047	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini

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