metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA763243" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA763243" 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
3294071	3294071	PRJNA763243_P_NODE_18583_length_364_cov_18.735395_g18238_i0	PRJNA763243	18583	364	18.735395	68.1968378	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	122	2.6e-23	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g18238	i0	90.323	19.6483516483516	93	9	26	0	93	185	3521087	3520995	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	7152	122	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
4571922	4571922	PRJNA763243_P_NODE_52604_length_250_cov_2.203390_g52258_i0	PRJNA763243	52604	250	2.20339	5.508475	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	206	1.6399999999999998e-48	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g52258	i0	85.572	43.888	201	24	80	5	15	213	1485	1288	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	10972	206	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
4572270	4572270	PRJNA763243_P_NODE_67924_length_228_cov_18.367742_g67578_i0	PRJNA763243	67924	228	18.367742	41.87845176	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	200	6.859999999999999e-47	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g67578	i0	83.7	96.5482456140351	227	22	96	14	9	227	274770	274989	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	22013	200	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
8397391	8397391	PRJNA763243_P_NODE_9047_length_493_cov_68.304762_g8705_i0	PRJNA763243	9047	493	68.304762	336.74247666	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	337	1.1899999999999995e-87	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g8705	i0	80.786	222.488843813387	458	64	90	23	1	445	3521275	3520829	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	109687	337	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9672069	9672069	PRJNA763243_P_NODE_55188_length_248_cov_0.880000_g54842_i0	PRJNA763243	55188	248	0.88	2.1824	Litorilinea aerophila	1204385	Bacteria	Bacteria	315	2.59e-81	NTclustered	gi\|393193706\|gb\|JQ733906.1\|	1204385	g54842	i0	91.63	227.262096774194	227	19	92	0	5	231	3459	3685	Litorilinea aerophila strain PRI-4131 small subunit ribosomal RNA, tRNA-Ile (trnI), and large subunit ribosomal RNA genes, complete sequence	blastn	56361	315	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Litorilinea	Litorilinea aerophila
13496780	13496780	PRJNA763243_P_NODE_2971_length_781_cov_37.725989_g2698_i0	PRJNA763243	2971	781	37.725989	294.63997409	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	1334	0	NTclustered	gi\|523452741\|gb\|KF183161.1\|	166587	g2698	i0	97.804	99.3738796414853	774	15	99	2	3	775	25	797	Uncultured Chloroflexi bacterium clone S3-032 16S ribosomal RNA gene, partial sequence	blastn	77611	1334	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
16045399	16045399	PRJNA763243_P_NODE_16933_length_378_cov_23.524590_g16588_i0	PRJNA763243	16933	378	23.52459	88.9229502	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	390	6.72e-104	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g16588	i0	85.867	327.126984126984	375	43	98	9	8	378	3522317	3521949	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	123654	390	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
18594827	18594827	PRJNA763243_P_NODE_35495_length_289_cov_1.740741_g35149_i0	PRJNA763243	35495	289	1.740741	5.03074149	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	490	4.78e-134	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g35149	i0	97.552	625.069204152249	286	7	99	0	1	286	18927	19212	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	180645	490	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
22421323	22421323	PRJNA763243_P_NODE_72098_length_210_cov_10.408759_g71752_i0	PRJNA763243	72098	210	10.408759	21.8583939	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	241	3.66e-59	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g71752	i0	88.038	38.4095238095238	209	17	98	4	5	209	3495583	3495787	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	8066	241	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
22882927	22882927	PRJNA763243_P_NODE_37058_length_284_cov_14.582938_g36712_i0	PRJNA763243	37058	284	14.582938	41.41554392	Bacillati	1783272	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2531976033\|emb\|OY282371.1\|	498747	g36712	i0	100	0.964788732394366	29	0	14	0	111	139	110650	110622	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	274	54.7	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
24156837	24156837	PRJNA763243_P_NODE_1379_length_1061_cov_31.281377_g1192_i0	PRJNA763243	1379	1061	31.281377	331.89540997	Chloroflexus	1107	Bacteria	Bacteria	505	6.879999999999998e-138	NTclustered	gi\|470483916\|ref\|NR_076619.1\|	152260	g1192	i0	76.085	137.1178133836	1083	193	99	53	1	1052	1729	682	Chloroflexus aggregans strain MD-66 23S ribosomal RNA gene, complete sequence	blastn	145482	510	0.990196078431373	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans
25431979	25431979	PRJNA763243_P_NODE_69580_length_222_cov_17.302013_g69234_i0	PRJNA763243	69580	222	17.302013	38.41046886	Herpetosiphon	64	Bacteria	Bacteria	148	2.44e-31	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g69234	i0	80.583	173.518018018018	206	28	89	8	11	208	2221	2422	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	38521	148	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus

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