metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA322517" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA322517" and tax_clade = "Opisthokonta"

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
28053604	28053604	PRJNA322517_P_NODE_5885_length_164_cov_0.886957_g5863_i0	PRJNA322517	5885	164	0.886957	1.45460948	Ditylenchus destructor	166010	Nematoda	Nematoda	65.9	3.16e-11	NR	KAI1709936.1	166010	g5863	i0	60.4	0.878048780487805	48	19	87.8	0	21	164	7	54	KAI1709936.1 ahpC/TSA family domain-containing protein [Ditylenchus destructor]	diamond	144	65.9	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Anguinidae	Ditylenchus	Ditylenchus destructor
28053605	28053605	PRJNA322517_P_NODE_6305_length_161_cov_0.910714_g6283_i0	PRJNA322517	6305	161	0.910714	1.46624954	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	70.9	1.46e-12	NR	RNA25872.1	10195	g6283	i0	91.4	0.652173913043478	35	3	65.2	0	1	105	529	563	RNA25872.1 eukaryotic translation initiation factor 3 subunit L [Brachionus plicatilis]	diamond	105	70.9	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
28116763	28116763	PRJNA322517_P_NODE_3225_length_236_cov_1.363636_g3203_i0	PRJNA322517	3225	236	1.363636	3.21818096	Molossus molossus	27622	Chordata	Chordata	50.1	8.98e-5	NR	KAF6407580.1	27622	g3203	i0	38.4	1.83050847457627	73	42	90.3	2	5	217	804	875	KAF6407580.1 NLR family pyrin domain containing 12 [Molossus molossus]	diamond	432	50.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Molossidae	Molossus	Molossus molossus
28337934	28337934	PRJNA322517_P_NODE_4246_length_190_cov_2.851064_g4224_i0	PRJNA322517	4246	190	2.851064	5.4170216	Cubamyces sp. BRFM 1775	1513325	Fungi	Fungi	101	3.35e-23	NR	KAI0333315.1	1513325	g4224	i0	96	3.15789473684211	50	2	78.9	0	190	41	843	892	KAI0333315.1 DNA repair helicase [Cubamyces sp. BRFM 1775]	diamond	600	101	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Cubamyces	Cubamyces sp. BRFM 1775
29222149	29222149	PRJNA322517_P_NODE_5949_length_163_cov_1.789474_g5927_i0	PRJNA322517	5949	163	1.789474	2.91684262	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	40.8	0.0158	NR	EDO32471.1	45351	g5927	i0	57.1	0.644171779141104	35	15	64.4	0	1	105	54	88	EDO32471.1 predicted protein, partial [Nematostella vectensis]	diamond	105	40.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
29442737	29442737	PRJNA322517_P_NODE_6350_length_161_cov_0.910714_g6328_i0	PRJNA322517	6350	161	0.910714	1.46624954	Sporobolomyces koalae	500713	Fungi	Fungi	44.3	0.00349	NR	GAA5929405.1	500713	g6328	i0	78.3	0.428571428571429	23	5	42.9	0	86	154	129	151	GAA5929405.1 hypothetical protein JCM15063_004140 [Sporobolomyces koalae]	diamond	69	44.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Sporobolomyces	Sporobolomyces koalae
30927820	30927820	PRJNA322517_P_NODE_3974_length_199_cov_2.840000_g3952_i0	PRJNA322517	3974	199	2.84	5.6516	Staurois parvus	386267	Chordata	Chordata	55.1	8.46e-8	NR	CAI9618505.1	386267	g3952	i0	54.3	1.38693467336683	46	20	67.8	1	3	137	12	57	CAI9618505.1 unnamed protein product, partial [Staurois parvus]	diamond	276	55.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
32540965	32540965	PRJNA322517_P_NODE_4979_length_174_cov_2.360000_g4957_i0	PRJNA322517	4979	174	2.36	4.1064	Nymphon striatum	424472	Arthropoda	Arthropoda	45.1	0.00234	NR	KAG1708490.1	424472	g4957	i0	38.8	4.22413793103448	49	30	84.5	0	171	25	793	841	KAG1708490.1 RNA-directed DNA polymerase from mobile element jockey [Nymphon striatum]	diamond	735	45.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Pycnogonida	Pantopoda	Nymphonidae	Nymphon	Nymphon striatum

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