metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA478247" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA478247" and tax_kingdom = "Pseudomonadati"

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
447836	447836	PRJNA478247_P_NODE_881_length_442_cov_3.670702_g776_i0	PRJNA478247	881	442	3.670702	16.22450284	Caldimonas aquatica	376175	Bacteria	Bacteria	412	1.6999999999999998e-110	NTclustered	gi\|2325778792\|gb\|CP110257.1\|	376175	g776	i0	96.761	206.692307692308	247	8	98	0	1	247	2127141	2127387	Caldimonas aquatica strain LMG 23380 chromosome, complete genome	blastn	91358	412	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Caldimonas	Caldimonas aquatica
1722519	1722519	PRJNA478247_P_NODE_1162_length_366_cov_3.163205_g1056_i0	PRJNA478247	1162	366	3.163205	11.5773303	Ehrlichia ruminantium	779	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|58416339\|emb\|CR925677.1\|	302409	g1056	i0	100	0.0765027322404372	28	0	8	0	82	109	1307643	1307670	Ehrlichia ruminantium str. Gardel, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Anaplasmataceae	Ehrlichia	Ehrlichia ruminantium
10651463	10651463	PRJNA478247_P_NODE_3129_length_171_cov_1.922535_g3023_i0	PRJNA478247	3129	171	1.922535	3.28753485	Temperatibacter marinus	1456591	Bacteria	Bacteria	193	8.089999999999999e-45	NTclustered	gi\|2578886475\|gb\|CP123872.1\|	1456591	g3023	i0	95.082	480.426900584795	122	6	71	0	50	171	1655784	1655663	Temperatibacter marinus strain NBRC 110045 chromosome, complete genome	blastn	82153	193	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Kordiimonadales	Temperatibacteraceae	Temperatibacter	Temperatibacter marinus
11300378	11300378	PRJNA478247_P_NODE_2449_length_211_cov_3.626374_g2343_i0	PRJNA478247	2449	211	3.626374	7.65164914	Massilia	149698	Bacteria	Bacteria	300	5.99e-77	NTclustered	gi\|1888689060\|gb\|CP050454.1\|	2709302	g2343	i0	96.667	235.672985781991	180	6	85	0	1	180	362599	362778	Massilia sp. Dwa41.01b chromosome, complete genome	blastn	49727	300	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Massilia	Massilia sp. Dwa41.01b
15125104	15125104	PRJNA478247_P_NODE_3212_length_166_cov_2.649635_g3106_i0	PRJNA478247	3212	166	2.649635	4.3983941	Burkholderiaceae	119060	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|532578729\|gb\|KC188318.1\|	305	g3106	i0	100	209	166	0	100	0	1	166	764	929	Ralstonia solanacearum strain CFBP 3059 23S ribosomal RNA gene, partial sequence	blastn	34694	307	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia solanacearum
20223501	20223501	PRJNA478247_P_NODE_976_length_415_cov_2.562176_g870_i0	PRJNA478247	976	415	2.562176	10.6330304	Hymenobacter	89966	Bacteria	Bacteria	593	5.289999999999998e-165	NTclustered	gi\|2423912131\|gb\|CP115396.1\|	748197	g870	i0	92.548	372.865060240964	416	28	100	3	1	415	2575073	2575486	Hymenobacter yonginensis strain KCTC 22745 chromosome, complete genome	blastn	154739	593	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter yonginensis
24673864	24673864	PRJNA478247_P_NODE_3440_length_157_cov_2.921875_g3334_i0	PRJNA478247	3440	157	2.921875	4.58734375	Caldimonas aquatica	376175	Bacteria	Bacteria	291	2.52e-74	NTclustered	gi\|2325778792\|gb\|CP110257.1\|	376175	g3334	i0	100	205.152866242038	157	0	100	0	1	157	2127169	2127013	Caldimonas aquatica strain LMG 23380 chromosome, complete genome	blastn	32209	291	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Caldimonas	Caldimonas aquatica

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