metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA414036" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA414036" 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
418843	418843	PRJNA414036_P_NODE_80901_length_161_cov_7.468254_g79162_i0	PRJNA414036	80901	161	7.468254	12.02388894	Gemmataceae bacterium	2052164	Bacteria	Bacteria	246	5.7199999999999986e-61	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g79162	i0	97.241	341.571428571429	145	4	90	0	8	152	318029	317885	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	54993	246	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
16996268	16996268	PRJNA414036_P_NODE_66454_length_193_cov_4.291139_g64715_i0	PRJNA414036	66454	193	4.291139	8.28189827	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	89.8	1.27e-13	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g64715	i0	78.986	0.715025906735751	138	24	70	3	10	144	417502	417367	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	138	89.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
18270461	18270461	PRJNA414036_P_NODE_85835_length_154_cov_2.512605_g84096_i0	PRJNA414036	85835	154	2.512605	3.8694117	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g84096	i0	100	0.181818181818182	28	0	18	0	16	43	6544913	6544886	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
19544563	19544563	PRJNA414036_P_NODE_42576_length_231_cov_4.209184_g40837_i0	PRJNA414036	42576	231	4.209184	9.72321504	Saltatorellus ferox	2528018	Bacteria	Bacteria	95.3	3.38e-15	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g40837	i0	92.424	67.0649350649351	66	5	29	0	157	222	2930170	2930105	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	15492	95.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox
20209065	20209065	PRJNA414036_P_NODE_2916_length_586_cov_8.186933_g2330_i0	PRJNA414036	2916	586	8.186933	47.97542738	Gemmata	113	Bacteria	Bacteria	468	4.85e-127	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g2330	i0	84.362	85.1962457337884	486	46	97	6	103	581	3633931	3633469	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	49925	468	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
22095231	22095231	PRJNA414036_P_NODE_59718_length_217_cov_8.939560_g57979_i0	PRJNA414036	59718	217	8.93956	19.3988452	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	254	4.9e-63	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g57979	i0	90.452	29.4976958525346	199	10	92	1	10	208	4959862	4959673	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	6401	254	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
23370748	23370748	PRJNA414036_P_NODE_15579_length_375_cov_11.400000_g13893_i0	PRJNA414036	15579	375	11.4	42.75	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	599	1.0199999999999998e-166	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g13893	i0	96.429	126.072	364	12	97	1	4	366	2002687	2002324	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	47277	599	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24645156	24645156	PRJNA414036_P_NODE_40580_length_231_cov_6.581633_g38841_i0	PRJNA414036	40580	231	6.581633	15.20357223	Planctomycetes bacterium syqfu	2896527	Bacteria	Bacteria	87.9	5.66e-13	NTclustered	gi\|2155219436\|gb\|CP087563.1\|	2896527	g38841	i0	93.333	19.3290043290043	60	3	26	1	16	75	4645381	4645323	Planctomycetes bacterium syqfu chromosome, complete genome	blastn	4465	87.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium syqfu

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