metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA915212" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA915212" 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
2170565	2170565	PRJNA915212_P_NODE_5462_length_254_cov_0.995122_g5424_i0	PRJNA915212	5462	254	0.995122	2.52760988	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	75	4.92e-9	NTclustered	gi\|575461033\|gb\|CP007129.1\|	861299	g5424	i0	92.308	13.3700787401575	52	4	20	0	1	52	1037414	1037465	Gemmatirosa kalamazoonesis strain KBS708 plasmid 1, complete sequence	blastn	3396	75	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
2526676	2526676	PRJNA915212_P_NODE_6102_length_238_cov_1.862434_g6064_i0	PRJNA915212	6102	238	1.862434	4.43259292	Aquirufa	2676247	Bacteria	Bacteria	313	8.88e-81	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g6064	i0	93.056	332.495798319328	216	12	90	3	1	215	361220	361433	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	79134	313	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
10179623	10179623	PRJNA915212_P_NODE_6408_length_232_cov_0.994536_g6370_i0	PRJNA915212	6408	232	0.994536	2.30732352	Elizabethkingia	308865	Bacteria	Bacteria	424	3.82e-114	NTclustered	gi\|1153157339\|gb\|CP016378.1\|	238	g6370	i0	99.569	479	232	1	100	0	1	232	922495	922726	Elizabethkingia meningoseptica strain G4120 chromosome, complete genome	blastn	111128	424	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia meningoseptica
12730487	12730487	PRJNA915212_P_NODE_9850_length_185_cov_1.102941_g9812_i0	PRJNA915212	9850	185	1.102941	2.04044085	Elizabethkingia	308865	Bacteria	Bacteria	342	8.369999999999999e-90	NTclustered	gi\|2461920362\|gb\|CP119595.1\|	172045	g9812	i0	100	476	185	0	100	0	1	185	305809	305625	Elizabethkingia miricola strain NW-2-4 chromosome, complete genome	blastn	88060	342	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia miricola
14923128	14923128	PRJNA915212_P_NODE_6232_length_235_cov_1.295699_g6194_i0	PRJNA915212	6232	235	1.295699	3.04489265	Aquirufa nivalisilvae	2516557	Bacteria	Bacteria	348	2.4e-91	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g6194	i0	93.277	305.348936170213	238	13	100	2	1	235	360715	360952	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	71757	348	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
16197987	16197987	PRJNA915212_P_NODE_11193_length_171_cov_1.254098_g11155_i0	PRJNA915212	11193	171	1.254098	2.14450758	Aurantibacillus circumpalustris	3036359	Bacteria	Bacteria	233	4.77e-57	NTclustered	gi\|2482055248\|gb\|CP121197.1\|	3036359	g11155	i0	91.379	200.198830409357	174	10	99	5	1	169	2012992	2013165	Aurantibacillus circumpalustris strain Swamp196 chromosome, complete genome	blastn	34234	233	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Aurantibacillaceae	Aurantibacillus	Aurantibacillus circumpalustris
17828559	17828559	PRJNA915212_P_NODE_3634_length_327_cov_1.539568_g3597_i0	PRJNA915212	3634	327	1.539568	5.03438736	Flavobacterium	237	Bacteria	Bacteria	339	2.1099999999999997e-88	NTclustered	gi\|2164478757\|gb\|CP089096.1\|	2897181	g3597	i0	87.713	370.318042813456	293	33	89	3	1	291	486073	485782	Flavobacterium channae strain KSM-R2A30 chromosome, complete genome	blastn	121094	340	0.997058823529412	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium channae
21653191	21653191	PRJNA915212_P_NODE_1317_length_585_cov_1.042910_g1285_i0	PRJNA915212	1317	585	1.04291	6.1010235	Aquirufa	2676247	Bacteria	Bacteria	806	0	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g1285	i0	91.652	405.032478632479	587	41	100	5	1	585	359536	360116	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	236944	811	0.99383477188656	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
22928708	22928708	PRJNA915212_P_NODE_4658_length_279_cov_1.539130_g4620_i0	PRJNA915212	4658	279	1.53913	4.2941727	Bacteroidota	976	Bacteria	Bacteria	265	3.03e-66	NTclustered	gi\|2874253937\|emb\|OY970262.1\|	2562116	g4620	i0	84.848	316.089605734767	264	38	94	2	1	262	3149472	3149209	MAG: Schleiferiaceae bacterium isolate MFD03250.bin.1.24 genome assembly, chromosome: 1	blastn	88189	267	0.99250936329588	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Schleiferiaceae		Schleiferiaceae bacterium
24202618	24202618	PRJNA915212_P_NODE_6939_length_222_cov_1.173410_g6901_i0	PRJNA915212	6939	222	1.17341	2.6049702	Emticicia	312278	Bacteria	Bacteria	383	6.1499999999999996e-102	NTclustered	gi\|470489174\|ref\|NR_076911.1\|	312279	g6901	i0	97.748	233.720720720721	222	5	100	0	1	222	2555	2776	Emticicia oligotrophica strain GPTSA100-15 23S ribosomal RNA gene, complete sequence	blastn	51886	383	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
25477650	25477650	PRJNA915212_P_NODE_6980_length_221_cov_1.662791_g6942_i0	PRJNA915212	6980	221	1.662791	3.67476811	Aquirufa	2676247	Bacteria	Bacteria	211	3.05e-50	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g6942	i0	93.056	160.986425339367	144	10	65	0	78	221	359049	359192	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	35578	211	1	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);;