metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA408129" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA408129" and tax_clade = "PVC group"

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
418304	418304	PRJNA408129_S_NODE_14281_length_198_cov_7.875776_g14263_i0	PRJNA408129	14281	198	7.875776	15.59403648	Blastopirellula sp. J2-11	2943192	Bacteria	Bacteria	196	7.49e-46	NTclustered	gi\|2283101653\|gb\|CP097384.1\|	2943192	g14263	i0	86.592	83.8232323232323	179	23	90	1	1	179	2919618	2919795	Blastopirellula sp. J2-11 chromosome	blastn	16597	196	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula sp. J2-11
418417	418417	PRJNA408129_S_NODE_25001_length_167_cov_2.076923_g24983_i0	PRJNA408129	25001	167	2.076923	3.46846141	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	182	1.71e-41	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g24983	i0	88.235	2.4311377245509	153	17	92	1	15	167	4422876	4422725	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	406	182	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
4910748	4910748	PRJNA408129_S_NODE_28564_length_160_cov_5.024390_g28546_i0	PRJNA408129	28564	160	5.02439	8.039024	Singulisphaera	466152	Bacteria	Bacteria	237	3.4100000000000004e-58	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g28546	i0	95.918	118.375	147	5	91	1	8	153	2272039	2271893	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	18940	237	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
6796351	6796351	PRJNA408129_S_NODE_9846_length_222_cov_8.356757_g9828_i0	PRJNA408129	9846	222	8.356757	18.55200054	Aureliella helgolandensis	2527968	Bacteria	Bacteria	254	5.03e-63	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g9828	i0	89.848	13.1621621621622	197	20	89	0	14	210	6999007	6998811	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	2922	254	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
7460670	7460670	PRJNA408129_S_NODE_26286_length_164_cov_4.716535_g26268_i0	PRJNA408129	26286	164	4.716535	7.7351174	Frigoriglobus	2774146	Bacteria	Bacteria	217	4.589999999999999e-52	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g26268	i0	92.157	28.3170731707317	153	12	93	0	5	157	2001782	2001630	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	4644	217	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
8071674	8071674	PRJNA408129_S_NODE_21007_length_176_cov_2.712230_g20989_i0	PRJNA408129	21007	176	2.71223	4.7735248	Pirellulimonas nuda	2528009	Bacteria	Bacteria	150	5.12e-32	NTclustered	gi\|1712662089\|gb\|CP036291.1\|	2528009	g20989	i0	83.234	3.60795454545455	167	24	94	4	5	169	4534752	4534916	Pirellulimonas nuda strain Pla175 chromosome, complete genome	blastn	635	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Pirellulimonas	Pirellulimonas nuda
10622361	10622361	PRJNA408129_S_NODE_3029_length_303_cov_21289.229323_g3011_i0	PRJNA408129	3029	303	21289.229323	64506.36484869	Lacipirellula parvula	2650471	Bacteria	Bacteria	268	2.57e-67	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g3011	i0	90.64	36.1980198019802	203	18	67	1	14	215	5164240	5164038	Lacipirellula parvula PX69 DNA, complete genome	blastn	10968	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
13172014	13172014	PRJNA408129_S_NODE_10651_length_217_cov_54.522222_g10633_i0	PRJNA408129	10651	217	54.522222	118.31322174	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	237	4.93e-58	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g10633	i0	89.73	6.29953917050691	185	19	85	0	15	199	7050393	7050209	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	1367	237	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
14447294	14447294	PRJNA408129_S_NODE_20812_length_176_cov_13.028777_g20794_i0	PRJNA408129	20812	176	13.028777	22.93064752	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	196	6.479999999999999e-46	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g20794	i0	88.024	5.02840909090909	167	18	94	2	11	176	7631081	7630916	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	885	196	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
18270050	18270050	PRJNA408129_S_NODE_25195_length_166_cov_6.930233_g25177_i0	PRJNA408129	25195	166	6.930233	11.50418678	Polystyrenella longa	2528007	Bacteria	Bacteria	145	2.23e-30	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g25177	i0	90.09	88.2228915662651	111	11	67	0	11	121	1415482	1415592	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	14645	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa

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