metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA884104" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA884104" 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
1241274	1241274	PRJNA884104_S_NODE_71381_length_250_cov_0.870056_g70638_i0	PRJNA884104	71381	250	0.870056	2.17514	Myxococcus	32	Bacteria	Bacteria	152	2.17e-32	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g70638	i0	81.967	74.776	183	29	72	4	70	250	10302689	10302509	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	18694	152	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
6345300	6345300	PRJNA884104_S_NODE_69645_length_251_cov_0.865169_g68902_i0	PRJNA884104	69645	251	0.865169	2.17157419	Myxococcales	29	Bacteria	Bacteria	165	2.8e-36	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g68902	i0	81.643	17.0239043824701	207	30	81	6	49	251	6508912	6508710	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	4273	165	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
7619211	7619211	PRJNA884104_S_NODE_20726_length_443_cov_2.005405_g19983_i0	PRJNA884104	20726	443	2.005405	8.88394415	Anaeromyxobacter	161492	Bacteria	Bacteria	422	2.84e-113	NTclustered	gi\|470482295\|ref\|NR_076524.1\|	404589	g19983	i0	85.922	206.363431151242	412	38	92	16	2	410	1154	1548	Anaeromyxobacter sp. Fw109-5 strain Fw109-5 23S ribosomal RNA, complete sequence	blastn	91419	422	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
7619321	7619321	PRJNA884104_S_NODE_64786_length_259_cov_1.080645_g64043_i0	PRJNA884104	64786	259	1.080645	2.79887055	Archangium	47	Bacteria	Bacteria	148	2.9199999999999998e-31	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g64043	i0	77.778	67.9150579150579	243	52	93	2	18	259	10633362	10633121	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	17590	148	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
9789244	9789244	PRJNA884104_S_NODE_69068_length_251_cov_0.865169_g68325_i0	PRJNA884104	69068	251	0.865169	2.17157419	Minicystis rosea	888845	Bacteria	Bacteria	243	1.2600000000000001e-59	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g68325	i0	84.252	1.56972111553785	254	34	100	6	1	251	319395	319645	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	394	243	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
11063911	11063911	PRJNA884104_S_NODE_20949_length_441_cov_1.798913_g20206_i0	PRJNA884104	20949	441	1.798913	7.93320633	Vulgatibacter incomptus	1391653	Bacteria	Bacteria	396	1.7099999999999995e-105	NTclustered	gi\|913607065\|gb\|CP012332.1\|	1391653	g20206	i0	85.567	173.281179138322	388	45	87	9	1	385	180491	180112	Vulgatibacter incomptus strain DSM 27710, complete genome	blastn	76417	396	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Vulgatibacteraceae	Vulgatibacter	Vulgatibacter incomptus
14888381	14888381	PRJNA884104_S_NODE_23552_length_417_cov_2.238372_g22809_i0	PRJNA884104	23552	417	2.238372	9.33401124	Archangium gephyra	48	Bacteria	Bacteria	58.4	8.62e-4	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g22809	i0	97.143	0.0839328537170264	35	0	8	1	303	336	8515860	8515826	Archangium gephyra strain DSM 2261, complete genome	blastn	35	58.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
22537447	22537447	PRJNA884104_S_NODE_3778_length_1035_cov_1.962578_g3316_i0	PRJNA884104	3778	1035	1.962578	20.3126823	Minicystis rosea	888845	Bacteria	Bacteria	78.7	1.73e-9	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g3316	i0	74.479	0.241545893719807	192	43	18	6	401	589	7166245	7166057	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	250	78.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
22537576	22537576	PRJNA884104_S_NODE_43918_length_314_cov_1.082988_g43175_i0	PRJNA884104	43918	314	1.082988	3.40058232	Pendulispora brunnea	2905690	Bacteria	Bacteria	486	6.7999999999999986e-133	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g43175	i0	95.44	151.165605095541	307	11	97	3	7	312	9037631	9037327	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	47466	486	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
22918830	22918830	PRJNA884104_S_NODE_41058_length_323_cov_1.712000_g40315_i0	PRJNA884104	41058	323	1.712	5.52976	Anaeromyxobacter	161492	Bacteria	Bacteria	436	7.169999999999999e-118	NTclustered	gi\|470484038\|ref\|NR_076626.1\|	161493	g40315	i0	92.508	229.625386996904	307	20	95	3	1	306	929	625	Anaeromyxobacter dehalogenans strain 2CP-1 23S ribosomal RNA gene, complete sequence	blastn	74169	436	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans

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