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

6 rows where analysis = "blastn", bioproject = "PRJNA980587" 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
4784262	4784262	PRJNA980587_P_NODE_74044_length_260_cov_2.096257_g73251_i0	PRJNA980587	74044	260	2.096257	5.4502682	Archangium violaceum	83451	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g73251	i0	96.875	0.123076923076923	32	0	12	1	91	122	8234337	8234367	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	32	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
12435369	12435369	PRJNA980587_P_NODE_83830_length_248_cov_0.880000_g83037_i0	PRJNA980587	83830	248	0.88	2.1824	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	283	7.309999999999999e-72	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g83037	i0	87.967	226.862903225806	241	28	97	1	8	247	8617053	8616813	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	56262	283	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
19120838	19120838	PRJNA980587_P_NODE_24695_length_499_cov_1.802817_g23904_i0	PRJNA980587	24695	499	1.802817	8.99605683	Pendulispora	3375062	Bacteria	Bacteria	507	8.659999999999998e-139	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g23904	i0	85.089	126.821643286573	503	68	100	7	1	499	3588928	3589427	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	63284	507	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
20396022	20396022	PRJNA980587_P_NODE_91136_length_243_cov_0.905882_g90343_i0	PRJNA980587	91136	243	0.905882	2.20129326	Archangium	47	Bacteria	Bacteria	307	4.23e-79	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g90343	i0	89.627	290.399176954733	241	25	99	0	3	243	106996	107236	Archangium gephyra strain DSM 2261, complete genome	blastn	70567	307	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
25182058	25182058	PRJNA980587_P_NODE_61900_length_288_cov_2.032558_g61107_i0	PRJNA980587	61900	288	2.032558	5.85376704	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	503	6.12e-138	NTclustered	gi\|470482295\|ref\|NR_076524.1\|	404589	g61107	i0	98.264	275.083333333333	288	3	100	2	1	288	2956	2671	Anaeromyxobacter sp. Fw109-5 strain Fw109-5 23S ribosomal RNA, complete sequence	blastn	79224	503	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
25495978	25495978	PRJNA980587_P_NODE_36460_length_390_cov_1.952681_g35667_i0	PRJNA980587	36460	390	1.9526809999999999	7.6154559	Myxococcus	32	Bacteria	Bacteria	316	1.2e-81	NTclustered	gi\|1691464223\|gb\|CP017171.1\|	34	g35667	i0	81.818	218.802564102564	385	63	98	6	1	382	376709	377089	Myxococcus xanthus strain KF3.2.8c11 chromosome, complete genome	blastn	85333	316	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus

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