metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA559720" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA559720" 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
543424	543424	PRJNA559720_P_NODE_11481_length_282_cov_1.248804_g11342_i0	PRJNA559720	11481	282	1.248804	3.52162728	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	468	2.18e-127	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g11342	i0	96.786	357.932624113475	280	9	99	0	1	280	338064	338343	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	100937	468	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128
1819175	1819175	PRJNA559720_P_NODE_12662_length_263_cov_1.621053_g12523_i0	PRJNA559720	12662	263	1.621053	4.26336939	Flavobacterium sp. GSB-24	2994319	Bacteria	Bacteria	481	2.58e-131	NTclustered	gi\|2415636785\|dbj\|AP027043.1\|	2994319	g12523	i0	99.62	550.988593155894	263	1	100	0	1	263	21860	22122	Flavobacterium sp. GSB-24 DNA, complete genome	blastn	144910	481	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. GSB-24
1819214	1819214	PRJNA559720_P_NODE_16282_length_241_cov_0.916667_g16143_i0	PRJNA559720	16282	241	0.916667	2.20916747	Pedobacter sp. SL55	2995161	Bacteria	Bacteria	407	4.0199999999999995e-109	NTclustered	gi\|2381133349\|gb\|CP113059.1\|	2995161	g16143	i0	97.095	341.502074688797	241	7	100	0	1	241	517785	517545	Pedobacter sp. SL55 chromosome	blastn	82302	407	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. SL55
3094527	3094527	PRJNA559720_P_NODE_4283_length_503_cov_1.648837_g4146_i0	PRJNA559720	4283	503	1.648837	8.29365011	Chlorobiota bacterium	2268192	Bacteria	Bacteria	52.8	0.049	NTclustered	gi\|1958119998\|gb\|CP065014.1\|	2268192	g4146	i0	100	0.0556660039761431	28	0	6	0	142	169	2211294	2211321	MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
4371012	4371012	PRJNA559720_P_NODE_7664_length_365_cov_1.181507_g7525_i0	PRJNA559720	7664	365	1.181507	4.31250055	Polaribacter litorisediminis	1908341	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|2094553133\|gb\|CP082966.1\|	1908341	g7525	i0	100	0.0767123287671233	28	0	8	0	214	241	23344	23317	Polaribacter litorisediminis strain OITF-11 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Polaribacter	Polaribacter litorisediminis
5647294	5647294	PRJNA559720_P_NODE_10205_length_304_cov_1.025974_g10066_i0	PRJNA559720	10205	304	1.025974	3.11896096	Flavobacterium sp. KBS0721	1179672	Bacteria	Bacteria	540	4.96e-149	NTclustered	gi\|1712897335\|gb\|CP042170.1\|	1179672	g10066	i0	98.684	508.805921052632	304	4	100	0	1	304	24538	24235	Flavobacterium sp. KBS0721 chromosome, complete genome	blastn	154677	540	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. KBS0721
5647340	5647340	PRJNA559720_P_NODE_13925_length_250_cov_0.870056_g13786_i0	PRJNA559720	13925	250	0.870056	2.17514	Prevotella histicola	470565	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|2913588672\|gb\|CP181053.1\|	470565	g13786	i0	99.6	23.636	250	1	100	0	1	250	51521	51770	Prevotella histicola strain T05-04 chromosome 2, complete sequence	blastn	5909	457	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella histicola
8196501	8196501	PRJNA559720_P_NODE_4667_length_482_cov_2.356968_g4529_i0	PRJNA559720	4667	482	2.356968	11.36058576	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	741	0	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g4529	i0	94.421	237.197095435685	484	23	100	4	1	482	2978105	2977624	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	114329	741	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
9472121	9472121	PRJNA559720_P_NODE_15608_length_244_cov_0.883041_g15469_i0	PRJNA559720	15608	244	0.883041	2.15462004	Prevotella sp. oral taxon 299	652716	Bacteria	Bacteria	424	4.05e-114	NTclustered	gi\|532125950\|gb\|CP003666.1\|	575614	g15469	i0	97.951	1	244	5	100	0	1	244	450705	450948	Prevotella sp. oral taxon 299 str. F0039, complete genome	blastn	244	424	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. oral taxon 299
9472129	9472129	PRJNA559720_P_NODE_16308_length_241_cov_0.916667_g16169_i0	PRJNA559720	16308	241	0.916667	2.20916747	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	425	1.11e-114	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g16169	i0	100	292.734439834025	230	0	95	0	12	241	338701	338930	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	70549	425	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128
11333521	11333521	PRJNA559720_P_NODE_14389_length_248_cov_0.880000_g14250_i0	PRJNA559720	14389	248	0.88	2.1824	Hoylesella	2974257	Bacteria	Bacteria	403	5.38e-108	NTclustered	gi\|2127571982\|gb\|CP085926.1\|	28127	g14250	i0	95.968	2	248	10	100	0	1	248	1270412	1270165	Hoylesella buccalis strain FDAARGOS_1588 chromosome, complete genome	blastn	496	403	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Hoylesella	Hoylesella buccalis
12022538	12022538	PRJNA559720_P_NODE_10050_length_307_cov_1.316239_g9911_i0	PRJNA559720	10050	307	1.316239	4.04085373	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	484	2.3799999999999994e-132	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g9911	i0	95.425	367.130293159609	306	10	99	3	1	305	1235729	1235427	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	112709	484	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.
12609329	12609329	PRJNA559720_P_NODE_15330_length_245_cov_0.895349_g15191_i0	PRJNA559720	15330	245	0.895349	2.19360505	Cloacibacterium	501783	Bacteria	Bacteria	303	5.53e-78	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g15191	i0	98.824	2.71836734693878	170	2	69	0	76	245	1574967	1575136	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	666	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
13297589	13297589	PRJNA559720_P_NODE_13691_length_251_cov_0.865169_g13552_i0	PRJNA559720	13691	251	0.865169	2.17157419	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	243	1.2600000000000001e-59	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g13552	i0	84.898	5.89641434262948	245	31	96	5	3	244	631833	632074	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	1480	243	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
13297630	13297630	PRJNA559720_P_NODE_2651_length_628_cov_1.754955_g2531_i0	PRJNA559720	2651	628	1.754955	11.0211174	Flammeovirga sp. MY04	1191459	Bacteria	Bacteria	56.5	0.005	NTclustered	gi\|1834190374\|gb\|CP003561.2\|	1191459	g2531	i0	96.97	0.0525477707006369	33	1	5	0	544	576	1248424	1248456	Flammeovirga sp. MY04 chromosome 2, complete sequence	blastn	33	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae	Flammeovirga	Flammeovirga sp. MY04
13297661	13297661	PRJNA559720_P_NODE_5331_length_448_cov_3.432000_g5192_i0	PRJNA559720	5331	448	3.432	15.37536	Panacibacter ginsenosidivorans	1813871	Bacteria	Bacteria	614	4.409999999999999e-171	NTclustered	gi\|1721657344\|gb\|CP042435.1\|	1813871	g5192	i0	91.518	209.508928571429	448	34	100	3	1	448	1672147	1672590	Panacibacter ginsenosidivorans strain Gsoil1550 chromosome, complete genome	blastn	93860	614	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Panacibacter	Panacibacter ginsenosidivorans
13884230	13884230	PRJNA559720_P_NODE_5751_length_429_cov_3.398876_g5612_i0	PRJNA559720	5751	429	3.398876	14.58117804	Sediminibacterium	504481	Bacteria	Bacteria	730	0	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g5612	i0	97.448	254.780885780886	431	6	100	5	1	429	55310	54883	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	109301	730	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
15158433	15158433	PRJNA559720_P_NODE_6992_length_385_cov_2.096154_g6853_i0	PRJNA559720	6992	385	2.096154	8.0701929	Sediminibacterium	504481	Bacteria	Bacteria	695	0	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g6853	i0	99.221	282.057142857143	385	3	100	0	1	385	56324	55940	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	108592	695	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
15846442	15846442	PRJNA559720_P_NODE_8793_length_334_cov_3.992337_g8654_i0	PRJNA559720	8793	334	3.992337	13.33440558	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	551	2.549999999999999e-152	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g8654	i0	97.806	262.458083832335	319	7	96	0	1	319	2978492	2978174	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	87661	551	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
17121271	17121271	PRJNA559720_P_NODE_4574_length_487_cov_1.480676_g4436_i0	PRJNA559720	4574	487	1.480676	7.21089212	Pedobacter sp. SL55	2995161	Bacteria	Bacteria	798	0	NTclustered	gi\|2381133349\|gb\|CP113059.1\|	2995161	g4436	i0	96.311	72.4086242299795	488	15	100	3	1	487	4886	5371	Pedobacter sp. SL55 chromosome	blastn	35263	798	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. SL55
20945675	20945675	PRJNA559720_P_NODE_11977_length_274_cov_1.283582_g11838_i0	PRJNA559720	11977	274	1.283582	3.51701468	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	322	1.74e-83	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g11838	i0	89.147	0.941605839416058	258	28	94	0	17	274	4337971	4338228	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	258	322	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
22220623	22220623	PRJNA559720_P_NODE_16598_length_204_cov_184.320611_g16459_i0	PRJNA559720	16598	204	184.320611	376.01404644	Chryseobacterium gallinarum	1324352	Bacteria	Bacteria	165	2.19e-36	NTclustered	gi\|1830200908\|gb\|CP050996.1\|	1324352	g16459	i0	98.925	3.92156862745098	93	0	63	1	76	167	1161	1069	Chryseobacterium gallinarum strain FDAARGOS_636 plasmid unnamed2	blastn	800	165	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gallinarum

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