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

8 rows where analysis = "blastn", bioproject = "PRJDB4941" 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
1284793	1284793	PRJDB4941_P_NODE_36382_length_167_cov_0.881356_g35614_i0	PRJDB4941	36382	167	0.881356	1.47186452	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	106	1.06e-18	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g35614	i0	81.538	32.3592814371258	130	22	77	2	31	159	3991538	3991666	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	5404	106	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
2256755	2256755	PRJDB4941_P_NODE_11042_length_335_cov_4.146853_g10274_i0	PRJDB4941	11042	335	4.146853	13.89195755	Engelhardtia	139931	Bacteria	Bacteria	189	2.31e-43	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g10274	i0	80.769	19.4388059701493	260	34	75	15	3	254	387998	387747	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	6512	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
8937030	8937030	PRJDB4941_P_NODE_13948_length_287_cov_2.105042_g13180_i0	PRJDB4941	13948	287	2.105042	6.04147054	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	126	1.5399999999999999e-24	NTclustered	gi\|2108165213\|gb\|CP070718.1\|	2052180	g13180	i0	82.857	0.895470383275261	140	24	49	0	137	276	2869895	2870034	MAG: Phycisphaerales bacterium isolate bin470 chromosome	blastn	257	126	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
11488659	11488659	PRJDB4941_P_NODE_8690_length_398_cov_2.000000_g7922_i0	PRJDB4941	8690	398	2	7.96	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	292	2.0599999999999993e-74	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g7922	i0	80.863	18.3819095477387	371	71	93	0	11	381	1778736	1779106	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	7316	292	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
12763592	12763592	PRJDB4941_P_NODE_13811_length_289_cov_2.050000_g13043_i0	PRJDB4941	13811	289	2.05	5.9245	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	167	9.16e-37	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g13043	i0	78.277	16	267	52	91	6	6	269	2668885	2668622	Planctomyces sp. SH-PL14, complete genome	blastn	4624	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
20108211	20108211	PRJDB4941_P_NODE_39216_length_164_cov_0.904348_g38448_i0	PRJDB4941	39216	164	0.904348	1.48313072	Urbifossiella	2807415	Bacteria	Bacteria	159	7.84e-35	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g38448	i0	84.756	492.487804878049	164	19	99	6	2	164	3454759	3454601	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	80768	159	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
21687006	21687006	PRJDB4941_P_NODE_31518_length_176_cov_2.370079_g30750_i0	PRJDB4941	31518	176	2.370079	4.17133904	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	137	3.98e-28	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g30750	i0	82.278	1.46022727272727	158	28	90	0	18	175	1460184	1460027	Lacipirellula limnantheis strain I41 chromosome	blastn	257	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
23933919	23933919	PRJDB4941_P_NODE_14859_length_276_cov_1.731278_g14091_i0	PRJDB4941	14859	276	1.731278	4.77832728	Gemmata	113	Bacteria	Bacteria	189	1.8499999999999993e-43	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g14091	i0	79.649	3.80797101449275	285	40	99	15	4	276	526191	525913	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	1051	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus

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