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

8 rows where analysis = "blastn", bioproject = "PRJNA495391" 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
4303789	4303789	PRJNA495391_S_NODE_57024_length_165_cov_1.223077_g55972_i0	PRJNA495391	57024	165	1.223077	2.01807705	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	132	1.72e-26	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g55972	i0	83.553	282.854545454545	152	13	88	9	5	149	3097293	3097439	Pirellula sp. SH-Sr6A, complete genome	blastn	46671	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
4935622	4935622	PRJNA495391_S_NODE_44764_length_184_cov_1.583893_g43712_i0	PRJNA495391	44764	184	1.583893	2.91436312	Bremerella	2714594	Bacteria	Bacteria	76.8	9.31e-10	NTclustered	gi\|1712647354\|gb\|CP036289.1\|	2527984	g43712	i0	91.071	2.2445652173913	56	5	30	0	129	184	2673360	2673415	Bremerella volcania strain Pan97 chromosome, complete genome	blastn	413	76.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella volcania
6210562	6210562	PRJNA495391_S_NODE_23485_length_248_cov_2.140845_g22433_i0	PRJNA495391	23485	248	2.140845	5.3092956	Bacteria	2	Bacteria	Bacteria	337	5.53e-88	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g22433	i0	91.77	353.866935483871	243	18	98	2	1	242	27243	27484	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	87759	337	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
8130184	8130184	PRJNA495391_S_NODE_65107_length_156_cov_1.165289_g64055_i0	PRJNA495391	65107	156	1.165289	1.81785084	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	267	4.2199999999999997e-67	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g64055	i0	97.436	275.673076923077	156	4	100	0	1	156	2748517	2748362	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	43005	267	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8130341	8130341	PRJNA495391_S_NODE_7427_length_447_cov_1.376214_g6376_i0	PRJNA495391	7427	447	1.376214	6.15167658	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	486	9.999999999999997e-133	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g6376	i0	86.444	364.022371364653	450	54	100	7	1	447	2583847	2583402	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	162718	486	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
11955462	11955462	PRJNA495391_S_NODE_50550_length_174_cov_1.474820_g49498_i0	PRJNA495391	50550	174	1.47482	2.5661868	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	263	6.21e-66	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g49498	i0	94.253	88.4770114942529	174	6	99	4	3	174	27830	27659	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	15395	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
14504546	14504546	PRJNA495391_S_NODE_15932_length_300_cov_2.158491_g14880_i0	PRJNA495391	15932	300	2.158491	6.475473	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	331	3.2e-86	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g14880	i0	87.031	77.6366666666667	293	38	98	0	6	298	3454980	3455272	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	23291	331	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
22153183	22153183	PRJNA495391_S_NODE_45698_length_182_cov_2.000000_g44646_i0	PRJNA495391	45698	182	2	3.64	Lacipirellula parvula	2650471	Bacteria	Bacteria	220	4.01e-53	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g44646	i0	89.385	169.467032967033	179	13	96	5	8	182	5162981	5163157	Lacipirellula parvula PX69 DNA, complete genome	blastn	30843	220	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula

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