metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax

10 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax_phylum = "Rhodothermota"

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
26062674	26062674	PRJEB20058_P_NODE_234949_length_226_cov_2.454545_g232124_i0	PRJEB20058	234949	226	2.454545	5.5472717	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	130	4.21e-36	NR	HEX8386404.1	2838334	g232124	i0	91.2	0.902654867256637	68	6	90.3	0	2	205	13	80	HEX8386404.1 carbonic anhydrase family protein [Rubricoccaceae bacterium]	diamond	204	130	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
26203082	26203082	PRJEB20058_P_NODE_91982_length_428_cov_1.043597_g89183_i0	PRJEB20058	91982	428	1.043597	4.46659516	Pseudomonadati	3379134	Bacteria	Bacteria	216	1.2299999999999998e-66	NR	HEX9952106.1	2838334	g89183	i0	85.7	1.69626168224299	119	17	83.4	0	72	428	3	121	HEX9952106.1 NADH:flavin oxidoreductase [Rubricoccaceae bacterium]	diamond	726	217	0.995391705069124	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
26336714	26336714	PRJEB20058_P_NODE_50639_length_591_cov_1.609434_g47910_i0	PRJEB20058	50639	591	1.609434	9.51175494	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	355	2.96e-117	NR	HEX8385862.1	2838334	g47910	i0	90.5	1.01015228426396	199	10	96.4	1	3	572	40	238	HEX8385862.1 aspartate--tRNA ligase [Rubricoccaceae bacterium]	diamond	597	355	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
26471068	26471068	PRJEB20058_P_NODE_23496_length_859_cov_2.340852_g21295_i0	PRJEB20058	23496	859	2.340852	20.10791868	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	454	3.43e-155	NR	HEX8386403.1	2838334	g21295	i0	81.5	0.9988358556461	286	53	99.9	0	2	859	236	521	HEX8386403.1 SulP family inorganic anion transporter [Rubricoccaceae bacterium]	diamond	858	454	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
32996433	32996433	PRJEB20058_P_NODE_199395_length_257_cov_0.908163_g196571_i0	PRJEB20058	199395	257	0.908163	2.33397891	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	67.4	3.59e-11	NR	HEX8299034.1	2838334	g196571	i0	79.5	0.910505836575875	39	8	45.5	0	139	255	1	39	HEX8299034.1 RecX family transcriptional regulator [Rubricoccaceae bacterium]	diamond	234	67.4	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
33013664	33013664	PRJEB20058_P_NODE_23484_length_859_cov_6.349624_g21283_i0	PRJEB20058	23484	859	6.349624	54.54327016	Rhodothermus marinus	29549	Bacteria	Bacteria	293	1.59e-86	NR	WP_144295528.1	29549	g21283	i0	59.3	0.883585564610012	253	87	83.5	2	8	724	939	1189	WP_144295528.1 AVAST type 2 anti-phage system protein Avs2 [Rhodothermus marinus]	diamond	759	293	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
33042374	33042374	PRJEB20058_P_NODE_11948_length_1201_cov_1.747368_g10345_i0	PRJEB20058	11948	1201	1.747368	20.98588968	FCB group	1783270	Bacteria	Bacteria	270	5.03e-83	NR	HUF08622.1	2306054	g10345	i0	61.3	1.06161532056619	212	82	53	0	728	93	201	412	HUF08622.1 ABC transporter substrate-binding protein [Rhodothermales bacterium]	diamond	1275	271	0.996309963099631	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
33099396	33099396	PRJEB20058_P_NODE_86446_length_443_cov_5.086387_g83657_i0	PRJEB20058	86446	443	5.086387	22.53269441	Rhodothermales bacterium	2306054	Bacteria	Bacteria	192	5.17e-60	NR	MEP0547605.1	2306054	g83657	i0	71.9	1.82844243792325	135	38	91.4	0	425	21	1	135	MEP0547605.1 hypothetical protein [Rhodothermales bacterium]	diamond	810	192	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
33127726	33127726	PRJEB20058_P_NODE_164247_length_294_cov_10.510730_g161424_i0	PRJEB20058	164247	294	10.51073	30.9015462	Pseudomonadati	3379134	Bacteria	Bacteria	124	6.78e-33	NR	WP_094545395.1	716817	g161424	i0	75	14.734693877551	76	19	77.6	0	14	241	169	244	WP_094545395.1 RadC family protein [Rubricoccus marinus]	diamond	4332	124	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubricoccus	Rubricoccus marinus
33167520	33167520	PRJEB20058_P_NODE_76880_length_473_cov_5.652913_g74100_i0	PRJEB20058	76880	473	5.652913	26.73827849	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	236	6.979999999999999e-72	NR	HEX8384786.1	2838334	g74100	i0	86	1.90274841437632	150	21	95.1	0	452	3	294	443	HEX8384786.1 ATP-binding protein [Rubricoccaceae bacterium]	diamond	900	236	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae 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);;