metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA1085664" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA1085664" and tax_phylum = "Pseudomonadota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1017255	1017255	PRJNA1085664_S_NODE_20821_length_192_cov_0.966443_g20402_i0	PRJNA1085664	20821	192	0.966443	1.85557056	Moraxellaceae	468	Bacteria	Bacteria	313	6.87e-81	NTclustered	gi\|1985959268\|gb\|CP069437.1\|	34062	g20402	i0	100	307.026041666667	169	0	88	0	24	192	1496717	1496549	Moraxella osloensis strain FDAARGOS_1202 chromosome, complete genome	blastn	58949	313	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
7395121	7395121	PRJNA1085664_S_NODE_986_length_768_cov_13.242759_g753_i0	PRJNA1085664	986	768	13.242759	101.70438912	Enterobacteriaceae	543	Bacteria	Bacteria	1203	0	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g753	i0	100	85.61328125	651	0	85	0	33	683	3406207	3405557	Escherichia coli strain Case 2 chromosome, complete genome	blastn	65751	1203	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
7846151	7846151	PRJNA1085664_S_NODE_15227_length_223_cov_1.216667_g14808_i0	PRJNA1085664	15227	223	1.216667	2.71316741	Acinetobacter johnsonii	40214	Bacteria	Bacteria	359	1.04e-94	NTclustered	gi\|2456158263\|gb\|CP119200.1\|	40214	g14808	i0	95.928	683.627802690583	221	9	99	0	1	221	168773	168553	Acinetobacter johnsonii strain AJ572 chromosome, complete genome	blastn	152449	359	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter johnsonii
9945511	9945511	PRJNA1085664_S_NODE_12928_length_241_cov_7.015152_g12509_i0	PRJNA1085664	12928	241	7.015152	16.90651632	Enterobacteriaceae	543	Bacteria	Bacteria	401	1.8699999999999993e-107	NTclustered	gi\|2211724983\|gb\|CP066839.1\|	562	g12509	i0	100	610.302904564315	217	0	90	0	25	241	78613	78397	Escherichia coli strain Ec-RL2-1X chromosome, complete genome	blastn	147083	401	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
11220757	11220757	PRJNA1085664_S_NODE_10669_length_266_cov_2.632287_g10250_i0	PRJNA1085664	10669	266	2.632287	7.00188342	Aeromonas	642	Bacteria	Bacteria	446	9.549999999999999e-121	NTclustered	gi\|2214134399\|gb\|CP094267.1\|	644	g10250	i0	100	780.586466165414	241	0	91	0	1	241	88180	87940	Aeromonas hydrophila strain A008N2 chromosome, complete genome	blastn	207636	446	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas hydrophila
15045020	15045020	PRJNA1085664_S_NODE_21452_length_189_cov_1.287671_g21033_i0	PRJNA1085664	21452	189	1.287671	2.43369819	Enterobacteriaceae	543	Bacteria	Bacteria	350	5.14e-92	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g21033	i0	100	100	189	0	100	0	1	189	2352570	2352758	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	18900	350	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
15496232	15496232	PRJNA1085664_S_NODE_32553_length_156_cov_1.716814_g32134_i0	PRJNA1085664	32553	156	1.716814	2.67822984	Acidovorax temperans	80878	Bacteria	Bacteria	268	1.1699999999999997e-67	NTclustered	gi\|2700484197\|gb\|CP147774.1\|	80878	g32134	i0	98.675	240.807692307692	151	2	97	0	1	151	2501212	2501062	Acidovorax temperans strain AA22 chromosome	blastn	37566	268	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Acidovorax	Acidovorax temperans
16319834	16319834	PRJNA1085664_S_NODE_10013_length_274_cov_9.731602_g9594_i0	PRJNA1085664	10013	274	9.731602	26.66458948	Enterobacteriaceae	543	Bacteria	Bacteria	464	2.7299999999999994e-126	NTclustered	gi\|2618357005\|gb\|CP137721.1\|	562	g9594	i0	100	627.310218978102	251	0	92	0	24	274	5149973	5149723	Escherichia coli strain HNTH2207 chromosome	blastn	171883	464	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
16770506	16770506	PRJNA1085664_S_NODE_2814_length_481_cov_6.394977_g2411_i0	PRJNA1085664	2814	481	6.394977	30.75983937	Metapseudomonas otitidis	319939	Bacteria	Bacteria	843	0	NTclustered	gi\|2385414983\|gb\|CP102328.1\|	319939	g2411	i0	100	367.83367983368	456	0	95	0	1	456	688167	687712	Metapseudomonas otitidis strain BC12 chromosome, complete genome	blastn	176928	843	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Metapseudomonas	Metapseudomonas otitidis
18868968	18868968	PRJNA1085664_S_NODE_18795_length_201_cov_1.082278_g18376_i0	PRJNA1085664	18795	201	1.082278	2.17537878	Pseudomonadaceae	135621	Bacteria	Bacteria	324	3.36e-84	NTclustered	gi\|2797109174\|gb\|CP154874.1\|	43263	g18376	i0	98.901	548.721393034826	182	1	91	1	20	201	3278	3458	Aquipseudomonas alcaligenes strain Med1 chromosome, complete genome	blastn	110293	324	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Aquipseudomonas	Aquipseudomonas alcaligenes
18868990	18868990	PRJNA1085664_S_NODE_7035_length_324_cov_2.156584_g6616_i0	PRJNA1085664	7035	324	2.156584	6.98733216	Escherichia	561	Bacteria	Bacteria	544	4.12e-150	NTclustered	gi\|2841922414\|gb\|CP163901.1\|	562	g6616	i0	97.196	693.567901234568	321	9	99	0	1	321	2295059	2295379	Escherichia coli strain OXEC-129 chromosome, complete genome	blastn	224716	544	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
21419354	21419354	PRJNA1085664_S_NODE_21137_length_190_cov_2.448980_g20718_i0	PRJNA1085664	21137	190	2.44898	4.653062	root	1	Root_unresolved	Root_unresolved	351	1.4399999999999997e-92	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g20718	i0	100	538.026315789474	190	0	100	0	1	190	1571647	1571458	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	102225	351	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
22694222	22694222	PRJNA1085664_S_NODE_19618_length_197_cov_1.246753_g19199_i0	PRJNA1085664	19618	197	1.246753	2.45610341	root	1	Root_unresolved	Root_unresolved	364	1.929999999999999e-96	NTclustered	gi\|2871849209\|gb\|PQ782541.1\|	329	g19199	i0	100	102	197	0	100	0	1	197	582	386	Ralstonia pickettii strain LT333 16S ribosomal RNA gene, partial sequence	blastn	20094	364	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia pickettii
23145766	23145766	PRJNA1085664_S_NODE_34359_length_153_cov_0.872727_g33940_i0	PRJNA1085664	34359	153	0.872727	1.33527231	Lacimicrobium alkaliphilum	1526571	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|962030499\|gb\|CP013650.1\|	1526571	g33940	i0	100	0.183006535947712	28	0	18	0	37	64	3241351	3241324	Lacimicrobium alkaliphilum strain YelD216 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Alteromonadaceae	Lacimicrobium	Lacimicrobium alkaliphilum
25243685	25243685	PRJNA1085664_S_NODE_3340_length_446_cov_15.161290_g2928_i0	PRJNA1085664	3340	446	15.16129	67.6193534	Moraxellaceae	468	Bacteria	Bacteria	778	0	NTclustered	gi\|1985959268\|gb\|CP069437.1\|	34062	g2928	i0	100	356.773542600897	421	0	94	0	1	421	1497447	1497867	Moraxella osloensis strain FDAARGOS_1202 chromosome, complete genome	blastn	159121	778	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis

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