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

6 rows where analysis = "blastn", bioproject = "PRJNA757618" 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
8386023	8386023	PRJNA757618_P_NODE_43787_length_244_cov_0.906433_g42735_i0	PRJNA757618	43787	244	0.906433	2.21169652	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	91.6	4.66e-14	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g42735	i0	80.315	1.15163934426229	127	19	51	6	116	239	5188847	5188970	Anaeromyxobacter oryzae DNA, complete genome	blastn	281	91.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
14761268	14761268	PRJNA757618_P_NODE_18412_length_283_cov_2.333333_g17360_i0	PRJNA757618	18412	283	2.333333	6.60333239	Pendulispora albinea	2741071	Bacteria	Bacteria	431	2.869999999999999e-116	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g17360	i0	94.306	150.272084805654	281	16	99	0	1	281	3590096	3589816	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	42527	431	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
16034968	16034968	PRJNA757618_P_NODE_18473_length_283_cov_1.466667_g17421_i0	PRJNA757618	18473	283	1.466667	4.15066761	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	252	2.4e-62	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g17421	i0	84.328	0.946996466431095	268	30	93	12	3	264	7087603	7087864	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	268	252	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
17310597	17310597	PRJNA757618_P_NODE_28634_length_252_cov_0.865922_g27582_i0	PRJNA757618	28634	252	0.865922	2.18212344	Polyangium aurulentum	2567896	Bacteria	Bacteria	135	2.21e-27	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g27582	i0	78.378	5.05952380952381	222	39	88	7	12	225	7279308	7279088	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	1275	135	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
18584364	18584364	PRJNA757618_P_NODE_28875_length_252_cov_0.865922_g27823_i0	PRJNA757618	28875	252	0.865922	2.18212344	Archangium violaceum	83451	Bacteria	Bacteria	329	9.43e-86	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g27823	i0	90.4	50.7976190476191	250	24	100	0	3	252	4721729	4721480	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	12801	329	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
23685573	23685573	PRJNA757618_P_NODE_33339_length_249_cov_0.886364_g32287_i0	PRJNA757618	33339	249	0.886364	2.20704636	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	158	4.639999999999999e-34	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g32287	i0	78.884	19.0843373493976	251	39	98	13	2	245	1797430	1797673	Anaeromyxobacter paludicola DNA, complete genome	blastn	4752	158	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola

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