metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA800090" and tax_clade = "Cyanobacteriota/Melainabacteria group"

8 rows where analysis = "blastn", bioproject = "PRJNA800090" and tax_clade = "Cyanobacteriota/Melainabacteria group"

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
1220324	1220324	PRJNA800090_P_NODE_149161_length_257_cov_1.255319_g146976_i0	PRJNA800090	149161	257	1.255319	3.22616983	Macrochaete	1844958	Bacteria	Bacteria	472	1.51e-128	NTclustered	gi\|336109608\|gb\|JN020217.1\|	1211	g146976	i0	100	99.3073929961089	255	0	99	0	3	257	809	555	Uncultured cyanobacterium clone cher4_2B_90 small subunit ribosomal RNA gene, partial sequence	blastn	25522	472	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
2075049	2075049	PRJNA800090_P_NODE_52182_length_492_cov_7.962175_g49998_i0	PRJNA800090	52182	492	7.962175	39.173901	Wilmottia koreana	2759957	Bacteria	Bacteria	808	0	NTclustered	gi\|1743541374\|gb\|MN473879.1\|	2613809	g49998	i0	96.341	162.270325203252	492	17	100	1	1	492	1922	2412	Wilmottia koreana FBCC-A812 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	79837	808	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Wilmottiaceae	Wilmottia	Wilmottia koreana
11425360	11425360	PRJNA800090_S_NODE_21869_length_268_cov_1.793970_g21757_i0	PRJNA800090	21869	268	1.79397	4.8078396	root	1	Root_unresolved	Root_unresolved	71.3	6.77e-8	NTclustered	gi\|2751213477\|emb\|OZ001294.2\|	1007660	g21757	i0	95.455	4.23134328358209	44	2	16	0	182	225	3269540	3269497	MAG: uncultured Hormoscilla sp. isolate 8e647e88-4706-4a17-b8b9-b52c092b67df genome assembly, chromosome: 2	blastn	1134	71.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Gomontiellaceae	Hormoscilla	uncultured Hormoscilla sp.
12278001	12278001	PRJNA800090_P_NODE_196790_length_219_cov_4.920000_g194605_i0	PRJNA800090	196790	219	4.92	10.7748	Microcoleus sp. PCC 8701	272133	Bacteria	Bacteria	276	1.06e-69	NTclustered	gi\|46409899\|gb\|AY584524.1\|	272133	g194605	i0	89.333	164.063926940639	225	16	100	7	1	219	766	988	Microcoleus sp. PCC 8701 23S ribosomal RNA gene, partial sequence	blastn	35930	276	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. PCC 8701
13552881	13552881	PRJNA800090_P_NODE_52511_length_490_cov_16.323040_g50327_i0	PRJNA800090	52511	490	16.32304	79.982896	cyanobacterium NIES-36	2510787	Bacteria	Bacteria	662	0	NTclustered	gi\|1566846291\|dbj\|LC455671.1\|	2510787	g50327	i0	91.02	163.726530612245	490	44	100	0	1	490	13	502	Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence	blastn	80226	662	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-36
21199659	21199659	PRJNA800090_P_NODE_140577_length_265_cov_2.938776_g138392_i0	PRJNA800090	140577	265	2.938776	7.7877564	Euhalothece natronophila	577489	Bacteria	Bacteria	364	2.739999999999999e-96	NTclustered	gi\|1720260411\|gb\|CP042326.1\|	522448	g138392	i0	91.386	271.007547169811	267	21	100	2	1	265	427383	427649	Euhalothece natronophila Z-M001 chromosome, complete genome	blastn	71817	364	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Halothecacae	Euhalothece	Euhalothece natronophila
22898276	22898276	PRJNA800090_P_NODE_189158_length_229_cov_1.800000_g186973_i0	PRJNA800090	189158	229	1.8	4.122	root	1	Root_unresolved	Root_unresolved	418	1.7499999999999995e-112	NTclustered	gi\|892164921\|gb\|KT182535.1\|	1211	g186973	i0	99.563	99.2139737991266	229	1	100	0	1	229	1354	1126	Uncultured cyanobacterium clone MBR Ca 100ppm 6 16S ribosomal RNA gene, partial sequence	blastn	22720	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
23752637	23752637	PRJNA800090_P_NODE_85939_length_357_cov_3.930556_g83754_i0	PRJNA800090	85939	357	3.930556	14.03208492	Microcoleus vaginatus	119532	Bacteria	Bacteria	359	1.78e-94	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g83754	i0	85.124	165.747899159664	363	41	99	10	2	357	102274	101918	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	59172	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus

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