metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA940501" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA940501" and tax_phylum = "Evosea"

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
918969	918969	PRJNA940501_S_NODE_20461_length_361_cov_2.144654_g19643_i0	PRJNA940501	20461	361	2.144654	7.74220094	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	121	9.25e-23	NTclustered	gi\|831753332\|ref\|XM_012892328.1\|	1410327	g19643	i0	82.069	0.803324099722992	145	22	40	3	186	328	782	640	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	290	121	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
3468547	3468547	PRJNA940501_S_NODE_116043_length_228_cov_1.778378_g115225_i0	PRJNA940501	116043	228	1.778378	4.05470184	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	54.7	0.006	NTclustered	gi\|831759414\|ref\|XM_012894185.1\|	1410327	g115225	i0	100	1.00438596491228	29	0	13	0	52	80	109	81	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	229	54.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
6023947	6023947	PRJNA940501_S_NODE_342065_length_159_cov_1.215517_g341247_i0	PRJNA940501	342065	159	1.215517	1.93267203	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	128	2.13e-25	NTclustered	gi\|330805165\|ref\|XM_003290509.1\|	5786	g341247	i0	83.942	4.72327044025157	137	18	85	3	9	143	445	579	Dictyostelium purpureum NADH-ubiquinone oxidoreductase 23 kDa subunit (DICPUDRAFT_89000), partial mRNA	blastn	751	128	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
11121216	11121216	PRJNA940501_S_NODE_108409_length_232_cov_3.354497_g107591_i0	PRJNA940501	108409	232	3.354497	7.78243304	Clastoderma debaryanum	137625	Evosea	other_Eukaryota	267	6.809999999999999e-67	NTclustered	gi\|385258608\|gb\|JF263592.1\|	137625	g107591	i0	88.889	92.0431034482759	216	24	93	0	17	232	241	26	Clastoderma debaryanum elongation factor 1 alpha (EF-1alpha) gene, partial cds	blastn	21354	267	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Echinosteliales	Clastodermataceae	Clastoderma	Clastoderma debaryanum
11462183	11462183	PRJNA940501_S_NODE_52909_length_281_cov_1.348739_g52091_i0	PRJNA940501	52909	281	1.348739	3.78995659	Trichiidae	208472	Evosea	other_Eukaryota	76.8	1.54e-9	NTclustered	gi\|2250222277\|gb\|ON713379.1\|	647301	g52091	i0	92.453	5.66903914590747	53	4	19	0	1	53	1315	1367	Trichia decipiens voucher MA83070 small subunit ribosomal RNA gene, partial sequence	blastn	1593	76.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Trichiida	Trichiidae	Trichia	Trichia decipiens
11462217	11462217	PRJNA940501_S_NODE_60389_length_271_cov_8.508772_g59571_i0	PRJNA940501	60389	271	8.508772	23.05877212	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	58.4	5.34e-4	NTclustered	gi\|330791506\|ref\|XM_003283786.1\|	5786	g59571	i0	92.5	1.82656826568266	40	3	15	0	79	118	6288	6327	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_45096), partial mRNA	blastn	495	58.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
12400499	12400499	PRJNA940501_S_NODE_40250_length_301_cov_1.457364_g39432_i0	PRJNA940501	40250	301	1.457364	4.38666564	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	54.7	0.008	NTclustered	gi\|166240234\|ref\|XM_630671.2\|	352472	g39432	i0	92.308	0.59468438538206	39	1	12	2	1	37	101	63	Dictyostelium discoideum AX4 RNase P protein subunit (drpp21) mRNA, complete cds	blastn	179	54.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
17835281	17835281	PRJNA940501_S_NODE_256954_length_177_cov_1.402985_g256136_i0	PRJNA940501	256954	177	1.402985	2.48328345	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	58.4	3.21e-4	NTclustered	gi\|66805702\|ref\|XM_631481.1\|	352472	g256136	i0	90.698	1.32203389830508	43	4	24	0	97	139	671	713	Dictyostelium discoideum AX4 hypothetical protein (DDB_G0288683) mRNA, complete cds	blastn	234	58.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
23870847	23870847	PRJNA940501_S_NODE_16099_length_389_cov_3.592486_g15284_i0	PRJNA940501	16099	389	3.592486	13.97477054	Protostelium mycophagum	472931	Evosea	other_Eukaryota	228	5.749999999999998e-55	NTclustered	gi\|262262917\|gb\|FJ766460.1\|	472931	g15284	i0	83.665	39.0282776349614	251	31	63	6	143	389	709	953	Protostelium mycophagum strain PRA-128 small subunit ribosomal RNA gene, partial sequence	blastn	15182	228	1	Eukaryota	Amoebozoa	Evosea	Variosea	Protosteliida	Protosteliaceae	Protostelium	Protostelium mycophagum
25484947	25484947	PRJNA940501_S_NODE_53900_length_279_cov_5.072034_g53082_i0	PRJNA940501	53900	279	5.072034	14.15097486	Trichiida	208471	Evosea	other_Eukaryota	219	2.3899999999999993e-52	NTclustered	gi\|2250222240\|gb\|ON713360.1\|	1334559	g53082	i0	85	43.8673835125448	220	28	78	5	4	222	1485	1270	Prototrichia metallica voucher MA80049 small subunit ribosomal RNA gene, partial sequence	blastn	12239	220	0.995454545454545	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Trichiida	Trichiidae	Prototrichia	Prototrichia metallica

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