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

10 rows where analysis = "blastn", bioproject = "PRJNA630877" and tax_phylum = "Planctomycetota"

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
2427005	2427005	PRJNA630877_S_NODE_88042_length_262_cov_1.429864_g68905_i0	PRJNA630877	88042	262	1.429864	3.74624368	Bremerella	2714594	Bacteria	Bacteria	60.2	1.43e-4	NTclustered	gi\|1712647354\|gb\|CP036289.1\|	2527984	g68905	i0	97.143	0.267175572519084	35	1	13	0	172	206	2032779	2032745	Bremerella volcania strain Pan97 chromosome, complete genome	blastn	70	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella volcania
8256278	8256278	PRJNA630877_S_NODE_64327_length_397_cov_2.176966_g45195_i0	PRJNA630877	64327	397	2.176966	8.64255502	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	381	4.269999999999999e-101	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g45195	i0	91.429	85.3098236775819	280	20	70	4	1	277	2002730	2003008	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	33868	381	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
10080216	10080216	PRJNA630877_S_NODE_67948_length_367_cov_2.230061_g48811_i0	PRJNA630877	67948	367	2.230061	8.18432387	Limnoglobus	2731450	Bacteria	Bacteria	446	1.3699999999999999e-120	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g48811	i0	89.167	186.264305177112	360	36	98	3	1	358	2002291	2002649	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	68359	446	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
10807301	10807301	PRJNA630877_S_NODE_142649_length_164_cov_2.861789_g123512_i0	PRJNA630877	142649	164	2.861789	4.69333396	Urbifossiella limnaea	2528023	Bacteria	Bacteria	248	1.63e-61	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g123512	i0	93.902	164.69512195122	164	10	100	0	1	164	2019281	2019118	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	27010	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
13905674	13905674	PRJNA630877_S_NODE_107291_length_211_cov_2.505882_g88154_i0	PRJNA630877	107291	211	2.505882	5.28741102	Limnoglobus	2731450	Bacteria	Bacteria	313	7.7e-81	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g88154	i0	93.365	211.047393364929	211	14	100	0	1	211	3456689	3456479	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	44531	313	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
17729609	17729609	PRJNA630877_S_NODE_141854_length_165_cov_1.774194_g122717_i0	PRJNA630877	141854	165	1.774194	2.9274201	Gemmataceae	1914233	Bacteria	Bacteria	263	5.86e-66	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g122717	i0	97.403	113.866666666667	154	4	93	0	1	154	1837	1990	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	18788	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
21005527	21005527	PRJNA630877_S_NODE_84237_length_276_cov_1.680851_g65100_i0	PRJNA630877	84237	276	1.680851	4.63914876	Urbifossiella limnaea	2528023	Bacteria	Bacteria	342	1.3399999999999999e-89	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g65100	i0	88.968	60.5978260869565	281	26	100	3	1	276	2020028	2020308	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	16725	342	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
21553691	21553691	PRJNA630877_S_NODE_140857_length_166_cov_1.680000_g121720_i0	PRJNA630877	140857	166	1.68	2.7888	Gemmata	113	Bacteria	Bacteria	305	9.67e-79	NTclustered	gi\|307591227\|gb\|GQ889438.1\|	886811	g121720	i0	100	98.3975903614458	165	0	99	0	2	166	583	747	Gemmata sp. Io3-3 16S ribosomal RNA gene, partial sequence	blastn	16334	305	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. Io3-3
22280230	22280230	PRJNA630877_S_NODE_148558_length_159_cov_1.864407_g129421_i0	PRJNA630877	148558	159	1.864407	2.96440713	Gemmataceae bacterium	2052164	Bacteria	Bacteria	122	9.889999999999999e-24	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g129421	i0	80.864	51.3207547169811	162	25	100	6	1	159	320222	320380	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	8160	122	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
22829183	22829183	PRJNA630877_S_NODE_124398_length_184_cov_1.846154_g105261_i0	PRJNA630877	124398	184	1.846154	3.39692336	Limnoglobus	2731450	Bacteria	Bacteria	207	3.16e-49	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g105261	i0	87.097	139.652173913043	186	20	100	3	1	184	2002300	2002117	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	25696	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium

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