metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA453567" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA453567" 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
441777	441777	PRJNA453567_P_NODE_13221_length_253_cov_1.083333_g12984_i0	PRJNA453567	13221	253	1.083333	2.74083249	Spirosoma aerolatum	1211326	Bacteria	Bacteria	440	4.189999999999998e-119	NTclustered	gi\|1163013319\|gb\|CP020104.1\|	1211326	g12984	i0	98.024	416.774703557312	253	5	100	0	1	253	755485	755233	Spirosoma aerolatum strain KACC 17939 chromosome, complete genome	blastn	105444	440	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma aerolatum
441841	441841	PRJNA453567_P_NODE_23001_length_183_cov_1.815068_g22764_i0	PRJNA453567	23001	183	1.815068	3.32157444	Spirosoma aerolatum	1211326	Bacteria	Bacteria	265	1.84e-66	NTclustered	gi\|1163013319\|gb\|CP020104.1\|	1211326	g22764	i0	93.011	183.371584699454	186	6	100	6	1	183	753507	753326	Spirosoma aerolatum strain KACC 17939 chromosome, complete genome	blastn	33557	265	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma aerolatum
1716621	1716621	PRJNA453567_P_NODE_12682_length_259_cov_1.256757_g12445_i0	PRJNA453567	12682	259	1.256757	3.25500063	Nonlabens ponticola	2496866	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1542006573\|gb\|CP034549.1\|	2496866	g12445	i0	100	0.787644787644788	30	0	12	0	139	168	1183874	1183903	Nonlabens ponticola strain MJ115 chromosome, complete genome	blastn	204	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Nonlabens	Nonlabens ponticola
1716727	1716727	PRJNA453567_P_NODE_28682_length_164_cov_0.889764_g28445_i0	PRJNA453567	28682	164	0.889764	1.45921296	uncultured candidate division Zixibacteria bacterium	1664345	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2621704311\|emb\|OY760907.1\|	1664345	g28445	i0	96.774	0.189024390243902	31	1	19	0	115	145	2676565	2676535	MAG: uncultured candidate division Zixibacteria bacterium isolate 2d357583-1faf-4436-89ad-6f0e4817d39a genome assembly, chromosome: 1	blastn	31	52.8	1	Bacteria	FCB group	Pseudomonadati	Candidatus Zixiibacteriota					uncultured candidate division Zixibacteria bacterium
3644396	3644396	PRJNA453567_P_NODE_1683_length_896_cov_2.904540_g1547_i0	PRJNA453567	1683	896	2.90454	26.0246784	Spirosoma	107	Bacteria	Bacteria	1022	0	NTclustered	gi\|283814236\|gb\|CP001769.1\|	504472	g1547	i0	87.668	318.138392857143	892	93	98	13	15	896	3192024	3192908	Spirosoma linguale DSM 74, complete genome	blastn	285052	1022	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma linguale
3644447	3644447	PRJNA453567_P_NODE_9303_length_313_cov_1.123188_g9066_i0	PRJNA453567	9303	313	1.123188	3.51557844	Hymenobacter	89966	Bacteria	Bacteria	132	3.66e-26	NTclustered	gi\|926465561\|gb\|CP012623.1\|	1385663	g9066	i0	80	21.5495207667732	180	34	57	2	33	211	1058920	1058742	Hymenobacter sp. DG25A, complete genome	blastn	6745	132	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. DG25A
4921511	4921511	PRJNA453567_P_NODE_22224_length_186_cov_2.275168_g21987_i0	PRJNA453567	22224	186	2.275168	4.23181248	Cytophagales	768507	Bacteria	Bacteria	279	6.7000000000000014e-71	NTclustered	gi\|384064804\|emb\|HE796683.1\|	1166018	g21987	i0	93.617	314.704301075269	188	10	100	2	1	186	610406	610219	Fibrella aestuarina BUZ 2 drat genome	blastn	58535	281	0.99288256227758	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Fibrella	Fibrella aestuarina
5545549	5545549	PRJNA453567_P_NODE_23565_length_181_cov_1.354167_g23328_i0	PRJNA453567	23565	181	1.354167	2.45104227	Chitinophaga caseinilytica	2267521	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2719403661\|gb\|CP150096.1\|	2267521	g23328	i0	100	0.154696132596685	28	0	15	0	114	141	310395	310422	Chitinophaga caseinilytica strain KACC 19118 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga caseinilytica
6196453	6196453	PRJNA453567_P_NODE_33065_length_152_cov_2.043478_g32828_i0	PRJNA453567	33065	152	2.043478	3.10608656	Fluviicola	332102	Bacteria	Bacteria	259	6.82e-65	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g32828	i0	97.368	406.967105263158	152	4	100	0	1	152	1623	1774	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	61859	259	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
9369689	9369689	PRJNA453567_P_NODE_23388_length_182_cov_1.062069_g23151_i0	PRJNA453567	23388	182	1.062069	1.93296558	Belliella baltica	232259	Bacteria	Bacteria	110	9.06e-20	NTclustered	gi\|390415094\|gb\|CP003281.1\|	866536	g23151	i0	83.193	5.12637362637363	119	20	65	0	1	119	3702549	3702431	Belliella baltica DSM 15883, complete genome	blastn	933	110	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Belliella	Belliella baltica
11920656	11920656	PRJNA453567_P_NODE_28210_length_165_cov_1.218750_g27973_i0	PRJNA453567	28210	165	1.21875	2.0109375	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	111	2.24e-20	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g27973	i0	80	54.5393939393939	155	28	93	3	1	154	1524637	1524789	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	8999	111	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
13195421	13195421	PRJNA453567_P_NODE_21051_length_192_cov_1.722581_g20814_i0	PRJNA453567	21051	192	1.722581	3.30735552	Fibrella aestuarina	651143	Bacteria	Bacteria	294	2.49e-75	NTclustered	gi\|384064804\|emb\|HE796683.1\|	1166018	g20814	i0	94.271	314.635416666667	192	11	100	0	1	192	610807	610998	Fibrella aestuarina BUZ 2 drat genome	blastn	60410	294	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Fibrella	Fibrella aestuarina
15744524	15744524	PRJNA453567_P_NODE_4593_length_487_cov_2.584444_g4360_i0	PRJNA453567	4593	487	2.584444	12.58624228	Spirosoma taeanense	2735870	Bacteria	Bacteria	468	3.98e-127	NTclustered	gi\|1843765704\|gb\|CP053435.1\|	2735870	g4360	i0	85.558	386.681724845996	457	54	93	12	37	487	5430938	5430488	Spirosoma taeanense strain TS118 chromosome, complete genome	blastn	188314	468	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma taeanense
16395980	16395980	PRJNA453567_P_NODE_14293_length_240_cov_1.719212_g14056_i0	PRJNA453567	14293	240	1.719212	4.1261088	FCB group	1783270	Bacteria	Bacteria	444	3.05e-120	NTclustered	gi\|1242562181\|gb\|CP022385.1\|	1019	g14056	i0	100	103	240	0	100	0	1	240	811218	811457	Capnocytophaga sputigena strain KC1668 chromosome, complete genome	blastn	24720	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga sputigena
18293527	18293527	PRJNA453567_P_NODE_31455_length_156_cov_1.638655_g31218_i0	PRJNA453567	31455	156	1.638655	2.5563018	Cruoricaptor ignavus	1118202	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2831273061\|gb\|CP171011.1\|	1118202	g31218	i0	100	0.358974358974359	28	0	18	0	110	137	526210	526237	Cruoricaptor ignavus strain WGS2074 chromosome, complete genome	blastn	56	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cruoricaptor	Cruoricaptor ignavus
21495198	21495198	PRJNA453567_P_NODE_10937_length_282_cov_3.722449_g10700_i0	PRJNA453567	10937	282	3.722449	10.49730618	Weeksellaceae	2762318	Bacteria	Bacteria	163	1.15e-35	NTclustered	gi\|1750497007\|gb\|CP043634.1\|	247	g10700	i0	81.481	160.783687943262	216	24	74	10	73	272	229793	230008	Empedobacter brevis strain SE1-3 chromosome, complete genome	blastn	45341	163	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter brevis
21495220	21495220	PRJNA453567_P_NODE_257_length_1903_cov_12.428189_g199_i1	PRJNA453567	257	1903	12.428189	236.50843667	Aquirufa	2676247	Bacteria	Bacteria	2026	0	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g199	i1	86.314	265.134524435102	1907	207	99	48	29	1903	2694998	2693114	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	504551	2026	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
22118354	22118354	PRJNA453567_P_NODE_26638_length_170_cov_1.165414_g26401_i0	PRJNA453567	26638	170	1.165414	1.9812038	Hymenobacter swuensis	1446467	Bacteria	Bacteria	95.3	2.33e-15	NTclustered	gi\|586953861\|gb\|CP007145.1\|	1227739	g26401	i0	79.021	7.94117647058824	143	26	83	3	29	169	1368460	1368320	Hymenobacter swuensis DY53, complete genome	blastn	1350	95.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter swuensis
22770357	22770357	PRJNA453567_P_NODE_218_length_1974_cov_17.929272_g199_i0	PRJNA453567	218	1974	17.929272	353.92382928	Aquirufa	2676247	Bacteria	Bacteria	2143	0	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g199	i0	87.284	486.622593718338	1911	199	96	38	1	1886	360544	358653	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	960593	2145	0.999067599067599	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
23394096	23394096	PRJNA453567_P_NODE_33899_length_150_cov_2.176991_g33662_i0	PRJNA453567	33899	150	2.176991	3.2654865	Runella sp. SP2	2268026	Bacteria	Bacteria	178	1.93e-40	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g33662	i0	88.079	261.966666666667	151	16	100	2	1	150	5733312	5733163	Runella sp. SP2 chromosome, complete genome	blastn	39295	178	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
24668105	24668105	PRJNA453567_P_NODE_6000_length_409_cov_3.981183_g5764_i0	PRJNA453567	6000	409	3.981183	16.28303847	Candidatus Fluviicola riflensis	1798018	Bacteria	Bacteria	571	2.4399999999999993e-158	NTclustered	gi\|1229046090\|gb\|CP022585.1\|	1798018	g5764	i0	91.912	294.799511002445	408	33	99	0	1	408	786301	786708	Candidatus Fluviicola riflensis chromosome, complete genome	blastn	120573	571	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Candidatus Fluviicola riflensis

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