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

21 rows where analysis = "blastn", bioproject = "PRJNA950981" 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
2209141	2209141	PRJNA950981_P_NODE_12362_length_292_cov_1.424658_g12186_i0	PRJNA950981	12362	292	1.424658	4.16000136	Solitalea lacus	2911172	Bacteria	Bacteria	363	1.1e-95	NTclustered	gi\|2189814522\|gb\|CP091740.1\|	2911172	g12186	i0	89.116	311.715753424658	294	29	100	3	1	292	1056596	1056304	Solitalea lacus strain S2-8 chromosome	blastn	91021	363	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Solitalea	Solitalea lacus
3814553	3814553	PRJNA950981_P_NODE_2343_length_622_cov_1.693989_g2170_i0	PRJNA950981	2343	622	1.693989	10.53661158	Aquirufa	2676247	Bacteria	Bacteria	721	0	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g2170	i0	87.961	163	623	59	99	16	1	615	360476	359862	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	101386	726	0.993112947658402	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
4762253	4762253	PRJNA950981_P_NODE_2064_length_655_cov_1.738832_g1891_i0	PRJNA950981	2064	655	1.738832	11.3893496	Candidatus Fluviicola riflensis	1798018	Bacteria	Bacteria	957	0	NTclustered	gi\|1229046090\|gb\|CP022585.1\|	1798018	g1891	i0	92.998	414.61679389313	657	44	100	2	1	655	786301	786957	Candidatus Fluviicola riflensis chromosome, complete genome	blastn	271574	957	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Candidatus Fluviicola riflensis
6036981	6036981	PRJNA950981_P_NODE_18305_length_249_cov_0.886364_g18129_i0	PRJNA950981	18305	249	0.886364	2.20704636	Cloacibacterium normanense	237258	Bacteria	Bacteria	265	2.6599999999999997e-66	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g18129	i0	89.202	3.69879518072289	213	21	85	2	1	212	39058	39269	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	921	265	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
6036984	6036984	PRJNA950981_P_NODE_19165_length_247_cov_1.293103_g18989_i0	PRJNA950981	19165	247	1.293103	3.19396441	Chryseobacterium gambrini	373672	Bacteria	Bacteria	424	4.1099999999999996e-114	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g18989	i0	97.571	5.95546558704453	247	6	100	0	1	247	4051950	4052196	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	1471	424	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
6036986	6036986	PRJNA950981_P_NODE_19645_length_246_cov_0.901734_g19469_i0	PRJNA950981	19645	246	0.901734	2.21826564	Chryseobacterium gambrini	373672	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g19469	i0	99.187	20.7764227642276	246	2	100	0	1	246	763790	764035	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	5111	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
6366564	6366564	PRJNA950981_P_NODE_16285_length_254_cov_1.723757_g16109_i0	PRJNA950981	16285	254	1.723757	4.37834278	Flavobacteriaceae	49546	Bacteria	Bacteria	390	4.299999999999999e-104	NTclustered	gi\|753770668\|gb\|CP010817.1\|	480520	g16109	i0	95.51	621.885826771654	245	10	98	1	11	254	798472	798228	Myroides profundi strain D25, complete genome	blastn	157959	392	0.994897959183674	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides profundi
8915247	8915247	PRJNA950981_P_NODE_12547_length_290_cov_1.437788_g12371_i0	PRJNA950981	12547	290	1.437788	4.1695852	Sediminibacterium	504481	Bacteria	Bacteria	370	6.53e-98	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g12371	i0	89.655	212.744827586207	290	30	100	0	1	290	54484	54195	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	61696	370	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
9861863	9861863	PRJNA950981_P_NODE_1748_length_715_cov_1.334891_g1582_i0	PRJNA950981	1748	715	1.334891	9.54447065	Aurantibacillus circumpalustris	3036359	Bacteria	Bacteria	843	0	NTclustered	gi\|2482055248\|gb\|CP121197.1\|	3036359	g1582	i0	88.178	323.055944055944	719	69	99	14	1	714	2011890	2012597	Aurantibacillus circumpalustris strain Swamp196 chromosome, complete genome	blastn	230985	843	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Aurantibacillaceae	Aurantibacillus	Aurantibacillus circumpalustris
11137473	11137473	PRJNA950981_P_NODE_16429_length_253_cov_1.472222_g16253_i0	PRJNA950981	16429	253	1.472222	3.72472166	Chryseobacterium sp. ZHDP1	2838877	Bacteria	Bacteria	455	1.5e-123	NTclustered	gi\|2046786976\|gb\|CP075682.1\|	2838877	g16253	i0	99.206	93.7312252964427	252	2	99	0	2	253	3586100	3585849	Chryseobacterium sp. ZHDP1 chromosome, complete genome	blastn	23714	455	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. ZHDP1
11466280	11466280	PRJNA950981_P_NODE_16149_length_255_cov_2.142857_g15973_i0	PRJNA950981	16149	255	2.142857	5.46428535	Flavobacterium	237	Bacteria	Bacteria	438	1.52e-118	NTclustered	gi\|2223843353\|gb\|CP090145.1\|	2024526	g15973	i0	97.647	496.725490196078	255	6	100	0	1	255	702005	702259	Flavobacterium sediminilitoris strain YSM-43 chromosome, complete genome	blastn	126665	438	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sediminilitoris
12412938	12412938	PRJNA950981_P_NODE_14810_length_268_cov_1.215385_g14634_i0	PRJNA950981	14810	268	1.215385	3.2572318	Flavobacterium covae	2906076	Bacteria	Bacteria	333	7.82e-87	NTclustered	gi\|982202715\|gb\|CP013992.1\|	2906076	g14634	i0	89.219	353.09328358209	269	26	100	3	1	268	565698	565432	Flavobacterium covae strain 94-081 chromosome, complete genome	blastn	94629	333	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium covae
13687486	13687486	PRJNA950981_P_NODE_11271_length_305_cov_1.336207_g11095_i0	PRJNA950981	11271	305	1.336207	4.07543135	Chryseobacterium sp. ZHDP1	2838877	Bacteria	Bacteria	542	1.38e-149	NTclustered	gi\|2046786976\|gb\|CP075682.1\|	2838877	g11095	i0	98.689	27.4098360655738	305	4	100	0	1	305	4891512	4891816	Chryseobacterium sp. ZHDP1 chromosome, complete genome	blastn	8360	542	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. ZHDP1
13687489	13687489	PRJNA950981_P_NODE_14211_length_273_cov_2.040000_g14035_i0	PRJNA950981	14211	273	2.04	5.5692	Cloacibacterium caeni	2004710	Bacteria	Bacteria	499	7.45e-137	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g14035	i0	99.634	464.74358974359	273	1	100	0	1	273	1872271	1872543	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	126875	499	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
13687519	13687519	PRJNA950981_P_NODE_9191_length_333_cov_1.196154_g9015_i0	PRJNA950981	9191	333	1.196154	3.98319282	Chryseobacterium gambrini	373672	Bacteria	Bacteria	604	1.9199999999999991e-168	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g9015	i0	99.399	100.675675675676	333	2	100	0	1	333	2229313	2229645	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	33525	604	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
14016369	14016369	PRJNA950981_P_NODE_4351_length_463_cov_1.600000_g4176_i0	PRJNA950981	4351	463	1.6	7.408	Flavobacterium	237	Bacteria	Bacteria	839	0	NTclustered	gi\|1003115209\|gb\|CP010992.1\|	996	g4176	i0	99.352	692.965442764579	463	3	100	0	1	463	473177	473639	Flavobacterium columnare strain B185, complete genome	blastn	320843	839	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium columnare
14016374	14016374	PRJNA950981_P_NODE_9831_length_324_cov_0.932271_g9655_i0	PRJNA950981	9831	324	0.932271	3.02055804	Flectobacillus	101	Bacteria	Bacteria	599	8.67e-167	NTclustered	gi\|4127845\|emb\|AJ011917.1\|	50419	g9655	i0	100	100.944444444444	324	0	100	0	1	324	1426	1103	Flectobacillus sp. 16S rRNA gene, partial, strain MWH38	blastn	32706	599	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp.
17512024	17512024	PRJNA950981_P_NODE_17114_length_252_cov_0.871508_g16938_i0	PRJNA950981	17114	252	0.871508	2.19620016	Chryseobacterium gambrini	373672	Bacteria	Bacteria	433	6.98e-117	NTclustered	gi\|2429907221\|gb\|CP116008.1\|	373672	g16938	i0	97.619	9.29761904761905	252	6	100	0	1	252	3031155	3031406	Chryseobacterium gambrini strain DMF-6 chromosome, complete genome	blastn	2343	433	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
17512055	17512055	PRJNA950981_P_NODE_9914_length_322_cov_2.204819_g9738_i0	PRJNA950981	9914	322	2.204819	7.09951718	Flavobacterium album	2175091	Bacteria	Bacteria	484	2.5099999999999994e-132	NTclustered	gi\|1387106870\|gb\|CP029186.1\|	2175091	g9738	i0	94.099	466.326086956522	322	13	100	3	1	322	3763519	3763834	Flavobacterium album strain HYN0059 chromosome, complete genome	blastn	150157	484	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium album
21664788	21664788	PRJNA950981_P_NODE_8797_length_339_cov_1.654135_g8621_i0	PRJNA950981	8797	339	1.654135	5.60751765	Fluviicola	332102	Bacteria	Bacteria	549	9.309999999999997e-152	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g8621	i0	95.87	317.949852507375	339	14	100	0	1	339	1499	1837	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	107785	549	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
22610831	22610831	PRJNA950981_P_NODE_16818_length_252_cov_1.687151_g16642_i0	PRJNA950981	16818	252	1.687151	4.25162052	Algoriphagus sanaruensis	1727163	Bacteria	Bacteria	344	3.37e-90	NTclustered	gi\|1006702952\|gb\|CP012836.1\|	1727163	g16642	i0	91.6	287.115079365079	250	20	99	1	3	252	1801221	1800973	Algoriphagus sanaruensis strain M8-2 chromosome, complete genome	blastn	72353	344	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Algoriphagus	Algoriphagus sanaruensis

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