metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA813520" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA813520" 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
1225357	1225357	PRJNA813520_S_NODE_1321_length_311_cov_8.645390_g1274_i0	PRJNA813520	1321	311	8.64539	26.8871629	Burkholderia	32008	Bacteria	Bacteria	433	8.88e-117	NTclustered	gi\|1913871957\|gb\|CP032009.1\|	292	g1274	i0	91.935	224.379421221865	310	24	99	1	3	311	3473237	3472928	Burkholderia cepacia strain 39628 chromosome 1, complete sequence	blastn	69782	433	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Burkholderia	Burkholderia cepacia
1225359	1225359	PRJNA813520_S_NODE_1681_length_280_cov_6.796813_g1634_i0	PRJNA813520	1681	280	6.796813	19.0310764	Burkholderia	32008	Bacteria	Bacteria	466	7.78e-127	NTclustered	gi\|2862534882\|gb\|CP174351.1\|	292	g1634	i0	100	187.2	252	0	90	0	29	280	447578	447327	Burkholderia cepacia strain ZY1 plasmid unnamed2, complete sequence	blastn	52416	466	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Burkholderia	Burkholderia cepacia
1225362	1225362	PRJNA813520_S_NODE_4501_length_172_cov_1.489510_g4454_i0	PRJNA813520	4501	172	1.48951	2.5619572	Enterobacteriaceae	543	Bacteria	Bacteria	318	1.2899999999999999e-82	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g4454	i0	100	100	172	0	100	0	1	172	2940970	2941141	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	17200	318	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
2500884	2500884	PRJNA813520_S_NODE_1182_length_326_cov_5.848485_g1135_i0	PRJNA813520	1182	326	5.848485	19.0660611	Enterobacteriaceae	543	Bacteria	Bacteria	603	6.749999999999998e-168	NTclustered	gi\|2211724983\|gb\|CP066839.1\|	562	g1135	i0	100	100	326	0	100	0	1	326	2421506	2421831	Escherichia coli strain Ec-RL2-1X chromosome, complete genome	blastn	32600	603	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
7603474	7603474	PRJNA813520_S_NODE_1926_length_263_cov_2.863248_g1879_i0	PRJNA813520	1926	263	2.863248	7.53034224	Enterobacteriaceae	543	Bacteria	Bacteria	486	5.5499999999999986e-133	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g1879	i0	100	100	263	0	100	0	1	263	1466720	1466458	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	26300	486	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
10153961	10153961	PRJNA813520_S_NODE_2988_length_212_cov_3.092896_g2941_i0	PRJNA813520	2988	212	3.092896	6.55693952	Enterobacteriaceae	543	Bacteria	Bacteria	392	9.67e-105	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g2941	i0	100	100	212	0	100	0	1	212	298981	298770	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	21200	392	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
11429221	11429221	PRJNA813520_S_NODE_2589_length_227_cov_2.626263_g2542_i0	PRJNA813520	2589	227	2.626263	5.96161701	Enterobacteriaceae	543	Bacteria	Bacteria	420	4.81e-113	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g2542	i0	100	100	227	0	100	0	1	227	4578923	4578697	Escherichia coli strain Case 2 chromosome, complete genome	blastn	22700	420	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
15253458	15253458	PRJNA813520_S_NODE_812_length_381_cov_4.735795_g765_i0	PRJNA813520	812	381	4.735795	18.04337895	Burkholderia	32008	Bacteria	Bacteria	665	0	NTclustered	gi\|2862534882\|gb\|CP174351.1\|	292	g765	i0	98.168	238.635170603675	382	5	100	2	1	381	448242	448622	Burkholderia cepacia strain ZY1 plasmid unnamed2, complete sequence	blastn	90920	665	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Burkholderia	Burkholderia cepacia
16117592	16117592	PRJNA813520_S_NODE_33_length_1475_cov_16.679806_g28_i0	PRJNA813520	33	1475	16.679806	246.0271385	Undibacterium sp. KW1	2058624	Bacteria	Bacteria	58.4	0.003	NTclustered	gi\|1798093821\|dbj\|AP018439.1\|	2058624	g28	i0	100	0.0413559322033898	31	0	2	0	171	201	5052095	5052125	Undibacterium sp. KW1 DNA, complete genome	blastn	61	58.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium sp. KW1
17802979	17802979	PRJNA813520_S_NODE_5214_length_159_cov_1.669231_g5167_i0	PRJNA813520	5214	159	1.669231	2.65407729	Enterobacteriaceae	543	Bacteria	Bacteria	291	2.56e-74	NTclustered	gi\|2211724983\|gb\|CP066839.1\|	562	g5167	i0	100	98.7421383647799	157	0	99	0	3	159	2327156	2327312	Escherichia coli strain Ec-RL2-1X chromosome, complete genome	blastn	15700	291	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
19077012	19077012	PRJNA813520_S_NODE_1515_length_292_cov_35.285171_g1468_i0	PRJNA813520	1515	292	35.285171	103.03269932	Enterobacteriaceae	543	Bacteria	Bacteria	486	6.259999999999999e-133	NTclustered	gi\|2688429608\|gb\|CP145714.1\|	562	g1468	i0	99.624	614.030821917808	266	1	91	0	27	292	4628754	4628489	Escherichia coli strain S1-CAM-01-A chromosome, complete genome	blastn	179297	486	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
19077019	19077019	PRJNA813520_S_NODE_3735_length_189_cov_3.093750_g3688_i0	PRJNA813520	3735	189	3.09375	5.8471875	root	1	Root_unresolved	Root_unresolved	350	5.14e-92	NTclustered	gi\|2023981091\|gb\|CP072662.1\|	562	g3688	i0	100	100	189	0	100	0	1	189	4362176	4361988	Escherichia coli strain BW25113 frmA KO chromosome	blastn	18900	350	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
22903003	22903003	PRJNA813520_S_NODE_738_length_399_cov_5.605405_g691_i0	PRJNA813520	738	399	5.605405	22.36556595	Burkholderia	32008	Bacteria	Bacteria	737	0	NTclustered	gi\|2090904009\|gb\|CP082808.1\|	488447	g691	i0	100	221.022556390977	399	0	100	0	1	399	2622298	2622696	Burkholderia contaminans strain SCAID TST1-2021 (11/270) chromosome 2, complete sequence	blastn	88188	737	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Burkholderia	Burkholderia contaminans
23767508	23767508	PRJNA813520_S_NODE_119_length_909_cov_9.829545_g97_i0	PRJNA813520	119	909	9.829545	89.35056405	Plesiomonas shigelloides	703	Bacteria	Bacteria	54.7	0.026	NTclustered	gi\|1037176310\|emb\|LT575468.1\|	703	g97	i0	100	0.0319031903190319	29	0	3	0	57	85	1838190	1838218	Plesiomonas shigelloides strain NCTC10360 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Plesiomonas	Plesiomonas shigelloides

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