metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA438572" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA438572" and tax_phylum = "Planctomycetota"

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
435059	435059	PRJNA438572_P_NODE_24121_length_242_cov_0.923077_g24002_i0	PRJNA438572	24121	242	0.923077	2.23384634	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	364	2.4699999999999992e-96	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g24002	i0	93.802	177.099173553719	242	15	100	0	1	242	5171957	5171716	Lacipirellula limnantheis strain I41 chromosome	blastn	42858	364	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
5538713	5538713	PRJNA438572_P_NODE_19525_length_249_cov_0.886364_g19406_i0	PRJNA438572	19525	249	0.886364	2.20704636	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	265	2.6599999999999997e-66	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g19406	i0	86.722	40.8353413654619	241	28	96	3	11	249	1830851	1830613	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	10168	265	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
8088095	8088095	PRJNA438572_P_NODE_12927_length_288_cov_0.855814_g12808_i0	PRJNA438572	12927	288	0.855814	2.46474432	Lacipirellula parvula	2650471	Bacteria	Bacteria	318	2.3799999999999995e-82	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g12808	i0	87.368	124.604166666667	285	26	98	8	1	281	5162957	5163235	Lacipirellula parvula PX69 DNA, complete genome	blastn	35886	318	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
9362999	9362999	PRJNA438572_P_NODE_18608_length_250_cov_2.220339_g18489_i0	PRJNA438572	18608	250	2.220339	5.5508475	Urbifossiella limnaea	2528023	Bacteria	Bacteria	285	2.05e-72	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g18489	i0	87.2	1	250	32	100	0	1	250	2521034	2520785	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	250	285	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
10638776	10638776	PRJNA438572_P_NODE_11749_length_300_cov_1.030837_g11630_i0	PRJNA438572	11749	300	1.030837	3.092511	Aeoliella mucimassa	2527972	Bacteria	Bacteria	392	1.4499999999999994e-104	NTclustered	gi\|1712622222\|gb\|CP036278.1\|	2527972	g11630	i0	90.635	116.666666666667	299	23	99	5	1	296	2043155	2043451	Aeoliella mucimassa strain Pan181 chromosome, complete genome	blastn	35000	392	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Aeoliella	Aeoliella mucimassa

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