metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA688931" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA688931" and tax_phylum = "Myxococcota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
4496437	4496437	PRJNA688931_P_NODE_13824_length_279_cov_1.343478_g13611_i0	PRJNA688931	13824	279	1.343478	3.74830362	Myxococcus fulvus	33	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|817709775\|gb\|CP006003.1\|	1334629	g13611	i0	100	0.100358422939068	28	0	10	0	159	186	8897046	8897019	Myxococcus fulvus 124B02, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
4496504	4496504	PRJNA688931_P_NODE_22544_length_215_cov_4.379518_g22331_i0	PRJNA688931	22544	215	4.379518	9.4159637	Labilithrix luteola	1391654	Bacteria	Bacteria	283	6.17e-72	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g22331	i0	90.698	510.86976744186	215	16	99	2	3	215	7088974	7089186	Labilithrix luteola strain DSM 27648, complete genome	blastn	109837	283	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
7047228	7047228	PRJNA688931_P_NODE_44286_length_158_cov_8.137615_g44073_i0	PRJNA688931	44286	158	8.137615	12.8574317	Labilithrix luteola	1391654	Bacteria	Bacteria	248	1.55e-61	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g44073	i0	94.937	6.11392405063291	158	8	100	0	1	158	7915686	7915843	Labilithrix luteola strain DSM 27648, complete genome	blastn	966	248	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
8321528	8321528	PRJNA688931_P_NODE_14067_length_276_cov_2.193833_g13854_i0	PRJNA688931	14067	276	2.193833	6.05497908	Labilithrix luteola	1391654	Bacteria	Bacteria	444	3.58e-120	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g13854	i0	95.652	160.95652173913	276	12	100	0	1	276	3942664	3942389	Labilithrix luteola strain DSM 27648, complete genome	blastn	44424	444	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
9597083	9597083	PRJNA688931_P_NODE_33428_length_174_cov_1.328000_g33215_i0	PRJNA688931	33428	174	1.328	2.31072	Pendulispora rubella	2741070	Bacteria	Bacteria	220	3.79e-53	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g33215	i0	90.476	227.247126436782	168	14	97	2	6	171	7289290	7289457	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	39541	220	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
12147915	12147915	PRJNA688931_P_NODE_40310_length_164_cov_1.791304_g40097_i0	PRJNA688931	40310	164	1.791304	2.93773856	Labilithrix luteola	1391654	Bacteria	Bacteria	276	7.46e-70	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g40097	i0	96.951	110.646341463415	164	5	100	0	1	164	3942359	3942522	Labilithrix luteola strain DSM 27648, complete genome	blastn	18146	276	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
14697302	14697302	PRJNA688931_P_NODE_10072_length_333_cov_1.866197_g9859_i0	PRJNA688931	10072	333	1.866197	6.21443601	Labilithrix luteola	1391654	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g9859	i0	100	0.0870870870870871	29	0	9	0	141	169	9099141	9099169	Labilithrix luteola strain DSM 27648, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
17246293	17246293	PRJNA688931_P_NODE_13414_length_284_cov_0.885106_g13201_i0	PRJNA688931	13414	284	0.885106	2.51370104	Pendulispora albinea	2741071	Bacteria	Bacteria	315	3.0299999999999993e-81	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g13201	i0	86.62	20.6654929577465	284	38	100	0	1	284	3589430	3589147	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	5869	315	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
18520588	18520588	PRJNA688931_P_NODE_31935_length_178_cov_4.348837_g31722_i0	PRJNA688931	31935	178	4.348837	7.74092986	Labilithrix luteola	1391654	Bacteria	Bacteria	302	1.35e-77	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g31722	i0	97.714	155.162921348315	175	4	98	0	1	175	3943986	3944160	Labilithrix luteola strain DSM 27648, complete genome	blastn	27619	302	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
18520734	18520734	PRJNA688931_P_NODE_7535_length_394_cov_3.284058_g7322_i0	PRJNA688931	7535	394	3.284058	12.93918852	Myxococcus xanthus	34	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|1957989826\|gb\|CP068048.1\|	34	g7322	i0	96.875	1.00507614213198	32	1	8	0	169	200	5345529	5345560	Myxococcus xanthus strain R31 chromosome, complete genome	blastn	396	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
22345998	22345998	PRJNA688931_P_NODE_43498_length_162_cov_0.920354_g43285_i0	PRJNA688931	43498	162	0.920354	1.49097348	Sorangium cellulosum	56	Bacteria	Bacteria	65.8	1.73e-6	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g43285	i0	91.667	0.296296296296296	48	3	29	1	42	88	3097367	3097320	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	48	65.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
22855404	22855404	PRJNA688931_P_NODE_14338_length_273_cov_1.638393_g14125_i0	PRJNA688931	14338	273	1.638393	4.47281289	Anaeromyxobacter	161492	Bacteria	Bacteria	440	4.5799999999999984e-119	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g14125	i0	96.269	137.967032967033	268	10	98	0	6	273	947196	947463	Anaeromyxobacter oryzae DNA, complete genome	blastn	37665	440	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
25404537	25404537	PRJNA688931_P_NODE_18320_length_240_cov_1.026178_g18107_i0	PRJNA688931	18320	240	1.026178	2.4628272	Anaeromyxobacter	161492	Bacteria	Bacteria	292	1.17e-74	NTclustered	gi\|85772941\|gb\|CP000251.1\|	290397	g18107	i0	89.496	82.4458333333333	238	16	97	9	3	235	4138327	4138094	Anaeromyxobacter dehalogenans 2CP-C, complete genome	blastn	19787	292	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans

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