metadata: contig_metadata: 10 rows where bioproject = "PRJNA591127", tax_clade = "Opisthokonta" and tax

10 rows where bioproject = "PRJNA591127", tax_clade = "Opisthokonta" and tax_phylum = "Nematoda"

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
1840525	1840525	PRJNA591127_P_NODE_13082_length_203_cov_3.042169_g12913_i0	PRJNA591127	13082	203	3.042169	6.17560307	Pelodera teres	96650	Nematoda	Nematoda	375	9.24e-100	NTclustered	gi\|158821915\|gb\|EU195979.1\|	96650	g12913	i0	100	43.384236453202	203	0	100	0	1	203	3132	3334	Pelodera teres strain EM437 28S ribosomal RNA gene, partial sequence	blastn	8807	375	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Pelodera	Pelodera teres
8218344	8218344	PRJNA591127_P_NODE_3647_length_377_cov_4.867647_g3479_i0	PRJNA591127	3647	377	4.867647	18.35102919	Pelodera teres	96650	Nematoda	Nematoda	673	0	NTclustered	gi\|8515041\|gb\|AF083002.1\|	96650	g3479	i0	99.728	21.3236074270557	368	0	98	1	1	368	367	1	Pelodera teres strain EM437 18S ribosomal RNA gene, partial sequence	blastn	8039	673	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Pelodera	Pelodera teres
9493573	9493573	PRJNA591127_P_NODE_6208_length_295_cov_3.461240_g6040_i0	PRJNA591127	6208	295	3.46124	10.210658	Pelodera teres	96650	Nematoda	Nematoda	545	1.03e-150	NTclustered	gi\|158821915\|gb\|EU195979.1\|	96650	g6040	i0	100	94.6949152542373	295	0	100	0	1	295	2219	1925	Pelodera teres strain EM437 28S ribosomal RNA gene, partial sequence	blastn	27935	545	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Pelodera	Pelodera teres
14594005	14594005	PRJNA591127_P_NODE_472_length_873_cov_4.216507_g388_i0	PRJNA591127	472	873	4.216507	36.81010611	Pelodera teres	96650	Nematoda	Nematoda	1591	0	NTclustered	gi\|158821915\|gb\|EU195979.1\|	96650	g388	i0	99.542	27.4650630011455	873	4	100	0	1	873	902	30	Pelodera teres strain EM437 28S ribosomal RNA gene, partial sequence	blastn	23977	1591	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Pelodera	Pelodera teres
15867789	15867789	PRJNA591127_P_NODE_28113_length_153_cov_3.301724_g27944_i0	PRJNA591127	28113	153	3.301724	5.0516377200000004	Pelodera teres	96650	Nematoda	Nematoda	283	4.0799999999999995e-72	NTclustered	gi\|2451035706\|gb\|OQ566795.1\|	96650	g27944	i0	100	99.6928104575163	153	0	100	0	1	153	999	847	Pelodera teres isolate f1 small subunit ribosomal RNA gene, partial sequence	blastn	15253	283	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Pelodera	Pelodera teres
15867840	15867840	PRJNA591127_P_NODE_3253_length_397_cov_3.038889_g3085_i0	PRJNA591127	3253	397	3.038889	12.06438933	Pelodera teres	96650	Nematoda	Nematoda	734	0	NTclustered	gi\|158821915\|gb\|EU195979.1\|	96650	g3085	i0	100	101.498740554156	397	0	100	0	1	397	1474	1870	Pelodera teres strain EM437 28S ribosomal RNA gene, partial sequence	blastn	40295	734	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Pelodera	Pelodera teres
18416817	18416817	PRJNA591127_P_NODE_11615_length_216_cov_3.000000_g11446_i0	PRJNA591127	11615	216	3	6.48	Pelodera teres	96650	Nematoda	Nematoda	399	5.909999999999999e-107	NTclustered	gi\|158821915\|gb\|EU195979.1\|	96650	g11446	i0	100	52.2685185185185	216	0	100	0	1	216	2657	2442	Pelodera teres strain EM437 28S ribosomal RNA gene, partial sequence	blastn	11290	399	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Pelodera	Pelodera teres
24791248	24791248	PRJNA591127_P_NODE_22920_length_181_cov_7.902778_g22751_i0	PRJNA591127	22920	181	7.902778	14.30402818	Opisthokonta	33154	Nematoda	Nematoda	102	5.19e-25	NR	NP_507940.1	6239	g22751	i0	76.7	11.8839779005525	60	14	99.4	0	180	1	14	73	NP_507940.1 Large ribosomal subunit protein uL2 [Caenorhabditis elegans]	diamond	2151	103	0.990291262135922	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
28135545	28135545	PRJNA591127_P_NODE_12025_length_212_cov_3.685714_g11856_i0	PRJNA591127	12025	212	3.685714	7.81371368	Nematoda	6231	Nematoda	Nematoda	82	1.44e-16	NR	XP_024509313.1	34506	g11856	i0	55.9	2.90094339622642	68	30	96.2	0	8	211	16	83	XP_024509313.1 60S acidic ribosomal protein P0 [Strongyloides ratti]	diamond	615	82.8	0.990338164251208	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Strongyloididae	Strongyloides	Strongyloides ratti
31059474	31059474	PRJNA591127_P_NODE_13175_length_202_cov_5.127273_g13006_i0	PRJNA591127	13175	202	5.127273	10.35709146	Caenorhabditis remanei	31234	Nematoda	Nematoda	43.1	0.0157	NR	XP_003107396.2	31234	g13006	i0	75	0.698019801980198	24	6	35.6	0	74	3	507	530	XP_003107396.2 hypothetical protein GCK72_003543 [Caenorhabditis remanei]	diamond	141	43.1	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis remanei

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