metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA278119" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA278119" and tax_phylum = "Chloroflexota"

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
6748889	6748889	PRJNA278119_P_NODE_24246_length_201_cov_1.019737_g23997_i0	PRJNA278119	24246	201	1.019737	2.04967137	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	187	4.5899999999999985e-43	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g23997	i0	83.663	7.99502487562189	202	29	100	3	1	201	1494	1296	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	1607	187	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
8711565	8711565	PRJNA278119_P_NODE_4467_length_568_cov_22.454721_g4224_i0	PRJNA278119	4467	568	22.454721	127.54281528	Herpetosiphon	64	Bacteria	Bacteria	377	8.14e-100	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g4224	i0	79.387	54.6302816901408	587	82	100	32	1	568	572	6	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	31030	377	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
9299392	9299392	PRJNA278119_P_NODE_31308_length_177_cov_1.554688_g31059_i0	PRJNA278119	31308	177	1.554688	2.75179776	Anaerolinea thermophila	167964	Bacteria	Bacteria	172	1.0999999999999999e-38	NTclustered	gi\|319993263\|dbj\|AP012029.1\|	926569	g31059	i0	90.37	97.6666666666667	135	8	75	5	10	142	198095	198226	Anaerolinea thermophila UNI-1 DNA, complete genome	blastn	17287	172	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolinea	Anaerolinea thermophila
13125056	13125056	PRJNA278119_P_NODE_2551_length_767_cov_2.661560_g2330_i0	PRJNA278119	2551	767	2.66156	20.4141652	Anaerolineales bacterium	2073117	Bacteria	Bacteria	760	0	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g2330	i0	97.95	150.831812255541	439	8	95	1	4	441	2030032	2029594	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	115688	760	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
18222715	18222715	PRJNA278119_P_NODE_11775_length_335_cov_1.045455_g11527_i0	PRJNA278119	11775	335	1.045455	3.50227425	Anaerolineales bacterium	2073117	Bacteria	Bacteria	470	7.36e-128	NTclustered	gi\|2556903179\|gb\|CP129482.1\|	2073117	g11527	i0	92.012	548.017910447761	338	22	100	5	1	335	3066872	3067207	MAG: Anaerolineales bacterium isolate cMAG.14 chromosome, complete genome	blastn	183586	470	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
18223185	18223185	PRJNA278119_P_NODE_46075_length_162_cov_2.265487_g45826_i0	PRJNA278119	46075	162	2.265487	3.67008894	Anaerolineales bacterium	2073117	Bacteria	Bacteria	231	1.6099999999999998e-56	NTclustered	gi\|2556903179\|gb\|CP129482.1\|	2073117	g45826	i0	92.593	266.302469135802	162	10	99	2	2	162	3067031	3066871	MAG: Anaerolineales bacterium isolate cMAG.14 chromosome, complete genome	blastn	43141	231	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
24597348	24597348	PRJNA278119_P_NODE_26540_length_192_cov_1.090909_g26291_i0	PRJNA278119	26540	192	1.090909	2.09454528	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	69.4	1.64e-7	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g26291	i0	93.478	0.239583333333333	46	3	24	0	5	50	9732920	9732875	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	46	69.4	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
24597486	24597486	PRJNA278119_P_NODE_34980_length_169_cov_0.866667_g34731_i0	PRJNA278119	34980	169	0.866667	1.46466723	Anaerolineales bacterium	2073117	Bacteria	Bacteria	58.4	3.03e-4	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g34731	i0	97.059	0.621301775147929	34	1	20	0	127	160	3791396	3791429	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	105	58.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium

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