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

7 rows where analysis = "blastn", bioproject = "PRJNA788929" 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
2045138	2045138	PRJNA788929_P_NODE_20622_length_359_cov_25.986014_g19962_i0	PRJNA788929	20622	359	25.986014	93.28979026	Labilithrix luteola	1391654	Bacteria	Bacteria	560	4.57e-155	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g19962	i0	97.273	156.91643454039	330	9	92	0	20	349	3943936	3944265	Labilithrix luteola strain DSM 27648, complete genome	blastn	56333	560	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
11418113	11418113	PRJNA788929_P_NODE_19169_length_375_cov_25.341060_g18509_i0	PRJNA788929	19169	375	25.34106	95.028975	root	1	Root_unresolved	Root_unresolved	52.8	0.036	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g18509	i0	94.286	0.413333333333333	35	1	9	1	296	330	1648744	1648711	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	155	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
12248686	12248686	PRJNA788929_P_NODE_16550_length_410_cov_25.091988_g15891_i0	PRJNA788929	16550	410	25.091988	102.8771508	Pajaroellobacter abortibovis	1882918	Bacteria	Bacteria	122	2.96e-23	NTclustered	gi\|1127377833\|gb\|CP016908.1\|	1882918	g15891	i0	90.526	48.0317073170732	95	5	23	3	25	117	1550925	1550833	Pajaroellobacter abortibovis strain BTF92-0548A/99-0131, genome	blastn	19693	122	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Pajaroellobacter	Pajaroellobacter abortibovis
20340754	20340754	PRJNA788929_P_NODE_43536_length_236_cov_16.509202_g42875_i0	PRJNA788929	43536	236	16.509202	38.96171672	root	1	Root_unresolved	Root_unresolved	278	3.2100000000000005e-70	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g42875	i0	90.566	195.991525423729	212	17	89	2	27	236	7290011	7289801	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	46254	279	0.996415770609319	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
22892071	22892071	PRJNA788929_P_NODE_42938_length_239_cov_13.457831_g42277_i0	PRJNA788929	42938	239	13.457831	32.16421609	Sorangium	39643	Bacteria	Bacteria	278	3.2600000000000004e-70	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g42277	i0	91.96	141.058577405858	199	14	82	2	21	217	3692314	3692116	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	33713	278	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
24166044	24166044	PRJNA788929_P_NODE_49519_length_201_cov_9.406250_g48858_i0	PRJNA788929	49519	201	9.40625	18.9065625	Stigmatella	40	Bacteria	Bacteria	219	1.6299999999999999e-52	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g48858	i0	89.714	234.940298507463	175	13	86	5	30	201	42	214	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	47223	219	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
25440844	25440844	PRJNA788929_P_NODE_13920_length_456_cov_36.297650_g13262_i0	PRJNA788929	13920	456	36.29765	165.517284	Stigmatella	40	Bacteria	Bacteria	673	0	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g13262	i0	95.913	201.508771929825	416	16	91	1	18	432	1596	1181	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	91888	673	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca

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