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

7 rows where analysis = "blastn", bioproject = "PRJNA690234" 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
670412	670412	PRJNA690234_P_NODE_32461_length_233_cov_2.831250_g32094_i0	PRJNA690234	32461	233	2.83125	6.5968125	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	303	5.21e-78	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g32094	i0	90.435	73.2103004291845	230	22	99	0	4	233	5363654	5363425	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	17058	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
1945989	1945989	PRJNA690234_P_NODE_12382_length_360_cov_1.358885_g12015_i0	PRJNA690234	12382	360	1.358885	4.891986	planctomycete str. 139	149588	Bacteria	Bacteria	494	4.72e-135	NTclustered	gi\|12583967\|gb\|AF245371.1\|AF245371	149588	g12015	i0	91.413	59.2083333333333	361	30	100	1	1	360	1415	1775	Planctomycete str. 139 23S ribosomal RNA gene, partial sequence	blastn	21315	494	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 139
8323184	8323184	PRJNA690234_P_NODE_19247_length_289_cov_1.143519_g18880_i0	PRJNA690234	19247	289	1.143519	3.30476991	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	340	5.0999999999999986e-89	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g18880	i0	87.889	6.2076124567474	289	35	100	0	1	289	7872801	7873089	Planctomyces sp. SH-PL14, complete genome	blastn	1794	340	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
10873939	10873939	PRJNA690234_P_NODE_11529_length_374_cov_1.790698_g11163_i0	PRJNA690234	11529	374	1.790698	6.69721052	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	344	5.24e-90	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g11163	i0	83.463	199.885026737968	387	47	99	11	1	373	2664416	2664033	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	74757	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
13424273	13424273	PRJNA690234_P_NODE_5991_length_529_cov_1.557018_g5627_i0	PRJNA690234	5991	529	1.557018	8.23662522	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	542	2.53e-149	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g5627	i0	93.261	73.3005671077505	371	20	70	3	1	369	1155480	1155113	Planctomyces sp. SH-PL62, complete genome	blastn	38776	542	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
19797021	19797021	PRJNA690234_P_NODE_19436_length_287_cov_2.864486_g19069_i0	PRJNA690234	19436	287	2.864486	8.22107482	Symmachiella dynata	2527995	Bacteria	Bacteria	424	4.88e-114	NTclustered	gi\|1712609668\|gb\|CP036276.1\|	2527995	g19069	i0	93.38	125.390243902439	287	17	99	2	1	286	1041543	1041258	Symmachiella dynata strain Mal52 chromosome, complete genome	blastn	35987	424	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Symmachiella	Symmachiella dynata
22347394	22347394	PRJNA690234_P_NODE_17418_length_304_cov_1.350649_g17051_i0	PRJNA690234	17418	304	1.350649	4.10597296	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	510	3.89e-140	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g17051	i0	97.039	235.148026315789	304	8	100	1	1	304	1256	954	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	71485	510	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii

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