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

5 rows where analysis = "blastn", bioproject = "PRJNA1144090" 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
287881	287881	PRJNA1144090_P_NODE_96281_length_255_cov_1.686813_g95746_i0	PRJNA1144090	96281	255	1.686813	4.30137315	Gimesia benthica	2608982	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1779265081\|gb\|CP043930.1\|	2608982	g95746	i0	100	0.109803921568627	28	0	11	0	15	42	5621148	5621121	Gimesia benthica strain E7 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia benthica
13786351	13786351	PRJNA1144090_P_NODE_42371_length_395_cov_2.838509_g41836_i0	PRJNA1144090	42371	395	2.838509	11.21211055	Engelhardtia	139931	Bacteria	Bacteria	52.8	0.038	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g41836	i0	94.286	0.177215189873418	35	1	9	1	78	111	2862071	2862037	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	70	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
14315866	14315866	PRJNA1144090_P_NODE_114812_length_242_cov_0.911243_g114277_i0	PRJNA1144090	114812	242	0.911243	2.20520806	Urbifossiella limnaea	2528023	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g114277	i0	100	0.115702479338843	28	0	12	0	130	157	5292034	5292061	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
20688334	20688334	PRJNA1144090_P_NODE_109757_length_245_cov_0.895349_g109222_i0	PRJNA1144090	109757	245	0.895349	2.19360505	Gemmataceae bacterium	2052164	Bacteria	Bacteria	58.4	4.75e-4	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g109222	i0	97.059	0.138775510204082	34	1	14	0	178	211	1646108	1646075	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	34	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
21964337	21964337	PRJNA1144090_P_NODE_67298_length_308_cov_4.582979_g66763_i0	PRJNA1144090	67298	308	4.582979	14.11557532	Gemmata massiliana	1210884	Bacteria	Bacteria	60.2	1.72e-4	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g66763	i0	100	0.194805194805195	32	0	10	0	131	162	1771805	1771836	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	60	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana

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