metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA289590" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA289590" 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
5475934	5475934	PRJNA289590_P_NODE_20505_length_196_cov_2.068027_g20281_i0	PRJNA289590	20505	196	2.068027	4.05333292	Oceaniferula spumae	2979115	Bacteria	Bacteria	132	2.12e-26	NTclustered	gi\|2753272999\|dbj\|AP026866.1\|	2979115	g20281	i0	91.579	48.0204081632653	95	8	48	0	1	95	833029	833123	Verrucomicrobiaceae bacterium NT6N DNA, complete genome	blastn	9412	132	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Oceaniferula	Oceaniferula spumae
5476120	5476120	PRJNA289590_P_NODE_29125_length_165_cov_0.896552_g28901_i0	PRJNA289590	29125	165	0.896552	1.4793108	Opitutales bacterium	2026772	Bacteria	Bacteria	150	4.76e-32	NTclustered	gi\|2814788334\|emb\|OY762281.2\|	2026772	g28901	i0	83.333	10.133333333333301	168	22	100	6	1	165	977513	977677	MAG: Opitutales bacterium isolate 685e4509-010e-4797-9872-a51ee4494a19 genome assembly, chromosome: 1	blastn	1672	150	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
18224466	18224466	PRJNA289590_P_NODE_6715_length_370_cov_2.246106_g6491_i0	PRJNA289590	6715	370	2.246106	8.3105922	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	169	3.3499999999999996e-37	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g6491	i0	90.625	61.7540540540541	128	10	34	2	245	370	3047506	3047379	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	22849	169	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
23324821	23324821	PRJNA289590_P_NODE_5199_length_432_cov_2.026110_g4975_i0	PRJNA289590	5199	432	2.02611	8.7527952	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	54.7	0.012	NTclustered	gi\|2621703756\|emb\|OY762711.1\|	2813034	g4975	i0	94.286	0.0810185185185185	35	2	8	0	25	59	3671457	3671423	MAG: Sedimentisphaerales bacterium isolate 370b4a7f-3155-49ac-97a8-084c2d75e38e genome assembly, chromosome: 1	blastn	35	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
25285525	25285525	PRJNA289590_P_NODE_29660_length_164_cov_0.904348_g29436_i0	PRJNA289590	29660	164	0.904348	1.48313072	Engelhardtia	139931	Bacteria	Bacteria	195	2.15e-45	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g29436	i0	90.604	160.975609756098	149	10	90	4	1	147	5247535	5247389	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	26400	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis

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