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

6 rows where analysis = "blastn", bioproject = "PRJNA795983" 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
5883716	5883716	PRJNA795983_S_NODE_35865_length_251_cov_1.089888_g35740_i0	PRJNA795983	35865	251	1.089888	2.73561888	Labilithrix luteola	1391654	Bacteria	Bacteria	377	3.2999999999999995e-100	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g35740	i0	94.309	138.876494023904	246	14	98	0	6	251	3943959	3944204	Labilithrix luteola strain DSM 27648, complete genome	blastn	34858	377	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
12696170	12696170	PRJNA795983_S_NODE_9890_length_390_cov_1.495268_g9765_i0	PRJNA795983	9890	390	1.495268	5.8315452	Archangium	47	Bacteria	Bacteria	412	1.4799999999999998e-110	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g9765	i0	90.446	215.14358974359	314	29	81	1	76	389	109906	109594	Archangium gephyra strain DSM 2261, complete genome	blastn	83906	412	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
16519409	16519409	PRJNA795983_S_NODE_35773_length_251_cov_1.297753_g35648_i0	PRJNA795983	35773	251	1.297753	3.25736003	Corallococcus	83461	Bacteria	Bacteria	392	1.18e-104	NTclustered	gi\|470490045\|ref\|NR_076964.1\|	184914	g35648	i0	94.862	222.585657370518	253	9	100	4	1	251	1566	1816	Corallococcus coralloides strain M2 23S ribosomal RNA gene, complete sequence	blastn	55869	392	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
17794213	17794213	PRJNA795983_S_NODE_40174_length_244_cov_3.286550_g40049_i0	PRJNA795983	40174	244	3.28655	8.019182	Sorangium	39643	Bacteria	Bacteria	300	7.12e-77	NTclustered	gi\|28395339\|gb\|AY190664.1\|	56	g40049	i0	88.934	164.918032786885	244	25	99	2	1	242	850	607	Polyangium cellulosum strain So9881 clone 3 16S ribosomal RNA and 23S ribosomal RNA genes, partial sequence	blastn	40240	300	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
21182576	21182576	PRJNA795983_S_NODE_27797_length_275_cov_1.321782_g27672_i0	PRJNA795983	27797	275	1.321782	3.6349005	Chondromyces crocatus	52	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g27672	i0	100	0.101818181818182	28	0	10	0	28	55	10632310	10632337	Chondromyces crocatus strain Cm c5, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
21618633	21618633	PRJNA795983_S_NODE_2537_length_655_cov_1.536082_g2423_i0	PRJNA795983	2537	655	1.536082	10.0613371	Archangiaceae	39	Bacteria	Bacteria	774	0	NTclustered	gi\|1243034522\|gb\|CP022098.1\|	43	g2423	i0	90.909	282.230534351145	583	44	89	6	1	580	388847	389423	Cystobacter fuscus strain DSM 52655 chromosome, complete genome	blastn	184861	774	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus

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