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

5 rows where analysis = "blastn", bioproject = "PRJNA399133" 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
2356307	2356307	PRJNA399133_P_NODE_5442_length_227_cov_2.208333_g5354_i0	PRJNA399133	5442	227	2.208333	5.01291591	root	1	Root_unresolved	Root_unresolved	416	6.219999999999999e-112	NTclustered	gi\|916370259\|gb\|KP769678.1\|	1211	g5354	i0	100	117.4140969163	225	0	99	0	3	227	5	229	Uncultured cyanobacterium clone VA1186n 16S ribosomal RNA gene, partial sequence	blastn	26653	416	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
4240305	4240305	PRJNA399133_P_NODE_224_length_1103_cov_6.900749_g183_i0	PRJNA399133	224	1103	6.900749	76.11526147	Gloeocapsa sp. PCC 7428	1173026	Bacteria	Bacteria	1528	0	NTclustered	gi\|485099145\|ref\|NR_102540.1\|	1173026	g183	i0	91.787	101.79601087942	1108	75	100	15	1	1103	469	1565	Gloeocapsa sp. PCC 7428 strain PCC 7428 23S ribosomal RNA, complete sequence	blastn	112281	1528	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
5516912	5516912	PRJNA399133_P_NODE_1145_length_475_cov_5.802273_g1065_i0	PRJNA399133	1145	475	5.802273	27.56079675	Aliterella chasmolithica	2739056	Bacteria	Bacteria	667	0	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g1065	i0	92.034	122.850526315789	477	34	100	4	1	475	2463	1989	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	58354	667	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
5517115	5517115	PRJNA399133_P_NODE_9865_length_167_cov_2.916667_g9777_i0	PRJNA399133	9865	167	2.916667	4.87083389	uncultured cyanobacterium	1211	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|389547675\|gb\|JQ402603.1\|	1211	g9777	i0	100	93.6287425149701	167	0	100	0	1	167	2	168	Uncultured cyanobacterium clone CNY_03004 16S ribosomal RNA gene, partial sequence	blastn	15636	309	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
23365274	23365274	PRJNA399133_P_NODE_12339_length_151_cov_1.034483_g12251_i0	PRJNA399133	12339	151	1.034483	1.56206933	Microcoleus vaginatus	119532	Bacteria	Bacteria	102	1.21e-17	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g12251	i0	80.576	17.2980132450331	139	22	98	5	1	136	101952	102088	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	2612	102	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);;