metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJEB49404" and tax

11 rows where analysis = "blastn", bioproject = "PRJEB49404" 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
991150	991150	PRJEB49404_P_NODE_607641_length_158_cov_1.361345_g593840_i0	PRJEB49404	607641	158	1.361345	2.1509251	Pendulispora	3375062	Bacteria	Bacteria	224	2.62e-54	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g593840	i0	92.857	279.291139240506	154	11	97	0	5	158	7289616	7289463	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	44128	224	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
2266168	2266168	PRJEB49404_P_NODE_208702_length_341_cov_4.096026_g194903_i0	PRJEB49404	208702	341	4.096026	13.96744866	Myxococcia	32015	Bacteria	Bacteria	516	9.51e-142	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g194903	i0	94.595	146.284457478006	333	18	98	0	9	341	3942473	3942805	Labilithrix luteola strain DSM 27648, complete genome	blastn	49883	516	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
3931150	3931150	PRJEB49404_P_NODE_383884_length_220_cov_2.425414_g370083_i0	PRJEB49404	383884	220	2.425414	5.3359108	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	124	4.07e-24	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g370083	i0	86.607	1.02272727272727	112	15	51	0	106	217	3054489	3054378	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	225	124	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
5217847	5217847	PRJEB49404_P_NODE_597585_length_160_cov_1.272727_g583784_i0	PRJEB49404	597585	160	1.272727	2.0363632	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	126	7.71e-25	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g583784	i0	81.761	35.675	159	22	98	6	4	160	2650705	2650552	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	5708	126	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
7752636	7752636	PRJEB49404_P_NODE_282507_length_275_cov_2.673729_g268706_i0	PRJEB49404	282507	275	2.673729	7.35275475	Pendulispora rubella	2741070	Bacteria	Bacteria	241	5.03e-59	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g268706	i0	82.624	59.6254545454545	282	39	100	9	1	275	9852411	9852689	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	16397	241	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
9919415	9919415	PRJEB49404_P_NODE_89708_length_621_cov_4.092784_g76481_i0	PRJEB49404	89708	621	4.092784	25.41618864	Myxococcia	32015	Bacteria	Bacteria	730	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g76481	i0	87.981	129.26731078905	624	67	99	7	1	618	7915224	7915845	Labilithrix luteola strain DSM 27648, complete genome	blastn	80275	734	0.994550408719346	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
10306850	10306850	PRJEB49404_P_NODE_360129_length_231_cov_1.661458_g346328_i0	PRJEB49404	360129	231	1.661458	3.83796798	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	204	5.3799999999999997e-48	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g346328	i0	82.819	35.995670995671	227	39	98	0	1	227	4859756	4859982	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	8315	204	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
11194199	11194199	PRJEB49404_P_NODE_125489_length_489_cov_4.413333_g111751_i0	PRJEB49404	125489	489	4.413333	21.58119837	Pendulispora	3375062	Bacteria	Bacteria	440	8.709999999999997e-119	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g111751	i0	83.068	141.237218813906	502	67	100	18	1	489	3588243	3587747	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	69065	440	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
14138658	14138658	PRJEB49404_P_NODE_492852_length_184_cov_1.131034_g479051_i0	PRJEB49404	492852	184	1.131034	2.08110256	Chondromyces crocatus	52	Bacteria	Bacteria	97.1	7.15e-16	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g479051	i0	81.513	5.38586956521739	119	21	65	1	1	119	11309603	11309720	Chondromyces crocatus strain Cm c5, complete genome	blastn	991	97.1	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
15421018	15421018	PRJEB49404_P_NODE_82573_length_659_cov_2.535484_g69570_i0	PRJEB49404	82573	659	2.535484	16.70883956	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	994	0	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g69570	i0	93.93	265.605462822458	659	38	99	2	1	658	1383902	1383245	Anaeromyxobacter paludicola DNA, complete genome	blastn	175034	994	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
25217067	25217067	PRJEB49404_P_NODE_295180_length_267_cov_1.587719_g281379_i0	PRJEB49404	295180	267	1.587719	4.23920973	Anaeromyxobacter	161492	Bacteria	Bacteria	436	5.769999999999999e-118	NTclustered	gi\|470482295\|ref\|NR_076524.1\|	404589	g281379	i0	96.255	169.730337078652	267	9	100	1	1	267	729	464	Anaeromyxobacter sp. Fw109-5 strain Fw109-5 23S ribosomal RNA, complete sequence	blastn	45318	436	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5

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