metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJEB2925" and tax

9 rows where analysis = "blastn", bioproject = "PRJEB2925" 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
26107	26107	PRJEB2925_P_NODE_6101_length_533_cov_3.763052_g5002_i0	PRJEB2925	6101	533	3.763052	20.05706716	Labilithrix luteola	1391654	Bacteria	Bacteria	523	9.229999999999997e-144	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g5002	i0	85.122	320.138836772983	531	58	96	11	20	533	3942470	3941944	Labilithrix luteola strain DSM 27648, complete genome	blastn	170634	523	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
1300304	1300304	PRJEB2925_P_NODE_1102_length_2241_cov_946.054850_g835_i0	PRJEB2925	1102	2241	946.05485	21201.0891885	Corallococcus exercitus	2316736	Bacteria	Bacteria	3245	0	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g835	i0	96.322	216.829094154395	1985	55	88	16	271	2241	86976	88956	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	485914	3245	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
1300333	1300333	PRJEB2925_P_NODE_1362_length_1740_cov_43.997067_g835_i2	PRJEB2925	1362	1740	43.997067	765.5489658	Corallococcus exercitus	2316736	Bacteria	Bacteria	2741	0	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g835	i2	98.893	225.981034482759	1536	15	88	2	1	1535	88956	87422	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	393207	2741	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
6404237	6404237	PRJEB2925_P_NODE_10586_length_349_cov_2.710191_g9314_i0	PRJEB2925	10586	349	2.710191	9.45856659	Labilithrix luteola	1391654	Bacteria	Bacteria	411	4.719999999999999e-110	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g9314	i0	87.921	51.1174785100287	356	33	100	7	1	349	3943132	3943484	Labilithrix luteola strain DSM 27648, complete genome	blastn	17840	411	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
10228882	10228882	PRJEB2925_P_NODE_16989_length_229_cov_2.061856_g15711_i0	PRJEB2925	16989	229	2.061856	4.72165024	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	110	1.2e-19	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g15711	i0	85.185	87.8951965065502	108	14	47	2	98	204	1383562	1383668	Anaeromyxobacter paludicola DNA, complete genome	blastn	20128	110	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
11504244	11504244	PRJEB2925_P_NODE_9530_length_382_cov_2.106628_g8260_i0	PRJEB2925	9530	382	2.106628	8.04731896	Labilithrix luteola	1391654	Bacteria	Bacteria	375	1.9e-99	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g8260	i0	83.92	104.015706806283	398	39	98	8	8	382	3943094	3943489	Labilithrix luteola strain DSM 27648, complete genome	blastn	39734	375	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
14054250	14054250	PRJEB2925_P_NODE_1692_length_1368_cov_42.704426_g835_i3	PRJEB2925	1692	1368	42.704426	584.19654768	Corallococcus exercitus	2316736	Bacteria	Bacteria	1853	0	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g835	i3	91.087	250.052631578947	1380	107	100	11	1	1368	87581	88956	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	342072	1853	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
22664931	22664931	PRJEB2925_P_NODE_10658_length_347_cov_4.737179_g9385_i0	PRJEB2925	10658	347	4.737179	16.43801113	Corallococcus	83461	Bacteria	Bacteria	531	3.4599999999999992e-146	NTclustered	gi\|2851136330\|gb\|CP172866.1\|	184914	g9385	i0	94.236	56.7291066282421	347	20	100	0	1	347	2475038	2475384	Corallococcus coralloides strain KYC2213 chromosome, complete genome	blastn	19685	531	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
22978051	22978051	PRJEB2925_P_NODE_1319_length_1794_cov_33.512791_g835_i1	PRJEB2925	1319	1794	33.512791	601.21947054	Corallococcus exercitus	2316736	Bacteria	Bacteria	2032	0	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g835	i1	87.196	251.376254180602	1812	201	100	24	1	1794	88956	87158	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	450969	2032	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus

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