metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA814235" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA814235" and tax_phylum = "Thermomicrobiota"

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
1225997	1225997	PRJNA814235_P_NODE_150721_length_174_cov_1.562044_g149326_i0	PRJNA814235	150721	174	1.562044	2.71795656	Sphaerobacter	2056	Bacteria	Bacteria	113	6.620000000000001e-21	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g149326	i0	86.538	7.99425287356322	104	13	60	1	71	174	1829	1931	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	1391	113	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
3777379	3777379	PRJNA814235_P_NODE_11103_length_568_cov_6.527307_g9909_i0	PRJNA814235	11103	568	6.527307	37.07510376	Sphaerobacter	2056	Bacteria	Bacteria	333	1.79e-86	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g9909	i0	77.931	60.2834507042254	580	96	98	25	11	567	592	22	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	34241	333	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
11430138	11430138	PRJNA814235_P_NODE_170489_length_159_cov_0.942623_g169094_i0	PRJNA814235	170489	159	0.942623	1.49877057	Sphaerobacter	2056	Bacteria	Bacteria	115	1.66e-21	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g169094	i0	80.124	3.52201257861635	161	27	99	5	1	158	2923	2765	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	560	115	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
15254536	15254536	PRJNA814235_P_NODE_18292_length_446_cov_7.691932_g16950_i0	PRJNA814235	18292	446	7.691932	34.30601672	Sphaerobacter	2056	Bacteria	Bacteria	117	1.51e-21	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g16950	i0	94.737	27.1121076233184	76	3	17	1	1	76	1939	1865	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	12092	117	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
16121419	16121419	PRJNA814235_P_NODE_9133_length_622_cov_374.610256_g8039_i0	PRJNA814235	9133	622	374.610256	2330.07579232	uncultured Thermomicrobium sp.	158795	Bacteria	Bacteria	1094	0	NTclustered	gi\|71844071\|gb\|DQ130040.1\|	158795	g8039	i0	98.392	99.2684887459807	622	10	100	0	1	622	273	894	Uncultured Thermomicrobium sp. clone GR108 16S ribosomal RNA gene, partial sequence	blastn	61745	1094	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales	Thermomicrobiaceae	Thermomicrobium	uncultured Thermomicrobium sp.
17803312	17803312	PRJNA814235_P_NODE_131934_length_193_cov_0.948718_g130539_i0	PRJNA814235	131934	193	0.948718	1.83102574	Sphaerobacter	2056	Bacteria	Bacteria	143	9.6e-30	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g130539	i0	84.615	186.248704663212	143	22	74	0	17	159	315	173	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	35946	143	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus

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