metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA674308" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA674308" 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
1166573	1166573	PRJNA674308_P_NODE_27241_length_192_cov_1.741259_g27006_i0	PRJNA674308	27241	192	1.741259	3.34321728	Pseudomonadati	3379134	Bacteria	Bacteria	113	7.480000000000001e-21	NTclustered	gi\|2851136330\|gb\|CP172866.1\|	184914	g27006	i0	94.521	37.2447916666667	73	4	38	0	1	73	1777028	1777100	Corallococcus coralloides strain KYC2213 chromosome, complete genome	blastn	7151	113	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
3718226	3718226	PRJNA674308_P_NODE_24823_length_200_cov_2.344371_g24588_i0	PRJNA674308	24823	200	2.344371	4.688742	Archangium	47	Bacteria	Bacteria	237	4.4700000000000005e-58	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g24588	i0	89.005	240.935	191	21	96	0	3	193	5100788	5100978	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	48187	237	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
3718292	3718292	PRJNA674308_P_NODE_3163_length_544_cov_2.086869_g2932_i0	PRJNA674308	3163	544	2.086869	11.35256736	Myxococcia	32015	Bacteria	Bacteria	512	2.04e-140	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g2932	i0	83.755	118.222426470588	554	77	100	11	1	544	4848734	4848184	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	64313	516	0.992248062015504	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
4472535	4472535	PRJNA674308_P_NODE_10764_length_291_cov_1.830579_g10529_i0	PRJNA674308	10764	291	1.830579	5.32698489	Pendulispora brunnea	2905690	Bacteria	Bacteria	344	3.97e-90	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g10529	i0	87.96	132.852233676976	299	26	100	6	1	291	7408948	7408652	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	38660	344	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
19018427	19018427	PRJNA674308_P_NODE_54655_length_154_cov_2.380952_g54420_i0	PRJNA674308	54655	154	2.380952	3.66666608	Sorangium	39643	Bacteria	Bacteria	224	2.5299999999999994e-54	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g54420	i0	92.857	124.077922077922	154	11	100	0	1	154	3690836	3690683	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	19108	224	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
23597417	23597417	PRJNA674308_P_NODE_13279_length_264_cov_1.032558_g13044_i0	PRJNA674308	13279	264	1.032558	2.72595312	Corallococcus coralloides	184914	Bacteria	Bacteria	488	1.5499999999999999e-133	NTclustered	gi\|2851136330\|gb\|CP172866.1\|	184914	g13044	i0	100	231.799242424242	264	0	100	0	1	264	1590	1853	Corallococcus coralloides strain KYC2213 chromosome, complete genome	blastn	61195	488	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
25392913	25392913	PRJNA674308_P_NODE_17420_length_233_cov_1.695652_g17185_i0	PRJNA674308	17420	233	1.695652	3.95086916	Myxococcaceae	31	Bacteria	Bacteria	392	1.08e-104	NTclustered	gi\|1159844713\|gb\|KX572755.2\|	33	g17185	i0	96.996	144.965665236052	233	7	100	0	1	233	250	18	Myxococcus fulvus strain 185 16S ribosomal RNA gene, partial sequence	blastn	33777	392	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus

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