metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA1227535" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA1227535" 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
7988930	7988930	PRJNA1227535_P_NODE_5827_length_312_cov_4.945607_g5704_i0	PRJNA1227535	5827	312	4.945607	15.43029384	Chondromyces crocatus	52	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g5704	i0	94.595	0.118589743589744	37	1	12	1	261	296	8333869	8333833	Chondromyces crocatus strain Cm c5, complete genome	blastn	37	56.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
11813758	11813758	PRJNA1227535_P_NODE_12690_length_283_cov_1.485714_g12567_i0	PRJNA1227535	12690	283	1.485714	4.20457062	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	191	5.3e-44	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g12567	i0	79.514	8.43816254416961	288	44	99	13	5	283	7861989	7862270	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	2388	191	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
14364513	14364513	PRJNA1227535_P_NODE_7372_length_312_cov_2.794979_g7249_i0	PRJNA1227535	7372	312	2.794979	8.72033448	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	132	3.64e-26	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g7249	i0	97.403	1.66025641025641	77	2	25	0	236	312	9685445	9685369	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	518	132	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
18186709	18186709	PRJNA1227535_P_NODE_14755_length_276_cov_1.374384_g14632_i0	PRJNA1227535	14755	276	1.374384	3.79329984	Corallococcus exercitus	2316736	Bacteria	Bacteria	488	1.6299999999999995e-133	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g14632	i0	98.551	66.304347826087	276	4	100	0	1	276	637929	637654	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	18300	488	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
19461417	19461417	PRJNA1227535_P_NODE_29676_length_243_cov_1.517647_g29552_i0	PRJNA1227535	29676	243	1.517647	3.68788221	Myxococcus landrumensis	2813577	Bacteria	Bacteria	339	1.4999999999999997e-88	NTclustered	gi\|1998497960\|gb\|CP071091.1\|	2813577	g29552	i0	91.77	10.9218106995885	243	20	100	0	1	243	1273525	1273767	Myxococcus landrumus strain SCHIC003 chromosome	blastn	2654	339	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus landrumensis
21448945	21448945	PRJNA1227535_P_NODE_6237_length_312_cov_3.577406_g6114_i0	PRJNA1227535	6237	312	3.577406	11.16150672	Bacteria	2	Bacteria	Bacteria	58.4	6.27e-4	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g6114	i0	85	0.881410256410256	60	6	19	2	58	115	15827401	15827343	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	275	58.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea

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