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

7 rows where analysis = "blastn", bioproject = "PRJNA1000943" 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
999255	999255	PRJNA1000943_P_NODE_241_length_1313_cov_2.620968_g193_i0	PRJNA1000943	241	1313	2.620968	34.41330984	Archangiaceae	39	Bacteria	Bacteria	1646	0	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g193	i0	89.402	257.134805788271	1321	121	99	15	3	1313	23	1334	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	337618	1646	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
3549833	3549833	PRJNA1000943_P_NODE_2943_length_449_cov_3.609043_g2806_i0	PRJNA1000943	2943	449	3.609043	16.20460307	Pendulispora	3375062	Bacteria	Bacteria	516	1.28e-141	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g2806	i0	87.751	106.632516703786	449	45	99	9	6	449	9852416	9852859	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	47878	520	0.992307692307692	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
14173689	14173689	PRJNA1000943_P_NODE_10512_length_258_cov_2.108108_g10374_i0	PRJNA1000943	10512	258	2.108108	5.43891864	Nannocystis punicea	2995304	Bacteria	Bacteria	213	1.02e-50	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g10374	i0	86.224	46.1085271317829	196	27	76	0	63	258	5377495	5377300	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	11896	213	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
15447895	15447895	PRJNA1000943_P_NODE_6253_length_324_cov_1.179283_g6115_i0	PRJNA1000943	6253	324	1.179283	3.82087692	Labilithrix luteola	1391654	Bacteria	Bacteria	449	9.24e-122	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g6115	i0	91.667	76.7901234567901	324	27	100	0	1	324	7915819	7915496	Labilithrix luteola strain DSM 27648, complete genome	blastn	24880	449	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
17577114	17577114	PRJNA1000943_P_NODE_3614_length_409_cov_2.446429_g3477_i0	PRJNA1000943	3614	409	2.446429	10.00589461	Corallococcus	83461	Bacteria	Bacteria	243	2.1700000000000007e-59	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g3477	i0	77.982	247.70904645476801	436	62	99	19	4	409	143880	144311	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	101313	243	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
20125760	20125760	PRJNA1000943_P_NODE_11416_length_252_cov_0.871508_g11278_i0	PRJNA1000943	11416	252	0.871508	2.19620016	Myxococcaceae	31	Bacteria	Bacteria	283	7.44e-72	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g11278	i0	89.778	137.797619047619	225	17	90	6	7	230	4003304	4003085	Myxococcus xanthus strain DK1050 chromosome	blastn	34725	283	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
24370958	24370958	PRJNA1000943_P_NODE_100_length_1718_cov_3.416413_g79_i0	PRJNA1000943	100	1718	3.416413	58.69397534	Pendulispora rubella	2741070	Bacteria	Bacteria	2220	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g79	i0	90.046	162.394644935972	1728	152	100	18	1	1718	9854133	9852416	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	278994	2220	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella

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