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

24 rows where analysis = "blastn", bioproject = "PRJNA1262902" 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
363479	363479	PRJNA1262902_P_NODE_11301_length_243_cov_0.905882_g11259_i0	PRJNA1262902	11301	243	0.905882	2.20129326	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	119	2.13e-22	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g11259	i0	82.482	1.2798353909465	137	22	56	2	95	230	3591900	3591765	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	311	119	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
2914234	2914234	PRJNA1262902_P_NODE_143_length_981_cov_2.647577_g116_i0	PRJNA1262902	143	981	2.647577	25.97273037	Hymenobacter volaticus	2932254	Bacteria	Bacteria	1701	0	NTclustered	gi\|2221934578\|gb\|CP095067.1\|	2932254	g116	i0	97.965	285.439347604485	983	17	100	3	1	981	64477	63496	Hymenobacter volaticus strain 5420 S-77 plasmid unnamed6, complete sequence	blastn	280016	1701	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter volaticus
2914273	2914273	PRJNA1262902_P_NODE_7703_length_251_cov_0.865169_g7661_i0	PRJNA1262902	7703	251	0.865169	2.17157419	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	263	9.65e-66	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g7661	i0	86.345	1.21513944223108	249	25	98	9	3	248	1712695	1712453	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	305	263	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
2914276	2914276	PRJNA1262902_P_NODE_7943_length_250_cov_0.870056_g7901_i0	PRJNA1262902	7943	250	0.870056	2.17514	Sphingobacterium daejeonense	371142	Bacteria	Bacteria	448	2.4699999999999996e-121	NTclustered	gi\|1639029986\|emb\|LR590470.1\|	371142	g7901	i0	98.81	1.008	252	1	100	1	1	250	370122	370373	Sphingobacterium daejeonense strain NCTC13534 genome assembly, chromosome: 1	blastn	252	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium daejeonense
2914286	2914286	PRJNA1262902_P_NODE_8863_length_248_cov_0.880000_g8821_i0	PRJNA1262902	8863	248	0.88	2.1824	Chryseobacterium indologenes	253	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1519580736\|gb\|CP033930.1\|	253	g8821	i0	100	10.9879032258065	248	0	100	0	1	248	4724376	4724129	Chryseobacterium indologenes strain H5559 chromosome, complete genome	blastn	2725	459	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
4882013	4882013	PRJNA1262902_P_NODE_9904_length_246_cov_0.890173_g9862_i0	PRJNA1262902	9904	246	0.890173	2.18982558	FCB group	1783270	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2844596544\|gb\|CP172416.1\|	29549	g9862	i0	96.875	0.386178861788618	32	0	13	1	50	80	2882913	2882882	Rhodothermus marinus strain ISCAR-493 chromosome	blastn	95	52.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
5466893	5466893	PRJNA1262902_P_NODE_8465_length_249_cov_0.875000_g8423_i0	PRJNA1262902	8465	249	0.875	2.17875	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	243	1.25e-59	NTclustered	gi\|575461033\|gb\|CP007129.1\|	861299	g8423	i0	85.776	0.931726907630522	232	29	92	4	8	237	313558	313787	Gemmatirosa kalamazoonesis strain KBS708 plasmid 1, complete sequence	blastn	232	243	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
6741275	6741275	PRJNA1262902_P_NODE_10926_length_244_cov_0.900585_g10884_i0	PRJNA1262902	10926	244	0.900585	2.1974274	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	324	4.22e-84	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g10884	i0	91.489	1.11065573770492	235	20	96	0	10	244	4597031	4597265	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	271	324	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
6741342	6741342	PRJNA1262902_P_NODE_7606_length_251_cov_0.865169_g7564_i0	PRJNA1262902	7606	251	0.865169	2.17157419	Chryseobacterium sp. CY350	2997336	Bacteria	Bacteria	263	9.65e-66	NTclustered	gi\|2430443073\|gb\|CP116034.1\|	2997336	g7564	i0	85.83	15.4980079681275	247	35	98	0	5	251	598711	598465	Chryseobacterium sp. CY350 chromosome, complete genome	blastn	3890	263	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. CY350
8016894	8016894	PRJNA1262902_P_NODE_12127_length_241_cov_0.916667_g12085_i0	PRJNA1262902	12127	241	0.916667	2.20916747	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	368	1.9e-97	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g12085	i0	94.191	94.9294605809129	241	14	100	0	1	241	4372589	4372349	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	22878	368	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
8016932	8016932	PRJNA1262902_P_NODE_5207_length_276_cov_1.152709_g5165_i0	PRJNA1262902	5207	276	1.152709	3.18147684	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	309	1.36e-79	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g5165	i0	87.004	4.89855072463768	277	32	99	4	1	275	3006274	3006548	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	1352	309	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
9291706	9291706	PRJNA1262902_P_NODE_7888_length_250_cov_0.870056_g7846_i0	PRJNA1262902	7888	250	0.870056	2.17514	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	204	5.909999999999999e-48	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g7846	i0	87.222	8.748	180	22	72	1	36	214	2345876	2345697	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	2187	204	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
9291727	9291727	PRJNA1262902_P_NODE_9268_length_247_cov_0.885057_g9226_i0	PRJNA1262902	9268	247	0.885057	2.18609079	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	337	5.5e-88	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g9226	i0	91.429	1.417004048583	245	21	99	0	3	247	4208997	4208753	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	350	337	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
10567666	10567666	PRJNA1262902_P_NODE_7609_length_251_cov_0.865169_g7567_i0	PRJNA1262902	7609	251	0.865169	2.17157419	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	348	2.5900000000000005e-91	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g7567	i0	93.913	0.916334661354582	230	14	92	0	16	245	2686370	2686599	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	230	348	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
11842160	11842160	PRJNA1262902_P_NODE_10910_length_244_cov_0.900585_g10868_i0	PRJNA1262902	10910	244	0.900585	2.1974274	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	134	7.640000000000001e-27	NTclustered	gi\|575461033\|gb\|CP007129.1\|	861299	g10868	i0	89.623	0.807377049180328	106	9	43	2	26	130	289108	289004	Gemmatirosa kalamazoonesis strain KBS708 plasmid 1, complete sequence	blastn	197	134	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
15666413	15666413	PRJNA1262902_P_NODE_1613_length_376_cov_6.372937_g1571_i0	PRJNA1262902	1613	376	6.372937	23.96224312	Flavobacterium fluviale	2249356	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|1421732866\|gb\|CP030261.1\|	2249356	g1571	i0	100	0.0771276595744681	29	0	8	0	343	371	115149	115121	Flavobacterium fluviale strain HYN0086 chromosome, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium fluviale
16940805	16940805	PRJNA1262902_P_NODE_7314_length_251_cov_1.556180_g7272_i0	PRJNA1262902	7314	251	1.55618	3.9060118	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	193	1.28e-44	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g7272	i0	87.952	4.51792828685259	166	17	65	3	1	163	2780364	2780529	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	1134	193	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
18215314	18215314	PRJNA1262902_P_NODE_8555_length_249_cov_0.875000_g8513_i0	PRJNA1262902	8555	249	0.875	2.17875	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	246	9.629999999999999e-61	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g8513	i0	84.8	56.1204819277108	250	33	99	5	1	247	1178063	1177816	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	13974	246	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
18215317	18215317	PRJNA1262902_P_NODE_8755_length_248_cov_0.880000_g8713_i0	PRJNA1262902	8755	248	0.88	2.1824	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	180	9.859999999999999e-41	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g8713	i0	84.916	10.883064516129	179	25	72	2	1	178	4557345	4557168	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	2699	180	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20765078	20765078	PRJNA1262902_P_NODE_2017_length_352_cov_1.347670_g1975_i0	PRJNA1262902	2017	352	1.34767	4.7437984	Chitinophagaceae bacterium LGM1	2837399	Bacteria	Bacteria	444	4.699999999999998e-120	NTclustered	gi\|2046997110\|gb\|CP075895.1\|	2837399	g1975	i0	90.719	222.068181818182	334	29	94	2	8	339	1076929	1076596	Chitinophagaceae bacterium LGM1 chromosome, complete genome	blastn	78168	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium LGM1
22040192	22040192	PRJNA1262902_P_NODE_2518_length_332_cov_2.675676_g2476_i0	PRJNA1262902	2518	332	2.675676	8.88324432	Hymenobacter tibetensis	497967	Bacteria	Bacteria	608	1.479999999999999e-169	NTclustered	gi\|2218432809\|gb\|CP094673.1\|	497967	g2476	i0	99.699	267.551204819277	332	1	100	0	1	332	59235	59566	Hymenobacter tibetensis strain KACC 21982 plasmid unnamed4, complete sequence	blastn	88827	608	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter tibetensis
23315679	23315679	PRJNA1262902_P_NODE_1919_length_357_cov_2.309859_g1877_i0	PRJNA1262902	1919	357	2.309859	8.24619663	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	545	1.27e-150	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g1877	i0	94.15	10.8487394957983	359	19	100	1	1	357	3149230	3149588	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	3873	545	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3
23315740	23315740	PRJNA1262902_P_NODE_9719_length_246_cov_0.890173_g9677_i0	PRJNA1262902	9719	246	0.890173	2.18982558	uncultured Flavobacteriaceae bacterium	165436	Bacteria	Bacteria	255	1.58e-63	NTclustered	gi\|921059534\|gb\|KP887319.1\|	165436	g9677	i0	90.452	125.40243902439	199	11	78	8	42	233	1811	1614	Uncultured Flavobacteriaceae bacterium clone 201_DPL 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	30849	255	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		uncultured Flavobacteriaceae bacterium
24005988	24005988	PRJNA1262902_P_NODE_5999_length_265_cov_2.328125_g5957_i0	PRJNA1262902	5999	265	2.328125	6.16953125	Fluviicola	332102	Bacteria	Bacteria	333	7.719999999999999e-87	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g5957	i0	93.363	213.139622641509	226	14	85	1	17	242	1431	1207	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	56482	335	0.994029850746269	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis

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