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

10 rows where analysis = "blastn", bioproject = "PRJNA1034994" 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
168239	168239	PRJNA1034994_P_NODE_661_length_642_cov_5.370826_g578_i0	PRJNA1034994	661	642	5.370826	34.48070292	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	680	0	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g578	i0	85.802	144.806853582555	648	85	100	6	1	642	2623571	2622925	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	92966	680	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
2282765	2282765	PRJNA1034994_P_NODE_3122_length_293_cov_1.050000_g3038_i0	PRJNA1034994	3122	293	1.05	3.0765	Planctomycetaceae	126	Bacteria	Bacteria	296	1.14e-75	NTclustered	gi\|1712491480\|gb\|CP036268.1\|	2527980	g3038	i0	90.991	178.59385665529	222	17	75	2	73	293	3083037	3082818	Stratiformator vulcanicus strain Pan189 chromosome	blastn	52328	298	0.993288590604027	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus
6110755	6110755	PRJNA1034994_P_NODE_4685_length_272_cov_1.547739_g4601_i0	PRJNA1034994	4685	272	1.547739	4.20985008	Planctomycetaceae	126	Bacteria	Bacteria	291	4.86e-74	NTclustered	gi\|1712549334\|gb\|CP036343.1\|	2527971	g4601	i0	86.081	157.033088235294	273	35	99	3	2	272	2344413	2344684	Gimesia algae strain Pan161 chromosome	blastn	42713	291	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia algae
6546261	6546261	PRJNA1034994_P_NODE_1726_length_387_cov_1.958599_g1642_i0	PRJNA1034994	1726	387	1.958599	7.57977813	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	462	1.44e-125	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g1642	i0	88.402	116.875968992248	388	39	99	6	3	387	1844561	1844945	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	45231	462	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
9095795	9095795	PRJNA1034994_P_NODE_5428_length_264_cov_1.382199_g5344_i0	PRJNA1034994	5428	264	1.382199	3.64900536	Urbifossiella limnaea	2528023	Bacteria	Bacteria	198	2.93e-46	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g5344	i0	80.451	88.75	266	47	100	5	1	264	4212458	4212196	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	23430	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
11646840	11646840	PRJNA1034994_P_NODE_7890_length_247_cov_1.971264_g7806_i0	PRJNA1034994	7890	247	1.971264	4.86902208	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g7806	i0	99.19	156.246963562753	247	2	100	0	1	247	3095125	3095371	Pirellula sp. SH-Sr6A, complete genome	blastn	38593	446	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
12921933	12921933	PRJNA1034994_P_NODE_1551_length_406_cov_1.879880_g1467_i0	PRJNA1034994	1551	406	1.87988	7.6323128	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	381	4.369999999999999e-101	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g1467	i0	83.942	155.869458128079	411	53	99	12	1	405	2663972	2664375	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	63283	381	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
21845148	21845148	PRJNA1034994_P_NODE_638_length_652_cov_2.373057_g555_i0	PRJNA1034994	638	652	2.373057	15.47233164	Planctomycetales bacterium	2053591	Bacteria	Bacteria	793	0	NTclustered	gi\|2210174292\|gb\|CP060262.1\|	2053591	g555	i0	88.72	222.216257668712	656	65	100	7	1	652	3542259	3542909	MAG: Planctomycetales bacterium isolate HK-STAS-UBP7_A-1 chromosome, complete genome	blastn	144885	793	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
24394369	24394369	PRJNA1034994_P_NODE_940_length_536_cov_1.166307_g856_i0	PRJNA1034994	940	536	1.166307	6.25140552	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	531	5.55e-146	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g856	i0	85.165	117.369402985075	546	49	100	22	1	536	1843757	1844280	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	62910	531	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
25233838	25233838	PRJNA1034994_P_NODE_9660_length_242_cov_2.526627_g9576_i0	PRJNA1034994	9660	242	2.526627	6.11443734	Singulisphaera	466152	Bacteria	Bacteria	296	9.12e-76	NTclustered	gi\|430012750\|gb\|CP003364.1\|	886293	g9576	i0	88.797	40.4876033057851	241	27	99	0	1	241	7354298	7354538	Singulisphaera acidiphila DSM 18658, complete genome	blastn	9798	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila

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