metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA283169" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA283169" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1646542	1646542	PRJNA283169_P_NODE_142_length_1078_cov_4.387755_g48_i2	PRJNA283169	142	1078	4.387755	47.2999989	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	917	0	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g48	i2	84.454	502.589981447124	952	125	87	22	1	938	4992784	4993726	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	541792	917	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
4198859	4198859	PRJNA283169_P_NODE_124_length_1139_cov_4.000000_g48_i1	PRJNA283169	124	1139	4	45.56	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	885	0	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g48	i1	81.067	419.014925373134	1162	175	99	38	3	1139	2826852	2827993	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	477258	885	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
4198876	4198876	PRJNA283169_P_NODE_2484_length_262_cov_1.215962_g2422_i0	PRJNA283169	2484	262	1.215962	3.18582044	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	257	4.7200000000000005e-64	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g2422	i0	85.892	187.480916030534	241	34	92	0	1	241	2201959	2202199	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	49120	257	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
5475155	5475155	PRJNA283169_P_NODE_3045_length_237_cov_3.952128_g2982_i0	PRJNA283169	3045	237	3.952128	9.36654336	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	176	1.21e-39	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g2982	i0	81.057	86.9324894514768	227	37	95	6	13	237	2202238	2202460	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	20603	176	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
6749444	6749444	PRJNA283169_P_NODE_2586_length_256_cov_1.801932_g2523_i0	PRJNA283169	2586	256	1.801932	4.61294592	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	137	6.25e-28	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g2523	i0	91.837	39.140625	98	8	38	0	159	256	7772	7869	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	10020	137	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
6749510	6749510	PRJNA283169_P_NODE_966_length_396_cov_1.567723_g904_i0	PRJNA283169	966	396	1.567723	6.20818308	Phototrophicaceae bacterium	3069543	Bacteria	Bacteria	399	1.18e-106	NTclustered	gi\|2893356046\|emb\|OZ220469.1\|	3069543	g904	i0	85.176	698.757575757576	398	50	99	8	1	394	2203167	2202775	MAG: Phototrophicaceae bacterium isolate 149760b3-584d-4ebc-81cd-1236e649b30c genome assembly, chromosome: 1	blastn	276708	399	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae		Phototrophicaceae bacterium
8025077	8025077	PRJNA283169_P_NODE_67_length_1515_cov_4.565484_g48_i0	PRJNA283169	67	1515	4.565484	69.1670826	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	1227	0	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g48	i0	82.986	549.838283828383	1393	202	91	31	1	1375	2828620	2827245	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	833005	1227	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
9299833	9299833	PRJNA283169_P_NODE_3048_length_237_cov_1.882979_g2985_i0	PRJNA283169	3048	237	1.882979	4.46266023	Herpetosiphon aurantiacus	65	Bacteria	Bacteria	176	1.21e-39	NTclustered	gi\|159889572\|gb\|CP000875.1\|	316274	g2985	i0	86.145	44.5569620253165	166	20	70	2	41	205	5446477	5446640	Herpetosiphon aurantiacus DSM 785, complete genome	blastn	10560	176	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
9299852	9299852	PRJNA283169_P_NODE_5048_length_190_cov_1.078014_g4985_i0	PRJNA283169	5048	190	1.078014	2.0482266	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2874254062\|emb\|OY970386.1\|	1672391	g4985	i0	100	0.152631578947368	29	0	15	0	75	103	82113	82085	MAG: uncultured Chloroflexia bacterium isolate MFD03726.bin.c.14 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
10575730	10575730	PRJNA283169_P_NODE_5069_length_189_cov_1.807143_g5006_i0	PRJNA283169	5069	189	1.807143	3.41550027	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	259	8.900000000000001e-65	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g5006	i0	91.534	223.015873015873	189	14	100	2	1	189	670080	670266	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	42150	259	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
11262172	11262172	PRJNA283169_P_NODE_2849_length_246_cov_1.187817_g2786_i0	PRJNA283169	2849	246	1.187817	2.92202982	Herpetosiphon	64	Bacteria	Bacteria	222	1.5999999999999996e-53	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g2786	i0	86.829	4.16666666666667	205	20	82	6	46	246	33	234	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	1025	222	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
11850475	11850475	PRJNA283169_P_NODE_8250_length_154_cov_2.914286_g8187_i0	PRJNA283169	8250	154	2.914286	4.48800044	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	63.9	5.84e-6	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g8187	i0	100	0.220779220779221	34	0	22	0	80	113	3494779	3494746	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	34	63.9	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
14400737	14400737	PRJNA283169_P_NODE_1912_length_294_cov_2.485714_g1850_i0	PRJNA283169	1912	294	2.485714	7.30799916	Aggregatilineales bacterium	2952883	Bacteria	Bacteria	270	6.92e-68	NTclustered	gi\|2621701266\|emb\|OY759986.1\|	2952883	g1850	i0	83.333	98.8163265306122	300	42	100	4	1	294	52825	52528	MAG: Aggregatilineales bacterium isolate 77605d95-9063-427a-b0a2-1f26f0f1d72f genome assembly, chromosome: 1	blastn	29052	270	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales			Aggregatilineales bacterium
18223451	18223451	PRJNA283169_P_NODE_4435_length_200_cov_1.596026_g4372_i0	PRJNA283169	4435	200	1.596026	3.192052	Phototrophicus methaneseepsis	2710758	Bacteria	Bacteria	158	3.58e-34	NTclustered	gi\|1932369605\|gb\|CP062983.1\|	2710758	g4372	i0	81.5	59.78	200	29	98	7	1	195	4992747	4992943	Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome	blastn	11956	158	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales	Phototrophicaceae	Phototrophicus	Phototrophicus methaneseepsis
20185044	20185044	PRJNA283169_P_NODE_1016_length_388_cov_3.949853_g954_i0	PRJNA283169	1016	388	3.949853	15.32542964	Herpetosiphon	64	Bacteria	Bacteria	353	9.07e-93	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g954	i0	83.377	85.0618556701031	385	60	99	4	3	385	1403	1785	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	33004	353	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
20773299	20773299	PRJNA283169_P_NODE_6877_length_167_cov_0.864407_g6814_i0	PRJNA283169	6877	167	0.864407	1.44355969	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	132	1.7500000000000002e-26	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g6814	i0	81.176	14.6766467065868	170	26	100	6	1	167	240359	240193	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	2451	132	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
24010902	24010902	PRJNA283169_P_NODE_559_length_509_cov_2.845652_g497_i0	PRJNA283169	559	509	2.845652	14.48436868	Chloroflexus	1107	Bacteria	Bacteria	549	1.4499999999999994e-151	NTclustered	gi\|470483916\|ref\|NR_076619.1\|	152260	g497	i0	86.187	231.056974459725	514	64	100	5	1	509	1971	1460	Chloroflexus aggregans strain MD-66 23S ribosomal RNA gene, complete sequence	blastn	117608	549	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans

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