metadata: contig_metadata: 11 rows where bioproject = "PRJNA734348", tax_clade = "Sar" and tax

11 rows where bioproject = "PRJNA734348", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2472429	2472429	PRJNA734348_P_NODE_20322_length_445_cov_4.564516_g19631_i0	PRJNA734348	20322	445	4.564516	20.3120962	Bacillariophyceae	33849	SAR_Eukaryotes	SAR_Eukaryotes	244	6.62e-60	NTclustered	gi\|725539117\|gb\|KM407590.1\|	1574083	g19631	i0	91.111	40.1258426966292	180	16	40	0	66	245	248	427	Luticola muticopsis f. capitata isolate Ant003-G11 28S ribosomal RNA gene, partial sequence	blastn	17856	244	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Diadesmidaceae	Luticola	Luticola muticopsis
12196833	12196833	PRJNA734348_P_NODE_143950_length_226_cov_5.581699_g143252_i0	PRJNA734348	143950	226	5.581699	12.61463974	Nitzschia dissipata	303402	SAR_Eukaryotes	SAR_Eukaryotes	407	3.73e-109	NTclustered	gi\|1891520246\|gb\|MN696750.1\|	303402	g143252	i0	99.115	97.0088495575221	226	2	100	0	1	226	85	310	Nitzschia dissipata culture TCC:632 large subunit ribosomal RNA gene, partial sequence	blastn	21924	407	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia dissipata
12197688	12197688	PRJNA734348_P_NODE_47450_length_294_cov_1.040724_g46753_i0	PRJNA734348	47450	294	1.040724	3.05972856	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	327	4.05e-85	NTclustered	gi\|657012562\|gb\|KF302618.1\|	2850	g46753	i0	87	2.96938775510204	300	27	99	6	2	294	48	342	Phaeodactylum tricornutum clone C537 hypothetical protein mRNA, complete cds	blastn	873	327	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
13472463	13472463	PRJNA734348_P_NODE_63411_length_276_cov_1.704433_g62714_i0	PRJNA734348	63411	276	1.704433	4.70423508	Gomphonema parvulum	97227	SAR_Eukaryotes	SAR_Eukaryotes	351	2.23e-92	NTclustered	gi\|2328365145\|ref\|NC_067847.1\|	97227	g62714	i0	94.69	81.8405797101449	226	12	82	0	7	232	4360	4585	Gomphonema parvulum voucher personal collection:A.Bruce Cahoon:diatom-2021-A mitochondrion, complete genome	blastn	22588	351	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Cymbellales	Gomphonemataceae	Gomphonema	Gomphonema parvulum
21599707	21599707	PRJNA734348_P_NODE_81257_length_259_cov_2.913978_g80559_i0	PRJNA734348	81257	259	2.913978	7.54720302	Navicula	50949	SAR_Eukaryotes	SAR_Eukaryotes	403	5.65e-108	NTclustered	gi\|2620230842\|gb\|OR797293.1\|	1923966	g80559	i0	94.656	99.7915057915058	262	11	100	2	1	259	4094	3833	Navicula sp. strain SZCZEY2262 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	25846	403	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Navicula	Navicula sp.
23671162	23671162	PRJNA734348_P_NODE_36339_length_323_cov_4.812000_g35643_i0	PRJNA734348	36339	323	4.812	15.54276	Attheya septentrionalis	420275	SAR_Eukaryotes	SAR_Eukaryotes	102	2.97e-17	NTclustered	gi\|2632235279\|gb\|OR922661.1\|	420275	g35643	i0	91.781	22.6904024767802	73	6	23	0	251	323	3869	3797	Attheya septentrionalis strain AGSB0004 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	7329	102	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Attheyaceae	Attheya	Attheya septentrionalis
24944208	24944208	PRJNA734348_P_NODE_20160_length_448_cov_1.301333_g19469_i0	PRJNA734348	20160	448	1.301333	5.82997184	Eucampia zodiacus	444606	SAR_Eukaryotes	SAR_Eukaryotes	99	5.49e-16	NTclustered	gi\|2026158947\|ref\|NC_054334.1\|	444606	g19469	i0	76.098	13.6830357142857	205	39	44	8	32	227	30050	29847	Eucampia zodiacus strain CNS00060 mitochondrion, complete genome	blastn	6130	99	1	Eukaryota	Sar	Bacillariophyta	Mediophyceae	Hemiaulales	Hemiaulaceae	Eucampia	Eucampia zodiacus
26957337	26957337	PRJNA734348_P_NODE_120442_length_244_cov_0.900585_g119744_i0	PRJNA734348	120442	244	0.900585	2.1974274	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	129	1.7199999999999998e-32	NR	KAL3789536.1	29204	g119744	i0	85.9	0.959016393442623	78	11	95.9	0	236	3	98	175	KAL3789536.1 hypothetical protein HJC23_001344 [Cyclotella cryptica]	diamond	234	129	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
29210122	29210122	PRJNA734348_P_NODE_85369_length_256_cov_1.530055_g84671_i0	PRJNA734348	85369	256	1.530055	3.9169408	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	49.3	2.15e-4	NR	XP_002176672.1	556484	g84671	i0	42.2	4.13671875	45	26	52.7	0	136	2	250	294	XP_002176672.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1]	diamond	1059	49.3	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
29210123	29210123	PRJNA734348_P_NODE_97929_length_250_cov_0.870056_g97231_i0	PRJNA734348	97929	250	0.870056	2.17514	Bacillariophyceae	33849	SAR_Eukaryotes	SAR_Eukaryotes	152	3.21e-42	NR	GKY91142.1	2872254	g97231	i0	96.2	4.74	79	3	94.8	0	239	3	147	225	GKY91142.1 26S proteasome regulatory subunit 6A [Mayamaea pseudoterrestris]	diamond	1185	152	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
30715833	30715833	PRJNA734348_P_NODE_140854_length_231_cov_2.563291_g140156_i0	PRJNA734348	140854	231	2.563291	5.92120221	Nitzschia inconspicua	303405	SAR_Eukaryotes	SAR_Eukaryotes	63.5	1.35e-9	NR	KAG7345940.1	303405	g140156	i0	61	0.766233766233766	59	17	76.6	2	47	223	2	54	KAG7345940.1 ribosomal RNA-processing protein 7 RRP7 [Nitzschia inconspicua]	diamond	177	63.5	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua

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