metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1215813" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1215813" 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
1045807	1045807	PRJNA1215813_P_NODE_6581_length_305_cov_1.344828_g6501_i0	PRJNA1215813	6581	305	1.344828	4.1017254	Emticicia	312278	Bacteria	Bacteria	508	1.4e-139	NTclustered	gi\|470489174\|ref\|NR_076911.1\|	312279	g6501	i0	96.721	297.819672131148	305	10	100	0	1	305	2049	2353	Emticicia oligotrophica strain GPTSA100-15 23S ribosomal RNA gene, complete sequence	blastn	90835	508	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
1606559	1606559	PRJNA1215813_P_NODE_7042_length_294_cov_2.819005_g6962_i0	PRJNA1215813	7042	294	2.819005	8.2878747	Spirosoma pollinicola	2057025	Bacteria	Bacteria	414	3.02e-111	NTclustered	gi\|1304138264\|gb\|CP025096.1\|	2057025	g6962	i0	92.44	188.187074829932	291	20	99	2	1	291	8391178	8390890	Spirosoma pollinicola strain Ha7 chromosome, complete genome	blastn	55327	414	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma pollinicola
5434921	5434921	PRJNA1215813_P_NODE_1065_length_701_cov_2.345541_g992_i0	PRJNA1215813	1065	701	2.345541	16.44224241	Spirosoma rigui	564064	Bacteria	Bacteria	1062	0	NTclustered	gi\|1163018612\|gb\|CP020105.1\|	564064	g992	i0	94.017	256.583452211127	702	41	100	1	1	701	1095354	1094653	Spirosoma rigui strain KCTC 12531 chromosome, complete genome	blastn	179865	1062	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma rigui
5435042	5435042	PRJNA1215813_P_NODE_6085_length_316_cov_1.283951_g6005_i0	PRJNA1215813	6085	316	1.283951	4.05728516	Myroides sp. JBRI-B21084	3119977	Bacteria	Bacteria	69.4	2.94e-7	NTclustered	gi\|2552842630\|gb\|CP120653.1\|	3119977	g6005	i0	100	0.117088607594937	37	0	12	0	135	171	1917518	1917482	Myroides sp. JBRI-B21084 chromosome, complete genome	blastn	37	69.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides sp. JBRI-B21084
8698819	8698819	PRJNA1215813_P_NODE_9507_length_252_cov_1.821229_g9427_i0	PRJNA1215813	9507	252	1.821229	4.58949708	Spirosoma	107	Bacteria	Bacteria	390	4.259999999999999e-104	NTclustered	gi\|1823150813\|gb\|CP050063.1\|	2692134	g9427	i0	95.142	199.06746031746	247	12	98	0	1	247	446478	446232	Spirosoma aureum strain BT328 chromosome, complete genome	blastn	50165	390	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma aureum
11249164	11249164	PRJNA1215813_P_NODE_509_length_938_cov_2.139884_g459_i0	PRJNA1215813	509	938	2.139884	20.07211192	Emticicia	312278	Bacteria	Bacteria	1424	0	NTclustered	gi\|470489174\|ref\|NR_076911.1\|	312279	g459	i0	94.136	333.848614072495	938	52	100	3	1	938	860	1794	Emticicia oligotrophica strain GPTSA100-15 23S ribosomal RNA gene, complete sequence	blastn	313150	1424	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
14360711	14360711	PRJNA1215813_P_NODE_12452_length_242_cov_0.923077_g12372_i0	PRJNA1215813	12452	242	0.923077	2.23384634	Myroides sp. JBRI-B21084	3119977	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2552842630\|gb\|CP120653.1\|	3119977	g12372	i0	91.892	0.152892561983471	37	3	15	0	88	124	1917518	1917482	Myroides sp. JBRI-B21084 chromosome, complete genome	blastn	37	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides sp. JBRI-B21084
18183268	18183268	PRJNA1215813_P_NODE_11295_length_246_cov_0.901734_g11215_i0	PRJNA1215813	11295	246	0.901734	2.21826564	Spirosoma rhododendri	2728024	Bacteria	Bacteria	433	6.79e-117	NTclustered	gi\|1835007590\|gb\|CP051677.1\|	2728024	g11215	i0	98.374	538.727642276423	246	4	100	0	1	246	1400401	1400156	Spirosoma sp. CJU-R4 chromosome, complete genome	blastn	132527	433	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma rhododendri
19457816	19457816	PRJNA1215813_P_NODE_4996_length_344_cov_2.302583_g4916_i0	PRJNA1215813	4996	344	2.302583	7.92088552	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2107779373\|gb\|CP070829.1\|	2448054	g4916	i0	100	0.25	29	0	8	0	254	282	771952	771980	MAG: Gemmatimonadales bacterium isolate bin109 chromosome	blastn	86	54.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
21447707	21447707	PRJNA1215813_P_NODE_77_length_1805_cov_6.889145_g65_i0	PRJNA1215813	77	1805	6.889145	124.34906725	Aquirufa	2676247	Bacteria	Bacteria	2028	0	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g65	i0	87.076	483.371745152355	1826	196	99	35	2	1805	360469	358662	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	872486	2047	0.990718124084025	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae

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