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

7 rows where analysis = "blastn", bioproject = "PRJNA322517" and tax_phylum = "Bacteroidota"

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
2344417	2344417	PRJNA322517_P_NODE_3862_length_203_cov_0.993506_g3840_i0	PRJNA322517	3862	203	0.993506	2.01681718	Cytophagales	768507	Bacteria	Bacteria	265	2.09e-66	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g3840	i0	90.196	86.2364532019704	204	18	100	2	1	203	5896339	5896541	Runella sp. SP2 chromosome, complete genome	blastn	17506	265	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
6766763	6766763	PRJNA322517_P_NODE_1666_length_379_cov_7.357576_g1644_i0	PRJNA322517	1666	379	7.357576	27.88521304	Emticicia sp. 21SJ11W-3	2916755	Bacteria	Bacteria	104	9.83e-18	NTclustered	gi\|2264098040\|gb\|CP092074.1\|	2916755	g1644	i0	87.912	1.42744063324538	91	7	23	4	260	348	2303333	2303421	Emticicia sp. 21SJ11W-3 chromosome, complete genome	blastn	541	104	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia sp. 21SJ11W-3
6766839	6766839	PRJNA322517_P_NODE_3406_length_224_cov_1.165714_g3384_i0	PRJNA322517	3406	224	1.165714	2.61119936	Pedobacter foliorum	2739058	Bacteria	Bacteria	217	6.67e-52	NTclustered	gi\|2844688158\|gb\|CP162529.1\|	2739058	g3384	i0	85.238	81.7544642857143	210	31	94	0	1	210	5093686	5093895	Pedobacter foliorum strain LMG 31463 chromosome, complete genome	blastn	18313	217	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter foliorum
15691942	15691942	PRJNA322517_P_NODE_4053_length_197_cov_1.121622_g4031_i0	PRJNA322517	4053	197	1.121622	2.20959534	Emticicia oligotrophica	312279	Bacteria	Bacteria	119	1.66e-22	NTclustered	gi\|387853393\|gb\|CP002961.1\|	929562	g4031	i0	88.66	0.49238578680203	97	11	49	0	1	97	4488614	4488710	Emticicia oligotrophica DSM 17448, complete genome	blastn	97	119	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
16966669	16966669	PRJNA322517_P_NODE_5074_length_173_cov_1.233871_g5052_i0	PRJNA322517	5074	173	1.233871	2.13459683	Sphingobacterium sp. BN32	3058432	Bacteria	Bacteria	257	2.87e-64	NTclustered	gi\|2547387045\|gb\|CP129963.1\|	3058432	g5052	i0	93.605	99.4739884393064	172	11	99	0	2	173	3124977	3125148	Sphingobacterium sp. BN32 chromosome, complete genome	blastn	17209	257	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium sp. BN32
20195217	20195217	PRJNA322517_P_NODE_5536_length_166_cov_0.871795_g5514_i0	PRJNA322517	5536	166	0.871795	1.4471797	root	1	Root_unresolved	Root_unresolved	307	2.69e-79	NTclustered	gi\|1957908205\|gb\|CP067044.1\|	253	g5514	i0	100	112.987951807229	166	0	100	0	1	166	4643573	4643738	Chryseobacterium indologenes strain 3125 chromosome, complete genome	blastn	18756	307	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
20790783	20790783	PRJNA322517_P_NODE_5357_length_167_cov_1.728814_g5335_i0	PRJNA322517	5357	167	1.728814	2.88711938	Algoriphagus sp. NBT04N3	2705473	Bacteria	Bacteria	97.1	6.38e-16	NTclustered	gi\|2075689917\|gb\|CP048415.1\|	2705473	g5335	i0	81.395	2.52694610778443	129	14	72	8	32	151	1206146	1206273	Algoriphagus sp. NBT04N3 chromosome, complete genome	blastn	422	97.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Algoriphagus	Algoriphagus sp. NBT04N3

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