metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax_phylum = "Chlorobiota"

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
601420	601420	PRJNA630162_P_NODE_111501_length_179_cov_1.330769_g109978_i0	PRJNA630162	111501	179	1.330769	2.38207651	Chlorobiota bacterium	2268192	Bacteria	Bacteria	311	2.27e-80	NTclustered	gi\|1958119998\|gb\|CP065014.1\|	2268192	g109978	i0	98.851	44.3240223463687	174	2	97	0	6	179	282340	282513	MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome	blastn	7934	311	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
19003048	19003048	PRJNA630162_P_NODE_78175_length_203_cov_3.623377_g76652_i0	PRJNA630162	78175	203	3.623377	7.35545531	Chlorobium	1091	Bacteria	Bacteria	196	7.72e-46	NTclustered	gi\|470481248\|ref\|NR_076462.1\|	1096	g76652	i0	85.714	19.8177339901478	189	24	93	2	6	193	609	795	Chlorobium phaeobacteroides strain DSM 266 23S ribosomal RNA gene, complete sequence	blastn	4023	196	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium phaeobacteroides
19728778	19728778	PRJNA630162_P_NODE_34036_length_307_cov_4.569767_g32513_i0	PRJNA630162	34036	307	4.569767	14.02918469	Chlorobiota bacterium	2268192	Bacteria	Bacteria	220	7.42e-53	NTclustered	gi\|1958119998\|gb\|CP065014.1\|	2268192	g32513	i0	80.583	95.3322475570033	309	40	98	18	1	301	281550	281254	MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome	blastn	29267	220	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
21553534	21553534	PRJNA630162_P_NODE_73877_length_209_cov_2.218750_g72354_i0	PRJNA630162	73877	209	2.21875	4.6371875	Pelodictyon	1099	Bacteria	Bacteria	148	2.27e-31	NTclustered	gi\|470477241\|ref\|NR_076371.1\|	1100	g72354	i0	80.488	77.4928229665072	205	30	96	9	7	206	1486	1685	Pelodictyon luteolum strain DSM 273 23S ribosomal RNA gene, complete sequence	blastn	16196	148	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Pelodictyon	Pelodictyon luteolum
23554058	23554058	PRJNA630162_P_NODE_119139_length_175_cov_1.301587_g117616_i0	PRJNA630162	119139	175	1.301587	2.27777725	Chlorobiota bacterium	2268192	Bacteria	Bacteria	211	2.3e-50	NTclustered	gi\|1958119998\|gb\|CP065014.1\|	2268192	g117616	i0	89.349	294.177142857143	169	16	95	1	1	167	281910	281742	MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome	blastn	51481	211	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
23554528	23554528	PRJNA630162_P_NODE_165379_length_159_cov_2.018182_g163856_i0	PRJNA630162	165379	159	2.018182	3.20890938	Chlorobiota bacterium	2268192	Bacteria	Bacteria	135	1.27e-27	NTclustered	gi\|1958119998\|gb\|CP065014.1\|	2268192	g163856	i0	90.476	79.2012578616352	105	6	64	2	5	105	282812	282708	MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome	blastn	12593	135	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium

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