metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA753112" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA753112" 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
3280333	3280333	PRJNA753112_P_NODE_26303_length_265_cov_3.322917_g25961_i0	PRJNA753112	26303	265	3.322917	8.80573005	Bremerella volcania	2527984	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1712647354\|gb\|CP036289.1\|	2527984	g25961	i0	100	0.113207547169811	30	0	11	0	147	176	1622239	1622268	Bremerella volcania strain Pan97 chromosome, complete genome	blastn	30	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella volcania
6305653	6305653	PRJNA753112_P_NODE_27245_length_260_cov_2.620321_g26903_i0	PRJNA753112	27245	260	2.620321	6.8128346	Frigoriglobus	2774146	Bacteria	Bacteria	368	2.07e-97	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g26903	i0	92.636	250.538461538462	258	15	98	4	5	260	319499	319244	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	65140	368	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
12208636	12208636	PRJNA753112_P_NODE_34510_length_232_cov_2.452830_g34168_i0	PRJNA753112	34510	232	2.45283	5.6905656	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	316	6.66e-82	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g34168	i0	91.416	176.172413793103	233	16	99	2	1	229	7050704	7050936	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	40872	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
14758065	14758065	PRJNA753112_P_NODE_33232_length_243_cov_0.917647_g32890_i0	PRJNA753112	33232	243	0.917647	2.22988221	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	267	7.19e-67	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g32890	i0	86.475	79.1399176954732	244	31	100	2	1	243	3326057	3325815	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	19231	267	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
16031697	16031697	PRJNA753112_P_NODE_28773_length_253_cov_0.866667_g28431_i0	PRJNA753112	28773	253	0.866667	2.19266751	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	220	5.95e-53	NTclustered	gi\|1938775668\|gb\|CP054178.1\|	2026777	g28431	i0	86.5	77.5652173913043	200	27	79	0	53	252	1919348	1919149	MAG: Phycisphaeraceae bacterium isolate H1_PLA4 chromosome, complete genome	blastn	19624	220	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
21131304	21131304	PRJNA753112_P_NODE_10637_length_416_cov_1.813411_g10295_i0	PRJNA753112	10637	416	1.813411	7.54378976	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	161	6.37e-35	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g10295	i0	81.057	19.0144230769231	227	21	54	14	34	256	1035001	1035209	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	7910	161	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
21603903	21603903	PRJNA753112_P_NODE_35157_length_221_cov_12.945946_g34815_i0	PRJNA753112	35157	221	12.945946	28.61054066	Pseudomonadati	3379134	Bacteria	Bacteria	121	5.29e-23	NTclustered	gi\|32445670\|emb\|BX294147.1\|	243090	g34815	i0	97.222	110.529411764706	72	1	64	1	151	221	94787	94716	Rhodopirellula baltica SH 1 complete genome; segment 15/24	blastn	24427	121	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula baltica

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